metadata: contig_metadata: 9 rows where bioproject = "PRJNA795983", tax_kingdom = "Metazoa" and tax

9 rows where bioproject = "PRJNA795983", 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
17358600	17358600	PRJNA795983_S_NODE_41554_length_243_cov_0.905882_g41429_i0	PRJNA795983	41554	243	0.905882	2.20129326	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	169	2.0799999999999997e-37	NTclustered	gi\|1752408182\|ref\|XM_777444.5\|	7668	g41429	i0	83.799	2.79423868312757	179	28	73	1	3	180	474	652	PREDICTED: Strongylocentrotus purpuratus ras-related protein Rab-2A (LOC577200), mRNA	blastn	679	169	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
23732820	23732820	PRJNA795983_S_NODE_1639_length_781_cov_1.761299_g1542_i0	PRJNA795983	1639	781	1.761299	13.75574519	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	293	9.16e-97	NR	XP_030830317.1	7668	g1542	i0	63.4	19.213828425096	238	84	90.7	3	69	776	11	247	XP_030830317.1 60S ribosomal protein L7 [Strongylocentrotus purpuratus]	diamond	15006	293	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
25006462	25006462	PRJNA795983_S_NODE_21380_length_301_cov_0.820175_g21255_i0	PRJNA795983	21380	301	0.820175	2.46872675	Opisthokonta	33154	Echinodermata	other_Eukaryota	155	2.74e-41	NR	XP_041481163.1	7654	g21255	i0	70	6.88704318936877	100	29	99.7	1	301	2	620	718	XP_041481163.1 valine--tRNA ligase-like isoform X2 [Lytechinus variegatus]	diamond	2073	156	0.993589743589744	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
25006554	25006554	PRJNA795983_S_NODE_31020_length_264_cov_2.324607_g30895_i0	PRJNA795983	31020	264	2.324607	6.13696248	Acanthaster planci	133434	Echinodermata	other_Eukaryota	132	8.44e-35	NR	XP_022093919.1	133434	g30895	i0	78.8	1.85227272727273	80	17	90.9	0	19	258	287	366	XP_022093919.1 obg-like ATPase 1 isoform X4 [Acanthaster planci]	diamond	489	132	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
27022228	27022228	PRJNA795983_S_NODE_28562_length_272_cov_2.261307_g28437_i0	PRJNA795983	28562	272	2.261307	6.15075504	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	53.5	8.66e-6	NR	XP_033096444.1	1529436	g28437	i0	39.3	1.79779411764706	61	28	57.4	2	4	159	366	426	XP_033096444.1 scavenger receptor cysteine-rich type 1 protein M130-like [Anneissia japonica]	diamond	489	53.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
27821255	27821255	PRJNA795983_S_NODE_13404_length_350_cov_2.155235_g13279_i0	PRJNA795983	13404	350	2.155235	7.5433225	Echinodermata	7586	Echinodermata	other_Eukaryota	47.4	0.00287	NR	XP_038065644.1	46514	g13279	i0	29.2	3.96857142857143	106	71	90	3	1	315	184	286	XP_038065644.1 ammonium transporter Rh type B-like isoform X1 [Patiria miniata]	diamond	1389	47.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
28348694	28348694	PRJNA795983_S_NODE_32186_length_261_cov_1.329787_g32061_i0	PRJNA795983	32186	261	1.329787	3.47074407	Acanthaster planci	133434	Echinodermata	other_Eukaryota	64.7	9.06e-10	NR	XP_022090907.1	133434	g32061	i0	52.4	2.24137931034483	63	30	72.4	0	228	40	535	597	XP_022090907.1 hyalin-like [Acanthaster planci]	diamond	585	64.7	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
30307106	30307106	PRJNA795983_S_NODE_30032_length_267_cov_2.494845_g29907_i0	PRJNA795983	30032	267	2.494845	6.66123615	Diadema antillarum	105358	Echinodermata	other_Eukaryota	83.2	2.52e-16	NR	XP_071501999.1	105358	g29907	i0	45.8	4.98876404494382	96	39	93.3	2	17	265	319	414	XP_071501999.1 carboxypeptidase B-like [Diadema antillarum]	diamond	1332	83.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
31918752	31918752	PRJNA795983_S_NODE_25697_length_282_cov_2.311005_g25572_i0	PRJNA795983	25697	282	2.311005	6.5170341	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	103	4.4e-26	NR	PIK48353.1	307972	g25572	i0	83.7	0.978723404255319	92	15	97.9	0	281	6	34	125	PIK48353.1 beta-transducin repeat containing protein-3 [Apostichopus japonicus]	diamond	276	103	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus

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