metadata: contig_metadata: 3 rows where bioproject = "PRJDB4941" and tax

3 rows where bioproject = "PRJDB4941" 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
26811005	26811005	PRJDB4941_P_NODE_32961_length_172_cov_1.268293_g32193_i0	PRJDB4941	32961	172	1.268293	2.18146396	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	55.8	3.4e-7	NR	KAJ8032781.1	206669	g32193	i0	62.5	0.697674418604651	40	15	69.8	0	1	120	384	423	KAJ8032781.1 DEP domain-containing mTOR-interacting protein [Holothuria leucospilota]	diamond	120	55.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
28422359	28422359	PRJDB4941_P_NODE_9706_length_367_cov_1.927673_g8938_i0	PRJDB4941	9706	367	1.927673	7.07455991	Ocnus glacialis	3074281	Echinodermata	other_Eukaryota	75.1	6.46e-13	NR	YP_010954568.1	3074281	g8938	i0	41.3	2.95095367847411	104	57	85	1	41	352	245	344	YP_010954568.1 NADH dehydrogenase subunit 4 [Ocnus glacialis]	diamond	1083	75.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Dendrochirotida	Cucumariidae	Ocnus	Ocnus glacialis
31644174	31644174	PRJDB4941_P_NODE_26477_length_195_cov_1.424658_g25709_i0	PRJDB4941	26477	195	1.424658	2.7780831	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	49.3	4.03e-5	NR	XP_033111226.1	1529436	g25709	i0	65.6	0.492307692307692	32	11	49.2	0	39	134	51	82	XP_033111226.1 MIT domain-containing protein 1-like, partial [Anneissia japonica]	diamond	96	49.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica

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