metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA1068830" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA1068830" and tax_superkingdom = "Archaea"

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
182669	182669	PRJNA1068830_P_NODE_36201_length_373_cov_1.533333_g35498_i0	PRJNA1068830	36201	373	1.533333	5.71933209	Methanobacteriota archaeon	2026739	Archaea	Archaea	182	1.1099999999999999e-54	NR	MEK9804820.1	2026739	g35498	i0	68.3	2.07506702412869	126	38	99.7	1	1	372	61	186	MEK9804820.1 thymidylate synthase [Methanobacteriota archaeon]	diamond	774	182	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
19309263	19309263	PRJNA1068830_P_NODE_78316_length_249_cov_0.886364_g77613_i0	PRJNA1068830	78316	249	0.886364	2.20704636	root	1	Root_unresolved	Root_unresolved	110	4.36e-26	NR	MBO7731199.1	66852	g77613	i0	66.3	10	83	28	100	0	1	249	251	333	MBO7731199.1 hypothetical protein [Methanobrevibacter sp.]	diamond	2490	110	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
26687429	26687429	PRJNA1068830_P_NODE_37021_length_368_cov_1.715254_g36318_i0	PRJNA1068830	37021	368	1.715254	6.31213472	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	134	7.8e-34	NR	MEM5878165.1	3121606	g36318	i0	54.5	1.99728260869565	123	55	99.5	1	2	367	221	343	MEM5878165.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon]	diamond	735	134	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota					Candidatus Aenigmatarchaeota archaeon
26846115	26846115	PRJNA1068830_P_NODE_78641_length_249_cov_0.886364_g77938_i0	PRJNA1068830	78641	249	0.886364	2.20704636	Methanoculleus sediminis	1550566	Archaea	Archaea	44.3	0.0113	NR	WP_052959027.1	1550566	g77938	i0	33.8	0.819277108433735	68	45	81.9	0	35	238	391	458	WP_052959027.1 glycoside hydrolase family 15 protein [Methanoculleus sediminis]	diamond	204	44.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanoculleus	Methanoculleus sediminis
26900822	26900822	PRJNA1068830_P_NODE_65581_length_267_cov_3.407216_g64878_i0	PRJNA1068830	65581	267	3.407216	9.09726672	root	1	Root_unresolved	Root_unresolved	45.4	0.00551	NR	MBU1604850.1	2026764	g64878	i0	38.2	1.31460674157303	76	36	78.7	4	224	15	56	126	MBU1604850.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	351	45.8	0.991266375545852	Archaea		Nanobdellati	Nanobdellota					Nanobdellota archaeon
27856941	27856941	PRJNA1068830_P_NODE_66505_length_265_cov_2.031250_g65802_i0	PRJNA1068830	66505	265	2.03125	5.3828125	Methanobacteriota archaeon	2026739	Archaea	Archaea	46.6	0.00209	NR	MBT05095.1	2026739	g65802	i0	33.3	2.04905660377359	90	53	94	2	250	2	127	216	MBT05095.1 hypothetical protein [Methanobacteriota archaeon]	diamond	543	46.6	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
28015042	28015042	PRJNA1068830_P_NODE_52385_length_302_cov_1.021834_g51682_i0	PRJNA1068830	52385	302	1.021834	3.08593868	Staphylothermus sp.	2820299	Archaea	Archaea	66.6	1.3099999999999999e-10	NR	MCD6195324.1	2820299	g51682	i0	41.5	1.05298013245033	106	50	96.4	6	302	12	66	168	MCD6195324.1 ribonuclease Z [Staphylothermus sp.]	diamond	318	66.6	1	Archaea		Thermoproteati	Thermoproteota	Thermoprotei	Desulfurococcales	Desulfurococcaceae	Staphylothermus	Staphylothermus sp.
29341105	29341105	PRJNA1068830_P_NODE_69829_length_258_cov_1.264865_g69126_i0	PRJNA1068830	69829	258	1.264865	3.2633517	Thermoplasmatota archaeon	2806419	Archaea	Archaea	68.9	2.57e-11	NR	MBU3902331.1	2806419	g69126	i0	46.3	1.91860465116279	82	42	95.3	1	254	9	220	299	MBU3902331.1 CTP synthase (glutamine hydrolyzing) [Thermoplasmatota archaeon]	diamond	495	68.9	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
30478197	30478197	PRJNA1068830_P_NODE_8433_length_879_cov_2.266749_g7834_i0	PRJNA1068830	8433	879	2.266749	19.92472371	Zestosphaera sp.	2303494	Archaea	Archaea	441	1.1099999999999999e-151	NR	MFN3268367.1	2303494	g7834	i0	96.1	0.784982935153584	230	9	78.5	0	877	188	201	430	MFN3268367.1 RNA-guided endonuclease InsQ/TnpB family protein [Zestosphaera sp.]	diamond	690	441	1	Archaea		Thermoproteati	Thermoproteota	Thermoprotei	Desulfurococcales	Desulfurococcaceae	Zestosphaera	Zestosphaera sp.
30604386	30604386	PRJNA1068830_P_NODE_75513_length_251_cov_0.876404_g74810_i0	PRJNA1068830	75513	251	0.876404	2.19977404	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	40	0.0417	NR	WP_295622269.1	253161	g74810	i0	46.3	0.49003984063745	41	22	49	0	19	141	7	47	WP_295622269.1 hypothetical protein [uncultured Methanobrevibacter sp.]	diamond	123	40	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
30848783	30848783	PRJNA1068830_P_NODE_62574_length_275_cov_0.975248_g61871_i0	PRJNA1068830	62574	275	0.975248	2.681932	root	1	Root_unresolved	Root_unresolved	121	8.89e-31	NR	WP_295591711.1	66852	g61871	i0	63.7	4.97454545454545	91	30	99.3	1	275	3	18	105	WP_295591711.1 ATP-binding protein [Methanobrevibacter sp.]	diamond	1368	121	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
31837192	31837192	PRJNA1068830_P_NODE_82497_length_246_cov_0.901734_g81794_i0	PRJNA1068830	82497	246	0.901734	2.21826564	Candidatus Thorarchaeota archaeon	2053491	Archaea	Archaea	45.8	0.00296	NR	MCK4740343.1	2053491	g81794	i0	39.7	0.768292682926829	63	38	76.8	0	4	192	165	227	MCK4740343.1 DUF362 domain-containing protein [Candidatus Thorarchaeota archaeon]	diamond	189	45.8	1	Archaea		Promethearchaeati	Candidatus Thorarchaeota					Candidatus Thorarchaeota archaeon
31900625	31900625	PRJNA1068830_P_NODE_39417_length_355_cov_1.361702_g38714_i0	PRJNA1068830	39417	355	1.361702	4.8340421	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	163	3.44e-44	NR	MEM5878272.1	3121606	g38714	i0	65	0.988732394366197	117	41	98.9	0	1	351	398	514	MEM5878272.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon]	diamond	351	163	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota					Candidatus Aenigmatarchaeota archaeon
32753997	32753997	PRJNA1068830_P_NODE_40520_length_349_cov_1.807971_g39817_i0	PRJNA1068830	40520	349	1.807971	6.30981879	Thermoplasmata archaeon	1906666	Archaea	Archaea	61.6	1.1e-9	NR	RLF66471.1	1906666	g39817	i0	64.9	0.318051575931232	37	13	31.8	0	127	17	2	38	RLF66471.1 MAG: hypothetical protein DRN30_02075 [Thermoplasmata archaeon]	diamond	111	61.6	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
32785355	32785355	PRJNA1068830_P_NODE_33920_length_388_cov_1.507937_g33217_i0	PRJNA1068830	33920	388	1.507937	5.85079556	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	90.1	4.46e-18	NR	MAH48438.1	2026773	g33217	i0	41.1	0.997422680412371	129	74	99	2	1	384	345	472	MAH48438.1 hypothetical protein [Candidatus Pacearchaeota archaeon]	diamond	387	90.1	1	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota archaeon

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