metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA811714" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA811714" 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
27307289	27307289	PRJNA811714_P_NODE_12263_length_285_cov_2.179245_g12070_i0	PRJNA811714	12263	285	2.179245	6.21084825	Amblyraja radiata	386614	Chordata	Chordata	47.8	9.6e-4	NR	XP_032872135.1	386614	g12070	i0	66.7	0.284210526315789	27	9	28.4	0	2	82	4	30	XP_032872135.1 zinc finger protein 239-like, partial [Amblyraja radiata]	diamond	81	47.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Rajiformes	Rajidae	Amblyraja	Amblyraja radiata
29391210	29391210	PRJNA811714_P_NODE_24769_length_233_cov_2.887500_g24576_i0	PRJNA811714	24769	233	2.8875	6.727875	Staurois parvus	386267	Chordata	Chordata	63.9	4.39e-11	NR	CAI9547784.1	386267	g24576	i0	56.8	1.13304721030043	44	19	56.7	0	2	133	6	49	CAI9547784.1 unnamed protein product, partial [Staurois parvus]	diamond	264	63.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
29991123	29991123	PRJNA811714_P_NODE_12431_length_284_cov_2.175355_g12238_i0	PRJNA811714	12431	284	2.175355	6.1780082	Triturus pygmaeus	171367	Chordata	Chordata	40	0.0483	NR	ABU95988.1	171367	g12238	i0	100	0.950704225352113	18	0	19	0	284	231	16	33	ABU95988.1 cytochrome oxidase subunit I, partial [Triturus pygmaeus]	diamond	270	40	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Triturus	Triturus pygmaeus
30054090	30054090	PRJNA811714_P_NODE_16471_length_261_cov_2.457447_g16278_i0	PRJNA811714	16471	261	2.457447	6.41393667	Podarcis lilfordi	74358	Chordata	Chordata	60.5	2.74e-8	NR	CAI5775279.1	74358	g16278	i0	52.3	0.747126436781609	65	22	69	2	261	82	745	805	CAI5775279.1 Sin3A associated protein 130 [Podarcis lilfordi]	diamond	195	60.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Lacertidae	Podarcis	Podarcis lilfordi
31413114	31413114	PRJNA811714_P_NODE_29056_length_218_cov_5.337931_g28863_i0	PRJNA811714	29056	218	5.337931	11.63668958	Bufotes viridis	30338	Chordata	Chordata	43.5	0.014	NR	CAK8629749.1	30338	g28863	i0	63.3	1.27981651376147	30	11	41.3	0	90	1	331	360	CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis]	diamond	279	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
32488934	32488934	PRJNA811714_P_NODE_30779_length_208_cov_5.733333_g30586_i0	PRJNA811714	30779	208	5.733333	11.92533264	Staurois parvus	386267	Chordata	Chordata	71.6	2.99e-14	NR	CAI9547784.1	386267	g30586	i0	46.4	0.995192307692308	69	37	99.5	0	2	208	8	76	CAI9547784.1 unnamed protein product, partial [Staurois parvus]	diamond	207	71.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
32615086	32615086	PRJNA811714_P_NODE_27660_length_226_cov_3.019608_g27467_i0	PRJNA811714	27660	226	3.019608	6.82431408	Engystomops pustulosus	76066	Chordata	Chordata	44.7	0.00647	NR	KAG8571490.1	76066	g27467	i0	56.8	10.5663716814159	37	16	49.1	0	117	7	982	1018	KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus]	diamond	2388	44.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Leptodactylidae	Engystomops	Engystomops pustulosus

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