metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA690592" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA690592" 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
672103	672103	PRJNA690592_S_NODE_89701_length_342_cov_1.732342_g88687_i0	PRJNA690592	89701	342	1.732342	5.92460964	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	477	4.499999999999998e-130	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g88687	i0	91.86	184.938596491228	344	25	100	3	1	342	1726797	1727139	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	63249	477	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5775027	5775027	PRJNA690592_S_NODE_206325_length_244_cov_0.929825_g205311_i0	PRJNA690592	206325	244	0.929825	2.268773	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	374	4.1399999999999986e-99	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g205311	i0	94.309	181.975409836066	246	11	100	3	1	244	1726884	1727128	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	44402	374	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
7050726	7050726	PRJNA690592_S_NODE_90806_length_340_cov_2.831461_g89792_i0	PRJNA690592	90806	340	2.831461	9.6269674	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	172	2.36e-38	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g89792	i0	78.519	51.25	270	52	79	6	11	277	3078634	3078900	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	17425	172	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13932899	13932899	PRJNA690592_S_NODE_134911_length_290_cov_1.064516_g133897_i0	PRJNA690592	134911	290	1.064516	3.0870964	Verrucomicrobiales	48461	Bacteria	Bacteria	204	7.01e-48	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g133897	i0	82.684	233.772413793103	231	39	79	1	5	234	5626819	5627049	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	67794	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
14699744	14699744	PRJNA690592_S_NODE_119512_length_305_cov_1.060345_g118498_i0	PRJNA690592	119512	305	1.060345	3.23405225	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	303	7.11e-78	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g118498	i0	90.749	208.639344262295	227	21	74	0	1	227	941	715	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	63635	303	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
18523030	18523030	PRJNA690592_S_NODE_147735_length_279_cov_1.121359_g146721_i0	PRJNA690592	147735	279	1.121359	3.12859161	Prosthecobacter debontii	48467	Bacteria	Bacteria	366	8.08e-97	NTclustered	gi\|164510703\|emb\|AJ966882.1\|	48467	g146721	i0	96	224.58064516129	225	9	81	0	55	279	4243	4467	Prosthecobacter debontii 16S rRNA gene (partial), 23S rRNA gene (partial), tRNA-Ala gene, tRNA-Ile gene and ITS1, strain DSM 14044	blastn	62658	366	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter debontii
18523964	18523964	PRJNA690592_S_NODE_7255_length_1037_cov_3.536307_g6632_i0	PRJNA690592	7255	1037	3.536307	36.67150359	Akkermansia muciniphila	239935	Bacteria	Bacteria	58.4	0.002	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g6632	i0	97.059	1.14850530376085	34	1	3	0	135	168	1958297	1958264	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	1191	58.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
22349227	22349227	PRJNA690592_S_NODE_62898_length_398_cov_1.418462_g61884_i0	PRJNA690592	62898	398	1.418462	5.64547876	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	558	1.84e-154	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g61884	i0	92	112.379396984925	400	28	100	4	1	398	1728429	1728826	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	44727	558	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
25405420	25405420	PRJNA690592_S_NODE_143700_length_282_cov_1.473684_g142686_i0	PRJNA690592	143700	282	1.473684	4.15578888	Fontisphaera	3050007	Bacteria	Bacteria	309	1.4e-79	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g142686	i0	86.572	76.2198581560284	283	35	100	3	1	282	3991663	3991943	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	21494	309	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);;