metadata: contig_metadata: 19 rows where bioproject = "PRJNA929952" and tax

19 rows where bioproject = "PRJNA929952" 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
2530475	2530475	PRJNA929952_P_NODE_2782_length_733_cov_4.593750_g642_i3	PRJNA929952	2782	733	4.59375	33.6721875	Opitutaceae	134623	Bacteria	Bacteria	800	0	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g642	i3	91.216	86.4679399727149	592	46	99	5	1	587	2834443	2833853	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	63381	800	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
7287246	7287246	PRJNA929952_P_NODE_2006_length_838_cov_25.721879_g106_i3	PRJNA929952	2006	838	25.721879	215.54934602	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1040	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g106	i3	94.041	112.965393794749	688	38	82	3	1	686	1315688	1316374	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	94665	1040	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
7287249	7287249	PRJNA929952_P_NODE_2086_length_823_cov_5.200252_g642_i1	PRJNA929952	2086	823	5.200252	42.79807396	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	998	0	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g642	i1	94.844	84.0315917375456	640	31	94	2	182	821	3557383	3556746	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	69158	998	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
8562079	8562079	PRJNA929952_P_NODE_15287_length_263_cov_3.529915_g13993_i0	PRJNA929952	15287	263	3.529915	9.28367645	Pedosphaera parvula	1032527	Bacteria	Bacteria	263	1.02e-65	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g13993	i0	83.083	10.8250950570342	266	42	100	1	1	263	835	1100	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	2847	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
8562108	8562108	PRJNA929952_P_NODE_5927_length_508_cov_5.670146_g4822_i0	PRJNA929952	5927	508	5.670146	28.80434168	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	702	0	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g4822	i0	99.482	60.9251968503937	386	2	76	0	1	386	3555593	3555978	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	30950	702	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
9837154	9837154	PRJNA929952_P_NODE_22868_length_170_cov_2.510638_g21574_i0	PRJNA929952	22868	170	2.510638	4.2680846	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	161	2.26e-35	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g21574	i0	85.443	0.929411764705882	158	19	91	4	16	170	1729067	1729223	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	158	161	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10183487	10183487	PRJNA929952_P_NODE_20928_length_195_cov_3.632530_g19634_i0	PRJNA929952	20928	195	3.63253	7.0834335	Opitutaceae	134623	Bacteria	Bacteria	257	3.33e-64	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g19634	i0	91.053	64.2717948717949	190	17	97	0	6	195	2498456	2498645	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	12533	257	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
11112779	11112779	PRJNA929952_P_NODE_15349_length_262_cov_8.613734_g14055_i0	PRJNA929952	15349	262	8.613734	22.56798308	uncultured Opitutia bacterium	575426	Bacteria	Bacteria	390	4.4599999999999996e-104	NTclustered	gi\|451919372\|gb\|KC453236.1\|	575426	g14055	i0	94.821	94.8778625954198	251	11	95	2	1	250	250	1	Uncultured Opitutae bacterium clone RLBp5626 16S ribosomal RNA gene, partial sequence	blastn	24858	390	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				uncultured Opitutia bacterium
12388291	12388291	PRJNA929952_P_NODE_10210_length_361_cov_1.701807_g8927_i0	PRJNA929952	10210	361	1.701807	6.14352327	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	117	1.2e-21	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g8927	i0	89.247	15.4349030470914	93	10	26	0	160	252	1904166	1904258	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	5572	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
12388349	12388349	PRJNA929952_P_NODE_910_length_1155_cov_4.797513_g642_i0	PRJNA929952	910	1155	4.797513	55.41127515	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	1587	0	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g642	i0	95.134	84.4112554112554	1007	47	99	2	147	1153	3557333	3556329	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	97495	1587	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
13662799	13662799	PRJNA929952_P_NODE_2691_length_742_cov_577.830295_g1994_i0	PRJNA929952	2691	742	577.830295	4287.5007889	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	767	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g1994	i0	92.265	192.764150943396	543	38	73	4	200	742	1316810	1317348	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	143031	767	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13662803	13662803	PRJNA929952_P_NODE_3871_length_634_cov_27.224793_g2976_i0	PRJNA929952	3871	634	27.224793	172.60518762	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	628	2.2899999999999998e-175	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g2976	i0	89.442	99.7649842271293	502	48	95	3	134	634	1315425	1314928	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	63251	628	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14937138	14937138	PRJNA929952_P_NODE_8052_length_424_cov_10.275949_g6803_i0	PRJNA929952	8052	424	10.275949	43.57002376	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	723	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g6803	i0	97.406	281.801886792453	424	11	100	0	1	424	1995	2418	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	119484	723	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
18760783	18760783	PRJNA929952_P_NODE_23635_length_161_cov_3.946970_g22341_i0	PRJNA929952	23635	161	3.94697	6.3546217	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	226	7.449999999999999e-55	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g22341	i0	91.925	69.583850931677	161	13	100	0	1	161	5153843	5154003	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	11203	226	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18760788	18760788	PRJNA929952_P_NODE_3515_length_664_cov_13.144882_g2681_i0	PRJNA929952	3515	664	13.144882	87.28201648	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	1090	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g2681	i0	96.784	277.263554216867	653	21	98	0	12	664	1171	519	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	184103	1090	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
19106222	19106222	PRJNA929952_P_NODE_2115_length_818_cov_4.519645_g642_i2	PRJNA929952	2115	818	4.519645	36.9706961	Verrucomicrobiota	74201	Bacteria	Bacteria	841	0	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g642	i2	90.484	82.1295843520782	641	56	93	4	182	818	652	1291	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	67182	843	0.997627520759193	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
20035756	20035756	PRJNA929952_P_NODE_13996_length_281_cov_4.130952_g12703_i0	PRJNA929952	13996	281	4.130952	11.60797512	Pedosphaera parvula	1032527	Bacteria	Bacteria	274	5.08e-69	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g12703	i0	84.342	215.772241992883	281	42	99	2	3	281	2853	2573	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	60632	274	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
21311223	21311223	PRJNA929952_P_NODE_11717_length_324_cov_13.450847_g1809_i1	PRJNA929952	11717	324	13.450847	43.58074428	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	483	9.11e-132	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g1809	i1	93.538	47.7592592592593	325	19	100	2	1	324	184	507	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	15474	483	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
22586154	22586154	PRJNA929952_P_NODE_2458_length_769_cov_7.320270_g1809_i0	PRJNA929952	2458	769	7.32027	56.2928763	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	621	4.689999999999999e-173	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g1809	i0	93.541	69.7087126137841	418	25	95	2	353	769	3557639	3558055	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	53606	621	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1

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