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

5 rows where analysis = "diamond", bioproject = "PRJNA924320" 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
28667077	28667077	PRJNA924320_S_NODE_53307_length_163_cov_0.894737_g53165_i0	PRJNA924320	53307	163	0.894737	1.45842131	Thermofilum pendens	2269	Archaea	Archaea	71.6	7.76e-13	NR	WP_011752483.1	2269	g53165	i0	54.7	0.975460122699387	53	24	97.5	0	3	161	289	341	WP_011752483.1 proline--tRNA ligase [Thermofilum pendens]	diamond	159	71.6	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermofilales	Thermofilaceae	Thermofilum	Thermofilum pendens
29582248	29582248	PRJNA924320_S_NODE_49770_length_165_cov_0.879310_g49628_i0	PRJNA924320	49770	165	0.87931	1.4508615	Metallosphaera hakonensis	79601	Archaea	Archaea	45.1	0.00193	NR	WP_240938780.1	79601	g49628	i0	43.1	0.927272727272727	51	25	92.7	1	2	154	252	298	WP_240938780.1 diphosphomevalonate decarboxylase [Metallosphaera hakonensis]	diamond	153	45.1	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae	Metallosphaera	Metallosphaera hakonensis
31415151	31415151	PRJNA924320_S_NODE_39736_length_178_cov_1.046512_g39594_i0	PRJNA924320	39736	178	1.046512	1.86279136	Candidatus Nitrosothermus koennekii	2927315	Archaea	Archaea	58.2	1.85e-8	NR	RMF28850.1	2927315	g39594	i0	44.4	1.8876404494382	54	30	91	0	17	178	82	135	RMF28850.1 MAG: 5-formyltetrahydrofolate cyclo-ligase [Candidatus Nitrosothermus koennekii]	diamond	336	58.2	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Candidatus Nitrosocaldales	Candidatus Nitrosocaldaceae	Candidatus Nitrosothermus	Candidatus Nitrosothermus koennekii
31478587	31478587	PRJNA924320_S_NODE_34736_length_188_cov_1.100719_g34594_i0	PRJNA924320	34736	188	1.100719	2.06935172	Candidatus Nitrosomaritimum aestuariumsis	3342354	Archaea	Archaea	50.8	2.19e-5	NR	MFB5604269.1	3342354	g34594	i0	34.4	2.93617021276596	61	39	97.3	1	188	6	10	69	MFB5604269.1 tRNA (adenine-N1)-methyltransferase [Candidatus Nitrosomaritimum aestuariumsis]	diamond	552	50.8	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Candidatus Nitrosomaritimum	Candidatus Nitrosomaritimum aestuariumsis
31549178	31549178	PRJNA924320_S_NODE_7956_length_343_cov_2.081633_g7814_i0	PRJNA924320	7956	343	2.081633	7.14000119	root	1	Root_unresolved	Root_unresolved	64.7	1.71e-9	NR	MFP3144362.1	2060322	g7814	i0	39.6	2.7201166180758	106	52	87.5	4	26	325	186	285	MFP3144362.1 ABC transporter ATP-binding protein [Caldisphaera sp.]	diamond	933	64.7	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Acidilobales	Caldisphaeraceae	Caldisphaera	Caldisphaera sp.

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