RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA596870" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA596870 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
17146071 17146071 PRJNA596870_P_NODE_27514_length_258_cov_1.610811_g27381_i0 PRJNA596870 27514 258 1.610811 4.15589238 Dendronephthya gigantea 151771 Cnidaria other_Eukaryota 88.6 3.41e-18   NR XP_028406015.1 151771 g27381 i0 52.9 1.94186046511628 85 40 98.8 0 4 258 1 85 XP_028406015.1 glutamate--cysteine ligase catalytic subunit-like [Dendronephthya gigantea] diamond 501 88.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea
27617030 27617030 PRJNA596870_P_NODE_31464_length_249_cov_0.875000_g31331_i0 PRJNA596870 31464 249 0.875 2.17875 Dendronephthya gigantea 151771 Cnidaria other_Eukaryota 50.4 7.85e-5   NR XP_028409898.1 151771 g31331 i0 39.5 0.975903614457831 81 47 95.2 2 242 6 1877 1957 XP_028409898.1 uncharacterized protein LOC114532567 [Dendronephthya gigantea] diamond 243 50.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea
28722099 28722099 PRJNA596870_P_NODE_30247_length_250_cov_0.870056_g30114_i0 PRJNA596870 30247 250 0.870056 2.17514 Porites evermanni 104178 Cnidaria other_Eukaryota 83.2 2.39e-16   NR CAH3020291.1 104178 g30114 i0 54.5 0.924 77 35 92.4 0 231 1 222 298 CAH3020291.1 unnamed protein product [Porites evermanni] diamond 231 83.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Poritidae Porites Porites evermanni
29290280 29290280 PRJNA596870_P_NODE_32049_length_249_cov_0.875000_g31916_i0 PRJNA596870 32049 249 0.875 2.17875 Paramuricea clavata 317549 Cnidaria other_Eukaryota 72.8 8.72e-13   NR CAB3996609.1 317549 g31916 i0 44.4 4.51807228915663 81 45 97.6 0 2 244 216 296 CAB3996609.1 Hypothetical predicted protein [Paramuricea clavata] diamond 1125 72.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea clavata
29447967 29447967 PRJNA596870_P_NODE_31010_length_250_cov_0.870056_g30877_i0 PRJNA596870 31010 250 0.870056 2.17514 Hydra vulgaris 6087 Cnidaria other_Eukaryota 129 1.7099999999999998e-35   NR XP_065643016.1 6087 g30877 i0 72.3 16.92 83 23 99.6 0 250 2 30 112 XP_065643016.1 small ribosomal subunit protein uS7 isoform X2 [Hydra vulgaris] diamond 4230 129 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
29542824 29542824 PRJNA596870_P_NODE_39610_length_241_cov_0.916667_g39477_i0 PRJNA596870 39610 241 0.916667 2.20916747 Hydra vulgaris 6087 Cnidaria other_Eukaryota 78.6 8.7e-15   NR XP_065649284.1 6087 g39477 i0 50 1.91701244813278 76 37 94.6 1 230 3 172 246 XP_065649284.1 uncharacterized protein LOC136078150 [Hydra vulgaris] diamond 462 78.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
30504005 30504005 PRJNA596870_P_NODE_32733_length_248_cov_0.880000_g32600_i0 PRJNA596870 32733 248 0.88 2.1824 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 85.9 9.82e-18   NR XP_057312634.1 13093 g32600 i0 48.1 1.97177419354839 81 42 98 0 1 243 105 185 XP_057312634.1 eukaryotic translation initiation factor 3 subunit H-like [Hydractinia symbiolongicarpus] diamond 489 86.3 0.995365005793743 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
31452207 31452207 PRJNA596870_P_NODE_38696_length_242_cov_0.911243_g38563_i0 PRJNA596870 38696 242 0.911243 2.20520806 Opisthokonta 33154 Cnidaria other_Eukaryota 100 1.97e-24   NR XP_020630702.1 48498 g38563 i0 62.5 19.7355371900826 80 29 99.2 1 241 2 21 99 XP_020630702.1 40S ribosomal protein S7-like [Orbicella faveolata] diamond 4776 101 0.99009900990099 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);;