metadata: contig_metadata: 6 rows where bioproject = "PRJNA682774", tax_clade = "PVC group" and tax

6 rows where bioproject = "PRJNA682774", 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
15967387	15967387	PRJNA682774_P_NODE_4813_length_245_cov_0.906977_g4784_i0	PRJNA682774	4813	245	0.906977	2.22209365	Akkermansia muciniphila	239935	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2051367837\|gb\|CP072029.1\|	239935	g4784	i0	99.592	65.0897959183673	245	1	100	0	1	245	1577096	1577340	Akkermansia muciniphila strain Akk1713 chromosome, complete genome	blastn	15947	448	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
17242596	17242596	PRJNA682774_P_NODE_4154_length_249_cov_0.886364_g4125_i0	PRJNA682774	4154	249	0.886364	2.20704636	Akkermansia muciniphila	239935	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2623926283\|gb\|CP137887.1\|	239935	g4125	i0	100	95.6746987951807	249	0	100	0	1	249	318517	318765	Akkermansia muciniphila strain SDLYAKK5 chromosome, complete genome	blastn	23823	460	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
27335164	27335164	PRJNA682774_P_NODE_5263_length_243_cov_0.917647_g5234_i0	PRJNA682774	5263	243	0.917647	2.22988221	Opitutaceae bacterium	2006848	Bacteria	Bacteria	73.9	2.33e-13	NR	HWA10989.1	2006848	g5234	i0	51.3	0.987654320987654	80	28	97.5	2	237	1	168	237	HWA10989.1 hypothetical protein [Opitutaceae bacterium]	diamond	240	73.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
27631013	27631013	PRJNA682774_P_NODE_1424_length_366_cov_1.993174_g1395_i0	PRJNA682774	1424	366	1.993174	7.29501684	Pseudomonadati	3379134	Bacteria	Bacteria	58.9	3.29e-7	NR	MBO6102755.1	2026772	g1395	i0	50.9	1.59836065573771	57	28	46.7	0	147	317	1054	1110	MBO6102755.1 hypothetical protein [Opitutales bacterium]	diamond	585	58.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
29260881	29260881	PRJNA682774_P_NODE_4849_length_245_cov_0.906977_g4820_i0	PRJNA682774	4849	245	0.906977	2.22209365	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	73.2	7.22e-13	NR	RYD77759.1	2026800	g4820	i0	45.6	0.96734693877551	79	42	96.7	1	244	8	511	588	RYD77759.1 MAG: hypothetical protein EOP84_15150, partial [Verrucomicrobiaceae bacterium]	diamond	237	73.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32200271	32200271	PRJNA682774_P_NODE_3438_length_253_cov_0.866667_g3409_i0	PRJNA682774	3438	253	0.866667	2.19266751	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	45.1	0.00681	NR	MBL9138679.1	2026801	g3409	i0	32.5	0.91304347826087	77	47	91.3	2	2	232	541	612	MBL9138679.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	231	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales 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);;