metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1118794" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1118794" 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
230288	230288	PRJNA1118794_P_NODE_10861_length_430_cov_2.355742_g10113_i0	PRJNA1118794	10861	430	2.355742	10.1296906	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	196	1.81e-45	NTclustered	gi\|2782929037\|ref\|XM_067073665.1\|	252671	g10113	i0	76.486	9.83720930232558	370	81	86	6	42	410	1057	693	PREDICTED: Clytia hemisphaerica calreticulin-like (LOC136817322), mRNA	blastn	4230	196	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
1505082	1505082	PRJNA1118794_P_NODE_10442_length_437_cov_4.936813_g9694_i0	PRJNA1118794	10442	437	4.936813	21.57387281	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	318	3.7699999999999984e-82	NTclustered	gi\|2518991437\|ref\|XM_057446583.1\|	13093	g9694	i0	83.146	80.4118993135011	356	52	81	7	74	425	515	164	PREDICTED: Hydractinia symbiolongicarpus ubiquitin-60S ribosomal protein L40 (LOC130636750), mRNA	blastn	35140	318	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
4057918	4057918	PRJNA1118794_P_NODE_7544_length_511_cov_4.490868_g6802_i0	PRJNA1118794	7544	511	4.490868	22.94833548	Kudoa ogawai	1041012	Cnidaria	other_Eukaryota	106	3.79e-18	NTclustered	gi\|1625808120\|gb\|MK850346.1\|	1041012	g6802	i0	88.636	17.185909980430502	88	9	17	1	1	87	2591	2678	Kudoa ogawai isolate OF-1 large subunit ribosomal RNA gene, partial sequence	blastn	8782	106	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Multivalvulida	Kudoidae	Kudoa	Kudoa ogawai
9953182	9953182	PRJNA1118794_P_NODE_4228_length_693_cov_1.669355_g3517_i0	PRJNA1118794	4228	693	1.669355	11.56863015	Metazoa	33208	Cnidaria	other_Eukaryota	58.4	0.001	NTclustered	gi\|2917940756\|emb\|OZ237571.1\|	6108	g3517	i0	94.737	1.51948051948052	38	1	5	1	608	644	11720957	11720920	Anemonia sulcata genome assembly, chromosome: 17	blastn	1053	58.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
12503922	12503922	PRJNA1118794_P_NODE_72030_length_241_cov_3.339286_g71280_i0	PRJNA1118794	72030	241	3.339286	8.04767926	Scyphozoa	6142	Cnidaria	other_Eukaryota	119	2.11e-22	NTclustered	gi\|166007839\|gb\|EU276014.1\|	497994	g71280	i0	90.11	40.0290456431535	91	9	38	0	140	230	6023	6113	Aurelia sp. Incheon-2006 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and intergenic spacer 1, complete sequence	blastn	9647	119	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Semaeostomeae	Ulmaridae	Aurelia	Aurelia sp. Incheon-2006
14259292	14259292	PRJNA1118794_P_NODE_1052_length_1425_cov_6.868343_g681_i0	PRJNA1118794	1052	1425	6.868343	97.87388775	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	65.8	1.88e-5	NTclustered	gi\|2257855075\|ref\|XM_048722042.1\|	45351	g681	i0	95.122	1.03578947368421	41	2	4	0	599	639	1974	1934	PREDICTED: Nematostella vectensis uncharacterized LOC5518860 (LOC5518860), transcript variant X3, mRNA	blastn	1476	65.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
15052594	15052594	PRJNA1118794_P_NODE_35432_length_279_cov_1.169903_g34682_i0	PRJNA1118794	35432	279	1.169903	3.26402937	Erythropodium	86549	Cnidaria	other_Eukaryota	117	8.98e-22	NTclustered	gi\|1318708066\|gb\|MG018861.1\|	86550	g34682	i0	94.667	1.61290322580645	75	4	27	0	111	185	74	148	Erythropodium caribaeorum voucher RMNH:Coel.40829 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	450	117	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Alcyoniidae	Erythropodium	Erythropodium caribaeorum
15052629	15052629	PRJNA1118794_P_NODE_52212_length_250_cov_0.870056_g51462_i0	PRJNA1118794	52212	250	0.870056	2.17514	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	54.7	0.006	NTclustered	gi\|2917940696\|emb\|OZ237557.1\|	6108	g51462	i0	90.476	0.632	42	2	16	2	125	164	18462682	18462723	Anemonia sulcata genome assembly, chromosome: 3	blastn	158	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
21907718	21907718	PRJNA1118794_P_NODE_46318_length_255_cov_1.692308_g45568_i0	PRJNA1118794	46318	255	1.692308	4.3153854	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	65.8	2.98e-6	NTclustered	gi\|2918369564\|emb\|OZ237730.1\|	317547	g45568	i0	97.368	10.9333333333333	38	1	15	0	152	189	14863891	14863928	Eunicella cavolini genome assembly, chromosome: 14	blastn	2788	65.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini

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