metadata: contig_metadata: 5 rows where bioproject = "PRJNA453111" and tax

5 rows where bioproject = "PRJNA453111" 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
441456	441456	PRJNA453111_P_NODE_4501_length_381_cov_0.944805_g4409_i0	PRJNA453111	4501	381	0.944805	3.59970705	Patiria miniata	46514	Echinodermata	other_Eukaryota	86.1	3.58e-12	NTclustered	gi\|1944940298\|ref\|XM_038190411.1\|	46514	g4409	i0	93.103	4.48818897637795	58	4	24	0	299	356	4793	4850	PREDICTED: Patiria miniata nucleolar protein dao-5-like (LOC119720640), transcript variant X5, mRNA	blastn	1710	86.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
19567201	19567201	PRJNA453111_P_NODE_12536_length_243_cov_0.905882_g12444_i0	PRJNA453111	12536	243	0.905882	2.20129326	Opisthokonta	33154	Echinodermata	other_Eukaryota	74.7	2.81e-14	NR	XP_041458601.1	7654	g12444	i0	59.4	7.66666666666667	69	27	84	1	5	208	137	205	XP_041458601.1 ras-related protein Rab-7a-like [Lytechinus variegatus]	diamond	1863	75.1	0.994673768308922	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
27455502	27455502	PRJNA453111_P_NODE_10243_length_250_cov_0.977401_g10151_i0	PRJNA453111	10243	250	0.977401	2.4435025	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	54.3	3.23e-6	NR	PIK43213.1	307972	g10151	i0	56.8	1.8	37	16	44.4	0	3	113	147	183	PIK43213.1 putative aspartate aminotransferase, cytoplasmic [Apostichopus japonicus]	diamond	450	54.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
31925591	31925591	PRJNA453111_P_NODE_6937_length_308_cov_1.076596_g6845_i0	PRJNA453111	6937	308	1.076596	3.31591568	Aspidochirotida	7682	Echinodermata	other_Eukaryota	148	6.279999999999999e-40	NR	KAJ8042800.1	206669	g6845	i0	71.3	5.9025974025974	101	29	98.4	0	306	4	32	132	KAJ8042800.1 Pre-mRNA-processing factor 19 [Holothuria leucospilota]	diamond	1818	148	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
32004380	32004380	PRJNA453111_P_NODE_7218_length_302_cov_1.004367_g7126_i0	PRJNA453111	7218	302	1.004367	3.03318834	Asterias rubens	7604	Echinodermata	other_Eukaryota	145	6.9e-40	NR	XP_033644390.1	7604	g7126	i0	72	10.9668874172185	100	28	99.3	0	300	1	173	272	XP_033644390.1 alcohol dehydrogenase class-3-like [Asterias rubens]	diamond	3312	145	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens

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