metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA859990" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA859990" 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
28160731	28160731	PRJNA859990_S_NODE_21565_length_242_cov_1.284024_g21304_i0	PRJNA859990	21565	242	1.284024	3.10733808	Hyla sarda	327740	Chordata	Chordata	62	4.26e-9	NR	XP_056389893.1	327740	g21304	i0	65.9	3.44628099173554	44	15	54.5	0	68	199	241	284	XP_056389893.1 ORM1-like protein 1 isoform X1 [Hyla sarda]	diamond	834	62	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Hylidae	Hyla	Hyla sarda
30308360	30308360	PRJNA859990_S_NODE_20792_length_244_cov_0.900585_g20531_i0	PRJNA859990	20792	244	0.900585	2.1974274	Polypterus senegalus	55291	Chordata	Chordata	47	0.00116	NR	KAG2460102.1	55291	g20531	i0	46.9	1.57377049180328	64	16	56.6	1	243	106	96	159	KAG2460102.1 TCB1 transposase, partial [Polypterus senegalus]	diamond	384	47	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
31856673	31856673	PRJNA859990_S_NODE_9197_length_333_cov_1.207692_g8936_i0	PRJNA859990	9197	333	1.207692	4.02161436	Hypanus sabinus	79690	Chordata	Chordata	60.8	4.61e-8	NR	XP_059823631.1	79690	g8936	i0	46	0.45045045045045	50	27	45	0	229	80	558	607	XP_059823631.1 IQ calmodulin-binding motif-containing protein 1 isoform X1 [Hypanus sabinus]	diamond	150	60.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Myliobatiformes	Dasyatidae	Hypanus	Hypanus sabinus
32458079	32458079	PRJNA859990_S_NODE_7179_length_371_cov_3.161074_g6918_i0	PRJNA859990	7179	371	3.161074	11.72758454	Erpetoichthys calabaricus	27687	Chordata	Chordata	133	3.79e-35	NR	XP_051791274.1	27687	g6918	i0	77.8	6.61455525606469	90	19	72	1	16	282	115	204	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	2454	133	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus

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