metadata: contig_metadata: 5 rows where bioproject = "PRJNA506002", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJNA506002", tax_clade = "Opisthokonta" 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
11962641	11962641	PRJNA506002_S_NODE_32090_length_302_cov_1.305677_g31844_i0	PRJNA506002	32090	302	1.305677	3.94314454	Patiria miniata	46514	Echinodermata	other_Eukaryota	107	1.09e-24	NR	XP_038062985.1	46514	g31844	i0	55.9	0.923841059602649	93	40	92.4	1	281	3	1307	1398	XP_038062985.1 uncharacterized protein LOC119733659 [Patiria miniata]	diamond	279	107	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
22160782	22160782	PRJNA506002_S_NODE_50398_length_261_cov_0.851064_g50152_i0	PRJNA506002	50398	261	0.851064	2.22127704	Patiria miniata	46514	Echinodermata	other_Eukaryota	52.8	0.024	NTclustered	gi\|1944905447\|ref\|XM_038209540.1\|	46514	g50152	i0	100	0.10727969348659	28	0	11	0	142	169	4	31	PREDICTED: Patiria miniata ubiquitin-associated and SH3 domain-containing protein B-like (LOC119735687), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
30076949	30076949	PRJNA506002_S_NODE_65652_length_242_cov_0.911243_g65406_i0	PRJNA506002	65652	242	0.911243	2.20520806	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	50.1	9.79e-5	NR	KAJ8046701.1	206669	g65406	i0	46.8	2.91322314049587	47	25	58.3	0	70	210	644	690	KAJ8046701.1 RNA-directed DNA polymerase from mobile element jockey [Holothuria leucospilota]	diamond	705	50.4	0.994047619047619	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
31214085	31214085	PRJNA506002_S_NODE_40195_length_282_cov_0.870813_g39949_i0	PRJNA506002	40195	282	0.870813	2.45569266	Patiria miniata	46514	Echinodermata	other_Eukaryota	79.7	6.13e-15	NR	XP_038073012.1	46514	g39949	i0	53.3	1.76595744680851	75	32	79.8	2	279	55	695	766	XP_038073012.1 uncharacterized protein LOC119741333 [Patiria miniata]	diamond	498	80.5	0.990062111801242	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
31847025	31847025	PRJNA506002_S_NODE_1037_length_728_cov_1.960305_g836_i0	PRJNA506002	1037	728	1.960305	14.2710204	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	102	1.26e-20	NR	KAJ8031231.1	206669	g836	i0	32.9	0.614010989010989	149	96	59.8	2	242	676	386	534	KAJ8031231.1 hypothetical protein HOLleu_27895 [Holothuria leucospilota]	diamond	447	102	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota

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