metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA641707" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA641707" 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
612821	612821	PRJNA641707_P_NODE_190121_length_199_cov_3.100000_g187458_i0	PRJNA641707	190121	199	3.1	6.169	Candidatus Nitrosocosmicus oleophilus	1353260	Archaea	Archaea	180	7.59e-41	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g187458	i0	99	2.88442211055276	100	1	97	0	2	101	3035484	3035583	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	574	180	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
1158145	1158145	PRJNA641707_P_NODE_70461_length_249_cov_10.150000_g67798_i0	PRJNA641707	70461	249	10.15	25.2735	Candidatus Nitrosocosmicus	1826864	Archaea	Archaea	135	2.18e-27	NTclustered	gi\|1599533355\|emb\|LR216287.1\|	1798806	g67798	i0	78.404	6.35341365461847	213	43	85	3	1	211	647173	646962	Candidatus Nitrosocosmicus franklandus isolate NFRAN1 genome assembly, chromosome: NFRAN	blastn	1582	135	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus franklandianus
1887860	1887860	PRJNA641707_P_NODE_140062_length_242_cov_2.906736_g137399_i0	PRJNA641707	140062	242	2.906736	7.03430112	Candidatus Nitrosocosmicus oleophilus	1353260	Archaea	Archaea	172	1.6e-38	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g137399	i0	100	2.73553719008264	93	0	80	0	149	241	426901	426993	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	662	172	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
4444644	4444644	PRJNA641707_P_NODE_64464_length_263_cov_8.766355_g61802_i0	PRJNA641707	64464	263	8.766355	23.05551365	Candidatus Nitrosocosmicus arcticus	2035267	Archaea	Archaea	300	7.77e-77	NTclustered	gi\|1241355791\|gb\|KX863713.1\|	2035267	g61802	i0	87.645	17.9619771863118	259	30	98	2	6	263	1687	1430	Candidatus Nitrosocosmicus arcticus 23S ribosomal RNA gene, partial sequence	blastn	4724	300	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus arcticus
10086149	10086149	PRJNA641707_P_NODE_31268_length_387_cov_6.961538_g28655_i0	PRJNA641707	31268	387	6.961538	26.94115206	Nitrososphaera	497726	Archaea	Archaea	486	8.549999999999997e-133	NTclustered	gi\|300521484\|gb\|GU797787.1\|	497727	g28655	i0	89.433	77.1447028423773	388	37	99	4	1	385	1	387	Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence	blastn	29855	486	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Candidatus Nitrososphaera gargensis
10818866	10818866	PRJNA641707_P_NODE_271709_length_173_cov_8.798387_g269046_i0	PRJNA641707	271709	173	8.798387	15.22120951	Candidatus Nitrosocosmicus oleophilus	1353260	Archaea	Archaea	292	7.87e-75	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g269046	i0	98.214	0.971098265895954	168	2	97	1	1	168	2898524	2898690	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	168	292	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
10820755	10820755	PRJNA641707_P_NODE_48169_length_311_cov_31.988550_g45514_i0	PRJNA641707	48169	311	31.98855	99.4843905	Candidatus Nitrosocosmicus oleophilus	1353260	Archaea	Archaea	372	1.96e-98	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g45514	i0	99.034	55.08038585209	207	2	93	0	7	213	847744	847950	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	17130	372	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
11360594	11360594	PRJNA641707_P_NODE_260469_length_178_cov_3.271318_g257806_i0	PRJNA641707	260469	178	3.271318	5.82294604	Nitrososphaera	497726	Archaea	Archaea	272	1.06e-68	NTclustered	gi\|647810480\|gb\|CP007536.1\|	926571	g257806	i0	94.35	106.455056179775	177	10	99	0	2	178	891142	891318	Nitrososphaera viennensis EN76, complete genome	blastn	18949	272	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera viennensis
12091588	12091588	PRJNA641707_P_NODE_160310_length_213_cov_29.506098_g157647_i0	PRJNA641707	160310	213	29.506098	62.84798874	Candidatus Nitrosocosmicus oleophilus	1353260	Archaea	Archaea	374	3.519999999999999e-99	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g157647	i0	99.515	18.3474178403756	206	0	98	1	5	210	848342	848546	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	3908	374	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
12636328	12636328	PRJNA641707_P_NODE_268990_length_174_cov_10.920000_g266327_i0	PRJNA641707	268990	174	10.92	19.0008	Nitrososphaera	497726	Archaea	Archaea	52.8	0.015	NTclustered	gi\|647810480\|gb\|CP007536.1\|	926571	g266327	i0	96.875	0.551724137931034	32	0	18	1	124	155	1510088	1510058	Nitrososphaera viennensis EN76, complete genome	blastn	96	52.8	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera viennensis
13366974	13366974	PRJNA641707_P_NODE_189831_length_199_cov_3.500000_g187168_i0	PRJNA641707	189831	199	3.5	6.965	Candidatus Nitrososphaera evergladensis	1459637	Archaea	Archaea	115	2.17e-21	NTclustered	gi\|665992324\|gb\|CP007174.1\|	1459636	g187168	i0	90.698	3.15075376884422	86	8	43	0	97	182	2224387	2224472	Candidatus Nitrososphaera evergladensis SR1, complete genome	blastn	627	115	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Candidatus Nitrososphaera evergladensis
14641885	14641885	PRJNA641707_P_NODE_19832_length_489_cov_20.943182_g17332_i0	PRJNA641707	19832	489	20.943182	102.41215998	Candidatus Nitrosocosmicus oleophilus	1353260	Archaea	Archaea	686	0	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g17332	i0	92.34	75.3783231083845	483	36	99	1	3	485	849119	848638	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	36860	686	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
14643397	14643397	PRJNA641707_P_NODE_263352_length_177_cov_2.007812_g260689_i0	PRJNA641707	263352	177	2.007812	3.55382724	uncultured Nitrososphaerota archaeon	651141	Archaea	Archaea	117	5.23e-22	NTclustered	gi\|2874253717\|emb\|OY969559.1\|	651141	g260689	i0	80.952	0.830508474576271	147	28	83	0	2	148	1566895	1567041	MAG: uncultured Nitrososphaerota archaeon isolate MFD05512.bin.c.15 genome assembly, chromosome: 1	blastn	147	117	1	Archaea	Thermoproteati	Nitrososphaerota					uncultured Nitrososphaerota archaeon
14644735	14644735	PRJNA641707_P_NODE_318872_length_158_cov_5.128440_g316209_i0	PRJNA641707	318872	158	5.12844	8.1029352	Candidatus Nitrosocosmicus oleophilus	1353260	Archaea	Archaea	268	1.1899999999999998e-67	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g316209	i0	98.675	0.955696202531646	151	2	96	0	7	157	1569455	1569605	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	151	268	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
14646588	14646588	PRJNA641707_P_NODE_96952_length_246_cov_4.644670_g94289_i0	PRJNA641707	96952	246	4.64467	11.4258882	Candidatus Nitrosocosmicus oleophilus	1353260	Archaea	Archaea	180	9.77e-41	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g94289	i0	100	0.788617886178862	97	0	79	0	4	100	1731053	1730957	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	194	180	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
15186051	15186051	PRJNA641707_P_NODE_31272_length_387_cov_6.807692_g28659_i0	PRJNA641707	31272	387	6.807692	26.34576804	Nitrososphaera	497726	Archaea	Archaea	475	1.8499999999999998e-129	NTclustered	gi\|300521484\|gb\|GU797787.1\|	497727	g28659	i0	88.918	72.7519379844961	388	39	99	4	3	387	387	1	Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence	blastn	28155	475	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Candidatus Nitrososphaera gargensis
17735815	17735815	PRJNA641707_P_NODE_44674_length_324_cov_27.640000_g42023_i0	PRJNA641707	44674	324	27.64	89.5536	Candidatus Nitrosocosmicus	1826864	Archaea	Archaea	566	8.789999999999997e-157	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g42023	i0	98.742	84.0493827160494	318	4	98	0	7	324	847744	848061	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	27232	566	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
22835552	22835552	PRJNA641707_P_NODE_66458_length_258_cov_18.894737_g63795_i0	PRJNA641707	66458	258	18.894737	48.74842146	Nitrososphaera	497726	Archaea	Archaea	279	9.9e-71	NTclustered	gi\|300521484\|gb\|GU797787.1\|	497727	g63795	i0	86.614	75.2558139534884	254	33	98	1	6	258	175	428	Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence	blastn	19416	279	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Candidatus Nitrososphaera gargensis
23568021	23568021	PRJNA641707_P_NODE_299159_length_164_cov_8.860870_g296496_i0	PRJNA641707	299159	164	8.86087	14.5318268	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	100	4.82e-17	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g296496	i0	81.6	2.61585365853659	125	19	75	4	26	148	121314	121192	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	429	100	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
23568223	23568223	PRJNA641707_P_NODE_306999_length_162_cov_5.513274_g304336_i0	PRJNA641707	306999	162	5.513274	8.93150388	Candidatus Nitrosopumilus sediminis	1229909	Archaea	Archaea	134	4.6800000000000005e-27	NTclustered	gi\|407047065\|gb\|CP003843.1\|	1229909	g304336	i0	85.714	6.25308641975309	126	18	78	0	32	157	1584244	1584119	Candidatus Nitrosopumilus sp. AR2, complete genome	blastn	1013	134	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Candidatus Nitrosopumilus sediminis
24840717	24840717	PRJNA641707_P_NODE_256640_length_179_cov_7.676923_g253977_i0	PRJNA641707	256640	179	7.676923	13.74169217	Candidatus Nitrosocosmicus arcticus	2035267	Archaea	Archaea	174	3.1e-39	NTclustered	gi\|1241355791\|gb\|KX863713.1\|	2035267	g253977	i0	89.781	8.22346368715084	137	12	76	2	44	179	1596	1731	Candidatus Nitrosocosmicus arcticus 23S ribosomal RNA gene, partial sequence	blastn	1472	174	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus arcticus
24843333	24843333	PRJNA641707_P_NODE_6560_length_830_cov_7.971831_g4978_i0	PRJNA641707	6560	830	7.971831	66.1661973	Candidatus Nitrosocosmicus oleophilus	1353260	Archaea	Archaea	1064	0	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g4978	i0	98.667	72.2927710843373	600	8	95	0	112	711	849853	849254	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	60003	1064	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus

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