metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1118794" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1118794" and tax_kingdom = "Thermoproteati"

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
26624873	26624873	PRJNA1118794_P_NODE_74021_length_241_cov_0.916667_g73271_i0	PRJNA1118794	74021	241	0.916667	2.20916747	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	44.7	0.00499	NR	MDR4512426.1	2169593	g73271	i0	41.3	0.572614107883817	46	26	56	1	104	238	112	157	MDR4512426.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	138	44.7	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
28859040	28859040	PRJNA1118794_P_NODE_67508_length_243_cov_0.905882_g66758_i0	PRJNA1118794	67508	243	0.905882	2.20129326	Pyrodictium	2308	Archaea	Archaea	50.4	2.17e-5	NR	HIP85490.1	1970082	g66758	i0	43.6	2.66666666666667	55	31	67.9	0	202	38	89	143	HIP85490.1 universal stress protein [Pyrodictium sp.]	diamond	648	50.4	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Desulfurococcales	Pyrodictiaceae	Pyrodictium	Pyrodictium sp.
29964384	29964384	PRJNA1118794_P_NODE_44811_length_258_cov_1.664865_g44061_i0	PRJNA1118794	44811	258	1.664865	4.2953517	Candidatus Nitrosotenuis	1825023	Archaea	Archaea	45.4	0.00482	NR	MDE1830666.1	2026795	g44061	i0	69.2	0.63953488372093	26	8	30.2	0	177	254	24	49	MDE1830666.1 hypothetical protein [Nitrososphaerota archaeon]	diamond	165	45.8	0.991266375545852	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
31141936	31141936	PRJNA1118794_P_NODE_32055_length_287_cov_1.177570_g31305_i0	PRJNA1118794	32055	287	1.17757	3.3796259	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	45.4	0.00643	NR	HXW86481.1	3045160	g31305	i0	36.8	0.710801393728223	68	41	69	1	210	13	165	232	HXW86481.1 hypothetical protein [Candidatus Bathyarchaeia archaeon]	diamond	204	45.4	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia				Candidatus Bathyarchaeia archaeon
32588557	32588557	PRJNA1118794_P_NODE_46359_length_255_cov_1.642857_g45609_i0	PRJNA1118794	46359	255	1.642857	4.18928535	Archaea	2157	Archaea	Archaea	70.5	7.27e-12	NR	MBS7625291.1	2026714	g45609	i0	52	5.35294117647059	75	34	88.2	1	29	253	9	81	MBS7625291.1 glycoside hydrolase family 3 C-terminal domain-containing protein [Candidatus Bathyarchaeota archaeon]	diamond	1365	70.5	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota 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);;