metadata: contig_metadata: 14 rows where bioproject = "PRJNA1010780" and tax

14 rows where bioproject = "PRJNA1010780" and tax_phylum = "Thermoplasmatota"

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
10358287	10358287	PRJNA1010780_S_NODE_3929_length_1362_cov_9.969103_g3536_i0	PRJNA1010780	3929	1362	9.969103	135.77918286	Thermoplasmata archaeon	1906666	Archaea	Archaea	54.7	0.039	NTclustered	gi\|2108430933\|gb\|CP070629.1\|	1906666	g3536	i0	100	0.0212922173274596	29	0	2	0	359	387	1587405	1587433	MAG: Thermoplasmata archaeon isolate bin983 chromosome	blastn	29	54.7	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
12908709	12908709	PRJNA1010780_S_NODE_11_length_7480_cov_28.199597_g3_i0	PRJNA1010780	11	7480	28.199597	2109.3298556	Acidiplasma aeolicum	507754	Archaea	Archaea	496	1.12e-155	NR	WP_393917166.1	507754	g3	i0	78.6	0.127540106951872	318	68	12.8	0	7474	6521	12	329	WP_393917166.1 NADH-quinone oxidoreductase subunit NuoH [Acidiplasma aeolicum]	diamond	954	496	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmatales	Ferroplasmaceae	Acidiplasma	Acidiplasma aeolicum
26622937	26622937	PRJNA1010780_S_NODE_161_length_3670_cov_7.293260_g127_i0	PRJNA1010780	161	3670	7.29326	267.662642	Thermoplasmata archaeon	1906666	Archaea	Archaea	82	1.49e-11	NR	MCX8174033.1	1906666	g127	i0	27	0.699727520435967	293	188	22.1	12	2705	3514	558	847	MCX8174033.1 fibronectin type III domain-containing protein [Thermoplasmata archaeon]	diamond	2568	82	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
26813178	26813178	PRJNA1010780_S_NODE_881_length_2356_cov_20.558380_g768_i0	PRJNA1010780	881	2356	20.55838	484.3554328	Candidatus Aciduliprofundum boonei	379547	Archaea	Archaea	100	1.47e-17	NR	WP_012997047.1	379547	g768	i0	30.5	0.669779286926995	272	172	33	8	955	179	1204	1471	WP_012997047.1 NosD domain-containing protein [Candidatus Aciduliprofundum boonei]	diamond	1578	100	1	Archaea	DHVE2 group	Methanobacteriati	Thermoplasmatota				Candidatus Aciduliprofundum	Candidatus Aciduliprofundum boonei
26908020	26908020	PRJNA1010780_S_NODE_24482_length_324_cov_2.110727_g23193_i0	PRJNA1010780	24482	324	2.110727	6.83875548	Thermoplasmata archaeon	1906666	Archaea	Archaea	87.8	1.46e-17	NR	MCK5559500.1	1906666	g23193	i0	33.9	1.06481481481481	115	68	99.1	2	322	2	354	468	MCK5559500.1 hypothetical protein [Thermoplasmata archaeon]	diamond	345	87.8	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
29150849	29150849	PRJNA1010780_S_NODE_52869_length_168_cov_2.278195_g51580_i0	PRJNA1010780	52869	168	2.278195	3.8273676	Candidatus Thalassarchaeum sp.	3134679	Archaea	Archaea	42	0.0248	NR	MCH2428708.1	3134679	g51580	i0	39.2	1.89285714285714	51	31	91.1	0	3	155	260	310	MCH2428708.1 DMT family transporter [Candidatus Thalassarchaeum sp.]	diamond	318	42	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Thalassarchaeaceae	Candidatus Thalassarchaeum	Candidatus Thalassarchaeum sp.
29308212	29308212	PRJNA1010780_S_NODE_27349_length_290_cov_1.898039_g26060_i0	PRJNA1010780	27349	290	1.898039	5.5043131	Thermoplasmatota archaeon	2806419	Archaea	Archaea	41.2	0.0412	NR	MCL4480106.1	2806419	g26060	i0	30.9	0.568965517241379	55	38	56.9	0	22	186	4	58	MCL4480106.1 hypothetical protein [Thermoplasmatota archaeon]	diamond	165	41.2	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
29371549	29371549	PRJNA1010780_S_NODE_40909_length_203_cov_2.285714_g39620_i0	PRJNA1010780	40909	203	2.285714	4.63999942	Thermoplasmatales archaeon SG8-52-4	1803819	Archaea	Archaea	43.9	0.00869	NR	KYK20903.1	1803819	g39620	i0	39.6	0.70935960591133	48	29	70.9	0	22	165	291	338	KYK20903.1 MAG: hypothetical protein AYK24_03460 [Thermoplasmatales archaeon SG8-52-4]	diamond	144	43.9	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmatales			Thermoplasmatales archaeon SG8-52-4
29592081	29592081	PRJNA1010780_S_NODE_3010_length_1526_cov_4.570087_g2690_i0	PRJNA1010780	3010	1526	4.570087	69.73952762	Candidatus Aciduliprofundum boonei	379547	Archaea	Archaea	50.8	0.0189	NR	WP_012997047.1	379547	g2690	i0	32.7	0.204456094364351	104	60	18.5	3	1162	1443	1209	1312	WP_012997047.1 NosD domain-containing protein [Candidatus Aciduliprofundum boonei]	diamond	312	50.8	1	Archaea	DHVE2 group	Methanobacteriati	Thermoplasmatota				Candidatus Aciduliprofundum	Candidatus Aciduliprofundum boonei
30034676	30034676	PRJNA1010780_S_NODE_1911_length_1826_cov_5.081519_g1697_i0	PRJNA1010780	1911	1826	5.081519	92.78853694	Candidatus Aciduliprofundum boonei	379547	Archaea	Archaea	91.7	5.7e-15	NR	WP_012997047.1	379547	g1697	i0	29.1	0.463307776560789	282	169	43.9	11	906	106	1301	1566	WP_012997047.1 NosD domain-containing protein [Candidatus Aciduliprofundum boonei]	diamond	846	91.7	1	Archaea	DHVE2 group	Methanobacteriati	Thermoplasmatota				Candidatus Aciduliprofundum	Candidatus Aciduliprofundum boonei
30153165	30153165	PRJNA1010780_S_NODE_1712_length_1905_cov_3.551872_g1515_i0	PRJNA1010780	1712	1905	3.551872	67.6631616	Candidatus Aciduliprofundum	379546	Archaea	Archaea	64.3	1.89e-6	NR	WP_012997047.1	379547	g1515	i0	26.9	1.11181102362205	242	153	35.4	10	678	4	1204	1438	WP_012997047.1 NosD domain-containing protein [Candidatus Aciduliprofundum boonei]	diamond	2118	64.3	1	Archaea	DHVE2 group	Methanobacteriati	Thermoplasmatota				Candidatus Aciduliprofundum	Candidatus Aciduliprofundum boonei
30887654	30887654	PRJNA1010780_S_NODE_20694_length_387_cov_6.164773_g19405_i0	PRJNA1010780	20694	387	6.164773	23.85767151	Candidatus Poseidoniaceae archaeon	2666346	Archaea	Archaea	75.9	2.96e-14	NR	MDP6011847.1	2666346	g19405	i0	41.1	4.13953488372093	112	56	84.5	3	34	360	44	148	MDP6011847.1 plastocyanin/azurin family copper-binding protein [Candidatus Poseidoniaceae archaeon]	diamond	1602	75.9	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales	Candidatus Poseidoniaceae		Candidatus Poseidoniaceae archaeon
31361960	31361960	PRJNA1010780_S_NODE_3336_length_1460_cov_12.468070_g2999_i0	PRJNA1010780	3336	1460	12.46807	182.033822	Thermoplasmata archaeon	1906666	Archaea	Archaea	474	4.3999999999999985e-161	NR	RLF35890.1	1906666	g2999	i0	52.1	0.883561643835616	430	197	86.7	4	1419	154	2	430	RLF35890.1 MAG: spermidine synthase [Thermoplasmata archaeon]	diamond	1290	474	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
31891930	31891930	PRJNA1010780_S_NODE_56077_length_162_cov_1.519685_g54788_i0	PRJNA1010780	56077	162	1.519685	2.4618897	root	1	Root_unresolved	Root_unresolved	48.5	1.14e-4	NR	WP_290705637.1	261388	g54788	i0	46.2	3.87037037037037	52	28	96.3	0	4	159	98	149	WP_290705637.1 MFS transporter, partial [Ferroplasma sp. Type II]	diamond	627	48.5	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmatales	Ferroplasmaceae	Ferroplasma	Ferroplasma sp. Type II

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