RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA454154" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 14 ✖

tax_clade 1

bioproject 1

  • PRJNA454154 · 14 ✖

analysis 1

  • diamond · 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
4268996 4268996 PRJNA454154_S_NODE_144_length_254_cov_3.953917_g141_i0 PRJNA454154 144 254 3.953917 10.04294918 Metazoa 33208 Mollusca Mollusca 94.7 2.13e-23   NR CAL1530465.1 6523 g141 i0 92.2 21.0826771653543 51 4 60.2 0 3 155 28 78 CAL1530465.1 unnamed protein product, partial [Lymnaea stagnalis] diamond 5355 94.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lymnaeidae Lymnaea Lymnaea stagnalis
8095071 8095071 PRJNA454154_S_NODE_247_length_209_cov_3.889535_g244_i0 PRJNA454154 247 209 3.889535 8.12912815 Thripidae 45053 Arthropoda Arthropoda 105 2.22e-25   NR XP_026293202.1 133901 g244 i0 69.6 2.97129186602871 69 21 99 0 207 1 236 304 XP_026293202.1 annexin B11 isoform X2 [Frankliniella occidentalis] diamond 621 105 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Frankliniella Frankliniella occidentalis
26949485 26949485 PRJNA454154_S_NODE_442_length_177_cov_1.807143_g439_i0 PRJNA454154 442 177 1.807143 3.19864311 Tigriopus californicus 6832 Arthropoda Arthropoda 63.9 1.01e-11   NR TRY61806.1 6832 g439 i0 48.2 1.79661016949153 56 29 94.9 0 8 175 11 66 TRY61806.1 hypothetical protein TCAL_17220 [Tigriopus californicus] diamond 318 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
27424015 27424015 PRJNA454154_S_NODE_663_length_152_cov_1.000000_g660_i0 PRJNA454154 663 152 1 1.52 Nymphon striatum 424472 Arthropoda Arthropoda 47.8 1.81e-4   NR KAG1668330.1 424472 g660 i0 51.5 0.651315789473684 33 16 65.1 0 3 101 298 330 KAG1668330.1 Actin-related protein 2/3 complex subunit 1A [Nymphon striatum] diamond 99 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Pycnogonida Pantopoda Nymphonidae Nymphon Nymphon striatum
28260725 28260725 PRJNA454154_S_NODE_646_length_153_cov_1.551724_g643_i0 PRJNA454154 646 153 1.551724 2.37413772 Opisthokonta 33154 Mollusca Mollusca 61.2 1.98e-9   NR KAK3592743.1 2493646 g643 i0 63.8 9.27450980392157 47 17 92.2 0 142 2 200 246 KAK3592743.1 hypothetical protein CHS0354_016499 [Potamilus streckersoni] diamond 1419 61.6 0.993506493506494 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Unionida Unionidae Potamilus Potamilus streckersoni
28655251 28655251 PRJNA454154_S_NODE_287_length_198_cov_8.565217_g284_i0 PRJNA454154 287 198 8.565217 16.95912966 Oscarella lobularis 121494 Porifera other_Eukaryota 85.9 8.62e-20   NR XP_065840722.1 121494 g284 i0 84.1 5.24242424242424 44 7 66.7 0 3 134 72 115 XP_065840722.1 large ribosomal subunit protein eL33-like [Oscarella lobularis] diamond 1038 85.9 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
29555265 29555265 PRJNA454154_S_NODE_150_length_251_cov_4.542056_g147_i0 PRJNA454154 150 251 4.542056 11.40056056 Metazoa 33208 Annelida Annelida 79.3 6.9e-17   NR ABW23182.1 6344 g147 i0 78.7 5.05577689243028 47 10 56.2 0 5 145 70 116 ABW23182.1 ribosomal protein rpl27a, partial [Arenicola marina] diamond 1269 79.7 0.994981179422836 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Arenicolidae Arenicola Arenicola marina
30455633 30455633 PRJNA454154_S_NODE_493_length_169_cov_4.825758_g490_i0 PRJNA454154 493 169 4.825758 8.15553102 Dirofilaria immitis 6287 Nematoda Nematoda 53.9 7e-7   NR MCP9259222.1 6287 g490 i0 61 0.727810650887574 41 16 72.8 0 156 34 100 140 MCP9259222.1 putative serine acetyltransferase [Dirofilaria immitis] diamond 123 53.9 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Onchocercidae Dirofilaria Dirofilaria immitis
30549980 30549980 PRJNA454154_S_NODE_273_length_202_cov_2.981818_g270_i0 PRJNA454154 273 202 2.981818 6.02327236 Dinothrombium tinctorium 1965070 Arthropoda Arthropoda 51.6 2.52e-6   NR RWS01562.1 1965070 g270 i0 65 1.76732673267327 40 11 55 1 197 87 34 73 RWS01562.1 ribosomal protein LP1-like protein [Dinothrombium tinctorium] diamond 357 51.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombidiidae Dinothrombium Dinothrombium tinctorium
30882173 30882173 PRJNA454154_S_NODE_454_length_175_cov_2.550725_g451_i0 PRJNA454154 454 175 2.550725 4.46376875 Opisthokonta 33154 Chordata Chordata 52.4 5.96e-6   NR XP_059810455.1 79690 g451 i0 56.4 1.88571428571429 39 14 66.9 1 174 58 428 463 XP_059810455.1 adenylyl cyclase-associated protein 1 [Hypanus sabinus] diamond 330 52.4 1 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Myliobatiformes Dasyatidae Hypanus Hypanus sabinus
32115636 32115636 PRJNA454154_S_NODE_98_length_286_cov_2.763052_g95_i0 PRJNA454154 98 286 2.763052 7.90232872 Metazoa 33208 Rotifera other_Eukaryota 99.4 2.1e-24   NR RNA36257.1 10195 g95 i0 78.6 6.46153846153846 56 12 58.7 0 283 116 75 130 RNA36257.1 40S ribosomal S15Aa [Brachionus plicatilis] diamond 1848 99.4 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Brachionidae Brachionus Brachionus plicatilis
32147199 32147199 PRJNA454154_S_NODE_118_length_268_cov_2.666667_g115_i0 PRJNA454154 118 268 2.666667 7.14666756 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 103 9.26e-26   NR XP_039269693.1 7725 g115 i0 71.4 7.80223880597015 70 20 78.4 0 2 211 96 165 XP_039269693.1 60S ribosomal protein L12-like [Styela clava] diamond 2091 103 1 Eukaryota Opisthokonta Metazoa Chordata Ascidiacea Stolidobranchia Styelidae Styela Styela clava
32289527 32289527 PRJNA454154_S_NODE_179_length_237_cov_3.160000_g176_i0 PRJNA454154 179 237 3.16 7.4892 Ptychodera flava 63121 Hemichordata other_Eukaryota 74.7 9.92e-15   NR XP_070568554.1 63121 g176 i0 68.3 2.35443037974684 63 20 79.7 0 6 194 56 118 XP_070568554.1 large ribosomal subunit protein eL24-like [Ptychodera flava] diamond 558 74.7 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
32794033 32794033 PRJNA454154_S_NODE_300_length_196_cov_9.805031_g297_i0 PRJNA454154 300 196 9.805031 19.21786076 Ptychodera flava 63121 Hemichordata other_Eukaryota 83.2 1.76e-18   NR XP_070580680.1 63121 g297 i0 54.5 4.05612244897959 66 27 98 2 5 196 73 137 XP_070580680.1 lipopolysaccharide-induced tumor necrosis factor-alpha factor homolog [Ptychodera flava] diamond 795 83.2 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava

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