RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "blastn", bioproject = "PRJEB8827" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 23 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB8827 · 23 ✖

analysis 1

  • blastn · 23 ✖
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
25530385 25530385 PRJEB8827h_S_NODE_689_length_333_cov_1388.516779_g670_i0 PRJEB8827 689 333 1388.516779 4623.76087407 Acropora digitifera 70779 Cnidaria other_Eukaryota 121 8.48e-23   NTclustered gi|1005425977|ref|XR_001560985.1| 70779 g670 i0 97.183 21.0930930930931 71 2 21 0 1 71 81 11 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X4, ncRNA blastn 7024 121 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
25665463 25665463 PRJEB8827b_S_NODE_38786_length_160_cov_1.552000_g38734_i0 PRJEB8827 38786 160 1.552 2.4832 Acropora millepora 45264 Cnidaria other_Eukaryota 52.8 0.013   NTclustered gi|2114135399|ref|XM_029355121.2| 45264 g38734 i0 100 0.525 28 0 18 0 35 62 605 578 PREDICTED: Acropora millepora uncharacterized LOC114974984 (LOC114974984), mRNA blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
25666270 25666270 PRJEB8827h_S_NODE_2194_length_228_cov_3260.404145_g2175_i0 PRJEB8827 2194 228 3260.404145 7433.7214506 Acropora digitifera 70779 Cnidaria other_Eukaryota 121 5.49e-23   NTclustered gi|1005425977|ref|XR_001560985.1| 70779 g2175 i0 97.183 30.8070175438597 71 2 31 0 1 71 81 11 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X4, ncRNA blastn 7024 121 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
25753826 25753826 PRJEB8827d_S_NODE_778_length_236_cov_5.323383_g774_i0 PRJEB8827 778 236 5.323383 12.56318388 Metazoa 33208 Cnidaria other_Eukaryota 56.5 0.002   NTclustered gi|2917940724|emb|OZ237563.1| 6108 g774 i0 100 1.05932203389831 30 0 13 0 85 114 455653 455682 Anemonia sulcata genome assembly, chromosome: 9 blastn 250 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
25754019 25754019 PRJEB8827g_S_NODE_1594_length_246_cov_11053.056872_g1573_i0 PRJEB8827 1594 246 11053.056872 27190.51990512 Metazoa 33208 Cnidaria other_Eukaryota 56.5 0.002   NTclustered gi|2917940724|emb|OZ237563.1| 6108 g1573 i0 100 1.07723577235772 30 0 12 0 60 89 455653 455682 Anemonia sulcata genome assembly, chromosome: 9 blastn 265 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
25754082 25754082 PRJEB8827h_S_NODE_738_length_326_cov_2964.017182_g719_i0 PRJEB8827 738 326 2964.017182 9662.69601332 root 1 Root_unresolved Root_unresolved 121 8.28e-23   NTclustered gi|1005425979|ref|XR_001560992.1| 70779 g719 i0 93.827 21.4570552147239 81 4 25 1 246 326 23 102 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X6, ncRNA blastn 6995 122 0.991803278688525 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
25801619 25801619 PRJEB8827d_S_NODE_435_length_280_cov_2276.359184_g431_i0 PRJEB8827 435 280 2276.359184 6373.8057152 Acropora digitifera 70779 Cnidaria other_Eukaryota 115 3.24e-21   NTclustered gi|1005425979|ref|XR_001560992.1| 70779 g431 i0 98.462 23.2607142857143 65 1 23 0 1 65 95 31 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X6, ncRNA blastn 6513 115 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
25889535 25889535 PRJEB8827c_S_NODE_19_length_609_cov_6666.047038_g8_i0 PRJEB8827 19 609 6666.047038 40596.22646142 root 1 Root_unresolved Root_unresolved 108 1.27e-18   NTclustered gi|1005425975|ref|XR_001560982.1| 70779 g8 i0 100 10.1428571428571 58 0 10 0 1 58 93 36 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X2, ncRNA blastn 6177 108 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
25938432 25938432 PRJEB8827f_S_NODE_4380_length_219_cov_2.923913_g4360_i0 PRJEB8827 4380 219 2.923913 6.40336947 Symplectoscyphus tricuspidatus 308614 Cnidaria other_Eukaryota 121 5.2399999999999996e-23   NTclustered gi|1006165264|gb|KT190774.1| 308614 g4360 i0 79.348 20.0547945205479 184 28 83 6 13 193 2488 2312 Symplectoscyphus tricuspidatus voucher MBM240558 clone STNB12P212-1, P213-1 28S ribosomal RNA gene, partial sequence blastn 4392 121 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Sertulariidae Symplectoscyphus Symplectoscyphus tricuspidatus
25938768 25938768 PRJEB8827j_S_NODE_716_length_217_cov_747.368132_g712_i0 PRJEB8827 716 217 747.368132 1621.78884644 Acropora digitifera 70779 Cnidaria other_Eukaryota 108 4.03e-19   NTclustered gi|1005425980|ref|XR_001560994.1| 70779 g712 i0 94.366 31.1566820276498 71 3 33 1 147 217 9 78 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X7, ncRNA blastn 6761 108 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
26026130 26026130 PRJEB8827h_S_NODE_876_length_305_cov_4049.566667_g857_i0 PRJEB8827 876 305 4049.566667 12351.17833435 root 1 Root_unresolved Root_unresolved 121 7.68e-23   NTclustered gi|1005425979|ref|XR_001560992.1| 70779 g857 i0 95.946 22.6491803278689 74 3 24 0 1 74 102 29 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X6, ncRNA blastn 6908 121 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
26073814 26073814 PRJEB8827c_S_NODE_125_length_300_cov_14032.683019_g112_i0 PRJEB8827 125 300 14032.683019 42098.049057 Acropora digitifera 70779 Cnidaria other_Eukaryota 110 1.63e-19   NTclustered gi|1005425980|ref|XR_001560994.1| 70779 g112 i0 96.97 19.9333333333333 66 0 22 1 235 300 9 72 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X7, ncRNA blastn 5980 110 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
26073835 26073835 PRJEB8827d_S_NODE_453_length_278_cov_3322.477366_g449_i0 PRJEB8827 453 278 3322.477366 9236.48707748 Acropora digitifera 70779 Cnidaria other_Eukaryota 110 1.5e-19   NTclustered gi|1005425979|ref|XR_001560992.1| 70779 g449 i0 96.923 23.8129496402878 65 2 23 0 214 278 31 95 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X6, ncRNA blastn 6620 110 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
26073989 26073989 PRJEB8827e_S_NODE_3525_length_236_cov_1344.810945_g3497_i0 PRJEB8827 3525 236 1344.810945 3173.7538302 Acropora digitifera 70779 Cnidaria other_Eukaryota 121 5.72e-23   NTclustered gi|1005425977|ref|XR_001560985.1| 70779 g3497 i0 97.183 29.7627118644068 71 2 30 0 1 71 81 11 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X4, ncRNA blastn 7024 121 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
26074533 26074533 PRJEB8827g_S_NODE_1189_length_275_cov_86041.925000_g1168_i0 PRJEB8827 1189 275 86041.925 236615.29375 Acropora digitifera 70779 Cnidaria other_Eukaryota 115 3.18e-21   NTclustered gi|1005425982|ref|XR_001560996.1| 70779 g1168 i0 97.059 23.7781818181818 68 2 25 0 1 68 77 10 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X9, ncRNA blastn 6539 115 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
26162115 26162115 PRJEB8827f_S_NODE_19077_length_166_cov_12.015267_g19057_i0 PRJEB8827 19077 166 12.015267 19.94534322 Ellisella 328399 Cnidaria other_Eukaryota 97.1 6.33e-16   NTclustered gi|2689317297|gb|PP410744.1| 2751895 g19057 i0 95.161 34.1265060240964 62 2 37 1 25 86 3588 3528 Ellisella elongata voucher USNM:1660444 large subunit ribosomal RNA gene, partial sequence blastn 5665 97.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleralcyonacea Ellisellidae Ellisella Ellisella elongata
26162236 26162236 PRJEB8827h_S_NODE_181_length_488_cov_195.273731_g162_i0 PRJEB8827 181 488 195.273731 952.93580728 Ellisella 328399 Cnidaria other_Eukaryota 97.1 2.17e-15   NTclustered gi|2689317297|gb|PP410744.1| 2751895 g162 i0 95.161 11.608606557377 62 2 13 1 328 389 3528 3588 Ellisella elongata voucher USNM:1660444 large subunit ribosomal RNA gene, partial sequence blastn 5665 97.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleralcyonacea Ellisellidae Ellisella Ellisella elongata
26210450 26210450 PRJEB8827f_S_NODE_1814_length_301_cov_4390.139098_g1794_i0 PRJEB8827 1814 301 4390.139098 13214.31868498 Acropora digitifera 70779 Cnidaria other_Eukaryota 121 7.57e-23   NTclustered gi|1005425980|ref|XR_001560994.1| 70779 g1794 i0 95.946 23.5382059800664 74 3 25 0 228 301 9 82 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X7, ncRNA blastn 7085 121 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
26210950 26210950 PRJEB8827h_S_NODE_926_length_299_cov_22520.337121_g907_i0 PRJEB8827 926 299 22520.337121 67335.80799179 Acropora digitifera 70779 Cnidaria other_Eukaryota 75 5.93e-9   NTclustered gi|1005425974|ref|XR_001560980.1| 70779 g907 i0 95.745 13.5685618729097 47 0 15 2 255 299 25 71 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X1, ncRNA blastn 4057 75 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
26346700 26346700 PRJEB8827h_S_NODE_1087_length_285_cov_4221.356000_g1068_i0 PRJEB8827 1087 285 4221.356 12030.8646 Acropora digitifera 70779 Cnidaria other_Eukaryota 121 7.119999999999999e-23   NTclustered gi|1005425980|ref|XR_001560994.1| 70779 g1068 i0 96 24.6631578947368 75 1 26 2 1 74 82 9 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X7, ncRNA blastn 7029 121 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
26346782 26346782 PRJEB8827h_S_NODE_6439_length_198_cov_4.472393_g6420_i0 PRJEB8827 6439 198 4.472393 8.85533814 Nematostella vectensis 45351 Cnidaria other_Eukaryota 124 3.59e-24   NTclustered gi|2257888155|ref|XM_001640516.3| 45351 g6420 i0 82.069 1.4040404040404 145 26 73 0 1 145 441 585 PREDICTED: Nematostella vectensis ubiquitin-40S ribosomal protein S27a (LOC5520747), mRNA blastn 278 124 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
26482633 26482633 PRJEB8827f_S_NODE_2992_length_252_cov_6.036866_g2972_i0 PRJEB8827 2992 252 6.036866 15.21290232 Acropora millepora 45264 Cnidaria other_Eukaryota 52.8 0.023   NTclustered gi|2114135399|ref|XM_029355121.2| 45264 g2972 i0 100 0.333333333333333 28 0 11 0 36 63 578 605 PREDICTED: Acropora millepora uncharacterized LOC114974984 (LOC114974984), mRNA blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
26570014 26570014 PRJEB8827g_S_NODE_384_length_411_cov_6465.654255_g365_i0 PRJEB8827 384 411 6465.654255 26573.83898805 root 1 Root_unresolved Root_unresolved 119 3.84e-22   NTclustered gi|1005425975|ref|XR_001560982.1| 70779 g365 i0 97.143 17.2335766423358 70 2 17 0 1 70 103 34 PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X2, ncRNA blastn 7083 119 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera

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