metadata: contig_metadata: 16 rows where bioproject = "PRJNA495917", tax_clade = "PVC group" and tax

16 rows where bioproject = "PRJNA495917", tax_clade = "PVC group" 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
3028473	3028473	PRJNA495917_S_NODE_4083_length_245_cov_2.828571_g3889_i0	PRJNA495917	4083	245	2.828571	6.92999895	Pedosphaera parvula	1032527	Bacteria	Bacteria	307	4.2700000000000006e-79	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g3889	i0	90	98.4040816326531	240	20	97	4	6	242	961	1199	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	24109	307	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
6855141	6855141	PRJNA495917_S_NODE_2546_length_306_cov_133.029520_g2352_i0	PRJNA495917	2546	306	133.02952	407.0703312	Luteolibacter sp.	1962973	Bacteria	Bacteria	462	1.11e-125	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g2352	i0	94.631	265.513071895425	298	16	97	0	1	298	1009079	1008782	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	81247	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
10681166	10681166	PRJNA495917_S_NODE_3069_length_280_cov_2.685714_g2875_i0	PRJNA495917	3069	280	2.685714	7.5199992	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	241	5.130000000000001e-59	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g2875	i0	82.784	150.735714285714	273	44	97	3	1	272	1317348	1317078	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	42206	241	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13231381	13231381	PRJNA495917_S_NODE_4111_length_244_cov_3.684211_g3917_i0	PRJNA495917	4111	244	3.684211	8.98947484	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	399	6.819999999999998e-107	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g3917	i0	96.311	364.401639344262	244	7	100	2	1	244	3411668	3411427	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	88914	399	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
13861499	13861499	PRJNA495917_S_NODE_13751_length_158_cov_3.747967_g13557_i0	PRJNA495917	13751	158	3.747967	5.92178786	Verrucomicrobiales	48461	Bacteria	Bacteria	231	1.5599999999999998e-56	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g13557	i0	93.038	71.4240506329114	158	11	100	0	1	158	3411389	3411232	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	11285	231	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
14506305	14506305	PRJNA495917_S_NODE_9052_length_180_cov_2.813793_g8858_i0	PRJNA495917	9052	180	2.813793	5.0648274	Luteolibacter sp.	1962973	Bacteria	Bacteria	243	8.439999999999999e-60	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g8858	i0	92.398	16.8055555555556	171	12	95	1	10	180	1010378	1010209	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	3025	243	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
15780144	15780144	PRJNA495917_S_NODE_2893_length_288_cov_5.241107_g2699_i0	PRJNA495917	2893	288	5.241107	15.09438816	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	220	6.8999999999999985e-53	NTclustered	gi\|2916415364\|gb\|CP170459.1\|	2026799	g2699	i0	89.266	18.4097222222222	177	18	61	1	78	254	2577506	2577331	MAG: Verrucomicrobiota bacterium isolate tig00002468 chromosome, complete genome	blastn	5302	220	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
17054945	17054945	PRJNA495917_S_NODE_954_length_484_cov_5.118040_g764_i0	PRJNA495917	954	484	5.11804	24.7713136	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	372	3.19e-98	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g764	i0	82.759	196.431818181818	435	58	87	15	1	423	3990449	3990020	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	95073	372	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
18329036	18329036	PRJNA495917_S_NODE_10435_length_172_cov_3.656934_g10241_i0	PRJNA495917	10435	172	3.656934	6.28992648	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	265	1.7e-66	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g10241	i0	94.706	226.866279069767	170	9	99	0	3	172	1522	1353	Luteolibacter sp. SL250 chromosome	blastn	39021	265	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
18329180	18329180	PRJNA495917_S_NODE_6595_length_201_cov_4.433735_g6401_i0	PRJNA495917	6595	201	4.433735	8.91180735	Luteolibacter sp.	1962973	Bacteria	Bacteria	294	2.63e-75	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g6401	i0	93.035	93.8407960199005	201	14	100	0	1	201	1010042	1010242	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	18862	294	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
20234329	20234329	PRJNA495917_S_NODE_3956_length_248_cov_302.023474_g3762_i0	PRJNA495917	3956	248	302.023474	749.01821552	Fontisphaera	3050007	Bacteria	Bacteria	342	1.1899999999999999e-89	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g3762	i0	91.633	115.201612903226	251	15	100	5	1	248	1316814	1317061	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	28570	342	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23429857	23429857	PRJNA495917_S_NODE_13279_length_160_cov_1.560000_g13085_i0	PRJNA495917	13279	160	1.56	2.496	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	63.9	6.13e-6	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g13085	i0	95.122	0.25625	41	1	25	1	41	80	915874	915834	Lacunisphaera limnophila strain IG16b, complete genome	blastn	41	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
27929842	27929842	PRJNA495917_S_NODE_5345_length_219_cov_1.956522_g5151_i0	PRJNA495917	5345	219	1.956522	4.28478318	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	42.4	0.0382	NR	MBE2181581.1	2201154	g5151	i0	33.9	0.849315068493151	62	38	80.8	1	188	12	990	1051	MBE2181581.1 SDR family NAD(P)-dependent oxidoreductase [Chthoniobacterales bacterium]	diamond	186	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
30171705	30171705	PRJNA495917_S_NODE_13592_length_159_cov_1.290323_g13398_i0	PRJNA495917	13592	159	1.290323	2.05161357	Coraliomargarita sp. SDUM461	2024828	Bacteria	Bacteria	57	1.6e-8	NR	WP_308984314.1	3041258	g13398	i0	54.2	1.45283018867925	48	21	88.7	1	18	158	7	54	WP_308984314.1 DUF4326 domain-containing protein [Coraliomargarita sp. SDUM461004]	diamond	231	57	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Thalassobacterium	Thalassobacterium sedimentorum
31941763	31941763	PRJNA495917_S_NODE_6797_length_199_cov_3.036585_g6603_i0	PRJNA495917	6797	199	3.036585	6.04280415	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	42.7	0.021	NR	MFT5470505.1	2026801	g6603	i0	36.4	0.994974874371859	66	41	98	1	2	196	103	168	MFT5470505.1 MFS family permease [Verrucomicrobiales bacterium]	diamond	198	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32495527	32495527	PRJNA495917_S_NODE_16779_length_150_cov_1.391304_g16585_i0	PRJNA495917	16779	150	1.391304	2.086956	Pseudomonadati	3379134	Bacteria	Bacteria	53.9	1.15e-6	NR	HXU58913.1	2499141	g16585	i0	51.2	4.1	41	20	82	0	145	23	61	101	HXU58913.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	615	53.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia 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);;