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

5 rows where analysis = "diamond", bioproject = "PRJNA637328" 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
27460369	27460369	PRJNA637328_P_NODE_16723_length_251_cov_1.009901_g16246_i0	PRJNA637328	16723	251	1.009901	2.53485151	Pleurodeles waltl	8319	Chordata	Chordata	41.6	0.0319	NR	KAJ1110109.1	8319	g16246	i0	29.2	0.860557768924303	72	50	86.1	1	29	244	25	95	KAJ1110109.1 hypothetical protein NDU88_007464 [Pleurodeles waltl]	diamond	216	41.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
30017918	30017918	PRJNA637328_P_NODE_5611_length_371_cov_1.263975_g5136_i0	PRJNA637328	5611	371	1.263975	4.68934725	Ranitomeya imitator	111125	Chordata	Chordata	69.7	4.9e-11	NR	CAJ0964204.1	111125	g5136	i0	73	0.905660377358491	37	10	29.9	0	286	176	15	51	CAJ0964204.1 unnamed protein product [Ranitomeya imitator]	diamond	336	69.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Dendrobatidae	Ranitomeya	Ranitomeya imitator
30902531	30902531	PRJNA637328_P_NODE_16494_length_252_cov_1.078818_g16017_i0	PRJNA637328	16494	252	1.078818	2.71862136	Engystomops pustulosus	76066	Chordata	Chordata	58.9	8.62e-8	NR	KAG8571490.1	76066	g16017	i0	53.2	2.82142857142857	79	36	92.9	1	234	1	1006	1084	KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus]	diamond	711	58.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Leptodactylidae	Engystomops	Engystomops pustulosus
31598221	31598221	PRJNA637328_S_NODE_4096_length_154_cov_0.905983_g4019_i0	PRJNA637328	4096	154	0.905983	1.39521382	Ranitomeya imitator	111125	Chordata	Chordata	42.7	0.0109	NR	CAJ0961913.1	111125	g4019	i0	58.6	2.82467532467532	29	12	56.5	0	3	89	785	813	CAJ0961913.1 unnamed protein product [Ranitomeya imitator]	diamond	435	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Dendrobatidae	Ranitomeya	Ranitomeya imitator
32862070	32862070	PRJNA637328_P_NODE_15860_length_255_cov_0.985437_g15383_i0	PRJNA637328	15860	255	0.985437	2.51286435	Rattus norvegicus	10116	Chordata	Chordata	47.8	7.65e-5	NR	EDL98840.1	10116	g15383	i0	76	0.588235294117647	50	12	58.8	0	105	254	1	50	EDL98840.1 acidic nuclear phosphoprotein 32 family, member B, isoform CRA_a [Rattus norvegicus]	diamond	150	47.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Rattus	Rattus norvegicus

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