metadata: contig_metadata: 10 rows where bioproject = "PRJNA1009807" and tax

10 rows where bioproject = "PRJNA1009807" 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
154795	154795	PRJNA1009807_S_NODE_1141_length_285_cov_3.467480_g1113_i0	PRJNA1009807	1141	285	3.46748	9.882318	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	383	8.22e-102	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g1113	i0	90.941	179.733333333333	287	23	99	3	2	285	1315815	1315529	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	51224	383	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
154814	154814	PRJNA1009807_S_NODE_21_length_1232_cov_20.537301_g7_i1	PRJNA1009807	21	1232	20.537301	253.01954832	Rubellicoccus peritrichatus	3080537	Bacteria	Bacteria	994	0	NTclustered	gi\|2605121622\|gb\|CP136920.1\|	3080537	g7	i1	82.288	228.801948051948	1180	179	94	27	59	1221	2162478	2161312	Rubellicoccus peritrichatus strain CR14 isolate coral tank chromosome, complete genome	blastn	281884	994	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Rubellicoccus	Rubellicoccus peritrichatus
6532996	6532996	PRJNA1009807_S_NODE_3146_length_182_cov_1.342657_g3118_i0	PRJNA1009807	3146	182	1.342657	2.44363574	Akkermansia glycaniphila	1679444	Bacteria	Bacteria	97.1	7.05e-16	NTclustered	gi\|1093279401\|emb\|LT629973.1\|	1679444	g3118	i0	81.897	27.4285714285714	116	19	63	2	66	180	2888785	2888899	Akkermansia glycaniphila isolate APytT genome assembly, chromosome: I	blastn	4992	97.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia glycaniphila
9929410	9929410	PRJNA1009807_S_NODE_3768_length_169_cov_1.700000_g3740_i0	PRJNA1009807	3768	169	1.7	2.873	Opitutaceae	134623	Bacteria	Bacteria	285	1.28e-72	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g3740	i0	97.041	25.585798816568	169	5	100	0	1	169	3073	3241	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	4324	285	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
9929419	9929419	PRJNA1009807_S_NODE_768_length_337_cov_14.412752_g740_i0	PRJNA1009807	768	337	14.412752	48.57097424	Akkermansia	239934	Bacteria	Bacteria	545	1.1999999999999999e-150	NTclustered	gi\|2756360508\|gb\|CP156688.1\|	239935	g740	i0	95.846	294.477744807122	337	14	100	0	1	337	360541	360205	Akkermansia muciniphila strain AKK-TMU chromosome, complete genome	blastn	99239	545	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
11204690	11204690	PRJNA1009807_S_NODE_269_length_507_cov_16.989316_g243_i0	PRJNA1009807	269	507	16.989316	86.13583212	Akkermansia	239934	Bacteria	Bacteria	621	3.0099999999999995e-173	NTclustered	gi\|2566450153\|gb\|CP114596.1\|	239935	g243	i0	88.845	300.173570019724	511	49	100	8	1	507	321588	322094	Akkermansia muciniphila strain MmAkk2 chromosome, complete genome	blastn	152188	621	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
18006555	18006555	PRJNA1009807_S_NODE_3035_length_184_cov_2.317241_g3007_i0	PRJNA1009807	3035	184	2.317241	4.26372344	Luteolibacter luteus	2728835	Bacteria	Bacteria	91.6	3.33e-14	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g3007	i0	87.5	52.625	80	8	43	2	1	80	3803573	3803650	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	9683	91.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
18853080	18853080	PRJNA1009807_S_NODE_135_length_638_cov_20.824708_g116_i0	PRJNA1009807	135	638	20.824708	132.86163704	Akkermansia	239934	Bacteria	Bacteria	632	1.7799999999999996e-176	NTclustered	gi\|2756360508\|gb\|CP156688.1\|	239935	g116	i0	84.664	297.492163009404	639	93	99	4	1	637	362730	362095	Akkermansia muciniphila strain AKK-TMU chromosome, complete genome	blastn	189800	638	0.990595611285266	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
18853093	18853093	PRJNA1009807_S_NODE_235_length_532_cov_9.411765_g211_i0	PRJNA1009807	235	532	9.411765	50.0705898	Verrucomicrobiales	48461	Bacteria	Bacteria	558	2.52e-154	NTclustered	gi\|1093279401\|emb\|LT629973.1\|	1679444	g211	i0	86.863	283.332706766917	510	54	95	12	30	532	909910	910413	Akkermansia glycaniphila isolate APytT genome assembly, chromosome: I	blastn	150733	560	0.996428571428571	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia glycaniphila
21831602	21831602	PRJNA1009807_S_NODE_4578_length_156_cov_2.452991_g4550_i0	PRJNA1009807	4578	156	2.452991	3.82666596	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	267	4.2199999999999997e-67	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g4550	i0	97.436	16.9935897435897	156	4	100	0	1	156	1315869	1316024	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	2651	267	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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);;