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

7 rows where analysis = "diamond", bioproject = "PRJNA473641" 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
28323962	28323962	PRJNA473641_P_NODE_20606_length_247_cov_0.885057_g20523_i0	PRJNA473641	20606	247	0.885057	2.18609079	Chordata	7711	Chordata	Chordata	99	3.84e-22	NR	XP_067901988.1	7792	g20523	i0	62.8	129.789473684211	78	29	94.7	0	1	234	363	440	XP_067901988.1 CUGBP Elav-like family member 1 isoform X3 [Heterodontus francisci]	diamond	32058	100	0.99	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Heterodontiformes	Heterodontidae	Heterodontus	Heterodontus francisci
29318190	29318190	PRJNA473641_P_NODE_15149_length_266_cov_1.860104_g15066_i0	PRJNA473641	15149	266	1.860104	4.94787664	Pleurodeles waltl	8319	Chordata	Chordata	52.4	1.88e-5	NR	KAJ1171285.1	8319	g15066	i0	75	0.406015037593985	36	9	40.6	0	8	115	325	360	KAJ1171285.1 hypothetical protein NDU88_003149 [Pleurodeles waltl]	diamond	108	52.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
29492261	29492261	PRJNA473641_P_NODE_21170_length_246_cov_1.485549_g21087_i0	PRJNA473641	21170	246	1.485549	3.65445054	Anura	8342	Chordata	Chordata	79.3	1.06e-15	NR	CAK8643388.1	30338	g21087	i0	48.7	5.70731707317073	78	40	95.1	0	3	236	108	185	CAK8643388.1 Thiosulfate sulfurtransferase [Bufotes viridis]	diamond	1404	80.1	0.990012484394507	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
29539180	29539180	PRJNA473641_P_NODE_20610_length_247_cov_0.885057_g20527_i0	PRJNA473641	20610	247	0.885057	2.18609079	Sigmodon hispidus	42415	Chordata	Chordata	73.6	5.31e-13	NR	KAL1770555.1	42415	g20527	i0	54.4	0.825910931174089	68	31	82.6	0	3	206	219	286	KAL1770555.1 putative tRNA N6-adenosine threonylcarbamoyltransferase, mitochondrial [Sigmodon hispidus]	diamond	204	73.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Sigmodon	Sigmodon hispidus
30377128	30377128	PRJNA473641_P_NODE_14932_length_268_cov_1.594872_g14849_i0	PRJNA473641	14932	268	1.594872	4.27425696	Metazoa	33208	Chordata	Chordata	57.8	2.31e-7	NR	KAF6366319.1	59472	g14849	i0	45.2	9.73880597014925	62	32	67.2	1	6	185	280	341	KAF6366319.1 hydroxysteroid 17-beta dehydrogenase 4 [Pipistrellus kuhlii]	diamond	2610	58.2	0.993127147766323	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Vespertilionidae	Pipistrellus	Pipistrellus kuhlii
30708023	30708023	PRJNA473641_P_NODE_17954_length_250_cov_0.870056_g17871_i0	PRJNA473641	17954	250	0.870056	2.17514	Phocoena sinus	42100	Chordata	Chordata	46.2	0.00229	NR	XP_032458646.1	42100	g17871	i0	63.2	0.456	38	14	45.6	0	60	173	256	293	XP_032458646.1 ras-related protein Rab-31 isoform X1 [Phocoena sinus]	diamond	114	46.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Phocoenidae	Phocoena	Phocoena sinus
31957224	31957224	PRJNA473641_P_NODE_14237_length_275_cov_0.960396_g14154_i0	PRJNA473641	14237	275	0.960396	2.641089	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	107	2.35e-27	NR	XP_034341345.1	61156	g14154	i0	49.4	10.7672727272727	89	45	97.1	0	9	275	36	124	XP_034341345.1 ubiquitin-conjugating enzyme E2 D2-like [Arvicanthis niloticus]	diamond	2961	107	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Arvicanthis	Arvicanthis niloticus

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