RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA306153" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 20 ✖

tax_clade 1

bioproject 1

  • PRJNA306153 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
1651153 1651153 PRJNA306153_S_NODE_2182_length_169_cov_3.121429_g2169_i0 PRJNA306153 2182 169 3.121429 5.27521501 Anthozoa 6101 Cnidaria other_Eukaryota 75.9 6.63e-16   NR XP_015757388.1 70779 g2169 i0 93.2 1.56213017751479 44 3 78.1 0 134 3 5 48 XP_015757388.1 PREDICTED: 60S ribosomal protein L30-like [Acropora digitifera] diamond 264 75.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
2927031 2927031 PRJNA306153_S_NODE_2283_length_165_cov_3.522059_g2270_i0 PRJNA306153 2283 165 3.522059 5.81139735 Metazoa 33208 Chordata Chordata 82 2.1e-18   NR XP_039271593.1 7725 g2270 i0 69.8 5.65454545454545 53 16 96.4 0 161 3 13 65 XP_039271593.1 40S ribosomal protein S20-like [Styela clava] diamond 933 82 1 Eukaryota Opisthokonta Metazoa Chordata Ascidiacea Stolidobranchia Styelidae Styela Styela clava
6754006 6754006 PRJNA306153_S_NODE_206_length_459_cov_5.425581_g194_i0 PRJNA306153 206 459 5.425581 24.90341679 Metazoa 33208 Arthropoda Arthropoda 247 1.08e-72   NR KAH0812308.1 7067 g194 i0 73.7 68.5490196078431 152 40 99.3 0 2 457 39 190 KAH0812308.1 hypothetical protein GEV33_010484 [Tenebrio molitor] diamond 31464 249 0.991967871485944 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
8714900 8714900 PRJNA306153_S_NODE_747_length_276_cov_3.574899_g734_i0 PRJNA306153 747 276 3.574899 9.86672124 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 144 9.629999999999997e-42   NR KAA0196388.1 27845 g734 i0 75.6 11.7934782608696 90 22 97.8 0 2 271 57 146 KAA0196388.1 Ribosomal protein L11 [Fasciolopsis buskii] diamond 3255 144 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Fasciolidae Fasciolopsis Fasciolopsis buskii
10580299 10580299 PRJNA306153_S_NODE_389_length_360_cov_3.389728_g376_i0 PRJNA306153 389 360 3.389728 12.203020799999999 Opisthokonta 33154 Arthropoda Arthropoda 155 5.88e-46   NR NP_001037209.1 7091 g376 i0 64.1 46.9666666666667 117 40 95.8 1 359 15 20 136 NP_001037209.1 ribosomal protein S15 [Bombyx mori] diamond 16908 156 0.993589743589744 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
13130168 13130168 PRJNA306153_S_NODE_1991_length_176_cov_3.142857_g1978_i0 PRJNA306153 1991 176 3.142857 5.53142832 Patiria miniata 46514 Echinodermata other_Eukaryota 108 1.46e-27   NR XP_038051326.1 46514 g1978 i0 82.8 0.988636363636364 58 10 98.9 0 3 176 186 243 XP_038051326.1 60S ribosomal protein L7-like [Patiria miniata] diamond 174 108 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
27422100 27422100 PRJNA306153_S_NODE_823_length_263_cov_5.717949_g810_i0 PRJNA306153 823 263 5.717949 15.03820587 Rotaria sp. Silwood2 2762512 Rotifera other_Eukaryota 105 3.6300000000000006e-27   NR CAF3440507.1 2762512 g810 i0 73.5 0.775665399239544 68 18 77.6 0 259 56 1 68 CAF3440507.1 unnamed protein product [Rotaria sp. Silwood2] diamond 204 105 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria sp. Silwood2
27439765 27439765 PRJNA306153_S_NODE_2663_length_154_cov_3.208000_g2650_i0 PRJNA306153 2663 154 3.208 4.94032 Opisthokonta 33154 Chordata Chordata 45.1 0.00149   NR XP_069463138.1 8296 g2650 i0 87 4.03246753246753 23 3 44.8 0 3 71 217 239 XP_069463138.1 large ribosomal subunit protein eL18 [Ambystoma mexicanum] diamond 621 45.1 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Caudata Ambystomatidae Ambystoma Ambystoma mexicanum
28905655 28905655 PRJNA306153_S_NODE_2148_length_170_cov_2.673759_g2135_i0 PRJNA306153 2148 170 2.673759 4.5453903 Rotaria sordida 392033 Rotifera other_Eukaryota 57.8 3.07e-9   NR CAF0795258.1 392033 g2135 i0 64.3 0.988235294117647 56 18 95.3 2 166 5 25 80 CAF0795258.1 unnamed protein product [Rotaria sordida] diamond 168 57.8 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria sordida
29127152 29127152 PRJNA306153_S_NODE_1649_length_191_cov_3.277778_g1636_i0 PRJNA306153 1649 191 3.277778 6.26055598 Elysia marginata 1093978 Mollusca Mollusca 107 5.14e-29   NR GFS19501.1 1093978 g1636 i0 77.8 5.93717277486911 54 12 84.8 0 185 24 1 54 GFS19501.1 40S ribosomal protein S29 [Elysia marginata] diamond 1134 107 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Plakobranchidae Elysia Elysia marginata
29158643 29158643 PRJNA306153_S_NODE_1669_length_190_cov_2.422360_g1656_i0 PRJNA306153 1669 190 2.42236 4.602484 Anneissia japonica 1529436 Echinodermata other_Eukaryota 101 1.57e-24   NR XP_033118288.1 1529436 g1656 i0 74.2 0.978947368421053 62 16 97.9 0 188 3 73 134 XP_033118288.1 60S ribosomal protein L7-like isoform X2 [Anneissia japonica] diamond 186 101 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
29744107 29744107 PRJNA306153_S_NODE_1390_length_205_cov_2.125000_g1377_i0 PRJNA306153 1390 205 2.125 4.35625 Ixodes 6944 Arthropoda Arthropoda 61.2 6.72e-9   NR CAL6250827.1 29930 g1377 i0 41.5 5.70731707317073 65 36 93.7 2 10 201 320 383 CAL6250827.1 unnamed protein product, partial [Ixodes pacificus] diamond 1170 61.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes pacificus
30692053 30692053 PRJNA306153_S_NODE_1493_length_199_cov_4.400000_g1480_i0 PRJNA306153 1493 199 4.4 8.756 Opisthokonta 33154 Cnidaria other_Eukaryota 106 1.13e-26   NR XP_029195562.1 45264 g1480 i0 69.2 9.79899497487437 65 20 98 0 3 197 33 97 XP_029195562.1 40S ribosomal protein S5 isoform X1 [Acropora millepora] diamond 1950 107 0.990654205607477 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
30881637 30881637 PRJNA306153_S_NODE_1434_length_202_cov_5.028902_g1421_i0 PRJNA306153 1434 202 5.028902 10.15838204 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 90.1 5.74e-22   NR XHB13796.1 34648 g1421 i0 74.1 4.63366336633663 58 15 86.1 0 3 176 6 63 XHB13796.1 putative venom peptide 511 [Mesobuthus eupeus] diamond 936 90.9 0.991199119911991 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Mesobuthus Mesobuthus eupeus
31640395 31640395 PRJNA306153_S_NODE_556_length_310_cov_4.914591_g543_i0 PRJNA306153 556 310 4.914591 15.2352321 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 129 1.87e-34   NR CAH0775212.1 7038 g543 i0 68.1 11.0612903225806 94 30 91 0 1 282 167 260 CAH0775212.1 unnamed protein product [Bemisia tabaci] diamond 3429 129 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
31717759 31717759 PRJNA306153_S_NODE_917_length_249_cov_3.463636_g904_i0 PRJNA306153 917 249 3.463636 8.62445364 Sycon ciliatum 27933 Porifera other_Eukaryota 124 1.05e-32   NR XP_065183035.1 27933 g904 i0 72 4.93975903614458 82 23 98.8 0 248 3 72 153 XP_065183035.1 small ribosomal subunit protein uS5-like [Sycon ciliatum] diamond 1230 124 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
31925076 31925076 PRJNA306153_S_NODE_677_length_288_cov_5.277992_g664_i0 PRJNA306153 677 288 5.277992 15.20061696 Arachnida 6854 Arthropoda Arthropoda 141 5.17e-40   NR RWS30488.1 299467 g664 i0 67.7 6 96 31 100 0 288 1 103 198 RWS30488.1 ribosomal protein rpl23a-like protein [Leptotrombidium deliense] diamond 1728 142 0.992957746478873 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombiculidae Leptotrombidium Leptotrombidium deliense
32115106 32115106 PRJNA306153_S_NODE_1738_length_187_cov_4.544304_g1725_i0 PRJNA306153 1738 187 4.544304 8.49784848 Arthropoda 6656 Arthropoda Arthropoda 103 6.5e-26   NR CAD7224002.1 163714 g1725 i0 77 5.8716577540107 61 14 97.9 0 3 185 15 75 CAD7224002.1 unnamed protein product [Cyprideis torosa] diamond 1098 103 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cytherideidae Cyprideis Cyprideis torosa
32319205 32319205 PRJNA306153_S_NODE_2039_length_174_cov_4.668966_g2026_i0 PRJNA306153 2039 174 4.668966 8.12400084 Meloidogyne graminicola 189291 Nematoda Nematoda 55.8 2.95e-7   NR AVZ46778.1 189291 g2026 i0 54.4 0.982758620689655 57 26 98.3 0 173 3 172 228 AVZ46778.1 hypothetical protein [Meloidogyne graminicola] diamond 171 55.8 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Meloidogynidae Meloidogyne Meloidogyne graminicola
32666381 32666381 PRJNA306153_S_NODE_2700_length_153_cov_3.072581_g2687_i0 PRJNA306153 2700 153 3.072581 4.70104893 Hermetia illucens 343691 Arthropoda Arthropoda 79 4.13e-17   NR XP_037917729.1 343691 g2687 i0 77.6 5.7843137254902 49 11 96.1 0 5 151 8 56 XP_037917729.1 60S ribosomal protein L27 [Hermetia illucens] diamond 885 79 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Stratiomyidae Hermetia Hermetia illucens

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