metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA438111" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA438111" 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
433951	433951	PRJNA438111_P_NODE_27721_length_210_cov_6.779006_g27096_i0	PRJNA438111	27721	210	6.779006	14.2359126	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	110	1.08e-19	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g27096	i0	86.735	0.466666666666667	98	13	47	0	3	100	3635480	3635577	Lacunisphaera limnophila strain IG16b, complete genome	blastn	98	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
1090513	1090513	PRJNA438111_P_NODE_33241_length_209_cov_4.038889_g32616_i0	PRJNA438111	33241	209	4.038889	8.44127801	Opitutaceae	134623	Bacteria	Bacteria	126	1.06e-24	NTclustered	gi\|2647674565\|gb\|CP139781.1\|	2866162	g32616	i0	96.104	1.20095693779904	77	3	37	0	1	77	2325392	2325316	Actomonas aquatica strain WL0086 chromosome, complete genome	blastn	251	126	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Actomonas	Actomonas aquatica
1709069	1709069	PRJNA438111_P_NODE_42642_length_190_cov_4.229814_g42017_i0	PRJNA438111	42642	190	4.229814	8.0366466	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	215	1.97e-51	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g42017	i0	89.412	0.894736842105263	170	18	89	0	1	170	3252526	3252695	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	170	215	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
1709625	1709625	PRJNA438111_P_NODE_85202_length_154_cov_2.272000_g84577_i0	PRJNA438111	85202	154	2.272	3.49888	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	198	1.53e-46	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g84577	i0	92.143	1.75974025974026	140	11	91	0	1	140	3565650	3565511	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	271	198	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2984903	2984903	PRJNA438111_P_NODE_46403_length_186_cov_1.783439_g45778_i0	PRJNA438111	46403	186	1.783439	3.31719654	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	195	2.5e-45	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g45778	i0	85.792	0.983870967741935	183	26	98	0	4	186	2679711	2679529	Lacunisphaera limnophila strain IG16b, complete genome	blastn	183	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
4261026	4261026	PRJNA438111_P_NODE_32224_length_210_cov_3.480663_g31599_i0	PRJNA438111	32224	210	3.480663	7.3093923	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	76.8	1.09e-9	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g31599	i0	88.71	0.819047619047619	62	7	30	0	142	203	406976	406915	Luteolibacter sp. Populi chromosome, complete genome	blastn	172	76.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
4918901	4918901	PRJNA438111_P_NODE_67564_length_166_cov_2.364964_g66939_i0	PRJNA438111	67564	166	2.364964	3.92584024	Verrucomicrobiota	74201	Bacteria	Bacteria	274	2.73e-69	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g66939	i0	98.089	138.277108433735	157	3	95	0	1	157	1913	1757	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	22954	274	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
6811579	6811579	PRJNA438111_P_NODE_18366_length_248_cov_9.908676_g17741_i0	PRJNA438111	18366	248	9.908676	24.57351648	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g17741	i0	94.286	0.141129032258065	35	2	14	0	32	66	4342705	4342739	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	35	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
6812209	6812209	PRJNA438111_P_NODE_61646_length_170_cov_2.801418_g61021_i0	PRJNA438111	61646	170	2.801418	4.7624106	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	198	1.73e-46	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g61021	i0	89.308	13.6	159	15	93	2	1	158	2400843	2400686	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	2312	198	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
9362587	9362587	PRJNA438111_P_NODE_70828_length_164_cov_1.785185_g70203_i0	PRJNA438111	70828	164	1.785185	2.9277034	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	130	6.15e-26	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g70203	i0	82.781	34.3536585365854	151	20	90	5	4	151	3798107	3797960	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	5634	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11912947	11912947	PRJNA438111_P_NODE_43270_length_189_cov_6.518750_g42645_i0	PRJNA438111	43270	189	6.51875	12.3204375	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	239	1.16e-58	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g42645	i0	89.474	19.1111111111111	190	18	100	2	1	189	2895664	2895852	Lacunisphaera limnophila strain IG16b, complete genome	blastn	3612	239	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
11913461	11913461	PRJNA438111_P_NODE_82510_length_156_cov_2.236220_g81885_i0	PRJNA438111	82510	156	2.23622	3.4885032	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	89.8	9.79e-14	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g81885	i0	84.444	1.46794871794872	90	14	58	0	17	106	1827875	1827964	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	229	89.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
13188018	13188018	PRJNA438111_P_NODE_54771_length_176_cov_5.945578_g54146_i0	PRJNA438111	54771	176	5.945578	10.46421728	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	235	1.37e-57	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g54146	i0	90.857	0.994318181818182	175	16	99	0	1	175	1564841	1564667	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	175	235	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
13188144	13188144	PRJNA438111_P_NODE_64071_length_168_cov_4.086331_g63446_i0	PRJNA438111	64071	168	4.086331	6.86503608	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	172	1.04e-38	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g63446	i0	85.207	2.19047619047619	169	23	100	2	1	168	1808314	1808147	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	368	172	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
13188308	13188308	PRJNA438111_P_NODE_76591_length_160_cov_4.229008_g75966_i0	PRJNA438111	76591	160	4.229008	6.7664128	Opitutales bacterium	2026772	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2626245913\|emb\|OY829953.1\|	2026772	g75966	i0	96.875	0.41875	32	1	20	0	43	74	4454477	4454446	MAG: Opitutales bacterium isolate cf0dc631-26ae-4be7-9546-4b6096dd6533 genome assembly, chromosome: 1	blastn	67	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
14462974	14462974	PRJNA438111_P_NODE_49032_length_182_cov_7.019608_g48407_i0	PRJNA438111	49032	182	7.019608	12.77568656	Opitutus terrae	107709	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g48407	i0	100	0.164835164835165	30	0	16	0	98	127	2139022	2139051	Opitutus terrae PB90-1, complete genome	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
14463210	14463210	PRJNA438111_P_NODE_66132_length_167_cov_2.057971_g65507_i0	PRJNA438111	66132	167	2.057971	3.43681157	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	176	7.969999999999999e-40	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g65507	i0	85.629	8.46107784431138	167	24	100	0	1	167	3615346	3615180	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	1413	176	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
15736581	15736581	PRJNA438111_P_NODE_26813_length_211_cov_6.340659_g26188_i0	PRJNA438111	26813	211	6.340659	13.37879049	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	213	8.03e-51	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g26188	i0	85.308	1	211	22	100	1	1	211	333300	333501	Lacunisphaera limnophila strain IG16b, complete genome	blastn	211	213	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
15736613	15736613	PRJNA438111_P_NODE_28593_length_210_cov_5.325967_g27968_i0	PRJNA438111	28593	210	5.325967	11.1845307	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	237	4.74e-58	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g27968	i0	86.19	1	210	26	100	1	1	210	3563435	3563229	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	210	237	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
15736968	15736968	PRJNA438111_P_NODE_54193_length_177_cov_2.939189_g53568_i0	PRJNA438111	54193	177	2.939189	5.20236453	Chthoniobacter flavus	191863	Bacteria	Bacteria	281	1.75e-71	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g53568	i0	95.48	242.090395480226	177	6	100	2	1	177	1896	1722	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	42850	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
17011584	17011584	PRJNA438111_P_NODE_51734_length_179_cov_8.620000_g51109_i0	PRJNA438111	51734	179	8.62	15.4298	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	296	6.34e-76	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g51109	i0	96.629	5.93296089385475	178	6	99	0	1	178	874590	874413	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	1062	296	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
18285629	18285629	PRJNA438111_P_NODE_28395_length_210_cov_5.613260_g27770_i0	PRJNA438111	28395	210	5.61326	11.787846	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	63.9	8.51e-6	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g27770	i0	95	0.19047619047619	40	2	19	0	169	208	855069	855108	Lacunisphaera limnophila strain IG16b, complete genome	blastn	40	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
19559927	19559927	PRJNA438111_P_NODE_31436_length_210_cov_3.707182_g30811_i0	PRJNA438111	31436	210	3.707182	7.7850822	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	115	2.32e-21	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g30811	i0	90.698	3.03809523809524	86	8	41	0	2	87	2755497	2755582	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	638	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20836183	20836183	PRJNA438111_P_NODE_71537_length_163_cov_4.231343_g70912_i0	PRJNA438111	71537	163	4.231343	6.89708909	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	95.3	2.23e-15	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g70912	i0	83.81	1.23926380368098	105	11	63	3	1	102	762896	762795	Luteolibacter sp. Populi chromosome, complete genome	blastn	202	95.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
23386797	23386797	PRJNA438111_P_NODE_73139_length_162_cov_4.105263_g72514_i0	PRJNA438111	73139	162	4.105263	6.65052606	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	134	4.6800000000000005e-27	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g72514	i0	82.353	2.41358024691358	170	14	100	11	1	162	418592	418431	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	391	134	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
24660716	24660716	PRJNA438111_P_NODE_62300_length_170_cov_1.007092_g61675_i0	PRJNA438111	62300	170	1.007092	1.7120564	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	111	2.31e-20	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g61675	i0	79.87	0.905882352941176	154	29	90	2	18	170	4298876	4299028	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	154	111	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);;