metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1237347" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1237347" 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
4877024	4877024	PRJNA1237347_P_NODE_439744_length_263_cov_1.621053_g433171_i0	PRJNA1237347	439744	263	1.621053	4.26336939	Metazoa	33208	Echinodermata	other_Eukaryota	60.2	1.43e-4	NTclustered	gi\|1752342542\|ref\|XM_011669965.2\|	7668	g433171	i0	100	4.58174904942966	32	0	12	0	97	128	2911	2942	PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC582550 (LOC582550), mRNA	blastn	1205	60.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
6719114	6719114	PRJNA1237347_P_NODE_341706_length_308_cov_1.289362_g335133_i0	PRJNA1237347	341706	308	1.289362	3.97123496	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	102	2.81e-17	NTclustered	gi\|1826653364\|ref\|XM_033258718.1\|	1529436	g335133	i0	77.957	0.775974025974026	186	26	56	5	121	291	531	346	PREDICTED: Anneissia japonica protein SSUH2 homolog (LOC117115064), mRNA	blastn	239	102	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
6721461	6721461	PRJNA1237347_P_NODE_461806_length_254_cov_3.602210_g455233_i0	PRJNA1237347	461806	254	3.60221	9.1496134	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	86.1	2.27e-12	NTclustered	gi\|2037980638\|ref\|XM_041602839.1\|	7654	g455233	i0	80.909	1.54330708661417	110	19	43	2	2	110	1182	1074	PREDICTED: Lytechinus variegatus late histone H2A.2.2-like (LOC121410623), mRNA	blastn	392	86.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
10545053	10545053	PRJNA1237347_P_NODE_324709_length_318_cov_1.191837_g318136_i0	PRJNA1237347	324709	318	1.191837	3.79004166	Diadema antillarum	105358	Echinodermata	other_Eukaryota	52.8	0.03	NTclustered	gi\|2919570884\|ref\|XM_071626461.1\|	105358	g318136	i0	100	0.0880503144654088	28	0	9	0	27	54	5381	5354	PREDICTED: Diadema antillarum androglobin-like (LOC139714806), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
14366088	14366088	PRJNA1237347_P_NODE_138472_length_551_cov_5.399582_g131936_i0	PRJNA1237347	138472	551	5.399582	29.75169682	Lytechinus pictus	7653	Echinodermata	other_Eukaryota	193	3.06e-44	NTclustered	gi\|2707408381\|ref\|XM_054893204.2\|	7653	g131936	i0	87.059	29.5553539019964	170	22	31	0	363	532	597	428	PREDICTED: Lytechinus pictus dynein light chain 2, cytoplasmic-like (LOC129254696), mRNA	blastn	16285	193	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
14369634	14369634	PRJNA1237347_P_NODE_303332_length_332_cov_0.806950_g296759_i0	PRJNA1237347	303332	332	0.80695	2.679074	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	237	8.04e-58	NTclustered	gi\|2037938285\|ref\|XM_041618221.1\|	7654	g296759	i0	84.082	70.828313253012	245	39	74	0	24	268	254	498	PREDICTED: Lytechinus variegatus late histone H2A.L3 (LOC121422971), mRNA	blastn	23515	237	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
15076011	15076011	PRJNA1237347_P_NODE_347252_length_305_cov_0.982759_g340679_i0	PRJNA1237347	347252	305	0.982759	2.99741495	Opisthokonta	33154	Echinodermata	other_Eukaryota	52.8	0.028	NTclustered	gi\|1944896787\|ref\|XM_038206482.1\|	46514	g340679	i0	100	0.459016393442623	28	0	9	0	1	28	2951	2924	PREDICTED: Patiria miniata serine/threonine-protein kinase par-1-like (LOC119732891), transcript variant X2, mRNA	blastn	140	52.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
15642942	15642942	PRJNA1237347_P_NODE_272333_length_355_cov_1.336879_g265760_i0	PRJNA1237347	272333	355	1.336879	4.74592045	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	167	1.15e-36	NTclustered	gi\|2037994970\|ref\|XM_041610425.1\|	7654	g265760	i0	81.043	3.95492957746479	211	38	59	2	53	262	199	408	PREDICTED: Lytechinus variegatus 60S ribosomal protein L12-like (LOC121416898), mRNA	blastn	1404	167	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
16350544	16350544	PRJNA1237347_P_NODE_272513_length_355_cov_1.092199_g265940_i0	PRJNA1237347	272513	355	1.092199	3.87730645	Echinodermata	7586	Echinodermata	other_Eukaryota	87.9	9.21e-13	NTclustered	gi\|2919381950\|ref\|XM_071628151.1\|	105358	g265940	i0	83.871	1.28169014084507	93	13	26	2	149	240	388	479	PREDICTED: Diadema antillarum protein DD3-3-like (LOC139716625), mRNA	blastn	455	87.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
20741359	20741359	PRJNA1237347_P_NODE_266937_length_359_cov_2.877622_g260364_i0	PRJNA1237347	266937	359	2.877622	10.33066298	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	54.7	0.009	NTclustered	gi\|1752336284\|ref\|XM_030980589.1\|	7668	g260364	i0	100	0.167130919220056	29	0	8	0	145	173	719	691	PREDICTED: Strongylocentrotus purpuratus phospholipase A2 AP-PLA2-I-like (LOC115918498), mRNA	blastn	60	54.7	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus

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