metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA1160211" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA1160211" 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
309214	309214	PRJNA1160211_S_NODE_134841_length_397_cov_5.685185_g133609_i0	PRJNA1160211	134841	397	5.685185	22.57018445	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	682	0	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g133609	i0	99.206	231.108312342569	378	3	95	0	20	397	179	556	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	91750	682	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
1584572	1584572	PRJNA1160211_S_NODE_235362_length_274_cov_37.945274_g234129_i0	PRJNA1160211	235362	274	37.945274	103.97005076	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	97.1	1.15e-15	NTclustered	gi\|2874253793\|emb\|OY969777.1\|	412056	g234129	i0	96.552	16.6824817518248	58	2	21	0	6	63	2364526	2364583	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1	blastn	4571	97.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4136161	4136161	PRJNA1160211_S_NODE_1524_length_1260_cov_4.849200_g1249_i0	PRJNA1160211	1524	1260	4.8492	61.09992	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1242	0	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g1249	i0	84.748	214.707142857143	1272	159	99	27	13	1260	914602	915862	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	270531	1242	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
7962964	7962964	PRJNA1160211_S_NODE_205047_length_305_cov_2.409483_g203814_i0	PRJNA1160211	205047	305	2.409483	7.34892315	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	195	4.46e-45	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g203814	i0	83.028	11.3245901639344	218	33	71	2	1	216	5049096	5049311	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	3454	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9238248	9238248	PRJNA1160211_S_NODE_288908_length_233_cov_3.431250_g287675_i0	PRJNA1160211	288908	233	3.43125	7.9948125	Luteolibacter luteus	2728835	Bacteria	Bacteria	193	1.18e-44	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g287675	i0	83.495	31.9356223175966	206	34	88	0	5	210	1862256	1862461	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	7441	193	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
10513321	10513321	PRJNA1160211_S_NODE_186689_length_326_cov_3.786561_g185456_i0	PRJNA1160211	186689	326	3.786561	12.34418886	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	464	3.3199999999999997e-126	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g185456	i0	94.137	96.2760736196319	307	14	93	3	1	303	1903206	1903512	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	31386	464	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
10514519	10514519	PRJNA1160211_S_NODE_8729_length_839_cov_36.154047_g8000_i0	PRJNA1160211	8729	839	36.154047	303.33245433	Pedosphaera parvula	1032527	Bacteria	Bacteria	1027	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g8000	i0	88.797	277.014302741359	848	81	100	14	1	839	1053	1895	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	232415	1027	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
11242225	11242225	PRJNA1160211_S_NODE_59209_length_549_cov_21.611345_g58025_i0	PRJNA1160211	59209	549	21.611345	118.64628405	Verrucomicrobiota	74201	Bacteria	Bacteria	676	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g58025	i0	90.945	93.9508196721311	508	39	92	7	28	531	1	505	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	51579	680	0.994117647058824	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
11788274	11788274	PRJNA1160211_S_NODE_18950_length_717_cov_5.402174_g17967_i0	PRJNA1160211	18950	717	5.402174	38.73358758	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	800	0	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g17967	i0	87.732	233.417015341702	701	66	97	17	1	692	2749713	2750402	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	167360	800	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11789329	11789329	PRJNA1160211_S_NODE_68850_length_524_cov_11.208426_g67645_i0	PRJNA1160211	68850	524	11.208426	58.73215224	Fontisphaera persica	2974023	Bacteria	Bacteria	470	1.2e-127	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g67645	i0	83.694	116.931297709924	509	71	96	11	1	501	3861535	3861031	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	61272	470	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
15613206	15613206	PRJNA1160211_S_NODE_37313_length_620_cov_5.177331_g36184_i0	PRJNA1160211	37313	620	5.177331	32.0994522	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	865	0	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g36184	i0	91.909	252.390322580645	618	50	99	0	3	620	2748423	2749040	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	156482	865	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15613281	15613281	PRJNA1160211_S_NODE_4873_length_952_cov_10.001138_g4311_i0	PRJNA1160211	4873	952	10.001138	95.21083376	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	606	1.6399999999999992e-168	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g4311	i0	80.278	94.9884453781513	862	123	86	30	46	868	3833000	3832147	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	90429	606	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18162539	18162539	PRJNA1160211_S_NODE_98295_length_460_cov_21.279070_g97070_i0	PRJNA1160211	98295	460	21.27907	97.883722	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	784	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g97070	i0	99.083	224.363043478261	436	4	95	0	1	436	613	178	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	103207	784	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
18890489	18890489	PRJNA1160211_S_NODE_51775_length_571_cov_1.819277_g50608_i0	PRJNA1160211	51775	571	1.819277	10.38807167	Chthoniobacter	295577	Bacteria	Bacteria	767	0	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g50608	i0	91.848	217.141856392294	552	41	96	2	1	548	15915	15364	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	123988	771	0.994811932555123	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
19436307	19436307	PRJNA1160211_S_NODE_291396_length_229_cov_14.237179_g290163_i0	PRJNA1160211	291396	229	14.237179	32.60313991	Horticoccus luteus	2862869	Bacteria	Bacteria	187	5.37e-43	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g290163	i0	85.106	3.14847161572052	188	22	80	4	25	207	2448317	2448503	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	721	187	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
20710869	20710869	PRJNA1160211_S_NODE_168377_length_349_cov_6.956522_g167144_i0	PRJNA1160211	168377	349	6.956522	24.27826178	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	433	1.0099999999999999e-116	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g167144	i0	90.826	137.315186246418	327	25	93	4	27	349	557371	557696	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	47923	433	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20711983	20711983	PRJNA1160211_S_NODE_57757_length_553_cov_172.768750_g56577_i0	PRJNA1160211	57757	553	172.76875	955.4111875	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	588	3.36e-163	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g56577	i0	87.354	71.8915009041591	514	63	93	2	19	530	3833088	3833601	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	39756	588	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21986302	21986302	PRJNA1160211_S_NODE_183878_length_329_cov_18.242188_g182645_i0	PRJNA1160211	183878	329	18.242188	60.01679852	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	305	2.15e-78	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g182645	i0	84.79	124.31914893617	309	41	93	6	23	329	15372	15676	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	40901	305	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
22715278	22715278	PRJNA1160211_S_NODE_173038_length_343_cov_5.418519_g171805_i0	PRJNA1160211	173038	343	5.418519	18.58552017	Prosthecobacter	48463	Bacteria	Bacteria	484	2.7e-132	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g171805	i0	93.789	56.801749271137	322	20	94	0	22	343	1195	1516	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	19483	484	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
22716035	22716035	PRJNA1160211_S_NODE_94498_length_468_cov_4.167089_g93273_i0	PRJNA1160211	94498	468	4.167089	19.50197652	Prosthecobacter	48463	Bacteria	Bacteria	791	0	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g93273	i0	98.022	247.155982905983	455	9	97	0	7	461	794	1248	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	115669	791	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
23261092	23261092	PRJNA1160211_S_NODE_100459_length_456_cov_6.550914_g99233_i0	PRJNA1160211	100459	456	6.550914	29.87216784	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	562	1.65e-155	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g99233	i0	90.183	157.142543859649	438	34	96	8	20	456	16800	17229	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	71657	562	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
23262356	23262356	PRJNA1160211_S_NODE_265499_length_250_cov_1.305085_g264266_i0	PRJNA1160211	265499	250	1.305085	3.2627125	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	250	7.48e-62	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g264266	i0	84.706	33.812	255	33	100	6	1	250	2749555	2749808	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	8453	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23262510	23262510	PRJNA1160211_S_NODE_289659_length_232_cov_3.012579_g288426_i0	PRJNA1160211	289659	232	3.012579	6.98918328	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	263	8.8e-66	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g288426	i0	89.151	51.3577586206897	212	21	91	2	23	232	1407	1618	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	11915	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
24535800	24535800	PRJNA1160211_S_NODE_22140_length_695_cov_7.490354_g21116_i0	PRJNA1160211	22140	695	7.490354	52.0579603	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	931	0	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g21116	i0	91.904	169.348201438849	667	53	97	1	18	684	1727337	1728002	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	117697	931	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);;