metadata: contig_metadata: 8 rows where bioproject = "PRJNA330616", tax_kingdom = "Metazoa" and tax

8 rows where bioproject = "PRJNA330616", 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
1664465	1664465	PRJNA330616_P_NODE_29922_length_163_cov_0.894737_g29513_i0	PRJNA330616	29922	163	0.894737	1.45842131	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	100	4.9899999999999996e-23	NR	XP_041478205.1	7654	g29513	i0	84.9	5.79754601226994	53	8	97.5	0	3	161	85	137	XP_041478205.1 probable citrate synthase 2, mitochondrial [Lytechinus variegatus]	diamond	945	100	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
16967236	16967236	PRJNA330616_P_NODE_7174_length_311_cov_1.912214_g6765_i0	PRJNA330616	7174	311	1.912214	5.94698554	Diadema antillarum	105358	Echinodermata	other_Eukaryota	172	2.14e-38	NTclustered	gi\|2919562891\|ref\|XM_071624859.1\|	105358	g6765	i0	83.889	62.4372990353698	180	29	58	0	19	198	267	88	PREDICTED: Diadema antillarum late histone H2A.3, gonadal (LOC139713103), mRNA	blastn	19418	172	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
18920845	18920845	PRJNA330616_P_NODE_26535_length_166_cov_0.871795_g26126_i0	PRJNA330616	26535	166	0.871795	1.4471797	Lytechinus	7652	Echinodermata	other_Eukaryota	147	6.2e-31	NTclustered	gi\|2707360192\|ref\|XM_054894817.2\|	7653	g26126	i0	83.648	90.9036144578313	159	23	95	3	6	163	181	25	PREDICTED: Lytechinus pictus ras-related protein Rap-1A-like (LOC129256657), mRNA	blastn	15090	147	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
24615671	24615671	PRJNA330616_P_NODE_14960_length_216_cov_1.125749_g14551_i0	PRJNA330616	14960	216	1.1257490000000001	2.43161784	Psammechinus miliaris	7660	Echinodermata	other_Eukaryota	139	1.42e-28	NTclustered	gi\|1036032539\|gb\|AH001093.2\|	7660	g14551	i0	83.226	70.4861111111111	155	22	71	3	55	207	817	665	Psammechinus miliaris histone H2B-2.1 and histone H2A-2.1 genes, complete cds	blastn	15225	139	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Parechinidae	Psammechinus	Psammechinus miliaris
27927464	27927464	PRJNA330616_P_NODE_12505_length_234_cov_1.102703_g12096_i0	PRJNA330616	12505	234	1.102703	2.58032502	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	47	3.59e-4	NR	KAJ8038666.1	206669	g12096	i0	52.2	1.25641025641026	46	22	59	0	226	89	80	125	KAJ8038666.1 60S ribosomal protein L28 [Holothuria leucospilota]	diamond	294	47	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
28243003	28243003	PRJNA330616_P_NODE_4626_length_394_cov_2.359420_g4217_i0	PRJNA330616	4626	394	2.35942	9.2961148	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	125	2.48e-34	NR	KAJ8030924.1	206669	g4217	i0	52.8	0.936548223350254	123	57	92.9	1	25	390	1	123	KAJ8030924.1 Profilin-1A [Holothuria leucospilota]	diamond	369	125	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
30832894	30832894	PRJNA330616_P_NODE_28834_length_164_cov_0.886957_g28425_i0	PRJNA330616	28834	164	0.886957	1.45460948	Patiria miniata	46514	Echinodermata	other_Eukaryota	67.8	1.87e-11	NR	XP_038067897.1	46514	g28425	i0	61.1	15.8048780487805	54	21	98.8	0	164	3	783	836	XP_038067897.1 unconventional myosin-Ie-like isoform X1 [Patiria miniata]	diamond	2592	67.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
31165849	31165849	PRJNA330616_P_NODE_28275_length_165_cov_0.879310_g27866_i0	PRJNA330616	28275	165	0.87931	1.4508615	Metazoa	33208	Echinodermata	other_Eukaryota	70.9	1.17e-12	NR	XP_038074418.1	46514	g27866	i0	70	6.25454545454545	50	15	90.9	0	16	165	202	251	XP_038074418.1 malate dehydrogenase, cytoplasmic-like [Patiria miniata]	diamond	1032	70.9	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);;