metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA669701" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA669701" and tax_phylum = "Nitrososphaerota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
635561	635561	PRJNA669701_P_NODE_144221_length_237_cov_2.890244_g143826_i0	PRJNA669701	144221	237	2.890244	6.84987828	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	411	3.049999999999999e-110	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g143826	i0	97.89	1	237	5	100	0	1	237	1706044	1705808	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	237	411	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
635823	635823	PRJNA669701_P_NODE_33001_length_409_cov_2.556548_g32606_i0	PRJNA669701	33001	409	2.556548	10.45628132	Nitrosopumilus oxyclinae	1959104	Archaea	Archaea	54.7	0.011	NTclustered	gi\|1869222960\|gb\|CP026994.1\|	1959104	g32606	i0	100	0.0709046454767726	29	0	7	0	243	271	1575741	1575713	Nitrosopumilus oxyclinae strain HCE1 chromosome, complete genome	blastn	29	54.7	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus oxyclinae
636578	636578	PRJNA669701_P_NODE_93061_length_266_cov_3.590674_g92666_i0	PRJNA669701	93061	266	3.590674	9.55119284	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	448	2.6599999999999996e-121	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g92666	i0	97.338	0.988721804511278	263	7	99	0	4	266	2012758	2012496	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	263	448	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
1911042	1911042	PRJNA669701_P_NODE_101982_length_257_cov_1.228261_g101587_i0	PRJNA669701	101982	257	1.228261	3.15663077	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	161	3.72e-35	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g101587	i0	86.897	0.673151750972763	145	18	56	1	84	227	218936	218792	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	173	161	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
1911206	1911206	PRJNA669701_P_NODE_113502_length_249_cov_1.750000_g113107_i0	PRJNA669701	113502	249	1.75	4.3575	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	446	8.849999999999999e-121	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g113107	i0	99.19	0.991967871485944	247	2	99	0	1	247	1912000	1912246	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	247	446	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
4463970	4463970	PRJNA669701_P_NODE_62624_length_310_cov_2.708861_g62229_i0	PRJNA669701	62624	310	2.708861	8.3974691	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	486	6.6999999999999986e-133	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g62229	i0	94.839	1	310	10	100	1	1	310	778363	778060	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	310	486	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
5738383	5738383	PRJNA669701_P_NODE_106945_length_251_cov_2.314607_g106550_i0	PRJNA669701	106945	251	2.314607	5.80966357	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	337	5.609999999999998e-88	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g106550	i0	90.837	1	251	23	100	0	1	251	1666123	1665873	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	251	337	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
7013529	7013529	PRJNA669701_P_NODE_106886_length_251_cov_2.516854_g106491_i0	PRJNA669701	106886	251	2.516854	6.31730354	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	246	9.72e-61	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g106491	i0	85.294	1.85657370517928	238	35	95	0	1	238	2467164	2467401	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	466	246	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
7013817	7013817	PRJNA669701_P_NODE_130006_length_244_cov_1.801170_g129611_i0	PRJNA669701	130006	244	1.80117	4.3948548	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	374	4.1399999999999986e-99	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g129611	i0	94.262	1	244	14	100	0	1	244	1067631	1067388	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	244	374	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
7013902	7013902	PRJNA669701_P_NODE_136466_length_242_cov_3.337278_g136071_i0	PRJNA669701	136466	242	3.337278	8.07621276	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	425	1.11e-114	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g136071	i0	98.347	2	242	4	100	0	1	242	1942860	1942619	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	484	425	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
7014052	7014052	PRJNA669701_P_NODE_148186_length_224_cov_4.562914_g147791_i0	PRJNA669701	148186	224	4.562914	10.22092736	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	207	4.01e-49	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g147791	i0	83.475	1.05357142857143	236	25	100	9	1	224	2703188	2702955	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	236	207	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
8289743	8289743	PRJNA669701_P_NODE_96727_length_262_cov_3.582011_g96332_i0	PRJNA669701	96727	262	3.582011	9.38486882	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	479	9.249999999999999e-131	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g96332	i0	100	0.988549618320611	259	0	99	0	4	262	2972828	2972570	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	259	479	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
9563339	9563339	PRJNA669701_P_NODE_103188_length_255_cov_2.274725_g102793_i0	PRJNA669701	103188	255	2.274725	5.80054875	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	433	7.08e-117	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g102793	i0	97.255	1	255	7	100	0	1	255	1648777	1649031	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	255	433	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
10839429	10839429	PRJNA669701_P_NODE_133969_length_243_cov_1.194118_g133574_i0	PRJNA669701	133969	243	1.194118	2.90170674	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	381	2.4599999999999995e-101	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g133574	i0	96.137	0.958847736625514	233	9	96	0	8	240	1728629	1728861	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	233	381	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
12115488	12115488	PRJNA669701_P_NODE_75730_length_287_cov_1.439252_g75335_i0	PRJNA669701	75730	287	1.439252	4.13065324	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	481	2.86e-131	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g75335	i0	96.864	1	287	9	100	0	1	287	1042899	1042613	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	287	481	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
13389384	13389384	PRJNA669701_P_NODE_136471_length_242_cov_3.289941_g136076_i0	PRJNA669701	136471	242	3.289941	7.96165722	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	392	1.1299999999999999e-104	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g136076	i0	95.868	1.13636363636364	242	10	100	0	1	242	857841	858082	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	275	392	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
13389483	13389483	PRJNA669701_P_NODE_144531_length_236_cov_3.134969_g144136_i0	PRJNA669701	144531	236	3.134969	7.39852684	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	401	1.8199999999999993e-107	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g144136	i0	97.458	1.29237288135593	236	5	100	1	1	236	1018090	1017856	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	305	401	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
13390309	13390309	PRJNA669701_P_NODE_80751_length_281_cov_1.384615_g80356_i0	PRJNA669701	80751	281	1.384615	3.89076815	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	424	4.77e-114	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g80356	i0	93.95	1	281	15	100	1	1	281	1408207	1408485	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	281	424	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
15937800	15937800	PRJNA669701_P_NODE_109053_length_251_cov_0.865169_g108658_i0	PRJNA669701	109053	251	0.865169	2.17157419	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	459	1.1499999999999996e-124	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g108658	i0	99.602	1	251	1	100	0	1	251	53086	52836	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	251	459	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
15938270	15938270	PRJNA669701_P_NODE_144813_length_235_cov_3.882716_g144418_i0	PRJNA669701	144813	235	3.882716	9.1243826	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	372	1.42e-98	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g144418	i0	95.319	1	235	10	100	1	1	235	1233537	1233770	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	235	372	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
15939024	15939024	PRJNA669701_P_NODE_74533_length_288_cov_3.353488_g74138_i0	PRJNA669701	74533	288	3.353488	9.65804544	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	488	1.7099999999999998e-133	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g74138	i0	97.222	1	288	8	100	0	1	288	1052947	1053234	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	288	488	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
17213217	17213217	PRJNA669701_P_NODE_128054_length_245_cov_0.895349_g127659_i0	PRJNA669701	128054	245	0.895349	2.19360505	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	420	5.26e-113	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g127659	i0	97.934	0.987755102040816	242	5	99	0	1	242	757001	757242	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	242	420	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
18487294	18487294	PRJNA669701_P_NODE_103215_length_255_cov_2.175824_g102820_i0	PRJNA669701	103215	255	2.175824	5.5483512	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	455	1.51e-123	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g102820	i0	98.824	1	255	3	100	0	1	255	2194080	2194334	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	255	455	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
22313744	22313744	PRJNA669701_P_NODE_87998_length_272_cov_2.271357_g87603_i0	PRJNA669701	87998	272	2.271357	6.17809104	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	481	2.69e-131	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g87603	i0	98.885	0.988970588235294	269	3	99	0	4	272	921640	921372	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	269	481	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
22313831	22313831	PRJNA669701_P_NODE_94558_length_265_cov_1.333333_g94163_i0	PRJNA669701	94558	265	1.333333	3.53333245	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	316	7.78e-82	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g94163	i0	89.057	1	265	15	100	6	1	265	1721376	1721626	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	265	316	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
23587655	23587655	PRJNA669701_P_NODE_102979_length_255_cov_3.719780_g102584_i0	PRJNA669701	102979	255	3.71978	9.485439	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	466	6.98e-127	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g102584	i0	99.608	1	255	1	100	0	1	255	1979713	1979967	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	255	466	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
23587890	23587890	PRJNA669701_P_NODE_119899_length_247_cov_1.770115_g119504_i0	PRJNA669701	119899	247	1.770115	4.37218405	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	457	4.05e-124	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g119504	i0	100	1	247	0	100	0	1	247	1897318	1897072	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	247	457	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
23588071	23588071	PRJNA669701_P_NODE_133479_length_243_cov_1.811765_g133084_i0	PRJNA669701	133479	243	1.811765	4.40258895	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	416	6.739999999999998e-112	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g133084	i0	97.531	1	243	6	100	0	1	243	1614699	1614941	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	243	416	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
24861406	24861406	PRJNA669701_P_NODE_126960_length_245_cov_1.377907_g126565_i0	PRJNA669701	126960	245	1.377907	3.37587215	uncultured marine thaumarchaeote AD1000_100_C06	1455887	Archaea	Archaea	453	5.1900000000000006e-123	NTclustered	gi\|663500052\|gb\|KF900324.1\|	1455887	g126565	i0	100	1	245	0	100	0	1	245	37014	37258	Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence	blastn	245	453	1	Archaea	Thermoproteati	Nitrososphaerota					uncultured marine thaumarchaeote AD1000_100_C06

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