RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJEB14175" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB14175 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
33028369 33028369 PRJEB14175_P_NODE_159716_length_265_cov_4.549020_g157449_i0 PRJEB14175 159716 265 4.54902 12.054903 Nematostella vectensis 45351 Cnidaria other_Eukaryota 43.1 0.0365   NR ABC88373.1 45351 g157449 i0 37 0.611320754716981 54 34 61.1 0 265 104 76 129 ABC88373.1 chordin [Nematostella vectensis] diamond 162 43.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
33042019 33042019 PRJEB14175_P_NODE_16596_length_887_cov_13.000000_g14901_i0 PRJEB14175 16596 887 13 115.31 Opisthokonta 33154 Cnidaria other_Eukaryota 79.7 1.9e-12   NR XP_065675386.1 6087 g14901 i0 31.4 4.75535512965051 204 109 59.9 10 354 884 1034 1233 XP_065675386.1 NFX1-type zinc finger-containing protein 1 isoform X2 [Hydra vulgaris] diamond 4218 80.5 0.990062111801242 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
33042121 33042121 PRJEB14175_P_NODE_211956_length_219_cov_2.493671_g209689_i0 PRJEB14175 211956 219 2.493671 5.46113949 Opisthokonta 33154 Cnidaria other_Eukaryota 86.3 1.25e-19   NR XP_057311841.1 13093 g209689 i0 64.3 7.67123287671233 56 20 76.7 0 210 43 75 130 XP_057311841.1 uncharacterized protein LOC130649561 [Hydractinia symbiolongicarpus] diamond 1680 87 0.991954022988506 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
33062832 33062832 PRJEB14175_P_NODE_204389_length_225_cov_1.335366_g202122_i0 PRJEB14175 204389 225 1.335366 3.0045735 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 44.3 0.00855   NR XP_066917219.1 252671 g202122 i0 33.9 1.6 59 39 78.7 0 225 49 382 440 XP_066917219.1 uncharacterized protein [Clytia hemisphaerica] diamond 360 44.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
33093581 33093581 PRJEB14175_P_NODE_78630_length_412_cov_11.638177_g76369_i0 PRJEB14175 78630 412 11.638177 47.94928924 Metazoa 33208 Cnidaria other_Eukaryota 56.6 3.2e-6   NR XP_065065088.1 499914 g76369 i0 68.4 1.79854368932039 38 12 27.7 0 330 217 453 490 XP_065065088.1 inositol-3-phosphate synthase 1-B-like [Rhopilema esculentum] diamond 741 56.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Rhizostomeae Rhizostomatidae Rhopilema Rhopilema esculentum
33097391 33097391 PRJEB14175_P_NODE_247550_length_204_cov_0.895105_g245282_i0 PRJEB14175 247550 204 0.895105 1.8260142 Hydra vulgaris 6087 Cnidaria other_Eukaryota 64.7 3.91e-10   NR XP_065645504.1 6087 g245282 i0 52.4 9.19117647058824 63 30 92.6 0 199 11 286 348 XP_065645504.1 zinc finger BED domain-containing protein 4-like [Hydra vulgaris] diamond 1875 64.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
33110191 33110191 PRJEB14175_P_NODE_147030_length_280_cov_5.908676_g144763_i0 PRJEB14175 147030 280 5.908676 16.5442928 Opisthokonta 33154 Cnidaria other_Eukaryota 55.5 1.67e-6   NR XP_057315388.1 13093 g144763 i0 82.4 5.06785714285714 34 6 36.4 0 24 125 284 317 XP_057315388.1 uncharacterized protein LOC130656529 isoform X1 [Hydractinia symbiolongicarpus] diamond 1419 55.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
33113316 33113316 PRJEB14175_P_NODE_135055_length_296_cov_10.604255_g132788_i0 PRJEB14175 135055 296 10.604255 31.3885948 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 77.4 4.65e-14   NR KXJ05234.1 2652724 g132788 i0 81 0.851351351351351 42 8 42.6 0 163 288 363 404 KXJ05234.1 Steroid 17-alpha-hydroxylase/17,20 lyase, partial [Exaiptasia diaphana] diamond 252 77.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
33114962 33114962 PRJEB14175_P_NODE_70711_length_438_cov_6.809019_g68452_i0 PRJEB14175 70711 438 6.809019 29.82350322 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 87.8 1.59e-17   NR XP_057309343.1 13093 g68452 i0 56.1 0.561643835616438 82 35 55.5 1 3 245 181 262 XP_057309343.1 60S acidic ribosomal protein P0-like [Hydractinia symbiolongicarpus] diamond 246 87.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
33127397 33127397 PRJEB14175_P_NODE_207887_length_222_cov_2.086957_g205620_i0 PRJEB14175 207887 222 2.086957 4.63304454 Metazoa 33208 Cnidaria other_Eukaryota 48.9 5.44e-5   NR XP_065672415.1 6087 g205620 i0 50 2.44594594594595 40 20 54.1 0 16 135 86 125 XP_065672415.1 keratinocyte-associated protein 2 isoform X2 [Hydra vulgaris] diamond 543 49.3 0.991886409736308 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
33127552 33127552 PRJEB14175_P_NODE_43223_length_567_cov_9.138340_g41009_i0 PRJEB14175 43223 567 9.13834 51.8143878 Cnidaria 6073 Cnidaria other_Eukaryota 60.5 4.31e-7   NR XP_057316610.1 13093 g41009 i0 48.1 1.5978835978836 52 27 27.5 0 533 378 261 312 XP_057316610.1 tRNA-splicing endonuclease subunit Sen54-like [Hydractinia symbiolongicarpus] diamond 906 60.8 0.995065789473684 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
33130206 33130206 PRJEB14175_P_NODE_106183_length_345_cov_1.619718_g103917_i0 PRJEB14175 106183 345 1.619718 5.5880271 Stylophora pistillata 50429 Cnidaria other_Eukaryota 76.3 1.95e-13   NR PFX20644.1 50429 g103917 i0 66.1 0.51304347826087 59 18 49.6 1 269 99 298 356 PFX20644.1 hypothetical protein AWC38_SpisGene14894 [Stylophora pistillata] diamond 177 76.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
33164739 33164739 PRJEB14175_P_NODE_162304_length_262_cov_7.641791_g160037_i0 PRJEB14175 162304 262 7.6417909999999996 20.02149242 Orbicella faveolata 48498 Cnidaria other_Eukaryota 73.9 3.22e-13   NR XP_020625827.1 48498 g160037 i0 40.9 5.77099236641221 88 49 97.3 1 256 2 93 180 XP_020625827.1 tolloid-like protein 1 [Orbicella faveolata] diamond 1512 73.9 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);;