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

5 rows where analysis = "diamond", bioproject = "PRJNA1139127" and tax_phylum = "Chordata"

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
27575932	27575932	PRJNA1139127_P_NODE_42524_length_252_cov_0.865922_g42031_i0	PRJNA1139127	42524	252	0.865922	2.18212344	Staurois parvus	386267	Chordata	Chordata	55.8	1.36e-7	NR	CAI9580232.1	386267	g42031	i0	47.4	1.80952380952381	76	33	82.1	2	5	211	48	123	CAI9580232.1 unnamed protein product, partial [Staurois parvus]	diamond	456	55.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
28807027	28807027	PRJNA1139127_P_NODE_39708_length_263_cov_1.331579_g39215_i0	PRJNA1139127	39708	263	1.331579	3.50205277	Phalacrocorax carbo	9209	Chordata	Chordata	72	1.07e-13	NR	XP_064297567.1	9209	g39215	i0	50.7	0.832699619771863	73	30	78.7	2	24	230	1	71	XP_064297567.1 mth938 domain-containing protein isoform X1 [Phalacrocorax carbo]	diamond	219	72	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Suliformes	Phalacrocoracidae	Phalacrocorax	Phalacrocorax carbo
30164999	30164999	PRJNA1139127_P_NODE_27392_length_341_cov_1.078358_g26900_i0	PRJNA1139127	27392	341	1.078358	3.67720078	Molossus molossus	27622	Chordata	Chordata	67.4	7.71e-11	NR	KAF6462323.1	27622	g26900	i0	52.1	1.24046920821114	71	29	58.9	2	214	14	121	190	KAF6462323.1 hypothetical protein HJG59_011354 [Molossus molossus]	diamond	423	67.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Molossidae	Molossus	Molossus molossus
30386749	30386749	PRJNA1139127_P_NODE_40473_length_259_cov_1.666667_g39980_i0	PRJNA1139127	40473	259	1.666667	4.31666753	Lynx pardinus	191816	Chordata	Chordata	63.9	3.14e-11	NR	VFV22668.1	191816	g39980	i0	70	0.926640926640927	40	12	46.3	0	2	121	25	64	VFV22668.1 Hypothetical predicted protein, partial [Lynx pardinus]	diamond	240	63.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Lynx	Lynx pardinus
31587538	31587538	PRJNA1139127_P_NODE_39276_length_265_cov_1.598958_g38783_i0	PRJNA1139127	39276	265	1.598958	4.2372387	Piaya cayana	33601	Chordata	Chordata	42.7	0.0246	NR	NWH82408.1	33601	g38783	i0	46.5	0.486792452830189	43	21	48.7	1	263	135	92	132	NWH82408.1 CCD97 protein [Piaya cayana]	diamond	129	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Cuculiformes	Coccyzidae	Piaya	Piaya cayana

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