metadata: contig_metadata: 4 rows where bioproject = "PRJNA703759", tax_kingdom = "Metazoa" and tax

4 rows where bioproject = "PRJNA703759", tax_kingdom = "Metazoa" 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
7063008	7063008	PRJNA703759_P_NODE_31906_length_260_cov_1.668449_g31430_i0	PRJNA703759	31906	260	1.668449	4.3379674	Lytechinus pictus	7653	Echinodermata	other_Eukaryota	54.7	0.007	NTclustered	gi\|2707366282\|ref\|XM_064112470.1\|	7653	g31430	i0	92.308	0.3	39	2	15	1	205	242	1890	1852	PREDICTED: Lytechinus pictus macrophage mannose receptor 1-like (LOC129280200), transcript variant X2, mRNA	blastn	78	54.7	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
31863828	31863828	PRJNA703759_P_NODE_20857_length_305_cov_1.107759_g20381_i0	PRJNA703759	20857	305	1.107759	3.37866495	root	1	Root_unresolved	Root_unresolved	88.2	8.58e-18	NR	XP_038064778.1	46514	g20381	i0	52.7	3.66885245901639	93	37	91.5	1	25	303	9	94	XP_038064778.1 uncharacterized protein LOC119735148 [Patiria miniata]	diamond	1119	88.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
32264452	32264452	PRJNA703759_P_NODE_33598_length_255_cov_1.428571_g33122_i0	PRJNA703759	33598	255	1.428571	3.64285605	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	64.3	1.13e-9	NR	KAJ8029065.1	206669	g33122	i0	42.4	1.96470588235294	85	49	100	0	255	1	365	449	KAJ8029065.1 hypothetical protein HOLleu_28369 [Holothuria leucospilota]	diamond	501	64.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
32359392	32359392	PRJNA703759_P_NODE_47819_length_244_cov_0.912281_g47343_i0	PRJNA703759	47819	244	0.912281	2.22596564	Patiria miniata	46514	Echinodermata	other_Eukaryota	44.7	0.00792	NR	XP_038052115.1	46514	g47343	i0	60	0.307377049180328	25	10	30.7	0	168	242	1124	1148	XP_038052115.1 uncharacterized protein LOC119724889 isoform X1 [Patiria miniata]	diamond	75	44.7	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata

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