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

5 rows where analysis = "blastn", bioproject = "PRJNA1180292" and tax_phylum = "Cnidaria"

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
9245787	9245787	PRJNA1180292_P_NODE_6608_length_274_cov_1.164179_g6476_i0	PRJNA1180292	6608	274	1.164179	3.18985046	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	202	2.3599999999999996e-47	NTclustered	gi\|2918369558\|emb\|OZ237728.1\|	317547	g6476	i0	81.423	7.00729927007299	253	41	91	5	1	249	3378862	3378612	Eunicella cavolini genome assembly, chromosome: 12	blastn	1920	202	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
19443861	19443861	PRJNA1180292_P_NODE_4396_length_330_cov_1.517510_g4264_i0	PRJNA1180292	4396	330	1.51751	5.007783	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	217	1.04e-51	NTclustered	gi\|2918369565\|emb\|OZ237731.1\|	317547	g4264	i0	81.319	76.3787878787879	273	45	82	3	5	274	9680292	9680561	Eunicella cavolini genome assembly, chromosome: 15	blastn	25205	217	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
21994560	21994560	PRJNA1180292_P_NODE_5918_length_287_cov_1.855140_g5786_i0	PRJNA1180292	5918	287	1.85514	5.3242518	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	54.7	0.007	NTclustered	gi\|2744889029\|ref\|XM_065810454.1\|	6087	g5786	i0	100	0.202090592334495	29	0	10	0	221	249	2276	2248	PREDICTED: Hydra vulgaris kinesin-like protein KIF28P (LOC100208423), transcript variant X3, mRNA	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
21994607	21994607	PRJNA1180292_P_NODE_978_length_708_cov_2.431496_g850_i0	PRJNA1180292	978	708	2.431496	17.21499168	Calycella syringa	314529	Cnidaria	other_Eukaryota	122	5.319999999999999e-23	NTclustered	gi\|256674468\|gb\|FJ550372.1\|	314529	g850	i0	86.087	14.1935028248588	115	14	16	2	526	639	1567	1454	Calycella syringa 28S ribosomal RNA gene, partial sequence	blastn	10049	122	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Campanulariidae	Calycella	Calycella syringa
24543885	24543885	PRJNA1180292_P_NODE_7160_length_264_cov_1.319372_g7028_i0	PRJNA1180292	7160	264	1.319372	3.48314208	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	161	3.84e-35	NTclustered	gi\|1270049062\|ref\|XM_022930896.1\|	50429	g7028	i0	85.806	3.97727272727273	155	18	58	4	20	172	334	486	PREDICTED: Stylophora pistillata calreticulin-like (LOC111326816), partial mRNA	blastn	1050	161	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata

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