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

22 rows where analysis = "blastn", bioproject = "PRJEB64798" 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
126671	126671	PRJEB64798_P_NODE_123681_length_203_cov_7.175325_g121915_i0	PRJEB64798	123681	203	7.175325	14.56590975	Nitrosarchaeum sp. AC2	2259673	Archaea	Archaea	315	2.04e-81	NTclustered	gi\|1869229208\|gb\|CP030847.1\|	2259673	g121915	i0	95	67.6206896551724	200	10	99	0	1	200	1086429	1086628	Nitrosarchaeum sp. AC2 chromosome, complete genome	blastn	13727	315	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp. AC2
993656	993656	PRJEB64798_P_NODE_58161_length_255_cov_19.592233_g56396_i0	PRJEB64798	58161	255	19.592233	49.96019415	Stenosarchaea group	2290931	Archaea	Archaea	58.4	4.98e-4	NTclustered	gi\|14548123\|gb\|U40238.2\|	44557	g56396	i0	94.737	8.44705882352941	38	0	14	2	149	184	29972	30009	Uncultured crenarchaeote 4B7 40 kb genomic fragment	blastn	2154	58.4	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales			uncultured crenarchaeote 4B7
2268566	2268566	PRJEB64798_P_NODE_248182_length_152_cov_6.436893_g246416_i0	PRJEB64798	248182	152	6.436893	9.78407736	Nitrosopumilus	338191	Archaea	Archaea	261	1.9e-65	NTclustered	gi\|2289589374\|dbj\|AP026695.1\|	718286	g246416	i0	98.639	36.5197368421053	147	2	97	0	5	151	1660242	1660388	Nitrosopumilus zosterae NM25 DNA, complete genome	blastn	5551	261	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus zosterae
2679467	2679467	PRJEB64798_P_NODE_63943_length_243_cov_4.680412_g62178_i0	PRJEB64798	63943	243	4.680412	11.37340116	Candidatus Nitrosocosmicus oleophilus	1353260	Archaea	Archaea	268	2e-67	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g62178	i0	87.023	19.5185185185185	262	5	96	3	6	239	848095	848355	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	4743	268	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
3955193	3955193	PRJEB64798_P_NODE_50624_length_275_cov_6.867257_g48859_i0	PRJEB64798	50624	275	6.867257	18.88495675	Nitrosarchaeum sp. AC2	2259673	Archaea	Archaea	475	1.2699999999999996e-129	NTclustered	gi\|1869229208\|gb\|CP030847.1\|	2259673	g48859	i0	97.818	59.1236363636364	275	6	100	0	1	275	1087101	1087375	Nitrosarchaeum sp. AC2 chromosome, complete genome	blastn	16259	475	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp. AC2
4821652	4821652	PRJEB64798_P_NODE_60324_length_251_cov_1.356436_g58559_i0	PRJEB64798	60324	251	1.356436	3.40465436	Candidatus Nitrosocosmicus	1826864	Archaea	Archaea	435	1.93e-117	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g58559	i0	98.394	40.195219123506	249	1	98	1	5	250	849436	849684	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	10089	435	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
5229274	5229274	PRJEB64798_P_NODE_124025_length_203_cov_3.746753_g122259_i0	PRJEB64798	124025	203	3.746753	7.60590859	Candidatus Nitrosotenuis aquarius	1846278	Archaea	Archaea	302	1.59e-77	NTclustered	gi\|1279207014\|gb\|CP024808.1\|	1846278	g122259	i0	93.596	1.54187192118227	203	11	99	2	2	203	1533851	1534052	Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome	blastn	313	302	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis aquarius
5231556	5231556	PRJEB64798_P_NODE_46185_length_289_cov_4.341667_g44420_i0	PRJEB64798	46185	289	4.341667	12.54741763	Nitrosarchaeum sp. AC2	2259673	Archaea	Archaea	501	2.21e-137	NTclustered	gi\|1869229208\|gb\|CP030847.1\|	2259673	g44420	i0	99.278	79.2975778546713	277	2	96	0	3	279	1085547	1085823	Nitrosarchaeum sp. AC2 chromosome, complete genome	blastn	22917	501	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp. AC2
6096875	6096875	PRJEB64798_P_NODE_73285_length_225_cov_8.789773_g71520_i0	PRJEB64798	73285	225	8.789773	19.77698925	Candidatus Nitrosocosmicus	1826864	Archaea	Archaea	329	8.25e-86	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g71520	i0	93.636	27.5422222222222	220	14	98	0	6	225	848584	848803	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	6197	329	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
6507054	6507054	PRJEB64798_P_NODE_38306_length_319_cov_6.311111_g36546_i0	PRJEB64798	38306	319	6.311111	20.13244409	Nitrosarchaeum sp. AC2	2259673	Archaea	Archaea	488	1.9199999999999997e-133	NTclustered	gi\|1869229208\|gb\|CP030847.1\|	2259673	g36546	i0	95.146	56.0282131661442	309	15	97	0	11	319	1086471	1086163	Nitrosarchaeum sp. AC2 chromosome, complete genome	blastn	17873	488	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp. AC2
7779445	7779445	PRJEB64798_P_NODE_14207_length_530_cov_4.334719_g12545_i0	PRJEB64798	14207	530	4.334719	22.9740107	Candidatus Nitrosotenuis aquarius	1846278	Archaea	Archaea	846	0	NTclustered	gi\|1026536793\|gb\|KX023321.1\|	1846278	g12545	i0	95.802	96.9471698113207	524	22	99	0	7	530	896	373	Candidatus Nitrosotenuis aquarius strain AQ6f 16S ribosomal RNA gene, partial sequence	blastn	51382	846	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis aquarius
7779727	7779727	PRJEB64798_P_NODE_160907_length_183_cov_2.470149_g159141_i0	PRJEB64798	160907	183	2.470149	4.52037267	Candidatus Nitrosocosmicus franklandianus	1798806	Archaea	Archaea	182	1.91e-41	NTclustered	gi\|1599533355\|emb\|LR216287.1\|	1798806	g159141	i0	85.549	40.9180327868852	173	25	95	0	1	173	2470	2642	Candidatus Nitrosocosmicus franklandus isolate NFRAN1 genome assembly, chromosome: NFRAN	blastn	7488	182	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus franklandianus
16703940	16703940	PRJEB64798_P_NODE_15934_length_499_cov_14.642222_g14241_i0	PRJEB64798	15934	499	14.642222	73.06468778	Nitrosarchaeum sp. AC2	2259673	Archaea	Archaea	595	1.8e-165	NTclustered	gi\|1869229208\|gb\|CP030847.1\|	2259673	g14241	i0	98.802	58.6513026052104	334	4	99	0	1	334	1087725	1088058	Nitrosarchaeum sp. AC2 chromosome, complete genome	blastn	29267	595	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp. AC2
16704214	16704214	PRJEB64798_P_NODE_176674_length_176_cov_1.354331_g174908_i0	PRJEB64798	176674	176	1.354331	2.38362256	Candidatus Nitrosotenuis aquarius	1846278	Archaea	Archaea	309	7.98e-80	NTclustered	gi\|1279207014\|gb\|CP024808.1\|	1846278	g174908	i0	99.412	44.5227272727273	170	1	97	0	1	170	106759	106590	Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome	blastn	7836	309	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis aquarius
16704975	16704975	PRJEB64798_P_NODE_228154_length_159_cov_6.300000_g226388_i0	PRJEB64798	228154	159	6.3	10.017	Nitrosopumilus sp. K4	2795383	Archaea	Archaea	230	5.67e-56	NTclustered	gi\|2028944715\|gb\|CP067007.1\|	2795383	g226388	i0	93.506	7.74842767295597	154	10	97	0	6	159	101751	101904	Nitrosopumilus sp. K4 chromosome, complete genome	blastn	1232	230	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp. K4
17978868	17978868	PRJEB64798_P_NODE_164355_length_181_cov_5.257576_g162589_i0	PRJEB64798	164355	181	5.257576	9.51621256	Candidatus Nitrosotenuis aquarius	1846278	Archaea	Archaea	272	1.08e-68	NTclustered	gi\|1279207014\|gb\|CP024808.1\|	1846278	g162589	i0	94.35	0.977900552486188	177	10	98	0	3	179	1533595	1533771	Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome	blastn	177	272	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis aquarius
17979727	17979727	PRJEB64798_P_NODE_223475_length_161_cov_4.330357_g221709_i0	PRJEB64798	223475	161	4.330357	6.97187477	Candidatus Nitrosotenuis aquarius	1846278	Archaea	Archaea	291	2.6e-74	NTclustered	gi\|1279207014\|gb\|CP024808.1\|	1846278	g221709	i0	99.375	15.3540372670807	160	1	99	0	2	161	291575	291734	Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome	blastn	2472	291	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis aquarius
17981148	17981148	PRJEB64798_P_NODE_78455_length_217_cov_4.255952_g76689_i0	PRJEB64798	78455	217	4.255952	9.23541584	Nitrosarchaeum sp. AC2	2259673	Archaea	Archaea	350	6.07e-92	NTclustered	gi\|1869229208\|gb\|CP030847.1\|	2259673	g76689	i0	96.262	56.9400921658986	214	7	98	1	5	217	1086829	1086616	Nitrosarchaeum sp. AC2 chromosome, complete genome	blastn	12356	350	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp. AC2
20529266	20529266	PRJEB64798_P_NODE_232137_length_158_cov_2.788991_g230371_i0	PRJEB64798	232137	158	2.788991	4.40660578	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	204	3.4099999999999996e-48	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g230371	i0	90.85	2.78481012658228	153	13	96	1	2	153	1789813	1789661	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	440	204	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
21804428	21804428	PRJEB64798_P_NODE_190278_length_170_cov_3.942149_g188512_i0	PRJEB64798	190278	170	3.942149	6.7016533	Candidatus Nitrosotenuis aquarius	1846278	Archaea	Archaea	172	1.0499999999999999e-38	NTclustered	gi\|1279207014\|gb\|CP024808.1\|	1846278	g188512	i0	90.769	0.764705882352941	130	10	76	2	6	134	1531727	1531855	Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome	blastn	130	172	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis aquarius
23080294	23080294	PRJEB64798_P_NODE_231559_length_158_cov_3.889908_g229793_i0	PRJEB64798	231559	158	3.889908	6.14605464	Candidatus Nitrosotenuis sp. DW1	2259672	Archaea	Archaea	150	4.499999999999999e-32	NTclustered	gi\|1869227213\|gb\|CP030846.1\|	2259672	g229793	i0	100	26.4050632911392	81	0	97	0	73	153	1026870	1026950	Candidatus Nitrosotenuis sp. DW1 chromosome, complete genome	blastn	4172	150	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis sp. DW1
24352620	24352620	PRJEB64798_P_NODE_129560_length_198_cov_7.107383_g127794_i0	PRJEB64798	129560	198	7.107383	14.07261834	Nitrosarchaeum sp. AC2	2259673	Archaea	Archaea	329	7.08e-86	NTclustered	gi\|1869229208\|gb\|CP030847.1\|	2259673	g127794	i0	97.895	27.5050505050505	190	4	96	0	2	191	1087579	1087768	Nitrosarchaeum sp. AC2 chromosome, complete genome	blastn	5446	329	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp. AC2

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