metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA591127" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA591127" 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
2414123	2414123	PRJNA591127_P_NODE_1762_length_516_cov_1.699374_g1606_i0	PRJNA591127	1762	516	1.699374	8.76876984	Verrucomicrobiota	74201	Bacteria	Bacteria	804	0	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g1606	i0	94.767	116.589147286822	516	27	100	0	1	516	2138	1623	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	60160	809	0.993819530284302	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
3116057	3116057	PRJNA591127_P_NODE_29783_length_151_cov_3.464912_g29614_i0	PRJNA591127	29783	151	3.464912	5.23201712	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	82.4	1.57e-11	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g29614	i0	89.231	0.860927152317881	65	7	43	0	10	74	367389	367453	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	130	82.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
5668829	5668829	PRJNA591127_P_NODE_24905_length_169_cov_1.530303_g24736_i0	PRJNA591127	24905	169	1.530303	2.58621207	Luteolibacter luteus	2728835	Bacteria	Bacteria	302	1.27e-77	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g24736	i0	98.817	12.6272189349112	169	2	100	0	1	169	3804565	3804733	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	2134	302	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
5668854	5668854	PRJNA591127_P_NODE_28005_length_154_cov_1.316239_g27836_i0	PRJNA591127	28005	154	1.316239	2.02700806	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	219	1.1799999999999996e-52	NTclustered	gi\|2754040317\|dbj\|LC785864.1\|	2026799	g27836	i0	92.208	95.448051948052	154	12	100	0	1	154	160	313	Verrucomicrobiota bacterium AR-M46MN gene for 16S rRNA, partial sequence	blastn	14699	219	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
6943270	6943270	PRJNA591127_P_NODE_26226_length_162_cov_1.640000_g26057_i0	PRJNA591127	26226	162	1.64	2.6568	uncultured Verrucomicrobiaceae bacterium	257470	Bacteria	Bacteria	270	3.4199999999999993e-68	NTclustered	gi\|220682444\|gb\|FJ543051.1\|	257470	g26057	i0	96.914	99.9259259259259	162	3	100	2	1	162	625	784	Uncultured Verrucomicrobiaceae bacterium clone B08-05F 16S ribosomal RNA gene, partial sequence	blastn	16188	270	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		uncultured Verrucomicrobiaceae bacterium
7516494	7516494	PRJNA591127_P_NODE_10186_length_231_cov_1.649485_g10018_i0	PRJNA591127	10186	231	1.649485	3.81031035	Opitutaceae	134623	Bacteria	Bacteria	315	2.38e-81	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g10018	i0	93.023	126.818181818182	215	15	93	0	17	231	2833904	2833690	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	29295	315	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
7516737	7516737	PRJNA591127_P_NODE_31206_length_150_cov_5.867257_g31037_i0	PRJNA591127	31206	150	5.867257	8.8008855	Opitutaceae	134623	Bacteria	Bacteria	122	9.18e-24	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g31037	i0	97.222	43.7733333333333	72	2	48	0	6	77	3420110	3420039	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	6566	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
8218206	8218206	PRJNA591127_P_NODE_16767_length_197_cov_2.706250_g16598_i0	PRJNA591127	16767	197	2.70625	5.3313125	Actomonas aquatica	2866162	Bacteria	Bacteria	124	3.5599999999999995e-24	NTclustered	gi\|2647674565\|gb\|CP139781.1\|	2866162	g16598	i0	96.053	0.385786802030457	76	3	39	0	1	76	794128	794203	Actomonas aquatica strain WL0086 chromosome, complete genome	blastn	76	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Actomonas	Actomonas aquatica
10769338	10769338	PRJNA591127_P_NODE_22709_length_183_cov_1.767123_g22540_i0	PRJNA591127	22709	183	1.767123	3.23383509	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	230	6.71e-56	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g22540	i0	90.341	134.868852459016	176	16	96	1	1	176	2661	2835	Luteolibacter sp. SL250 chromosome	blastn	24681	230	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
12617824	12617824	PRJNA591127_P_NODE_20250_length_197_cov_1.756250_g20081_i0	PRJNA591127	20250	197	1.75625	3.4598125	Termitidicoccus	3126963	Bacteria	Bacteria	124	3.5599999999999995e-24	NTclustered	gi\|573471959\|gb\|CP007053.1\|	794903	g20081	i0	97.26	3.85279187817259	73	2	37	0	125	197	4592672	4592744	Opitutaceae bacterium TAV5, complete genome	blastn	759	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
13319024	13319024	PRJNA591127_P_NODE_21471_length_192_cov_1.658065_g21302_i0	PRJNA591127	21471	192	1.658065	3.1834848	uncultured Opitutaceae bacterium	333967	Bacteria	Bacteria	209	9.27e-50	NTclustered	gi\|443301248\|gb\|KC217279.1\|	333967	g21302	i0	86.058	67.90625	208	13	100	6	1	192	214	7	Uncultured Opitutaceae bacterium clone DBW-467 16S ribosomal RNA gene, partial sequence	blastn	13038	209	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		uncultured Opitutaceae bacterium
14593802	14593802	PRJNA591127_P_NODE_11672_length_216_cov_1.307263_g11503_i0	PRJNA591127	11672	216	1.307263	2.82368808	Coraliomargarita algicola	3092156	Bacteria	Bacteria	204	4.9699999999999994e-48	NTclustered	gi\|2623481368\|gb\|CP138858.1\|	3092156	g11503	i0	89.024	5.85648148148148	164	18	76	0	1	164	2458520	2458357	Coraliomargarita algicola strain J2-16 chromosome, complete genome	blastn	1265	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Coraliomargarita	Coraliomargarita algicola
17142688	17142688	PRJNA591127_P_NODE_19214_length_197_cov_2.050000_g19045_i0	PRJNA591127	19214	197	2.05	4.0385	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	124	3.5599999999999995e-24	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g19045	i0	96.053	17.9644670050761	76	3	77	0	1	76	3076097	3076022	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	3539	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
20967371	20967371	PRJNA591127_P_NODE_7797_length_264_cov_1.414097_g7629_i0	PRJNA591127	7797	264	1.414097	3.73321608	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	344	3.55e-90	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g7629	i0	90.152	166.344696969697	264	26	100	0	1	264	16358	16095	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	43915	344	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
20967389	20967389	PRJNA591127_P_NODE_9657_length_237_cov_1.280000_g9489_i0	PRJNA591127	9657	237	1.28	3.0336	Opitutales bacterium	2026772	Bacteria	Bacteria	228	3.2899999999999986e-55	NTclustered	gi\|2626245913\|emb\|OY829953.1\|	2026772	g9489	i0	86.256	695.409282700422	211	28	89	1	28	237	679176	678966	MAG: Opitutales bacterium isolate cf0dc631-26ae-4be7-9546-4b6096dd6533 genome assembly, chromosome: 1	blastn	164812	228	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
22242174	22242174	PRJNA591127_P_NODE_21638_length_191_cov_1.253247_g21469_i0	PRJNA591127	21638	191	1.253247	2.39370177	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	259	9.02e-65	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g21469	i0	91.579	101.968586387435	190	13	98	3	4	191	3833255	3833443	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	19476	259	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22815928	22815928	PRJNA591127_P_NODE_16918_length_197_cov_2.650000_g16749_i0	PRJNA591127	16918	197	2.65	5.2205	Bacteria	2	Bacteria	Bacteria	121	4.6099999999999997e-23	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g16749	i0	95.946	37.5228426395939	74	3	38	0	123	196	2645541	2645614	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	7392	121	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
23517340	23517340	PRJNA591127_P_NODE_10999_length_222_cov_1.908108_g10831_i0	PRJNA591127	10999	222	1.908108	4.23599976	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	243	1.09e-59	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g10831	i0	86.726	71.5720720720721	226	20	99	9	1	220	2749703	2749924	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	15889	243	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23517543	23517543	PRJNA591127_P_NODE_5899_length_302_cov_2.573585_g5731_i0	PRJNA591127	5899	302	2.573585	7.7722267	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	228	4.349999999999999e-55	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g5731	i0	82.463	125.718543046358	268	39	87	6	1	264	1188	1451	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	37967	228	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
24791350	24791350	PRJNA591127_P_NODE_5580_length_310_cov_2.468864_g5412_i0	PRJNA591127	5580	310	2.468864	7.6534784	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	298	3.37e-76	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g5412	i0	86.989	141.68064516129	269	29	86	5	45	310	736993	737258	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	43921	298	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);;