metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA395690" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA395690" 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
1686339	1686339	PRJNA395690_P_NODE_16462_length_200_cov_1.350993_g16310_i0	PRJNA395690	16462	200	1.350993	2.701986	Opitutus terrae	107709	Bacteria	Bacteria	171	4.599999999999999e-38	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g16310	i0	82.843	3.435	204	22	99	10	4	200	4393271	4393468	Opitutus terrae PB90-1, complete genome	blastn	687	171	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
1686652	1686652	PRJNA395690_P_NODE_5762_length_335_cov_1.262238_g5612_i0	PRJNA395690	5762	335	1.262238	4.2284973	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	497	3.3799999999999998e-136	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g5612	i0	93.433	210.531343283582	335	22	100	0	1	335	1291	957	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	70528	497	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
4238781	4238781	PRJNA395690_P_NODE_31424_length_165_cov_0.879310_g31272_i0	PRJNA395690	31424	165	0.87931	1.4508615	Actomonas aquatica	2866162	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2647674565\|gb\|CP139781.1\|	2866162	g31272	i0	100	0.16969696969697	28	0	17	0	43	70	5852526	5852553	Actomonas aquatica strain WL0086 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Actomonas	Actomonas aquatica
5515538	5515538	PRJNA395690_P_NODE_5385_length_344_cov_5.518644_g5235_i0	PRJNA395690	5385	344	5.518644	18.98413536	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	139	2.43e-28	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g5235	i0	84.932	15.7238372093023	146	12	42	8	172	314	1685915	1685777	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	5409	139	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
6789208	6789208	PRJNA395690_P_NODE_12066_length_234_cov_2.200000_g11914_i0	PRJNA395690	12066	234	2.2	5.148	Horticoccus luteus	2862869	Bacteria	Bacteria	217	7.02e-52	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g11914	i0	83.817	31.1452991452991	241	26	100	10	1	234	685185	685419	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	7288	217	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
8065017	8065017	PRJNA395690_P_NODE_29667_length_166_cov_0.871795_g29515_i0	PRJNA395690	29667	166	0.871795	1.4471797	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	207	2.8e-49	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g29515	i0	89.222	1.00602409638554	167	17	100	1	1	166	3594090	3593924	Luteolibacter sp. SL250 chromosome	blastn	167	207	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
9339619	9339619	PRJNA395690_P_NODE_11888_length_236_cov_1.122995_g11736_i0	PRJNA395690	11888	236	1.122995	2.6502682	Verrucomicrobium sp. GAS474	1882831	Bacteria	Bacteria	73.1	1.62e-8	NTclustered	gi\|1085974270\|emb\|LT629781.1\|	1882831	g11736	i0	95.556	0.190677966101695	45	2	19	0	149	193	3699426	3699382	Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I	blastn	45	73.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp. GAS474
16989271	16989271	PRJNA395690_P_NODE_5674_length_337_cov_1.656250_g5524_i0	PRJNA395690	5674	337	1.65625	5.5815625	Horticoccus luteus	2862869	Bacteria	Bacteria	333	1.01e-86	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g5524	i0	85.89	3.18694362017804	326	31	94	13	3	318	2448681	2448361	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	1074	333	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
18263479	18263479	PRJNA395690_P_NODE_5395_length_344_cov_1.891525_g5245_i0	PRJNA395690	5395	344	1.891525	6.506846	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	592	1.5499999999999996e-164	NTclustered	gi\|2442650069\|gb\|OQ422736.1\|	156588	g5245	i0	97.674	97	344	8	100	0	1	344	795	452	Uncultured Verrucomicrobia bacterium clone KCM_4_1_112 16S ribosomal RNA gene, partial sequence	blastn	33368	592	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
19537716	19537716	PRJNA395690_P_NODE_5696_length_336_cov_2.878049_g5546_i0	PRJNA395690	5696	336	2.878049	9.67024464	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	544	4.29e-150	NTclustered	gi\|511202471\|gb\|KC994702.1\|	156588	g5546	i0	95.846	95.9077380952381	337	12	100	2	1	336	340	5	Uncultured Verrucomicrobia bacterium clone BF 022 16S ribosomal RNA gene, partial sequence	blastn	32225	544	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
19537723	19537723	PRJNA395690_P_NODE_6076_length_326_cov_1.613718_g5926_i0	PRJNA395690	6076	326	1.613718	5.26072068	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	538	1.9299999999999992e-148	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g5926	i0	96.605	226.782208588957	324	11	99	0	3	326	1521	1844	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	73931	538	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
22088214	22088214	PRJNA395690_P_NODE_31158_length_165_cov_0.879310_g31006_i0	PRJNA395690	31158	165	0.87931	1.4508615	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	135	1.33e-27	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g31006	i0	86.29	69.2363636363636	124	17	75	0	40	163	1835874	1835997	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	11424	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22088301	22088301	PRJNA395690_P_NODE_37278_length_152_cov_2.524272_g37125_i0	PRJNA395690	37278	152	2.524272	3.83689344	Actomonas aquatica	2866162	Bacteria	Bacteria	102	1.22e-17	NTclustered	gi\|2647674565\|gb\|CP139781.1\|	2866162	g37125	i0	78.808	0.993421052631579	151	32	99	0	2	152	329139	329289	Actomonas aquatica strain WL0086 chromosome, complete genome	blastn	151	102	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Actomonas	Actomonas aquatica
24638130	24638130	PRJNA395690_P_NODE_34480_length_162_cov_0.902655_g34328_i0	PRJNA395690	34480	162	0.902655	1.4623011	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	82.4	1.72e-11	NTclustered	gi\|2518556548\|emb\|OX638380.1\|	412056	g34328	i0	84.706	2.97530864197531	85	10	51	3	80	162	528529	528446	MAG: uncultured Verrucomicrobiae bacterium isolate efd5e50e-5b6a-4a0f-a0a2-e496bae301b3 genome assembly, chromosome: 1	blastn	482	82.4	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);;