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

4 rows where analysis = "diamond", bioproject = "PRJNA340009" and tax_phylum = "Echinodermata"

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
28085349	28085349	PRJNA340009_P_NODE_71665_length_163_cov_0.894737_g71358_i0	PRJNA340009	71665	163	0.894737	1.45842131	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	42	0.0183	NR	KAJ8040522.1	206669	g71358	i0	43.9	2.33742331288344	41	21	75.5	1	132	10	14	52	KAJ8040522.1 hypothetical protein HOLleu_14837 [Holothuria leucospilota]	diamond	381	42	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
29348459	29348459	PRJNA340009_P_NODE_28749_length_231_cov_2.236264_g28442_i0	PRJNA340009	28749	231	2.236264	5.16576984	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	46.2	6.83e-4	NR	XP_041472159.1	7654	g28442	i0	38.9	3.66233766233766	72	35	83.1	3	230	39	69	139	XP_041472159.1 ubiquitin-conjugating enzyme E2 variant 2-like [Lytechinus variegatus]	diamond	846	46.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
29569291	29569291	PRJNA340009_P_NODE_12890_length_326_cov_1.870036_g12583_i0	PRJNA340009	12890	326	1.870036	6.09631736	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	52.8	2.64e-5	NR	PIK56948.1	307972	g12583	i0	34.1	2.13496932515337	82	51	72.7	1	81	317	172	253	PIK56948.1 hypothetical protein BSL78_06149 [Apostichopus japonicus]	diamond	696	52.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
31844619	31844619	PRJNA340009_P_NODE_34697_length_213_cov_8.536585_g34390_i0	PRJNA340009	34697	213	8.536585	18.18292605	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	43.1	0.0175	NR	XP_030840376.1	7668	g34390	i0	58.1	3.09859154929577	31	13	43.7	0	203	111	273	303	XP_030840376.1 mitochondrial glycine transporter B [Strongylocentrotus purpuratus]	diamond	660	43.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus

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