RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1150539" 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

  • PRJNA1150539 · 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
301420 301420 PRJNA1150539_S_NODE_60961_length_293_cov_1.854545_g60365_i0 PRJNA1150539 60961 293 1.854545 5.43381685 Acropora muricata 159855 Cnidaria other_Eukaryota 52.8 0.027   NTclustered gi|2784646160|ref|XM_067174174.1| 159855 g60365 i0 100 0.286689419795222 28 0 10 0 120 147 4365 4338 PREDICTED: Acropora muricata peroxidasin homolog (LOC136907478), transcript variant X3, mRNA blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora muricata
301655 301655 PRJNA1150539_S_NODE_82681_length_262_cov_3.116402_g82085_i0 PRJNA1150539 82681 262 3.116402 8.16497324 Eunicella cavolini 317547 Cnidaria other_Eukaryota 56.5 0.002   NTclustered gi|2918369552|emb|OZ237724.1| 317547 g82085 i0 100 0.114503816793893 30 0 11 0 79 108 14057462 14057433 Eunicella cavolini genome assembly, chromosome: 8 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
4128675 4128675 PRJNA1150539_S_NODE_87564_length_256_cov_3.060109_g86968_i0 PRJNA1150539 87564 256 3.060109 7.83387904 Pocillopora verrucosa 203993 Cnidaria other_Eukaryota 54.7 0.006   NTclustered gi|2751515433|ref|XM_059111930.2| 203993 g86968 i0 100 0.11328125 29 0 11 0 165 193 2190 2218 PREDICTED: Pocillopora verrucosa CCHC-type zinc finger nucleic acid binding protein (LOC131794408), transcript variant X1, mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Pocillopora Pocillopora verrucosa
4128751 4128751 PRJNA1150539_S_NODE_95004_length_248_cov_1.965714_g94408_i0 PRJNA1150539 95004 248 1.965714 4.87497072 Hydra vulgaris 6087 Cnidaria other_Eukaryota 52.8 0.022   NTclustered gi|2213065759|ref|XM_047285346.1| 6087 g94408 i0 100 0.112903225806452 28 0 11 0 182 209 546 573 PREDICTED: Hydra vulgaris alpha-(1,6)-fucosyltransferase-like (LOC124816241), transcript variant X1, mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
11780187 11780187 PRJNA1150539_S_NODE_70070_length_279_cov_3.281553_g69474_i0 PRJNA1150539 70070 279 3.281553 9.15553287 Anemonia sulcata 6108 Cnidaria other_Eukaryota 60.2 1.54e-4   NTclustered gi|2917940766|emb|OZ237573.1| 6108 g69474 i0 100 0.114695340501792 32 0 11 0 81 112 8609634 8609603 Anemonia sulcata genome assembly, chromosome: 19 blastn 32 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
13054610 13054610 PRJNA1150539_S_NODE_105291_length_236_cov_2.300613_g104695_i0 PRJNA1150539 105291 236 2.300613 5.42944668 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 52.8 0.021   NTclustered gi|2518962117|ref|XM_057434974.1| 13093 g104695 i0 100 0.11864406779661 28 0 12 0 183 210 107 134 PREDICTED: Hydractinia symbiolongicarpus uncharacterized LOC130613657 (LOC130613657), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
14330373 14330373 PRJNA1150539_S_NODE_48952_length_313_cov_1.766667_g48356_i0 PRJNA1150539 48952 313 1.766667 5.52966771 Xenia sp. Carnegie-2017 2897299 Cnidaria other_Eukaryota 54.7 0.008   NTclustered gi|2202666560|ref|XR_006951441.1| 2897299 g48356 i0 94.286 0.111821086261981 35 2 11 0 279 313 35 1 PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124454405 (LOC124454405), ncRNA blastn 35 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Xeniidae Xenia Xenia sp. Carnegie-2017

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