metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1168532" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1168532" 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
26882428	26882428	PRJNA1168532_S_NODE_297821_length_169_cov_2.420635_g294878_i0	PRJNA1168532	297821	169	2.420635	4.09087315	Orcinus orca	9733	Chordata	Chordata	52	6.78e-6	NR	XP_049563841.1	9733	g294878	i0	94.4	0.63905325443787	36	2	63.9	0	60	167	1	36	XP_049563841.1 translation initiation factor IF-2-like [Orcinus orca]	diamond	108	52	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Delphinidae	Orcinus	Orcinus orca
29851089	29851089	PRJNA1168532_S_NODE_286611_length_174_cov_0.969466_g283668_i0	PRJNA1168532	286611	174	0.969466	1.68687084	Sciurus carolinensis	30640	Chordata	Chordata	70.1	3.27e-12	NR	MBZ3889236.1	30640	g283668	i0	68.4	0.982758620689655	57	8	98.3	1	2	172	111	157	MBZ3889236.1 Serine/threonine-protein phosphatase 6 regulatory ankyrin repeat subunit A [Sciurus carolinensis]	diamond	171	70.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Sciuridae	Sciurus	Sciurus carolinensis
30640674	30640674	PRJNA1168532_S_NODE_362973_length_150_cov_0.878505_g360030_i0	PRJNA1168532	362973	150	0.878505	1.3177575	Eschrichtius robustus	9764	Chordata	Chordata	41.2	0.0378	NR	XP_068406946.1	9764	g360030	i0	56.7	0.6	30	13	60	0	61	150	264	293	XP_068406946.1 LOW QUALITY PROTEIN: RNA-binding protein with multiple splicing 2-like [Eschrichtius robustus]	diamond	90	41.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Eschrichtiidae	Eschrichtius	Eschrichtius robustus
32095241	32095241	PRJNA1168532_S_NODE_345838_length_153_cov_3.572727_g342895_i0	PRJNA1168532	345838	153	3.572727	5.46627231	Oryctolagus cuniculus	9986	Chordata	Chordata	59.7	1.11e-8	NR	XP_069906595.1	9986	g342895	i0	59.6	3.68627450980392	47	19	92.2	0	6	146	594	640	XP_069906595.1 LOW QUALITY PROTEIN: LINE-1 retrotransposable element ORF2 protein [Oryctolagus cuniculus]	diamond	564	59.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Lagomorpha	Leporidae	Oryctolagus	Oryctolagus cuniculus
32127107	32127107	PRJNA1168532_S_NODE_278758_length_177_cov_1.201493_g275815_i0	PRJNA1168532	278758	177	1.201493	2.12664261	Loxodonta africana	9785	Chordata	Chordata	53.1	3.36e-6	NR	XP_064138050.1	9785	g275815	i0	49	3.91525423728814	49	25	83.1	0	28	174	789	837	XP_064138050.1 protein zyg-11 homolog B isoform X1 [Loxodonta africana]	diamond	693	53.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Proboscidea	Elephantidae	Loxodonta	Loxodonta africana
32190253	32190253	PRJNA1168532_S_NODE_187938_length_227_cov_3.635870_g184995_i0	PRJNA1168532	187938	227	3.63587	8.2534249	Diceros bicornis minor	77932	Chordata	Chordata	45.4	0.00334	NR	XP_058412502.1	77932	g184995	i0	84	0.330396475770925	25	3	31.7	1	83	12	15	39	XP_058412502.1 LOW QUALITY PROTEIN: serine/threonine-protein kinase 24-like [Diceros bicornis minor]	diamond	75	45.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Perissodactyla	Rhinocerotidae	Diceros	Diceros bicornis
32526171	32526171	PRJNA1168532_S_NODE_337779_length_156_cov_1.371681_g334836_i0	PRJNA1168532	337779	156	1.371681	2.13982236	root	1	Root_unresolved	Root_unresolved	87.8	1.47e-18	NR	AAA39757.1	10090	g334836	i0	88	28.8461538461538	50	6	96.2	0	152	3	52	101	AAA39757.1 pol protein, partial [Mus musculus]	diamond	4500	88.6	0.99097065462754	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
32695702	32695702	PRJNA1168532_S_NODE_262040_length_184_cov_1.815603_g259097_i0	PRJNA1168532	262040	184	1.815603	3.34070952	Mesoplodon densirostris	48708	Chordata	Chordata	62	1.26e-9	NR	XP_059939792.1	48708	g259097	i0	49.2	0.994565217391304	61	29	96.2	1	2	178	8	68	XP_059939792.1 zinc finger protein 580 isoform X1 [Mesoplodon densirostris]	diamond	183	62	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Ziphiidae	Mesoplodon	Mesoplodon densirostris

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