metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA670521" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA670521" 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
8291637	8291637	PRJNA670521_P_NODE_82907_length_245_cov_1.343023_g82162_i0	PRJNA670521	82907	245	1.343023	3.29040635	Diadema antillarum	105358	Echinodermata	other_Eukaryota	156	1.64e-33	NTclustered	gi\|2919367781\|ref\|XM_071648815.1\|	105358	g82162	i0	79.724	6.8938775510204104	217	42	88	2	1	216	687	902	PREDICTED: Diadema antillarum eukaryotic initiation factor 4A-III (LOC139738150), mRNA	blastn	1689	156	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
8817939	8817939	PRJNA670521_P_NODE_24467_length_389_cov_1.604430_g23723_i0	PRJNA670521	24467	389	1.60443	6.2412327	Metazoa	33208	Echinodermata	other_Eukaryota	307	7.180000000000001e-79	NTclustered	gi\|1229128602\|ref\|XM_022231094.1\|	133434	g23723	i0	83.636	88.1670951156812	330	51	85	2	1	330	914	588	PREDICTED: Acanthaster planci ATP synthase subunit beta, mitochondrial (LOC110977189), mRNA	blastn	34297	307	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
19016612	19016612	PRJNA670521_P_NODE_54335_length_285_cov_2.084906_g53590_i0	PRJNA670521	54335	285	2.084906	5.9419821	Metazoa	33208	Echinodermata	other_Eukaryota	204	6.869999999999999e-48	NTclustered	gi\|1834291358\|ref\|XM_033783991.1\|	7604	g53590	i0	80.22	73.7964912280702	273	53	95	1	2	273	1062	1334	PREDICTED: Asterias rubens uncharacterized LOC117300260 (LOC117300260), mRNA	blastn	21032	204	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
23590888	23590888	PRJNA670521_P_NODE_14459_length_482_cov_5.599022_g13718_i0	PRJNA670521	14459	482	5.599022	26.98728604	Paracentrotus lividus	7656	Echinodermata	other_Eukaryota	322	3.24e-83	NTclustered	gi\|557665\|emb\|X76081.1\|	7656	g13718	i0	80.779	90.6576763485477	411	79	85	0	44	454	475	65	P.lividus H3.3 Histone mRNA	blastn	43697	322	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Echinidae	Paracentrotus	Paracentrotus lividus
24864241	24864241	PRJNA670521_P_NODE_26760_length_376_cov_1.501650_g26016_i0	PRJNA670521	26760	376	1.50165	5.646204	Patiria miniata	46514	Echinodermata	other_Eukaryota	54.7	0.01	NTclustered	gi\|1944874203\|ref\|XM_038200820.1\|	46514	g26016	i0	100	0.154255319148936	29	0	8	0	8	36	989	961	PREDICTED: Patiria miniata vascular endothelial growth factor A-like (LOC119728539), transcript variant X2, mRNA	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata

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