metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA312899" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA312899" and tax_clade = "Bacteria candidate phyla"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
380122	380122	PRJNA312899_P_NODE_75041_length_186_cov_1.452555_g74599_i0	PRJNA312899	75041	186	1.452555	2.7017523	Candidatus Ozemobacteraceae bacterium	2818468	Bacteria	Bacteria	202	1.4899999999999999e-47	NTclustered	gi\|2907625676\|emb\|OZ223236.1\|	2818468	g74599	i0	86.74	2.96236559139785	181	24	97	0	1	181	2218296	2218476	MAG: Candidatus Ozemobacteraceae bacterium isolate 4ee0fdf2-fbb4-4151-bfa0-813162405533 genome assembly, chromosome: 2	blastn	551	202	1	Bacteria	Bacteria candidate phyla		Candidatus Ozemobacteria		Candidatus Ozemobacteraceae		Candidatus Ozemobacteraceae bacterium
1653958	1653958	PRJNA312899_P_NODE_2282_length_1081_cov_32.059109_g2080_i0	PRJNA312899	2282	1081	32.059109	346.55896829	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	1991	0	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g2080	i0	99.907	246.63644773358	1081	1	100	0	1	1081	851529	850449	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	266614	1991	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
1654685	1654685	PRJNA312899_P_NODE_62082_length_213_cov_1.243902_g61640_i0	PRJNA312899	62082	213	1.243902	2.64951126	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	350	5.94e-92	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g61640	i0	96.244	6.97652582159624	213	8	100	0	1	213	62076	62288	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	1486	350	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
2930736	2930736	PRJNA312899_P_NODE_73283_length_188_cov_1.467626_g72841_i0	PRJNA312899	73283	188	1.467626	2.75913688	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	145	2.58e-30	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g72841	i0	93.75	1.1063829787234	96	6	51	0	1	96	435573	435668	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	208	145	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria genomosp. TM7-H1
2931099	2931099	PRJNA312899_P_NODE_95983_length_163_cov_1.789474_g95541_i0	PRJNA312899	95983	163	1.789474	2.91684262	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	132	1.7e-26	NTclustered	gi\|2874253687\|emb\|OY969413.1\|	2030810	g95541	i0	81.928	4.86503067484663	166	21	99	6	1	162	886208	886048	MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1	blastn	793	132	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria bacterium
9308370	9308370	PRJNA312899_P_NODE_89508_length_166_cov_0.871795_g89066_i0	PRJNA312899	89508	166	0.871795	1.4471797	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	302	1.2500000000000001e-77	NTclustered	gi\|2218410560\|gb\|CP089288.1\|	2899133	g89066	i0	99.398	11.9879518072289	166	1	100	0	1	166	135775	135610	Candidatus Nanosynbacter sp. HMT-352 strain TM7-037 chromosome	blastn	1990	302	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
10583207	10583207	PRJNA312899_P_NODE_28029_length_350_cov_29.730897_g27587_i0	PRJNA312899	28029	350	29.730897	104.0581395	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	453	7.760000000000001e-123	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g27587	i0	90.23	78.1257142857143	348	33	99	1	3	350	814382	814036	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	27344	453	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
10583280	10583280	PRJNA312899_P_NODE_32249_length_322_cov_54.710623_g31807_i0	PRJNA312899	32249	322	54.710623	176.16820606	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|1950815156\|gb\|CP066686.1\|	2026804	g31807	i0	100	0.0869565217391304	28	0	9	0	184	211	482302	482275	MAG: Candidatus Woesebacteria bacterium isolate NC_groundwater_442_Ag_B-0.1um_40_41 chromosome	blastn	28	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota					Candidatus Woesebacteria bacterium
10584115	10584115	PRJNA312899_P_NODE_82449_length_174_cov_1.632000_g82007_i0	PRJNA312899	82449	174	1.632	2.83968	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	311	2.19e-80	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g82007	i0	98.857	1.00574712643678	175	1	100	1	1	174	491671	491497	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	175	311	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria genomosp. TM7-H1
11267555	11267555	PRJNA312899_P_NODE_1769_length_1184_cov_22.917181_g183_i2	PRJNA312899	1769	1184	22.917181	271.33942304	Bacteria	2	Bacteria	Bacteria	939	0	NTclustered	gi\|507148395\|ref\|NR_103198.1\|	671143	g183	i2	82.214	888.858108108108	1102	184	92	9	1	1094	2983	1886	Candidatus Methylomirabilis oxyfera 23S ribosomal RNA gene, complete sequence	blastn	1052408	948	0.990506329113924	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis oxygeniifera
11857827	11857827	PRJNA312899_P_NODE_230_length_2253_cov_43.495463_g210_i0	PRJNA312899	230	2253	43.495463	979.95278139	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	3092	0	NTclustered	gi\|2893356064\|emb\|OZ220487.1\|	3036252	g210	i0	95.734	26.4403018197958	1922	79	85	3	334	2253	3095644	3097564	MAG: uncultured Candidatus Binatia bacterium isolate d2d8104a-f810-4fb4-bb0c-dc82b69497ba genome assembly, chromosome: 1	blastn	59570	3092	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				uncultured Candidatus Binatia bacterium
20781618	20781618	PRJNA312899_P_NODE_74497_length_186_cov_3.963504_g74055_i0	PRJNA312899	74497	186	3.963504	7.37211744	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	209	8.92e-50	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g74055	i0	87.097	7.55913978494624	186	23	99	1	2	186	891624	891439	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	1406	209	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium HOT-871
24605643	24605643	PRJNA312899_P_NODE_45400_length_261_cov_10.400943_g44958_i0	PRJNA312899	45400	261	10.400943	27.14646123	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	481	2.56e-131	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g44958	i0	100	419.325670498084	260	0	99	0	2	261	850115	849856	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	109444	481	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
24606207	24606207	PRJNA312899_P_NODE_76300_length_184_cov_1.511111_g75858_i0	PRJNA312899	76300	184	1.511111	2.78044424	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	268	1.43e-67	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g75858	i0	92.935	6.93478260869565	184	13	100	0	1	184	183610	183427	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	1276	268	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;