metadata: contig_metadata: 18 rows where bioproject = "PRJNA939369", tax_clade = "PVC group" and tax

18 rows where bioproject = "PRJNA939369", 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
8567555	8567555	PRJNA939369_S_NODE_75087_length_241_cov_1.821429_g74670_i0	PRJNA939369	75087	241	1.821429	4.38964389	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	412	8.64e-111	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g74670	i0	97.51	112.423236514523	241	6	100	0	1	241	735640	735880	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	27094	412	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8908872	8908872	PRJNA939369_S_NODE_18967_length_343_cov_2.959259_g18550_i0	PRJNA939369	18967	343	2.959259	10.15025837	Akkermansia	239934	Bacteria	Bacteria	573	5.599999999999998e-159	NTclustered	gi\|2051360498\|gb\|CP072032.1\|	239935	g18550	i0	96.793	296	343	11	100	0	1	343	395293	394951	Akkermansia muciniphila strain Akk1613 chromosome, complete genome	blastn	101528	573	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
9842216	9842216	PRJNA939369_S_NODE_19488_length_340_cov_2.741573_g19071_i0	PRJNA939369	19488	340	2.741573	9.3213482	Rubellicoccus peritrichatus	3080537	Bacteria	Bacteria	309	1.7300000000000003e-79	NTclustered	gi\|2605121622\|gb\|CP136920.1\|	3080537	g19071	i0	83.988	184.055882352941	331	43	96	9	1	326	2161657	2161982	Rubellicoccus peritrichatus strain CR14 isolate coral tank chromosome, complete genome	blastn	62579	309	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Rubellicoccus	Rubellicoccus peritrichatus
9842458	9842458	PRJNA939369_S_NODE_54848_length_251_cov_0.865169_g54431_i0	PRJNA939369	54848	251	0.865169	2.17157419	Pseudomonadati	3379134	Bacteria	Bacteria	176	7.08e-51	NR	HCG20426.1	2026799	g54431	i0	95.2	19.8406374501992	83	4	99.2	0	250	2	10	92	HCG20426.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase GatCAB subunit B [Verrucomicrobiota bacterium]	diamond	4980	177	0.994350282485876	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
13667855	13667855	PRJNA939369_S_NODE_18671_length_345_cov_1.470588_g18254_i0	PRJNA939369	18671	345	1.470588	5.0735286	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	363	1.33e-95	NTclustered	gi\|2225500096\|gb\|CP095464.1\|	2026799	g18254	i0	87.077	331.91884057971	325	36	93	6	1	322	594236	594557	MAG: Verrucomicrobia bacterium isolate LL51 chromosome, complete genome	blastn	114512	363	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
14942427	14942427	PRJNA939369_S_NODE_61652_length_248_cov_0.880000_g61235_i0	PRJNA939369	61652	248	0.88	2.1824	uncultured Opitutaceae bacterium	333967	Bacteria	Bacteria	106	1.7e-18	NTclustered	gi\|2518551946\|emb\|OX638348.1\|	333967	g61235	i0	75.833	4.23387096774194	240	41	94	15	16	248	4609834	4609605	MAG: uncultured Opitutaceae bacterium isolate b1b57f99-08c0-43d1-969e-fd0ef39b1292 genome assembly, chromosome: 1	blastn	1050	106	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		uncultured Opitutaceae bacterium
16558579	16558579	PRJNA939369_S_NODE_3933_length_593_cov_4.084615_g3527_i0	PRJNA939369	3933	593	4.084615	24.22176695	Akkermansia	239934	Bacteria	Bacteria	1085	0	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g3527	i0	99.663	296	593	2	100	0	1	593	137908	137316	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	175528	1085	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
18766104	18766104	PRJNA939369_S_NODE_43235_length_270_cov_1.172589_g42818_i0	PRJNA939369	43235	270	1.172589	3.1659903	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	346	1.01e-90	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g42818	i0	90.637	127.751851851852	267	15	97	7	4	264	1316478	1316740	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	34493	346	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20041227	20041227	PRJNA939369_S_NODE_73236_length_242_cov_1.284024_g72819_i0	PRJNA939369	73236	242	1.284024	3.10733808	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	392	1.1299999999999999e-104	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g72819	i0	95.885	204.107438016529	243	8	100	2	1	242	1315546	1315787	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	49394	392	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21316420	21316420	PRJNA939369_S_NODE_41157_length_274_cov_1.437811_g40740_i0	PRJNA939369	41157	274	1.437811	3.93960214	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	368	2.1999999999999996e-97	NTclustered	gi\|2225500096\|gb\|CP095464.1\|	2026799	g40740	i0	91.144	133.890510948905	271	24	99	0	4	274	594369	594639	MAG: Verrucomicrobia bacterium isolate LL51 chromosome, complete genome	blastn	36686	368	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
21316439	21316439	PRJNA939369_S_NODE_43297_length_270_cov_1.126904_g42880_i0	PRJNA939369	43297	270	1.126904	3.0426408	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	291	4.82e-74	NTclustered	gi\|2225500096\|gb\|CP095464.1\|	2026799	g42880	i0	86.296	159.3	270	34	100	3	1	270	594661	594927	MAG: Verrucomicrobia bacterium isolate LL51 chromosome, complete genome	blastn	43011	291	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
26993089	26993089	PRJNA939369_S_NODE_17402_length_353_cov_1.082143_g16985_i0	PRJNA939369	17402	353	1.082143	3.81996479	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	97.8	6.680000000000001e-21	NR	MBR6464573.1	2026799	g16985	i0	47.9	1.01133144475921	119	54	99.4	4	2	352	390	502	MBR6464573.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	357	97.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27024981	27024981	PRJNA939369_S_NODE_21642_length_330_cov_1.322957_g21225_i0	PRJNA939369	21642	330	1.322957	4.3657581	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.5	0.049	NR	MBK9989404.1	2026799	g21225	i0	41.7	0.654545454545455	72	37	61.8	4	5	208	263	333	MBK9989404.1 homocysteine S-methyltransferase family protein [Verrucomicrobiota bacterium]	diamond	216	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28067288	28067288	PRJNA939369_S_NODE_31025_length_298_cov_1.026667_g30608_i0	PRJNA939369	31025	298	1.026667	3.05946766	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	157	3.99e-42	NR	MBR6464573.1	2026799	g30608	i0	63.6	0.996644295302013	99	36	99.7	0	297	1	721	819	MBR6464573.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	297	157	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28919639	28919639	PRJNA939369_S_NODE_13908_length_380_cov_1.205212_g13491_i0	PRJNA939369	13908	380	1.205212	4.5798056	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	82.4	6.77e-16	NR	MBR6464572.1	2026799	g13491	i0	38.2	1.03421052631579	131	74	97.9	3	380	9	18	148	MBR6464572.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	393	82.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29677239	29677239	PRJNA939369_S_NODE_66850_length_245_cov_1.296512_g66433_i0	PRJNA939369	66850	245	1.296512	3.1764544	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	100	2.49e-22	NR	MBR6464573.1	2026799	g66433	i0	56.3	0.979591836734694	80	35	98	0	243	4	307	386	MBR6464573.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	240	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30151123	30151123	PRJNA939369_S_NODE_2232_length_746_cov_3.326895_g1851_i0	PRJNA939369	2232	746	3.326895	24.8186367	Akkermansia sp.	1872421	Bacteria	Bacteria	127	1.1399999999999999e-32	NR	MBR3927256.1	1872421	g1851	i0	38.2	0.715817694369973	178	110	71.6	0	205	738	1	178	MBR3927256.1 hypothetical protein [Akkermansia sp.]	diamond	534	127	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp.
30530450	30530450	PRJNA939369_S_NODE_65813_length_246_cov_0.890173_g65396_i0	PRJNA939369	65813	246	0.890173	2.18982558	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	140	1.65e-36	NR	MBR6464573.1	2026799	g65396	i0	79	0.98780487804878	81	17	98.8	0	244	2	16	96	MBR6464573.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	243	140	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					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);;