metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA688931" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA688931" 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
668528	668528	PRJNA688931_P_NODE_33321_length_174_cov_1.664000_g33108_i0	PRJNA688931	33321	174	1.664	2.89536	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	237	3.77e-58	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g33108	i0	94.194	68.4885057471264	155	9	89	0	2	156	28190	28344	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	11917	237	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
1944505	1944505	PRJNA688931_P_NODE_26422_length_198_cov_2.087248_g26209_i0	PRJNA688931	26422	198	2.087248	4.13275104	Haloferula helveola	490095	Bacteria	Bacteria	165	2.11e-36	NTclustered	gi\|2647781590\|dbj\|AP024702.1\|	490095	g26209	i0	82.234	16.5	197	29	99	4	2	198	774711	774901	Haloferula helveola CN-1 DNA, complete genome	blastn	3267	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula helveola
4496428	4496428	PRJNA688931_P_NODE_12644_length_293_cov_1.266393_g12431_i0	PRJNA688931	12644	293	1.266393	3.71053149	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	250	8.98e-62	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g12431	i0	82.313	383.941979522184	294	46	100	4	1	293	276714	276426	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	112495	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
4496587	4496587	PRJNA688931_P_NODE_33164_length_175_cov_1.222222_g32951_i0	PRJNA688931	33164	175	1.222222	2.1388885	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	278	2.23e-70	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g32951	i0	95.455	212.822857142857	176	5	100	3	1	175	2294	2467	Luteolibacter sp. SL250 chromosome	blastn	37244	278	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
7047147	7047147	PRJNA688931_P_NODE_32886_length_176_cov_1.047244_g32673_i0	PRJNA688931	32886	176	1.047244	1.84314944	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	298	1.73e-76	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g32673	i0	97.159	9.64772727272727	176	5	100	0	1	176	1316284	1316109	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	1698	298	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8321545	8321545	PRJNA688931_P_NODE_15547_length_261_cov_2.009434_g15334_i0	PRJNA688931	15547	261	2.009434	5.24462274	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	351	2.1e-92	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g15334	i0	90.909	118.83908045977	264	21	100	3	1	261	3833329	3833592	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	31017	351	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8321567	8321567	PRJNA688931_P_NODE_18247_length_240_cov_1.586387_g18034_i0	PRJNA688931	18247	240	1.586387	3.8073288	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	337	5.32e-88	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g18034	i0	94.884	14.15	215	11	90	0	26	240	1316374	1316160	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	3396	337	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9596956	9596956	PRJNA688931_P_NODE_16108_length_256_cov_1.724638_g15895_i0	PRJNA688931	16108	256	1.724638	4.41507328	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	361	3.4e-95	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g15895	i0	92.157	169.19140625	255	20	99	0	2	256	5152562	5152308	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	43313	361	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9596964	9596964	PRJNA688931_P_NODE_17288_length_247_cov_1.156566_g17075_i0	PRJNA688931	17288	247	1.156566	2.85671802	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	337	5.5e-88	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g17075	i0	91.498	242.392712550607	247	18	100	3	1	247	1317034	1317277	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	59871	337	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10106774	10106774	PRJNA688931_P_NODE_7888_length_384_cov_1.588060_g7675_i0	PRJNA688931	7888	384	1.58806	6.0981504	Verrucomicrobiaceae	203557	Bacteria	Bacteria	579	1.3599999999999996e-160	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g7675	i0	93.995	277.3359375	383	21	99	2	1	382	2624	2243	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	106497	579	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
12147892	12147892	PRJNA688931_P_NODE_3690_length_585_cov_1.886194_g3492_i0	PRJNA688931	3690	585	1.886194	11.0342349	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	904	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g3492	i0	95.288	179.682051282051	573	22	97	5	17	585	1315262	1315833	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	105114	904	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13422488	13422488	PRJNA688931_P_NODE_39111_length_165_cov_1.784483_g38898_i0	PRJNA688931	39111	165	1.784483	2.94439695	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	267	4.53e-67	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g38898	i0	95.758	36.4060606060606	165	7	100	0	1	165	1404510	1404346	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	6007	267	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
14697442	14697442	PRJNA688931_P_NODE_27912_length_193_cov_1.027778_g27699_i0	PRJNA688931	27912	193	1.027778	1.98361154	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	322	1.15e-83	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g27699	i0	96.891	37.1865284974093	193	4	100	2	1	193	5153590	5153400	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	7177	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14697480	14697480	PRJNA688931_P_NODE_32672_length_176_cov_1.637795_g32459_i0	PRJNA688931	32672	176	1.637795	2.8825192	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	292	8.04e-75	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g32459	i0	96.591	260.363636363636	176	6	100	0	1	176	1316650	1316825	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	45824	292	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14697526	14697526	PRJNA688931_P_NODE_37832_length_166_cov_1.769231_g37619_i0	PRJNA688931	37832	166	1.769231	2.93692346	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	259	7.63e-65	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g37619	i0	95.122	154.698795180723	164	8	99	0	3	166	2732	2569	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	25680	259	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
14697632	14697632	PRJNA688931_P_NODE_8632_length_365_cov_0.977848_g8419_i0	PRJNA688931	8632	365	0.977848	3.5691452	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	536	7.849999999999998e-148	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g8419	i0	93.169	76.3041095890411	366	23	100	2	1	365	16665	16301	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	27851	536	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
15971163	15971163	PRJNA688931_P_NODE_21213_length_222_cov_1.601156_g21000_i0	PRJNA688931	21213	222	1.601156	3.55456632	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	303	4.92e-78	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g21000	i0	91.441	289.189189189189	222	18	100	1	1	222	3411930	3412150	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	64200	303	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
18520593	18520593	PRJNA688931_P_NODE_32235_length_178_cov_1.116279_g32022_i0	PRJNA688931	32235	178	1.116279	1.98697662	Pedosphaera parvula	1032527	Bacteria	Bacteria	252	1.38e-62	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g32022	i0	93.491	114.88202247191	169	11	95	0	9	177	347	179	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	20449	252	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
19029750	19029750	PRJNA688931_P_NODE_27935_length_192_cov_4.874126_g27722_i0	PRJNA688931	27935	192	4.874126	9.35832192	Luteolibacter	518753	Bacteria	Bacteria	322	1.14e-83	NTclustered	gi\|197360304\|gb\|EU979092.1\|	156588	g27722	i0	96.875	97.5	192	6	100	0	1	192	196	5	Uncultured Verrucomicrobia bacterium clone g83 16S ribosomal RNA gene, partial sequence	blastn	18720	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
22345734	22345734	PRJNA688931_P_NODE_12098_length_300_cov_2.231076_g11885_i0	PRJNA688931	12098	300	2.231076	6.693228	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	342	1.4799999999999999e-89	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g11885	i0	90.734	64.2033333333333	259	21	86	3	1	257	437	180	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	19261	342	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
22345874	22345874	PRJNA688931_P_NODE_29558_length_187_cov_1.123188_g29345_i0	PRJNA688931	29558	187	1.123188	2.10036156	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	296	6.7e-76	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g29345	i0	95.187	278.989304812834	187	9	100	0	1	187	1021	835	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	52171	296	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
22346049	22346049	PRJNA688931_P_NODE_9278_length_349_cov_2.510000_g9065_i0	PRJNA688931	9278	349	2.51	8.7599	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	568	2.6499999999999995e-157	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g9065	i0	95.989	287.022922636103	349	14	100	0	1	349	2218344	2218692	Luteolibacter sp. LG18 DNA, complete genome	blastn	100171	568	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
24894718	24894718	PRJNA688931_P_NODE_31360_length_181_cov_0.818182_g31147_i0	PRJNA688931	31360	181	0.818182	1.48090942	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	126	8.93e-25	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g31147	i0	79.558	2.19889502762431	181	33	99	4	3	181	4461183	4461005	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	398	126	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);;