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

9 rows where bioproject = "PRJNA431371", 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
15731058	15731058	PRJNA431371_P_NODE_35713_length_241_cov_1.785714_g35640_i0	PRJNA431371	35713	241	1.785714	4.30357074	root	1	Root_unresolved	Root_unresolved	131	8.919999999999999e-34	NR	XP_792094.3	7668	g35640	i0	70.9	6.88381742738589	79	23	98.3	0	5	241	156	234	XP_792094.3 delta(24)-sterol reductase [Strongylocentrotus purpuratus]	diamond	1659	132	0.992424242424242	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
27360396	27360396	PRJNA431371_P_NODE_11403_length_372_cov_1.287625_g11330_i0	PRJNA431371	11403	372	1.287625	4.789965	Diadema antillarum	105358	Echinodermata	other_Eukaryota	105	4.709999999999999e-24	NR	XP_071480239.1	105358	g11330	i0	51	7.06451612903226	96	47	77.4	0	289	2	245	340	XP_071480239.1 solute carrier family 35 member B1-like [Diadema antillarum]	diamond	2628	105	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
28433832	28433832	PRJNA431371_P_NODE_19426_length_290_cov_1.294931_g19353_i0	PRJNA431371	19426	290	1.294931	3.7552999	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	62	1.05e-8	NR	PIK34493.1	307972	g19353	i0	40	1.55172413793103	75	40	77.6	1	227	3	358	427	PIK34493.1 putative FAS-associated factor 2 [Apostichopus japonicus]	diamond	450	62	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
28939097	28939097	PRJNA431371_P_NODE_5928_length_497_cov_1.341981_g5855_i0	PRJNA431371	5928	497	1.341981	6.66964557	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	140	1.79e-35	NR	XP_030847790.1	7668	g5855	i0	49.4	2.89134808853119	160	69	96.6	2	492	13	316	463	XP_030847790.1 putative phospholipase B-like 2 [Strongylocentrotus purpuratus]	diamond	1437	140	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
29176655	29176655	PRJNA431371_P_NODE_5929_length_497_cov_1.323113_g5856_i0	PRJNA431371	5929	497	1.323113	6.57587161	Valvatida	41166	Echinodermata	other_Eukaryota	122	2.9199999999999998e-31	NR	XP_038061580.1	46514	g5856	i0	42.1	1.83501006036217	152	87	91.8	1	27	482	24	174	XP_038061580.1 glutathione S-transferase theta-1-like [Patiria miniata]	diamond	912	122	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
29428824	29428824	PRJNA431371_P_NODE_8709_length_420_cov_1.997118_g8636_i0	PRJNA431371	8709	420	1.997118	8.3878956	Valvatida	41166	Echinodermata	other_Eukaryota	79	4.16e-14	NR	XP_038050470.1	46514	g8636	i0	41.1	9.95714285714286	124	71	87.9	2	1	369	190	312	XP_038050470.1 G-protein coupled receptor 1-like isoform X1 [Patiria miniata]	diamond	4182	79	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
30565850	30565850	PRJNA431371_P_NODE_8053_length_436_cov_1.060606_g7980_i0	PRJNA431371	8053	436	1.060606	4.62424216	Metazoa	33208	Echinodermata	other_Eukaryota	47.8	0.00433	NR	XP_038056122.1	46514	g7980	i0	35.6	2.02981651376147	73	47	50.2	0	3	221	307	379	XP_038056122.1 SEC14-like protein 2 [Patiria miniata]	diamond	885	47.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
32289144	32289144	PRJNA431371_P_NODE_8919_length_416_cov_1.346939_g8846_i0	PRJNA431371	8919	416	1.346939	5.60326624	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	87.8	4.38e-17	NR	XP_041466350.1	7654	g8846	i0	47.4	0.699519230769231	97	43	68.5	3	83	367	409	499	XP_041466350.1 uncharacterized protein LOC121416889 [Lytechinus variegatus]	diamond	291	87.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
32573751	32573751	PRJNA431371_P_NODE_18579_length_297_cov_1.205357_g18506_i0	PRJNA431371	18579	297	1.205357	3.57991029	Diadema antillarum	105358	Echinodermata	other_Eukaryota	58.5	1.28e-7	NR	XP_071503996.1	105358	g18506	i0	36.2	0.94949494949495	94	50	88.9	3	3	266	37	126	XP_071503996.1 ribonuclease T2-like [Diadema antillarum]	diamond	282	58.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum

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