metadata: contig_metadata: 5 rows where bioproject = "PRJNA1199330", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA1199330", 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
5429066	5429066	PRJNA1199330_P_NODE_62045_length_289_cov_1.199074_g61346_i0	PRJNA1199330	62045	289	1.199074	3.46532386	Diadema antillarum	105358	Echinodermata	other_Eukaryota	209	1.4999999999999998e-49	NTclustered	gi\|2919513449\|ref\|XM_071652062.1\|	105358	g61346	i0	86.772	61.0519031141868	189	23	65	2	8	195	1230	1417	PREDICTED: Diadema antillarum tubulin beta-4B chain-like (LOC139741477), mRNA	blastn	17644	209	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
11804418	11804418	PRJNA1199330_P_NODE_61050_length_289_cov_4.518519_g60351_i0	PRJNA1199330	61050	289	4.518519	13.05851991	Acanthaster planci	133434	Echinodermata	other_Eukaryota	211	4.17e-50	NTclustered	gi\|1229139431\|ref\|XM_022226113.1\|	133434	g60351	i0	84.259	77.1141868512111	216	34	75	0	1	216	356	141	PREDICTED: Acanthaster planci tubulin alpha-1A chain-like (LOC110974457), mRNA	blastn	22286	211	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
18177423	18177423	PRJNA1199330_P_NODE_54515_length_297_cov_2.482143_g53816_i0	PRJNA1199330	54515	297	2.482143	7.37196471	Acanthaster planci	133434	Echinodermata	other_Eukaryota	217	9.25e-52	NTclustered	gi\|1229139431\|ref\|XM_022226113.1\|	133434	g53816	i0	81.343	72.006734006734	268	48	90	2	2	268	378	112	PREDICTED: Acanthaster planci tubulin alpha-1A chain-like (LOC110974457), mRNA	blastn	21386	217	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
27672969	27672969	PRJNA1199330_P_NODE_91744_length_261_cov_2.489362_g91045_i0	PRJNA1199330	91744	261	2.489362	6.49723482	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	47	2.64e-4	NR	KAJ8043773.1	206669	g91045	i0	51.1	1.11494252873563	47	23	54	0	219	79	53	99	KAJ8043773.1 hypothetical protein HOLleu_11030 [Holothuria leucospilota]	diamond	291	47	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
29409307	29409307	PRJNA1199330_P_NODE_86869_length_266_cov_1.803109_g86170_i0	PRJNA1199330	86869	266	1.803109	4.79626994	Diadema antillarum	105358	Echinodermata	other_Eukaryota	63.9	1.78e-9	NR	XP_071495824.1	105358	g86170	i0	36.6	1.84962406015038	82	44	83.5	1	22	243	1892	1973	XP_071495824.1 uncharacterized protein [Diadema antillarum]	diamond	492	63.9	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);;