metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA669701" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA669701" and tax_phylum = "Verrucomicrobiota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
636519	636519	PRJNA669701_P_NODE_88381_length_272_cov_1.391960_g87986_i0	PRJNA669701	88381	272	1.39196	3.7861312	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	172	1.84e-38	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g87986	i0	80.169	0.871323529411765	237	41	86	5	23	256	4816730	4816963	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	237	172	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
1912203	1912203	PRJNA669701_P_NODE_62662_length_310_cov_2.654008_g62267_i0	PRJNA669701	62662	310	2.654008	8.2274248	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	147	1.29e-30	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g62267	i0	85.315	38.5	143	19	79	2	1	142	637684	637825	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	11935	147	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
3187299	3187299	PRJNA669701_P_NODE_90843_length_269_cov_1.510204_g90448_i0	PRJNA669701	90843	269	1.510204	4.06244876	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	259	1.35e-64	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g90448	i0	84.015	1	269	43	100	0	1	269	2099950	2099682	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	269	259	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
4992141	4992141	PRJNA669701_P_NODE_125384_length_246_cov_0.890173_g124989_i0	PRJNA669701	125384	246	0.890173	2.18982558	Luteolibacter	518753	Bacteria	Bacteria	222	1.5999999999999996e-53	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g124989	i0	83.983	11.8739837398374	231	37	94	0	1	231	2062862	2063092	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	2921	222	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
8288442	8288442	PRJNA669701_P_NODE_123587_length_246_cov_1.387283_g123192_i0	PRJNA669701	123587	246	1.387283	3.41271618	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	174	4.55e-39	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g123192	i0	79.832	3.63008130081301	238	48	97	0	9	246	3493455	3493692	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	893	174	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9563610	9563610	PRJNA669701_P_NODE_121368_length_247_cov_0.885057_g120973_i0	PRJNA669701	121368	247	0.885057	2.18609079	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	189	1.6299999999999999e-43	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g120973	i0	82.629	0.862348178137652	213	37	86	0	19	231	1529611	1529823	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	213	189	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9564742	9564742	PRJNA669701_P_NODE_78588_length_284_cov_0.872038_g78193_i0	PRJNA669701	78588	284	0.872038	2.47658792	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	182	3.21e-41	NTclustered	gi\|2874253793\|emb\|OY969777.1\|	412056	g78193	i0	79.087	16.1443661971831	263	55	93	0	14	276	1173677	1173939	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1	blastn	4585	182	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10839133	10839133	PRJNA669701_P_NODE_110209_length_250_cov_2.129944_g109814_i0	PRJNA669701	110209	250	2.129944	5.32486	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	213	9.81e-51	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g109814	i0	82.449	55.332	245	41	98	2	1	244	1170184	1170427	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	13833	213	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10839443	10839443	PRJNA669701_P_NODE_134549_length_243_cov_0.905882_g134154_i0	PRJNA669701	134549	243	0.905882	2.20129326	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g134154	i0	99.588	159.337448559671	243	1	100	0	1	243	15707	15949	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	38719	444	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
10839470	10839470	PRJNA669701_P_NODE_136569_length_242_cov_2.544379_g136174_i0	PRJNA669701	136569	242	2.544379	6.15739718	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	243	1.2100000000000004e-59	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g136174	i0	85	1.22314049586777	240	34	99	2	3	241	144116	144354	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	296	243	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10840130	10840130	PRJNA669701_P_NODE_62229_length_310_cov_3.303797_g61834_i0	PRJNA669701	62229	310	3.303797	10.2417707	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	124	6.049999999999999e-24	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g61834	i0	87.156	0.351612903225806	109	14	35	0	42	150	6217637	6217745	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	109	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
11367227	11367227	PRJNA669701_P_NODE_101789_length_257_cov_1.434783_g101394_i0	PRJNA669701	101789	257	1.434783	3.68739231	Opitutaceae	134623	Bacteria	Bacteria	254	5.970000000000001e-63	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g101394	i0	87.33	83.9922178988327	221	28	86	0	1	221	2769396	2769176	Lacunisphaera limnophila strain IG16b, complete genome	blastn	21586	254	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
12114206	12114206	PRJNA669701_P_NODE_103650_length_255_cov_1.329670_g103255_i0	PRJNA669701	103650	255	1.32967	3.3906585	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	228	3.589999999999999e-55	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g103255	i0	82.745	9.95686274509804	255	44	100	0	1	255	4718109	4718363	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	2539	228	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
12115074	12115074	PRJNA669701_P_NODE_41610_length_368_cov_1.149153_g41215_i0	PRJNA669701	41610	368	1.149153	4.22888304	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	283	1.14e-71	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g41215	i0	80.8	2.71467391304348	375	60	100	12	1	368	5458136	5458505	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	999	283	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13389354	13389354	PRJNA669701_P_NODE_134411_length_243_cov_0.905882_g134016_i0	PRJNA669701	134411	243	0.905882	2.20129326	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	270	5.5499999999999986e-68	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g134016	i0	89.623	89.59670781893	212	22	87	0	32	243	5777991	5778202	Luteolibacter sp. LG18 DNA, complete genome	blastn	21772	270	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
13390179	13390179	PRJNA669701_P_NODE_71811_length_292_cov_2.027397_g71416_i0	PRJNA669701	71811	292	2.027397	5.91999924	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	263	1.15e-65	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g71416	i0	83.505	54.0821917808219	291	38	98	10	4	289	1051143	1050858	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	15792	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13390314	13390314	PRJNA669701_P_NODE_81211_length_280_cov_2.391304_g80816_i0	PRJNA669701	81211	280	2.391304	6.6956512	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	102	2.53e-17	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g80816	i0	84.404	0.389285714285714	109	11	38	6	10	115	2086033	2085928	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	109	102	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
17213962	17213962	PRJNA669701_P_NODE_55934_length_324_cov_1.693227_g55539_i0	PRJNA669701	55934	324	1.693227	5.48605548	Opitutaceae bacterium TAV5	794903	Bacteria	Bacteria	254	7.77e-63	NTclustered	gi\|573471959\|gb\|CP007053.1\|	794903	g55539	i0	83.824	89.1882716049383	272	38	83	5	3	271	4261104	4261372	Opitutaceae bacterium TAV5, complete genome	blastn	28897	254	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
18487388	18487388	PRJNA669701_P_NODE_110935_length_250_cov_0.870056_g110540_i0	PRJNA669701	110935	250	0.870056	2.17514	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	307	4.3800000000000005e-79	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g110540	i0	89.796	9.152	245	17	96	6	10	248	4793527	4793285	Luteolibacter sp. SL250 chromosome	blastn	2288	307	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
18487402	18487402	PRJNA669701_P_NODE_111975_length_250_cov_0.870056_g111580_i0	PRJNA669701	111975	250	0.870056	2.17514	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	204	5.909999999999999e-48	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g111580	i0	83.258	21.504	221	37	88	0	30	250	5319579	5319799	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	5376	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
18487427	18487427	PRJNA669701_P_NODE_113675_length_249_cov_1.454545_g113280_i0	PRJNA669701	113675	249	1.454545	3.62181705	Luteolibacter luteus	2728835	Bacteria	Bacteria	329	9.3e-86	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g113280	i0	91.597	3.68273092369478	238	20	96	0	9	246	4603015	4603252	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	917	329	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
19761930	19761930	PRJNA669701_P_NODE_114456_length_249_cov_0.875000_g114061_i0	PRJNA669701	114456	249	0.875	2.17875	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	124	4.709999999999999e-24	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g114061	i0	80	0.682730923694779	170	33	68	1	3	171	2185671	2185502	Luteolibacter sp. SL250 chromosome	blastn	170	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
21037970	21037970	PRJNA669701_P_NODE_145397_length_234_cov_2.124224_g145002_i0	PRJNA669701	145397	234	2.124224	4.97068416	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	195	3.29e-45	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g145002	i0	81.78	1.00854700854701	236	39	100	4	1	234	4802438	4802671	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	236	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
21038014	21038014	PRJNA669701_P_NODE_148737_length_214_cov_4.964539_g148342_i0	PRJNA669701	148737	214	4.964539	10.62411346	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	154	5.02e-33	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g148342	i0	80.583	1.28504672897196	206	34	95	5	3	205	2634361	2634563	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	275	154	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
22312839	22312839	PRJNA669701_P_NODE_149138_length_208_cov_4.044444_g148743_i0	PRJNA669701	149138	208	4.044444	8.41244352	Chthoniobacter flavus	191863	Bacteria	Bacteria	335	1.6199999999999996e-87	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g148743	i0	95.673	242.716346153846	208	9	100	0	1	208	2632	2839	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	50485	335	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
24861222	24861222	PRJNA669701_P_NODE_112940_length_250_cov_0.870056_g112545_i0	PRJNA669701	112940	250	0.870056	2.17514	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	292	1.2299999999999999e-74	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g112545	i0	88.983	9.396	236	26	94	0	14	249	4482150	4482385	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	2349	292	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
24862313	24862313	PRJNA669701_P_NODE_69340_length_297_cov_1.031250_g68945_i0	PRJNA669701	69340	297	1.03125	3.0628125	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	171	7.299999999999999e-38	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g68945	i0	84.795	0.848484848484849	171	24	57	2	127	296	2480366	2480197	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	252	171	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24862545	24862545	PRJNA669701_P_NODE_85960_length_275_cov_1.252475_g85565_i0	PRJNA669701	85960	275	1.252475	3.44430625	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	191	5.13e-44	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g85565	i0	81.07	25.5636363636364	243	42	88	4	3	243	539552	539792	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	7030	191	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
25391186	25391186	PRJNA669701_P_NODE_85040_length_276_cov_1.344828_g84645_i0	PRJNA669701	85040	276	1.344828	3.71172528	Luteolibacter	518753	Bacteria	Bacteria	148	3.1499999999999996e-31	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g84645	i0	90.265	5.55072463768116	113	11	41	0	1	113	4760038	4759926	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	1532	148	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus

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);;