metadata: contig_metadata: 9 rows where bioproject = "PRJNA533623" and tax

9 rows where bioproject = "PRJNA533623" 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
5610408	5610408	PRJNA533623_P_NODE_4625_length_1048_cov_72.466059_g3471_i0	PRJNA533623	4625	1048	72.466059	759.44429832	Acanthaster planci	133434	Echinodermata	other_Eukaryota	56.5	0.008	NTclustered	gi\|1229153226\|ref\|XM_022233550.1\|	133434	g3471	i0	97.059	0.0973282442748092	34	0	3	1	902	935	925	893	PREDICTED: Acanthaster planci nuclear transcription factor Y subunit alpha-like (LOC110978499), transcript variant X2, mRNA	blastn	102	56.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
22182669	22182669	PRJNA533623_P_NODE_17318_length_564_cov_20.258449_g15590_i0	PRJNA533623	17318	564	20.258449	114.25765236	Metazoa	33208	Echinodermata	other_Eukaryota	163	3.0099999999999993e-43	NR	AAC47807.1	7668	g15590	i0	72.4	70.9574468085106	98	27	52.1	0	20	313	95	192	AAC47807.1 myb-related transcription factor, partial [Strongylocentrotus purpuratus]	diamond	40020	164	0.99390243902439	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
26729168	26729168	PRJNA533623_P_NODE_9081_length_777_cov_3.296089_g7569_i0	PRJNA533623	9081	777	3.296089	25.61061153	Patiria miniata	46514	Echinodermata	other_Eukaryota	106	4.5400000000000005e-22	NR	XP_038070046.1	46514	g7569	i0	31.8	4.10810810810811	280	132	91.5	12	6	716	418	681	XP_038070046.1 uncharacterized protein LOC119739259 isoform X2 [Patiria miniata]	diamond	3192	106	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
28292732	28292732	PRJNA533623_P_NODE_22966_length_483_cov_16.516588_g21210_i0	PRJNA533623	22966	483	16.516588	79.77512004	Metazoa	33208	Echinodermata	other_Eukaryota	140	3.0299999999999995e-35	NR	NP_999817.1	7668	g21210	i0	60	9.8695652173913	115	45	70.8	1	93	434	1	115	NP_999817.1 kinesin-II 95 kDa subunit [Strongylocentrotus purpuratus]	diamond	4767	141	0.99290780141844	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
28846071	28846071	PRJNA533623_P_NODE_56728_length_266_cov_5.863415_g54948_i0	PRJNA533623	56728	266	5.863415	15.5966839	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	95.5	1.05e-21	NR	XP_033125693.1	1529436	g54948	i0	73.8	0.68796992481203	61	16	68.8	0	241	59	199	259	XP_033125693.1 40S ribosomal protein S4, X isoform-like [Anneissia japonica]	diamond	183	95.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
30377465	30377465	PRJNA533623_P_NODE_31672_length_400_cov_12.563422_g29901_i0	PRJNA533623	31672	400	12.563422	50.253688	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	138	2.48e-39	NR	XP_011667733.1	7668	g29901	i0	65.1	3.315	106	36	79.5	1	325	8	9	113	XP_011667733.1 dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit dad1 [Strongylocentrotus purpuratus]	diamond	1326	139	0.992805755395683	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
32400810	32400810	PRJNA533623_P_NODE_19539_length_529_cov_13.220085_g17797_i0	PRJNA533623	19539	529	13.220085	69.93424965	Opisthokonta	33154	Echinodermata	other_Eukaryota	127	1.11e-30	NR	XP_033647031.1	7604	g17797	i0	45.6	11.8412098298677	147	77	83.4	2	510	70	358	501	XP_033647031.1 ATP-dependent RNA helicase DDX51-like isoform X2 [Asterias rubens]	diamond	6264	128	0.9921875	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
32417444	32417444	PRJNA533623_P_NODE_5019_length_1013_cov_18.884454_g3817_i0	PRJNA533623	5019	1013	18.884454	191.29951902	Diadema antillarum	105358	Echinodermata	other_Eukaryota	254	4.8400000000000005e-79	NR	XP_071504090.1	105358	g3817	i0	48.5	1.54886475814413	262	135	77.6	0	911	126	12	273	XP_071504090.1 ribosome production factor 2 homolog [Diadema antillarum]	diamond	1569	254	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
32858813	32858813	PRJNA533623_P_NODE_15220_length_604_cov_8.825046_g13516_i0	PRJNA533623	15220	604	8.825046	53.30327784	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	62.4	6.67e-8	NR	XP_033120138.1	1529436	g13516	i0	34.4	0.794701986754967	160	80	76.5	5	463	2	25	165	XP_033120138.1 RPA-interacting protein B-like [Anneissia japonica]	diamond	480	62.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica

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