metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA1112809" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA1112809" 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
1494944	1494944	PRJNA1112809_P_NODE_195262_length_238_cov_2.363636_g191987_i0	PRJNA1112809	195262	238	2.363636	5.62545368	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	329	8.82e-86	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g191987	i0	91.667	229.247899159664	240	17	100	3	1	238	2750210	2750448	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	54561	329	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4048202	4048202	PRJNA1112809_P_NODE_69564_length_422_cov_1.816619_g66289_i0	PRJNA1112809	69564	422	1.816619	7.66613218	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	527	5.539999999999998e-145	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g66289	i0	89.448	456.137440758294	417	44	99	0	4	420	4129140	4129556	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	192490	527	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4048609	4048609	PRJNA1112809_P_NODE_90984_length_351_cov_2.884892_g87709_i0	PRJNA1112809	90984	351	2.884892	10.12597092	Chthoniobacter flavus	191863	Bacteria	Bacteria	440	6.059999999999999e-119	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g87709	i0	89.429	281.621082621083	350	36	99	1	2	351	502	850	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	98849	440	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
5322633	5322633	PRJNA1112809_P_NODE_165545_length_250_cov_11.209040_g162270_i0	PRJNA1112809	165545	250	11.20904	28.0226	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	267	7.43e-67	NTclustered	gi\|164510704\|emb\|AJ966883.1\|	48466	g162270	i0	86.179	257.724	246	34	98	0	1	246	4614	4859	Prosthecobacter vanneervenii 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 12252	blastn	64431	267	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
6598399	6598399	PRJNA1112809_P_NODE_197066_length_233_cov_3.168750_g193791_i0	PRJNA1112809	197066	233	3.16875	7.3831875	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	331	2.39e-86	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g193791	i0	92.275	103.618025751073	233	18	100	0	1	233	5153779	5154011	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	24143	331	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
7871531	7871531	PRJNA1112809_P_NODE_10787_length_1981_cov_2.472746_g9183_i0	PRJNA1112809	10787	1981	2.472746	48.98509826	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	1339	0	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g9183	i0	84.846	58.907117617365	1333	198	67	4	642	1972	5312639	5313969	Luteolibacter sp. Populi chromosome, complete genome	blastn	116695	1339	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
7872054	7872054	PRJNA1112809_P_NODE_13547_length_1675_cov_5.739076_g11609_i0	PRJNA1112809	13547	1675	5.739076	96.129523	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	2706	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g11609	i0	95.823	92.4250746268657	1676	69	100	1	1	1675	5153984	5152309	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	154812	2706	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
7872248	7872248	PRJNA1112809_P_NODE_145247_length_268_cov_1.579487_g141972_i0	PRJNA1112809	145247	268	1.579487	4.23302516	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	182	3e-41	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g141972	i0	80	2.79477611940298	245	49	91	0	1	245	146501	146745	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	749	182	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
8676405	8676405	PRJNA1112809_P_NODE_12047_length_1834_cov_6.134583_g10279_i0	PRJNA1112809	12047	1834	6.134583	112.50825222	Verrucomicrobiaceae	203557	Bacteria	Bacteria	1435	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g10279	i0	81.281	259.196292257361	1843	283	99	48	1	1825	1898	100	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	475366	1435	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
10422697	10422697	PRJNA1112809_P_NODE_133569_length_280_cov_2.231884_g130294_i0	PRJNA1112809	133569	280	2.231884	6.2492752	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	91.6	5.47e-14	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g130294	i0	92.308	0.232142857142857	65	4	23	1	144	208	5255214	5255151	Luteolibacter sp. Populi chromosome, complete genome	blastn	65	91.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
11697365	11697365	PRJNA1112809_P_NODE_103530_length_324_cov_1.756972_g100255_i0	PRJNA1112809	103530	324	1.756972	5.69258928	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	433	9.299999999999999e-117	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g100255	i0	91.022	196.854938271605	323	25	98	4	6	324	1315318	1315640	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	63781	433	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11698406	11698406	PRJNA1112809_P_NODE_159650_length_254_cov_2.906077_g156375_i0	PRJNA1112809	159650	254	2.906077	7.38143558	Pedosphaera parvula	1032527	Bacteria	Bacteria	392	1.1999999999999999e-104	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g156375	i0	94.488	147.716535433071	254	14	100	0	1	254	2398	2145	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	37520	392	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
12972572	12972572	PRJNA1112809_P_NODE_109111_length_314_cov_1.522822_g105836_i0	PRJNA1112809	109111	314	1.522822	4.78166108	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	185	2.7799999999999993e-42	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g105836	i0	83.938	1.19426751592357	193	31	61	0	36	228	4509482	4509290	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	375	185	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
14249569	14249569	PRJNA1112809_P_NODE_35412_length_717_cov_4.768634_g32257_i0	PRJNA1112809	35412	717	4.768634	34.19110578	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	429	2.84e-115	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g32257	i0	85.888	4.00976290097629	411	49	57	4	1	411	3216275	3215874	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	2875	429	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
15522012	15522012	PRJNA1112809_P_NODE_142593_length_271_cov_1.186869_g139318_i0	PRJNA1112809	142593	271	1.186869	3.21641499	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	379	1e-100	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g139318	i0	91.971	72.4723247232472	274	16	100	4	1	271	1316246	1315976	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	19640	379	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15522633	15522633	PRJNA1112809_P_NODE_179773_length_245_cov_3.372093_g176498_i0	PRJNA1112809	179773	245	3.372093	8.26162785	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	331	2.5400000000000002e-86	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g176498	i0	91.02	163.436734693878	245	22	100	0	1	245	3832520	3832764	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	40042	331	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
16795704	16795704	PRJNA1112809_P_NODE_102794_length_325_cov_2.821429_g99519_i0	PRJNA1112809	102794	325	2.821429	9.16964425	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	337	7.53e-88	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g99519	i0	87.671	307.335384615385	292	32	91	4	11	301	3450468	3450180	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	99884	337	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
16796227	16796227	PRJNA1112809_P_NODE_128554_length_286_cov_1.446009_g125279_i0	PRJNA1112809	128554	286	1.446009	4.13558574	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	416	8.139999999999999e-112	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g125279	i0	93.841	219.814685314685	276	17	97	0	11	286	2833437	2833162	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	62867	416	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
16796918	16796918	PRJNA1112809_P_NODE_16794_length_1406_cov_5.300825_g11609_i1	PRJNA1112809	16794	1406	5.300825	74.5295995	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	2180	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g11609	i1	94.729	103.040540540541	1404	71	99	3	1	1403	5152309	5153710	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	144875	2180	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20622093	20622093	PRJNA1112809_P_NODE_53097_length_517_cov_1.905405_g49830_i0	PRJNA1112809	53097	517	1.905405	9.85094385	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	165	6.23e-36	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g49830	i0	75.749	16.4738878143133	367	68	69	19	4	359	518250	517894	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	8517	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21425459	21425459	PRJNA1112809_P_NODE_200817_length_213_cov_4.378571_g197542_i0	PRJNA1112809	200817	213	4.378571	9.32635623	Opitutaceae	134623	Bacteria	Bacteria	311	2.8000000000000003e-80	NTclustered	gi\|2452067159\|gb\|CP119075.1\|	2909285	g197542	i0	92.958	25.1784037558685	213	15	100	0	1	213	536201	535989	Synoicihabitans lomoniglobus strain LMO-M01 chromosome, complete genome	blastn	5363	311	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Synoicihabitans	Synoicihabitans lomoniglobus
21895992	21895992	PRJNA1112809_P_NODE_134578_length_279_cov_2.131068_g131303_i0	PRJNA1112809	134578	279	2.131068	5.94567972	Pedosphaera parvula	1032527	Bacteria	Bacteria	315	2.97e-81	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g131303	i0	87.143	137.4229390681	280	32	100	4	1	279	24	300	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	38341	315	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
21896052	21896052	PRJNA1112809_P_NODE_137118_length_276_cov_3.453202_g133843_i0	PRJNA1112809	137118	276	3.453202	9.53083752	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	89.8	1.93e-13	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g133843	i0	83.333	1.2536231884058	102	11	36	4	6	104	261361	261263	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	346	89.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
21896573	21896573	PRJNA1112809_P_NODE_161618_length_253_cov_1.166667_g158343_i0	PRJNA1112809	161618	253	1.166667	2.95166751	Horticoccus luteus	2862869	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g158343	i0	96.875	0.126482213438735	32	1	13	0	5	36	2068645	2068614	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	32	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
23975987	23975987	PRJNA1112809_P_NODE_90779_length_352_cov_1.655914_g87504_i0	PRJNA1112809	90779	352	1.655914	5.82881728	Prosthecobacter	48463	Bacteria	Bacteria	555	2.0799999999999995e-153	NTclustered	gi\|2116728087\|gb\|OK513264.1\|	48465	g87504	i0	94.766	103.071022727273	363	8	100	4	1	352	500	138	Prosthecobacter dejongeii strain CG69 16S ribosomal RNA gene, partial sequence	blastn	36281	560	0.991071428571429	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii

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);;