RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1174234" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1174234 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
3591401 3591401 PRJNA1174234_P_NODE_27703_length_258_cov_2.156757_g27507_i0 PRJNA1174234 27703 258 2.156757 5.56443306 Acropora 6127 Cnidaria other_Eukaryota 189 1.7199999999999999e-43   NTclustered gi|2114098761|ref|XM_029328531.2| 45264 g27507 i0 83.582 18.5813953488372 201 33 78 0 50 250 78 278 PREDICTED: Acropora millepora tubulin beta-4B chain-like (LOC114952563), mRNA blastn 4794 189 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
4868976 4868976 PRJNA1174234_P_NODE_13444_length_375_cov_1.781457_g13248_i0 PRJNA1174234 13444 375 1.781457 6.68046375 Metazoa 33208 Cnidaria other_Eukaryota 52.8 0.036   NTclustered gi|2918369567|emb|OZ237733.1| 317547 g13248 i0 100 0.149333333333333 28 0 7 0 92 119 812020 812047 Eunicella cavolini genome assembly, chromosome: 17 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
11794716 11794716 PRJNA1174234_P_NODE_25410_length_272_cov_1.949749_g25214_i0 PRJNA1174234 25410 272 1.949749 5.30331728 Orbicella faveolata 48498 Cnidaria other_Eukaryota 115 3.14e-21   NTclustered gi|1176118129|ref|XM_020774603.1| 48498 g25214 i0 83.2 9.48529411764706 125 21 46 0 3 127 371 247 PREDICTED: Orbicella faveolata ras-related protein Rab-5B-like (LOC110067288), mRNA blastn 2580 115 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Orbicella Orbicella faveolata
11794782 11794782 PRJNA1174234_P_NODE_3990_length_667_cov_21.405724_g3802_i0 PRJNA1174234 3990 667 21.405724 142.77617908 Hydra vulgaris 6087 Cnidaria other_Eukaryota 303 1.66e-77   NTclustered gi|2744794010|ref|XM_012698561.3| 6087 g3802 i0 81.383 14.5217391304348 376 66 56 4 123 496 217 590 PREDICTED: Hydra vulgaris small ribosomal subunit protein uS11 (LOC100201565), transcript variant X1, mRNA blastn 9686 303 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
15068643 15068643 PRJNA1174234_P_NODE_552_length_1400_cov_6.700829_g483_i0 PRJNA1174234 552 1400 6.700829 93.811606 Metazoa 33208 Cnidaria other_Eukaryota 948 0   NTclustered gi|2518998737|ref|XM_057450856.1| 13093 g483 i0 81.699 247.091428571429 1142 205 81 4 205 1344 1216 77 PREDICTED: Hydractinia symbiolongicarpus polyubiquitin-C-like (LOC130645015), mRNA blastn 345928 948 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
16893206 16893206 PRJNA1174234_P_NODE_25934_length_269_cov_1.561224_g25738_i0 PRJNA1174234 25934 269 1.561224 4.19969256 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 115 3.1e-21   NTclustered gi|2518988319|ref|XR_008982170.1| 13093 g25738 i0 94.595 149.847583643123 74 4 28 0 195 268 913 840 PREDICTED: Hydractinia symbiolongicarpus uncharacterized LOC130635550 (LOC130635550), ncRNA blastn 40309 115 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus

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