metadata: contig_metadata: 12 rows where bioproject = "PRJNA1196384" and tax

12 rows where bioproject = "PRJNA1196384" 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
1597280	1597280	PRJNA1196384_S_NODE_3222_length_217_cov_1.344444_g3158_i0	PRJNA1196384	3222	217	1.344444	2.91744348	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	342	1.02e-89	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g3158	i0	94.977	115.345622119816	219	9	100	2	1	217	15907	16125	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	25030	342	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
2873448	2873448	PRJNA1196384_S_NODE_2763_length_233_cov_4.571429_g2699_i0	PRJNA1196384	2763	233	4.571429	10.65142957	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	300	6.74e-77	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g2699	i0	91.071	285.995708154506	224	16	95	4	12	233	16295	16074	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	66637	300	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
2873541	2873541	PRJNA1196384_S_NODE_843_length_418_cov_21.188976_g779_i0	PRJNA1196384	843	418	21.188976	88.56991968	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	492	1.9999999999999996e-134	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g779	i0	91.808	235	354	27	84	2	67	418	1320589	1320236	Luteolibacter sp. Populi chromosome, complete genome	blastn	98230	492	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
4149623	4149623	PRJNA1196384_S_NODE_4144_length_195_cov_2.537975_g4080_i0	PRJNA1196384	4144	195	2.537975	4.94905125	Chthoniobacter flavus	191863	Bacteria	Bacteria	305	1.17e-78	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g4080	i0	94.872	95.2615384615385	195	10	100	0	1	195	955	1149	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	18576	305	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
10526391	10526391	PRJNA1196384_S_NODE_1209_length_352_cov_2.622222_g1145_i0	PRJNA1196384	1209	352	2.622222	9.23022144	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	455	2.17e-123	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g1145	i0	92.744	246.039772727273	317	20	90	3	1	316	2748639	2748325	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	86606	455	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11801179	11801179	PRJNA1196384_S_NODE_1190_length_355_cov_2.773585_g1126_i0	PRJNA1196384	1190	355	2.773585	9.84622675	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	621	2.04e-173	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g1126	i0	98.305	271.684507042254	354	6	99	0	1	354	17809	18162	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	96448	621	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
11801180	11801180	PRJNA1196384_S_NODE_1250_length_345_cov_5.259740_g1186_i0	PRJNA1196384	1250	345	5.25974	18.146103	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	322	2.25e-83	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g1186	i0	87.912	179.098550724638	273	33	79	0	1	273	631813	631541	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	61789	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
11801215	11801215	PRJNA1196384_S_NODE_3790_length_203_cov_2.915663_g3726_i0	PRJNA1196384	3790	203	2.915663	5.91879589	Luteolibacter luteus	2728835	Bacteria	Bacteria	196	7.72e-46	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g3726	i0	85.204	122.674876847291	196	23	96	5	1	195	3803530	3803720	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	24903	196	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
21999448	21999448	PRJNA1196384_S_NODE_358_length_609_cov_4.921329_g301_i0	PRJNA1196384	358	609	4.921329	29.97089361	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	497	6.45e-136	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g301	i0	83.835	240.896551724138	532	77	87	7	1	529	924	1449	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	146706	497	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
25269345	25269345	PRJNA1196384_S_NODE_1940_length_281_cov_4.381148_g1876_i0	PRJNA1196384	1940	281	4.381148	12.31102588	Akkermansia	239934	Bacteria	Bacteria	326	1.38e-84	NTclustered	gi\|183579827\|emb\|AM905424.1\|	239935	g1876	i0	87.676	299.163701067616	284	30	100	4	1	281	923	1204	Akkermansia muciniphila 23S rRNA gene, strain CIP107961	blastn	84065	326	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
29535553	29535553	PRJNA1196384_S_NODE_6170_length_168_cov_0.885496_g6106_i0	PRJNA1196384	6170	168	0.885496	1.48763328	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	106	3.95e-28	NR	MEI6568784.1	2026799	g6106	i0	89.3	1	56	6	100	0	168	1	60	115	MEI6568784.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	168	106	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31431249	31431249	PRJNA1196384_S_NODE_1016_length_380_cov_1.314869_g952_i0	PRJNA1196384	1016	380	1.314869	4.9965022	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	104	1.5199999999999995e-23	NR	HLH54161.1	2499141	g952	i0	47.2	1.70526315789474	106	53	81.3	1	5	313	318	423	HLH54161.1 CRTAC1 family protein [Verrucomicrobiia bacterium]	diamond	648	104	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);;