RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA800090" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA800090 · 7 ✖

analysis 1

  • blastn · 7 ✖
Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag 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
796419 796419 PRJNA800090_P_NODE_106241_length_314_cov_1.816327_g104056_i0 PRJNA800090 106241 314 1.816327 5.70326678 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 198 3.57e-46   NTclustered gi|2782919631|ref|XM_067071982.1| 252671 g104056 i0 80.608 45.2484076433121 263 46 83 5 55 314 928 668 PREDICTED: Clytia hemisphaerica adenosylhomocysteinase-like (LOC136815526), mRNA blastn 14208 198 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
7178786 7178786 PRJNA800090_S_NODE_17066_length_296_cov_0.947137_g16954_i0 PRJNA800090 17066 296 0.947137 2.80352552 Dipsastraea favus 1869259 Cnidaria other_Eukaryota 303 6.87e-78   NTclustered gi|62732001|dbj|AB193293.1| 1869259 g16954 i0 88.446 1.69594594594595 251 29 85 0 1 251 46 296 Favia favus KikGR mRNA for photoconvertible fluorescent protein, complete cds blastn 502 303 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Dipsastraea Dipsastraea favus
12277424 12277424 PRJNA800090_P_NODE_172650_length_236_cov_0.874251_g170465_i0 PRJNA800090 172650 236 0.874251 2.06323236 Acropora digitifera 70779 Cnidaria other_Eukaryota 52.8 0.021   NTclustered gi|1005465472|ref|XM_015914242.1| 70779 g170465 i0 100 0.11864406779661 28 0 12 0 27 54 112 139 PREDICTED: Acropora digitifera uncharacterized LOC107348219 (LOC107348219), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
19924180 19924180 PRJNA800090_P_NODE_148096_length_258_cov_1.470899_g145911_i0 PRJNA800090 148096 258 1.470899 3.79491942 Hydra vulgaris 6087 Cnidaria other_Eukaryota 52.8 0.023   NTclustered gi|2744805288|ref|XM_012698441.3| 6087 g145911 i0 96.774 0.36046511627907 31 1 12 0 3 33 7378 7408 PREDICTED: Hydra vulgaris serine/threonine-protein kinase SMG1 (LOC100210457), transcript variant X1, mRNA blastn 93 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
19926136 19926136 PRJNA800090_P_NODE_55376_length_474_cov_2.666667_g53192_i0 PRJNA800090 55376 474 2.666667 12.64000158 Orbicella faveolata 48498 Cnidaria other_Eukaryota 56.5 0.004   NTclustered gi|1176092358|ref|XM_020761004.1| 48498 g53192 i0 97.059 0.0717299578059072 34 0 7 1 50 82 2926 2893 PREDICTED: Orbicella faveolata hemicentin-1-like (LOC110054655), mRNA blastn 34 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Orbicella Orbicella faveolata
21199433 21199433 PRJNA800090_P_NODE_130437_length_277_cov_1.745192_g128252_i0 PRJNA800090 130437 277 1.745192 4.83418184 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 111 4.15e-20   NTclustered gi|2782949226|ref|XM_067078255.1| 252671 g128252 i0 84.211 0.826714801444043 114 18 41 0 152 265 410 523 PREDICTED: Clytia hemisphaerica charged multivesicular body protein 2a-like (LOC136822037), mRNA blastn 229 111 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
21200898 21200898 PRJNA800090_P_NODE_195617_length_223_cov_2.272727_g193432_i0 PRJNA800090 195617 223 2.272727 5.06818121 Dipsastraea favus 1869259 Cnidaria other_Eukaryota 322 1.37e-83   NTclustered gi|62732001|dbj|AB193293.1| 1869259 g193432 i0 93.151 63.2600896860987 219 15 98 0 5 223 479 261 Favia favus KikGR mRNA for photoconvertible fluorescent protein, complete cds blastn 14107 322 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Dipsastraea Dipsastraea favus

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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