RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA1146366" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1146366 · 15 ✖

analysis 1

  • diamond · 15 ✖
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
290314 290314 PRJNA1146366_S_NODE_801_length_342_cov_13.111524_g798_i0 PRJNA1146366 801 342 13.111524 44.84141208 Hydra vulgaris 6087 Cnidaria other_Eukaryota 166 4.54e-51   NR XP_002164628.1 6087 g798 i0 85.9 0.807017543859649 92 13 80.7 0 293 18 1 92 XP_002164628.1 large ribosomal subunit protein eL43 isoform X1 [Hydra vulgaris] diamond 276 166 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
1564933 1564933 PRJNA1146366_S_NODE_322_length_431_cov_3.494413_g319_i0 PRJNA1146366 322 431 3.494413 15.06092003 Actinostola sp. cb2 3060491 Cnidaria other_Eukaryota 85.5 1.32e-18   NR KAK3742108.1 3060491 g319 i0 56.8 1.53828306264501 74 30 50.1 1 102 317 24 97 KAK3742108.1 hypothetical protein QZH41_020264 [Actinostola sp. cb2023] diamond 663 85.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actinostolidae Actinostola Actinostola sp. cb2023
19416384 19416384 PRJNA1146366_S_NODE_396_length_408_cov_11.465672_g393_i0 PRJNA1146366 396 408 11.465672 46.77994176 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 81.3 4.81e-17   NR XP_057302225.1 13093 g393 i0 45.4 0.713235294117647 97 44 64.7 3 315 52 1 97 XP_057302225.1 U8-theraphotoxin-Hhn1c 3-like [Hydractinia symbiolongicarpus] diamond 291 81.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
24516211 24516211 PRJNA1146366_S_NODE_1620_length_279_cov_2.766990_g1617_i0 PRJNA1146366 1620 279 2.76699 7.7199021 Metazoa 33208 Cnidaria other_Eukaryota 94.7 1.8299999999999994e-23   NR CAB3982470.1 317549 g1617 i0 80.7 8.62365591397849 57 11 61.3 0 88 258 1 57 CAB3982470.1 60S ribosomal L29 [Paramuricea clavata] diamond 2406 95.5 0.991623036649215 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea clavata
26721957 26721957 PRJNA1146366_S_NODE_1961_length_262_cov_2.724868_g1958_i0 PRJNA1146366 1961 262 2.724868 7.13915416 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 118 1.11e-30   NR XP_066913556.1 252671 g1958 i0 71.1 1.03053435114504 90 23 99.6 1 2 262 164 253 XP_066913556.1 uncharacterized protein [Clytia hemisphaerica] diamond 270 118 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
27165248 27165248 PRJNA1146366_S_NODE_1382_length_294_cov_1.058824_g1379_i0 PRJNA1146366 1382 294 1.058824 3.11294256 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 52.4 1.88e-5   NR XP_066932640.1 252671 g1379 i0 48.1 0.551020408163265 54 28 55.1 0 292 131 183 236 XP_066932640.1 uncharacterized protein [Clytia hemisphaerica] diamond 162 52.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
27260320 27260320 PRJNA1146366_S_NODE_1003_length_324_cov_3.984064_g1000_i0 PRJNA1146366 1003 324 3.984064 12.90836736 Actinostola sp. cb2 3060491 Cnidaria other_Eukaryota 65.9 2.49e-11   NR KAK3730808.1 3060491 g1000 i0 50 0.611111111111111 66 33 61.1 0 302 105 39 104 KAK3730808.1 hypothetical protein QZH41_001165 [Actinostola sp. cb2023] diamond 198 65.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actinostolidae Actinostola Actinostola sp. cb2023
28365274 28365274 PRJNA1146366_S_NODE_466_length_393_cov_2.659375_g463_i0 PRJNA1146366 466 393 2.659375 10.45134375 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 56.2 2.35e-6   NR XP_066924927.1 252671 g463 i0 37.9 0.66412213740458 87 45 62.6 3 88 333 168 250 XP_066924927.1 uncharacterized protein [Clytia hemisphaerica] diamond 261 56.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
29722854 29722854 PRJNA1146366_S_NODE_2270_length_249_cov_0.886364_g2267_i0 PRJNA1146366 2270 249 0.886364 2.20704636 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 137 3.61e-37   NR XP_057314052.1 13093 g2267 i0 75.3 0.975903614457831 81 20 97.6 0 243 1 102 182 XP_057314052.1 uncharacterized protein LOC130655325 isoform X3 [Hydractinia symbiolongicarpus] diamond 243 137 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
30575862 30575862 PRJNA1146366_S_NODE_1993_length_260_cov_2.422460_g1990_i0 PRJNA1146366 1993 260 2.42246 6.298396 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 84.3 2.3e-18   NR XP_057307294.1 13093 g1990 i0 63.2 0.657692307692308 57 21 65.8 0 244 74 96 152 XP_057307294.1 28S ribosomal protein S6, mitochondrial-like [Hydractinia symbiolongicarpus] diamond 171 84.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
31176148 31176148 PRJNA1146366_S_NODE_835_length_339_cov_2.616541_g832_i0 PRJNA1146366 835 339 2.616541 8.87007399 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 204 2.13e-63   NR XP_066933110.1 252671 g832 i0 89.4 0.920353982300885 104 11 92 0 3 314 28 131 XP_066933110.1 ficolin-1-like [Clytia hemisphaerica] diamond 312 204 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
32304372 32304372 PRJNA1146366_S_NODE_1659_length_277_cov_2.676471_g1656_i0 PRJNA1146366 1659 277 2.676471 7.41382467 Anthozoa 6101 Cnidaria other_Eukaryota 72.4 2.03e-14   NR CAH3174559.1 104178 g1656 i0 44.9 2.97833935018051 69 38 74.7 0 277 71 6 74 CAH3174559.1 unnamed protein product [Porites evermanni] diamond 825 72.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Poritidae Porites Porites evermanni
32347131 32347131 PRJNA1146366_S_NODE_1379_length_294_cov_1.407240_g1376_i0 PRJNA1146366 1379 294 1.40724 4.1372856 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 90.5 1.19e-18   NR XP_057303236.1 13093 g1376 i0 43.2 2.69387755102041 88 48 88.8 2 265 5 19163 19249 XP_057303236.1 uncharacterized protein LOC130640729 isoform X3 [Hydractinia symbiolongicarpus] diamond 792 90.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
32442069 32442069 PRJNA1146366_S_NODE_1499_length_287_cov_1.364486_g1496_i0 PRJNA1146366 1499 287 1.364486 3.91607482 Hydra vulgaris 6087 Cnidaria other_Eukaryota 62.4 2.83e-9   NR XP_012562072.2 6087 g1496 i0 82.1 0.773519163763066 39 7 40.8 0 169 285 3 41 XP_012562072.2 cysteinyl leukotriene receptor 1 [Hydra vulgaris] diamond 222 62.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
32725803 32725803 PRJNA1146366_S_NODE_2340_length_246_cov_1.445087_g2337_i0 PRJNA1146366 2340 246 1.445087 3.55491402 Xenia sp. Carnegie-2 86540 Cnidaria other_Eukaryota 40.8 0.0367   NR XP_046839560.1 2897299 g2337 i0 39.6 0.585365853658537 48 29 58.5 0 6 149 36 83 XP_046839560.1 cytochrome c oxidase subunit 7A-related protein, mitochondrial-like [Xenia sp. Carnegie-2017] diamond 144 40.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Xeniidae Xenia Xenia sp. Carnegie-2017

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