metadata: contig_metadata: 7 rows where bioproject = "PRJNA763243" and tax

7 rows where bioproject = "PRJNA763243" 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
16508243	16508243	PRJNA763243_P_NODE_73553_length_204_cov_4.694656_g73207_i0	PRJNA763243	73553	204	4.694656	9.57709824	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	99	1.9e-22	NR	KAJ8043112.1	206669	g73207	i0	64.1	0.941176470588235	64	23	94.1	0	200	9	178	241	KAJ8043112.1 Nucleoredoxin [Holothuria leucospilota]	diamond	192	99	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
28032442	28032442	PRJNA763243_P_NODE_44345_length_266_cov_3.632124_g43999_i0	PRJNA763243	44345	266	3.632124	9.66144984	Acanthaster planci	133434	Echinodermata	other_Eukaryota	46.2	0.003	NR	XP_022099682.1	133434	g43999	i0	36	0.969924812030075	86	51	97	2	3	260	354	435	XP_022099682.1 importin-11-like [Acanthaster planci]	diamond	258	46.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
28736605	28736605	PRJNA763243_P_NODE_67827_length_229_cov_2.307692_g67481_i0	PRJNA763243	67827	229	2.307692	5.28461468	Metazoa	33208	Echinodermata	other_Eukaryota	44.3	0.00906	NR	XP_796328.1	7668	g67481	i0	41.8	6.85152838427948	55	26	72.1	2	175	11	519	567	XP_796328.1 scavenger receptor cysteine-rich domain-containing group B protein [Strongylocentrotus purpuratus]	diamond	1569	44.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
29178783	29178783	PRJNA763243_P_NODE_53329_length_250_cov_0.870056_g52983_i0	PRJNA763243	53329	250	0.870056	2.17514	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	44.7	0.00889	NR	XP_071507152.1	105358	g52983	i0	33.8	3.348	74	35	74.4	3	49	234	1374	1445	XP_071507152.1 proprotein convertase subtilisin/kexin type 5-like [Diadema antillarum]	diamond	837	45.1	0.991130820399113	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
30084607	30084607	PRJNA763243_P_NODE_22532_length_337_cov_2.742424_g22186_i0	PRJNA763243	22532	337	2.742424	9.24196888	Acanthaster planci	133434	Echinodermata	other_Eukaryota	105	2.0399999999999994e-24	NR	XP_022106438.1	133434	g22186	i0	44.8	0.934718100890208	105	50	93.5	2	315	1	67	163	XP_022106438.1 uncharacterized protein LOC110987731 [Acanthaster planci]	diamond	315	105	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
31348876	31348876	PRJNA763243_P_NODE_57356_length_246_cov_0.890173_g57010_i0	PRJNA763243	57356	246	0.890173	2.18982558	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	57.4	2.57e-7	NR	PIK51349.1	307972	g57010	i0	34.8	1.67073170731707	69	43	84.1	1	232	26	1	67	PIK51349.1 putative major facilitator superfamily domain-containing protein 7 [Apostichopus japonicus]	diamond	411	57.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
32434265	32434265	PRJNA763243_P_NODE_17899_length_370_cov_2.313131_g17554_i0	PRJNA763243	17899	370	2.313131	8.5585847	root	1	Root_unresolved	Root_unresolved	80.1	1.36e-14	NR	XP_071479160.1	105358	g17554	i0	58.3	2.33513513513514	60	25	48.6	0	367	188	531	590	XP_071479160.1 ATP-dependent translocase ABCB1-like [Diadema antillarum]	diamond	864	80.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum

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