metadata: contig_metadata: 13 rows where bioproject = "PRJEB10320", tax_kingdom = "Metazoa" and tax

13 rows where bioproject = "PRJEB10320", 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
13579	13579	PRJEB10320_P_NODE_7321_length_378_cov_3.221574_g7065_i0	PRJEB10320	7321	378	3.221574	12.17754972	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	370	8.75e-98	NTclustered	gi\|1752395070\|ref\|XM_030999610.1\|	7668	g7065	i0	86.93	83.9285714285714	329	43	87	0	1	329	226	554	PREDICTED: Strongylocentrotus purpuratus ubiquitin-40S ribosomal protein S27a (LOC579019), mRNA	blastn	31725	370	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
3839673	3839673	PRJEB10320_P_NODE_11084_length_290_cov_1.968627_g10826_i0	PRJEB10320	11084	290	1.968627	5.7090183	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	70.1	1.6e-11	NR	XP_030844905.1	7668	g10826	i0	50	0.744827586206897	72	34	73.4	2	31	243	822	892	XP_030844905.1 LOW QUALITY PROTEIN: sushi, von Willebrand factor type A, EGF and pentraxin domain-containing protein 1-like [Strongylocentrotus purpuratus]	diamond	216	70.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
17560338	17560338	PRJEB10320_P_NODE_20634_length_188_cov_1.928105_g20376_i0	PRJEB10320	20634	188	1.928105	3.6248374	Valvatida	41166	Echinodermata	other_Eukaryota	209	9.03e-50	NTclustered	gi\|46909232\|gb\|AY580175.1\|	46514	g20376	i0	86.842	102.441489361702	190	21	100	4	1	188	725	912	Asterina miniata ATP synthase beta subunit mRNA, partial cds	blastn	19259	209	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
26715786	26715786	PRJEB10320_P_NODE_24281_length_167_cov_2.113636_g24023_i0	PRJEB10320	24281	167	2.113636	3.52977212	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	56.6	1.65e-7	NR	XP_030830622.1	7668	g24023	i0	43.6	2.96407185628743	55	30	98.8	1	166	2	228	281	XP_030830622.1 apoptosis-inducing factor 2 [Strongylocentrotus purpuratus]	diamond	495	56.6	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
26906181	26906181	PRJEB10320_P_NODE_17942_length_208_cov_1.150289_g17684_i0	PRJEB10320	17942	208	1.150289	2.39260112	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	62.8	2e-9	NR	KAJ8022464.1	206669	g17684	i0	56.1	0.822115384615385	57	24	82.2	1	200	30	2389	2444	KAJ8022464.1 Prosaposin [Holothuria leucospilota]	diamond	171	62.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
27443885	27443885	PRJEB10320_P_NODE_21343_length_184_cov_1.167785_g21085_i0	PRJEB10320	21343	184	1.167785	2.1487244	Diadema antillarum	105358	Echinodermata	other_Eukaryota	50.1	4.42e-5	NR	XP_071511245.1	105358	g21085	i0	45	2.73913043478261	60	33	97.8	0	181	2	349	408	XP_071511245.1 DNA-directed RNA polymerase III subunit RPC4-like [Diadema antillarum]	diamond	504	50.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
27538371	27538371	PRJEB10320_P_NODE_13984_length_248_cov_1.122066_g13726_i0	PRJEB10320	13984	248	1.122066	2.78272368	Asterias rubens	7604	Echinodermata	other_Eukaryota	88.2	7.05e-19	NR	XP_033639674.1	7604	g13726	i0	52.4	3.0241935483871	82	37	99.2	1	248	3	190	269	XP_033639674.1 carbonyl reductase [NADPH] 1-like [Asterias rubens]	diamond	750	88.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
28927540	28927540	PRJEB10320_P_NODE_28288_length_151_cov_1.379310_g28030_i0	PRJEB10320	28288	151	1.37931	2.0827581	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	60.1	8.08e-9	NR	KAJ8033345.1	206669	g28030	i0	52.1	1.90728476821192	48	23	95.4	0	5	148	387	434	KAJ8033345.1 Steroid 17-alpha-hydroxylase/17,20 lyase [Holothuria leucospilota]	diamond	288	60.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
28984880	28984880	PRJEB10320_P_NODE_25688_length_161_cov_0.944444_g25430_i0	PRJEB10320	25688	161	0.944444	1.52055484	Echinoidea	7625	Echinodermata	other_Eukaryota	60.8	2.46e-9	NR	XP_041455763.1	7654	g25430	i0	47.2	3.95031055900621	53	28	98.8	0	159	1	89	141	XP_041455763.1 ras-related protein Rab-3A-like [Lytechinus variegatus]	diamond	636	61.2	0.993464052287582	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
30848140	30848140	PRJEB10320_P_NODE_28714_length_150_cov_1.000000_g28456_i0	PRJEB10320	28714	150	1	1.5	Echinoidea	7625	Echinodermata	other_Eukaryota	70.1	2.29e-12	NR	XP_041477321.1	7654	g28456	i0	63.3	9.8	49	18	98	0	149	3	904	952	XP_041477321.1 protein RRP5 homolog [Lytechinus variegatus]	diamond	1470	70.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
31865773	31865773	PRJEB10320_P_NODE_22237_length_178_cov_2.307692_g21979_i0	PRJEB10320	22237	178	2.307692	4.10769176	Acanthaster planci	133434	Echinodermata	other_Eukaryota	60.5	8.73e-9	NR	XP_022081049.1	133434	g21979	i0	51	1.70224719101124	51	25	86	0	177	25	459	509	XP_022081049.1 uncharacterized protein LOC110974041 isoform X2 [Acanthaster planci]	diamond	303	60.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
31897622	31897622	PRJEB10320_P_NODE_18157_length_206_cov_1.637427_g17899_i0	PRJEB10320	18157	206	1.637427	3.37309962	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	44.7	0.00161	NR	AFU36096.1	307972	g17899	i0	40.8	0.713592233009709	49	29	71.4	0	204	58	77	125	AFU36096.1 profilin [Apostichopus japonicus]	diamond	147	44.7	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
32403986	32403986	PRJEB10320_P_NODE_19019_length_199_cov_1.951220_g18761_i0	PRJEB10320	19019	199	1.95122	3.8829278	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	42	0.0402	NR	XP_041479886.1	7654	g18761	i0	38.6	0.85929648241206	57	32	81.4	1	31	192	663	719	XP_041479886.1 ABC transporter G family member 21-like isoform X2 [Lytechinus variegatus]	diamond	171	42	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus

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