RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA352610 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
2944791 2944791 PRJNA352610_P_NODE_7823_length_405_cov_1.138554_g7762_i0 PRJNA352610 7823 405 1.138554 4.6111437 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 743 0   NTclustered gi|2518984096|ref|XM_057441433.1| 13093 g7762 i0 99.753 78.0716049382716 405 1 100 0 1 405 940 1344 PREDICTED: Hydractinia symbiolongicarpus cytochrome b-like (LOC130628217), mRNA blastn 31619 743 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
8047100 8047100 PRJNA352610_P_NODE_23607_length_259_cov_1.037634_g23546_i0 PRJNA352610 23607 259 1.037634 2.68747206 Pocillopora verrucosa 203993 Cnidaria other_Eukaryota 257 4.66e-64   NTclustered gi|2367574861|gb|OM201532.1| 203993 g23546 i0 86.25 92.3976833976834 240 30 92 1 1 237 583 344 Pocillopora verrucosa isolate PS0103-46 beta-tubulin (TUB) gene, partial cds blastn 23931 257 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Pocillopora Pocillopora verrucosa
10597875 10597875 PRJNA352610_P_NODE_9269_length_379_cov_3.931373_g9208_i0 PRJNA352610 9269 379 3.931373 14.89990367 Actinia tenebrosa 6105 Cnidaria other_Eukaryota 329 1.49e-85   NTclustered gi|1778059731|ref|XM_031711301.1| 6105 g9208 i0 83.768 83.1899736147757 345 56 91 0 24 368 449 105 PREDICTED: Actinia tenebrosa ubiquitin-40S ribosomal protein S27a (LOC116302103), mRNA blastn 31529 329 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
11872516 11872516 PRJNA352610_P_NODE_26890_length_248_cov_1.611429_g26829_i0 PRJNA352610 26890 248 1.611429 3.99634392 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 459 1.13e-124   NTclustered gi|2518983886|ref|XM_057441323.1| 13093 g26829 i0 100 13.5927419354839 248 0 100 0 1 248 255 8 PREDICTED: Hydractinia symbiolongicarpus NADH-ubiquinone oxidoreductase chain 2-like (LOC130626408), mRNA blastn 3371 459 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
22070294 22070294 PRJNA352610_P_NODE_22538_length_265_cov_1.203125_g22477_i0 PRJNA352610 22538 265 1.203125 3.18828125 Orbicella faveolata 48498 Cnidaria other_Eukaryota 235 2.24e-57   NTclustered gi|1176113485|ref|XM_020772146.1| 48498 g22477 i0 84.681 90.2792452830189 235 36 89 0 27 261 1261 1027 PREDICTED: Orbicella faveolata eukaryotic initiation factor 4A-III (LOC110065039), mRNA blastn 23924 235 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Orbicella Orbicella faveolata

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