RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA1174207" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1174207 · 14 ✖

analysis 1

  • blastn · 14 ✖
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
315542 315542 PRJNA1174207_P_NODE_21121_length_310_cov_2.493671_g20592_i0 PRJNA1174207 21121 310 2.493671 7.7303801 Acropora millepora 45264 Cnidaria other_Eukaryota 169 2.7599999999999997e-37   NTclustered gi|2114287613|ref|XM_044324432.1| 45264 g20592 i0 100 4.43870967741935 91 0 29 0 1 91 2096 2186 PREDICTED: Acropora millepora uncharacterized LOC122961664 (LOC122961664), mRNA blastn 1376 169 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
315782 315782 PRJNA1174207_P_NODE_32721_length_253_cov_1.711111_g32192_i0 PRJNA1174207 32721 253 1.711111 4.32911083 Acropora digitifera 70779 Cnidaria other_Eukaryota 298 2.6699999999999998e-76   NTclustered gi|1005457315|ref|XR_001564468.1| 70779 g32192 i0 88.627 36.0750988142292 255 16 100 7 1 253 11 254 PREDICTED: Acropora digitifera uncharacterized LOC107344610 (LOC107344610), transcript variant X4, ncRNA blastn 9127 298 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
316006 316006 PRJNA1174207_P_NODE_43601_length_210_cov_4.824818_g43072_i0 PRJNA1174207 43601 210 4.824818 10.1321178 Acropora lutkeni 513072 Cnidaria other_Eukaryota 377 2.68e-100   NTclustered gi|1253553532|emb|LT631050.1| 513072 g43072 i0 100 52.3761904761905 204 0 97 0 7 210 848 645 Acropora lutkeni partial 18S rRNA gene, specimen voucher GA027 blastn 10999 377 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora lutkeni
1590538 1590538 PRJNA1174207_P_NODE_40822_length_242_cov_0.911243_g40293_i0 PRJNA1174207 40822 242 0.911243 2.20520806 Parvicapsula minibicornis 109801 Cnidaria other_Eukaryota 124 4.55e-24   NTclustered gi|605060084|gb|KF874224.1| 109801 g40293 i0 86.726 48.3925619834711 113 13 47 2 2 114 343 233 Parvicapsula minibicornis 28S ribosomal RNA gene, partial sequence blastn 11711 124 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Parvicapsulidae Parvicapsula Parvicapsula minibicornis
3591099 3591099 PRJNA1174207_P_NODE_29243_length_267_cov_4.819588_g28714_i0 PRJNA1174207 29243 267 4.819588 12.86829996 Acropora 6127 Cnidaria other_Eukaryota 464 2.6499999999999993e-126   NTclustered gi|33150500|gb|AY139663.1| 70779 g28714 i0 98.851 94.1348314606742 261 1 97 1 1 259 261 1 Acropora digitifera clone 5 28S ribosomal RNA gene, partial sequence blastn 25134 468 0.991452991452991 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
4142664 4142664 PRJNA1174207_P_NODE_34344_length_250_cov_0.870056_g33815_i0 PRJNA1174207 34344 250 0.870056 2.17514 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 54.7 0.006   NTclustered gi|2518990735|ref|XM_057446203.1| 13093 g33815 i0 100 0.116 29 0 12 0 64 92 356 384 PREDICTED: Hydractinia symbiolongicarpus MORN repeat-containing protein 4-like (LOC130636469), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
6693770 6693770 PRJNA1174207_P_NODE_40306_length_242_cov_1.822485_g39777_i0 PRJNA1174207 40306 242 1.822485 4.4104137 Acropora millepora 45264 Cnidaria other_Eukaryota 326 1.16e-84   NTclustered gi|2114001540|ref|XM_029336244.2| 45264 g39777 i0 91.736 17.7685950413223 242 9 100 1 1 242 3669 3899 PREDICTED: Acropora millepora uncharacterized LOC114958465 (LOC114958465), mRNA blastn 4300 326 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
9969006 9969006 PRJNA1174207_P_NODE_9588_length_496_cov_4.851064_g9062_i0 PRJNA1174207 9588 496 4.851064 24.06127744 Acropora 6127 Cnidaria other_Eukaryota 712 0   NTclustered gi|2113715643|ref|XR_006393644.1| 45264 g9062 i0 92.829 1214.22177419355 502 19 100 12 1 496 2841 2351 PREDICTED: Acropora millepora large subunit ribosomal RNA (LOC122954207), rRNA blastn 602254 712 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
16892703 16892703 PRJNA1174207_P_NODE_27954_length_273_cov_1.540000_g27425_i0 PRJNA1174207 27954 273 1.54 4.2042 Clytia paulensis 252666 Cnidaria other_Eukaryota 267 8.219999999999999e-67   NTclustered gi|62825431|gb|AY789852.1| 252666 g27425 i0 84.644 59.9523809523809 267 41 98 0 7 273 370 104 Clytia paulensis voucher 39IT calmodulin gene, partial cds blastn 16367 267 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia paulensis
18167616 18167616 PRJNA1174207_P_NODE_8995_length_517_cov_4.112613_g8470_i0 PRJNA1174207 8995 517 4.112613 21.26220921 Acropora millepora 45264 Cnidaria other_Eukaryota 815 0   NTclustered gi|2113715643|ref|XR_006393644.1| 45264 g8470 i0 95.038 32.3597678916828 524 17 99 6 2 517 1853 1331 PREDICTED: Acropora millepora large subunit ribosomal RNA (LOC122954207), rRNA blastn 16730 815 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
20716932 20716932 PRJNA1174207_P_NODE_24997_length_285_cov_7.608491_g24468_i0 PRJNA1174207 24997 285 7.608491 21.68419935 Acropora lutkeni 513072 Cnidaria other_Eukaryota 527 3.59e-145   NTclustered gi|1253553532|emb|LT631050.1| 513072 g24468 i0 100 80.5263157894737 285 0 100 0 1 285 299 15 Acropora lutkeni partial 18S rRNA gene, specimen voucher GA027 blastn 22950 527 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora lutkeni
22717593 22717593 PRJNA1174207_P_NODE_32638_length_253_cov_2.861111_g32109_i0 PRJNA1174207 32638 253 2.861111 7.23861083 Acropora 6127 Cnidaria other_Eukaryota 60.2 1.37e-4   NTclustered gi|33150516|gb|AY139679.1| 46687 g32109 i0 77.586 4.49802371541502 116 15 45 9 139 253 478 373 Acropora humilis clone 1 28S ribosomal RNA gene, partial sequence blastn 1138 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora humilis
23992938 23992938 PRJNA1174207_P_NODE_40299_length_242_cov_1.905325_g39770_i0 PRJNA1174207 40299 242 1.905325 4.6108865 Acropora 6127 Cnidaria other_Eukaryota 448 2.3799999999999995e-121   NTclustered gi|2164965894|gb|MW246498.1| 6130 g39770 i0 100 100 242 0 100 0 1 242 1047 1288 Acropora cervicornis voucher 13917 clone HG0061 mitochondrion, complete genome blastn 24200 448 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora cervicornis
25266660 25266660 PRJNA1174207_P_NODE_11740_length_435_cov_1.922652_g11213_i0 PRJNA1174207 11740 435 1.922652 8.3635362 Myxozoa 35581 Cnidaria other_Eukaryota 130 1.89e-25   NTclustered gi|241911758|gb|FJ417064.1| 371547 g11213 i0 86.667 21.816091954023 120 13 28 2 119 238 1958 2074 Myxidium incurvatum isolate M0308 28S large subunit ribosomal RNA gene, partial sequence blastn 9490 130 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Myxidiidae Myxidium Myxidium incurvatum

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