metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA599208" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA599208" 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
572160	572160	PRJNA599208_P_NODE_12081_length_188_cov_0.973510_g11885_i0	PRJNA599208	12081	188	0.97351	1.8301988	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	244	2.48e-60	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g11885	i0	90.761	171.085106382979	184	15	97	2	6	188	27750	27932	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	32164	244	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
572186	572186	PRJNA599208_P_NODE_1481_length_780_cov_5.721400_g1349_i0	PRJNA599208	1481	780	5.7214	44.62692	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	1190	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g1349	i0	94.231	106.096153846154	780	44	100	1	1	780	1087	1865	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	82755	1190	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
1848028	1848028	PRJNA599208_P_NODE_5802_length_323_cov_2.213287_g5606_i0	PRJNA599208	5802	323	2.213287	7.14891701	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	291	5.9e-74	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g5606	i0	83.385	98.3962848297214	325	42	99	10	3	323	276408	276724	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	31782	291	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
3692984	3692984	PRJNA599208_P_NODE_8683_length_240_cov_2.152709_g8487_i0	PRJNA599208	8683	240	2.152709	5.1665016	Opitutaceae	134623	Bacteria	Bacteria	444	3.05e-120	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g8487	i0	100	117.595833333333	240	0	100	0	1	240	2498669	2498430	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	28223	444	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
4399975	4399975	PRJNA599208_P_NODE_8344_length_248_cov_1.184834_g8148_i0	PRJNA599208	8344	248	1.184834	2.93838832	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	409	1.16e-109	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g8148	i0	96.371	287.120967741935	248	9	100	0	1	248	1066	819	Luteolibacter sp. SL250 chromosome	blastn	71206	409	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
4969591	4969591	PRJNA599208_P_NODE_4564_length_383_cov_38.413295_g4369_i0	PRJNA599208	4564	383	38.413295	147.12291985	Verrucomicrobiaceae	203557	Bacteria	Bacteria	468	3.06e-127	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g4369	i0	88.743	265.845953002611	382	43	99	0	1	382	633533	633914	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	101819	468	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
5675944	5675944	PRJNA599208_P_NODE_16505_length_151_cov_2.807018_g16309_i0	PRJNA599208	16505	151	2.807018	4.23859718	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	174	2.52e-39	NTclustered	gi\|164510704\|emb\|AJ966883.1\|	48466	g16309	i0	87.5	160.364238410596	152	18	100	1	1	151	4653	4804	Prosthecobacter vanneervenii 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 12252	blastn	24215	174	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
6950582	6950582	PRJNA599208_P_NODE_9886_length_218_cov_1.497238_g9690_i0	PRJNA599208	9886	218	1.497238	3.26397884	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	281	2.26e-71	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g9690	i0	90.045	122.977064220183	221	17	99	5	2	218	1315429	1315648	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	26809	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9500744	9500744	PRJNA599208_P_NODE_6828_length_287_cov_4.496000_g6632_i0	PRJNA599208	6828	287	4.496	12.90352	Akkermansia muciniphila	239935	Bacteria	Bacteria	307	5.13e-79	NTclustered	gi\|2756360508\|gb\|CP156688.1\|	239935	g6632	i0	85.959	298.15331010453	292	35	100	5	1	287	361883	361593	Akkermansia muciniphila strain AKK-TMU chromosome, complete genome	blastn	85570	307	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
10776452	10776452	PRJNA599208_P_NODE_1109_length_937_cov_6.073333_g1004_i0	PRJNA599208	1109	937	6.073333	56.90713021	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	1592	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g1004	i0	97.332	279.79295624333	937	25	100	0	1	937	193	1129	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	262166	1592	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
10776515	10776515	PRJNA599208_P_NODE_2229_length_606_cov_2.829525_g2056_i0	PRJNA599208	2229	606	2.829525	17.1469215	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	292	3.2499999999999993e-74	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g2056	i0	90.95	114.23597359736	221	14	81	6	1	216	914120	914339	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	69227	292	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10776600	10776600	PRJNA599208_P_NODE_7969_length_256_cov_1.461187_g7773_i0	PRJNA599208	7969	256	1.461187	3.74063872	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	169	2.21e-37	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g7773	i0	90.625	65.36328125	128	11	50	1	34	160	15668	15541	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	16733	169	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
12051485	12051485	PRJNA599208_P_NODE_8570_length_242_cov_4.204878_g8374_i0	PRJNA599208	8570	242	4.204878	10.17580476	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	263	9.250000000000001e-66	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g8374	i0	86.364	271.330578512397	242	32	100	1	1	242	277112	276872	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	65662	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
13326221	13326221	PRJNA599208_P_NODE_4471_length_390_cov_14.586402_g4277_i0	PRJNA599208	4471	390	14.586402	56.8869678	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	459	1.8799999999999998e-124	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g4277	i0	88.041	283.74358974359	393	40	100	6	1	390	2080	2468	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	110660	459	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
13895466	13895466	PRJNA599208_P_NODE_12491_length_183_cov_2.301370_g12295_i0	PRJNA599208	12491	183	2.30137	4.2115071	Verrucomicrobiota	74201	Bacteria	Bacteria	141	3.23e-29	NTclustered	gi\|2889362999\|gb\|CP151838.1\|	454148	g12295	i0	82.716	10.6885245901639	162	25	87	2	24	183	781378	781538	Roseibacillus persicicus strain AS69 chromosome, complete genome	blastn	1956	141	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseibacillus	Roseibacillus persicicus
14601208	14601208	PRJNA599208_P_NODE_8332_length_248_cov_1.644550_g8136_i0	PRJNA599208	8332	248	1.64455	4.0784840000000004	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	420	5.34e-113	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g8136	i0	97.177	287.008064516129	248	7	100	0	1	248	1319935	1319688	Luteolibacter sp. Populi chromosome, complete genome	blastn	71178	420	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
15169626	15169626	PRJNA599208_P_NODE_10132_length_214_cov_1.870056_g9936_i0	PRJNA599208	10132	214	1.870056	4.00191984	Bacteria	2	Bacteria	Bacteria	243	1.0400000000000001e-59	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g9936	i0	89.637	14.6542056074766	193	16	89	4	3	192	3832121	3832312	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	3136	243	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15874989	15874989	PRJNA599208_P_NODE_2593_length_552_cov_10.277670_g2410_i0	PRJNA599208	2593	552	10.27767	56.7327384	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	601	4.299999999999998e-167	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g2410	i0	86.462	271.188405797101	554	68	100	7	1	552	5625023	5625571	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	149696	601	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
18424128	18424128	PRJNA599208_P_NODE_11775_length_191_cov_1.980519_g11579_i0	PRJNA599208	11775	191	1.980519	3.78279129	Fontisphaera persica	2974023	Bacteria	Bacteria	250	5.43e-62	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g11579	i0	93.023	20.9738219895288	172	10	90	2	21	191	3861699	3861869	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	4006	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
18992912	18992912	PRJNA599208_P_NODE_7495_length_268_cov_2.922078_g7299_i0	PRJNA599208	7495	268	2.922078	7.83116904	Verrucomicrobiales	48461	Bacteria	Bacteria	263	1.04e-65	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g7299	i0	94.675	104.276119402985	169	9	63	0	1	169	3412679	3412511	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	27946	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
19698684	19698684	PRJNA599208_P_NODE_12176_length_187_cov_1.013333_g11980_i0	PRJNA599208	12176	187	1.013333	1.89493271	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	165	1.97e-36	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g11980	i0	82.723	175.27807486631	191	27	100	6	1	187	2751025	2750837	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	32777	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
19698776	19698776	PRJNA599208_P_NODE_4996_length_359_cov_3.049689_g4801_i0	PRJNA599208	4996	359	3.049689	10.94838351	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	449	1.0299999999999999e-121	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g4801	i0	96.667	85.4986072423398	270	9	75	0	1	270	2497091	2497360	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	30694	449	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
20974464	20974464	PRJNA599208_P_NODE_12217_length_186_cov_2.026846_g12021_i0	PRJNA599208	12217	186	2.026846	3.76993356	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	278	2.41e-70	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g12021	i0	93.548	14.1774193548387	186	12	100	0	1	186	1165	1350	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	2637	278	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
20974571	20974571	PRJNA599208_P_NODE_7177_length_277_cov_2.075000_g6981_i0	PRJNA599208	7177	277	2.075	5.74775	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	335	2.2599999999999993e-87	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g6981	i0	88.489	13.2924187725632	278	30	100	2	1	277	277454	277730	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	3682	335	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
22818703	22818703	PRJNA599208_P_NODE_7158_length_277_cov_4.625000_g6962_i0	PRJNA599208	7158	277	4.625	12.81125	Verrucomicrobiota	74201	Bacteria	Bacteria	281	2.99e-71	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g6962	i0	85.401	80.3465703971119	274	36	98	4	6	277	885	1156	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	22256	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
23524582	23524582	PRJNA599208_P_NODE_14019_length_169_cov_1.750000_g13823_i0	PRJNA599208	14019	169	1.75	2.9575	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	278	2.14e-70	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g13823	i0	96.429	47.0710059171598	168	6	99	0	1	168	1404311	1404478	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	7955	278	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
23524593	23524593	PRJNA599208_P_NODE_14879_length_162_cov_2.432000_g14683_i0	PRJNA599208	14879	162	2.432	3.93984	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	261	2.06e-65	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g14683	i0	95.679	116.432098765432	162	7	100	0	1	162	1321793	1321954	Luteolibacter sp. Populi chromosome, complete genome	blastn	18862	261	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
24798433	24798433	PRJNA599208_P_NODE_1820_length_691_cov_6.555046_g1665_i0	PRJNA599208	1820	691	6.555046	45.29536786	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	503	1.58e-137	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g1665	i0	81.938	236.021707670043	609	96	87	13	1	601	26794	27396	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	163091	503	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium

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