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

4 rows where bioproject = "PRJEB81327", 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
11618776	11618776	PRJEB81327_P_NODE_9510_length_446_cov_2.916890_g8902_i0	PRJEB81327	9510	446	2.91689	13.0093294	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	198	5.24e-46	NTclustered	gi\|1752402107\|ref\|XM_030973663.1\|	7668	g8902	i0	78.571	6.4932735426009	308	61	68	5	130	434	349	654	PREDICTED: Strongylocentrotus purpuratus polyA-binding protein (pabp), transcript variant X1, mRNA	blastn	2896	198	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
28265832	28265832	PRJEB81327_P_NODE_63626_length_242_cov_0.911243_g63018_i0	PRJEB81327	63626	242	0.911243	2.20520806	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	72.4	1.35e-12	NR	KAJ8035013.1	206669	g63018	i0	55.4	1.35123966942149	56	24	68.2	1	16	180	2894	2949	KAJ8035013.1 Myosin-11 [Holothuria leucospilota]	diamond	327	72.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
29679238	29679238	PRJEB81327_P_NODE_50790_length_249_cov_0.875000_g50182_i0	PRJEB81327	50790	249	0.875	2.17875	Metazoa	33208	Echinodermata	other_Eukaryota	85.5	3.62e-18	NR	XP_038056180.1	46514	g50182	i0	46.7	10.2048192771084	75	40	90.4	0	21	245	155	229	XP_038056180.1 catechol O-methyltransferase-like [Patiria miniata]	diamond	2541	85.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
32373916	32373916	PRJEB81327_P_NODE_11499_length_400_cov_2.636086_g10891_i0	PRJEB81327	11499	400	2.636086	10.544344	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	102	1.7599999999999994e-23	NR	XP_030850438.1	7668	g10891	i0	44.3	1.7475	115	63	85.5	1	1	342	144	258	XP_030850438.1 40S ribosomal protein S4 [Strongylocentrotus purpuratus]	diamond	699	102	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);;