RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA734313" 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

  • PRJNA734313 · 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
22394215 22394215 PRJNA734313_S_NODE_10338_length_292_cov_1.232653_g10225_i0 PRJNA734313 10338 292 1.232653 3.59934676 root 1 Root_unresolved Root_unresolved 106 9.19e-27   NR EGT45232.1 135651 g10225 i0 75 7.92123287671233 64 16 65.8 0 291 100 108 171 EGT45232.1 CBN-CYN-7 protein [Caenorhabditis brenneri] diamond 2313 106 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis brenneri
26767579 26767579 PRJNA734313_S_NODE_7921_length_329_cov_6.914894_g7808_i0 PRJNA734313 7921 329 6.914894 22.75000126 Chelonoidis abingdonii 106734 Chordata Chordata 43.9 0.0405   NR XP_032649260.1 106734 g7808 i0 38.7 0.683890577507599 75 40 62.9 1 33 239 1266 1340 XP_032649260.1 zinc finger protein 804B isoform X1 [Chelonoidis abingdonii] diamond 225 43.9 1 Eukaryota Opisthokonta Metazoa Chordata   Testudines Testudinidae Chelonoidis Chelonoidis abingdonii
26799168 26799168 PRJNA734313_S_NODE_25521_length_184_cov_0.956204_g25408_i0 PRJNA734313 25521 184 0.956204 1.75941536 Mirounga angustirostris 9716 Chordata Chordata 45.4 0.00192   NR XP_064426076.1 9716 g25408 i0 67.7 0.505434782608696 31 10 50.5 0 93 1 30 60 XP_064426076.1 protein ENTREP2 isoform X1 [Mirounga angustirostris] diamond 93 45.4 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Carnivora Phocidae Mirounga Mirounga angustirostris
27062588 27062588 PRJNA734313_S_NODE_16482_length_231_cov_1.663043_g16369_i0 PRJNA734313 16482 231 1.663043 3.84162933 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 53.9 3.65e-6   NR ARX80207.1 35630 g16369 i0 46.2 2.06493506493507 52 28 67.5 0 8 163 728 779 ARX80207.1 notch-a [Hydractinia echinata] diamond 477 53.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia echinata
27084049 27084049 PRJNA734313_S_NODE_17962_length_221_cov_1.172414_g17849_i0 PRJNA734313 17962 221 1.172414 2.59103494 Leptotrombidium deliense 299467 Arthropoda Arthropoda 57 2.59e-7   NR RWS31390.1 299467 g17849 i0 45 0.81447963800905 60 31 78.7 1 219 46 364 423 RWS31390.1 uncharacterized protein B4U80_02538 [Leptotrombidium deliense] diamond 180 57 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombiculidae Leptotrombidium Leptotrombidium deliense
27210250 27210250 PRJNA734313_S_NODE_9802_length_300_cov_1.584980_g9689_i0 PRJNA734313 9802 300 1.58498 4.75494 Patella caerulea 87958 Mollusca Mollusca 56.2 2.12e-7   NR KAK6168675.1 87958 g9689 i0 39.6 1.74 91 51 90 2 278 9 34 121 KAK6168675.1 hypothetical protein SNE40_019866 [Patella caerulea] diamond 522 56.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella caerulea
27347273 27347273 PRJNA734313_S_NODE_26523_length_180_cov_1.150376_g26410_i0 PRJNA734313 26523 180 1.150376 2.0706768 Araneidae 6913 Arthropoda Arthropoda 90.9 7.61e-20   NR XP_055941438.1 94029 g26410 i0 62.7 3.93333333333333 59 22 98.3 0 2 178 300 358 XP_055941438.1 protein SSUH2 homolog [Argiope bruennichi] diamond 708 90.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Argiope Argiope bruennichi
28094713 28094713 PRJNA734313_S_NODE_8965_length_313_cov_2.187970_g8852_i0 PRJNA734313 8965 313 2.18797 6.8483461 Leptopilina boulardi 63433 Arthropoda Arthropoda 55.8 2.13e-6   NR XP_051173332.1 63433 g8852 i0 29.7 0.87220447284345 91 55 87.2 2 312 40 38 119 XP_051173332.1 ankyrin-1-like [Leptopilina boulardi] diamond 273 55.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Figitidae Leptopilina Leptopilina boulardi
29178585 29178585 PRJNA734313_S_NODE_16589_length_230_cov_2.229508_g16476_i0 PRJNA734313 16589 230 2.229508 5.1278684 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 53.9 2.01e-7   NR KAK2720597.1 6661 g16476 i0 37.3 2.60869565217391 67 42 87.4 0 230 30 10 76 KAK2720597.1 hypothetical protein QYM36_004472 [Artemia franciscana] diamond 600 54.3 0.992633517495396 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
29357721 29357721 PRJNA734313_S_NODE_32549_length_163_cov_1.318966_g32436_i0 PRJNA734313 32549 163 1.318966 2.14991458 Porites evermanni 104178 Cnidaria other_Eukaryota 56.2 2.1e-7   NR CAH3029810.1 104178 g32436 i0 72.2 0.662576687116564 36 9 64.4 1 161 57 397 432 CAH3029810.1 unnamed protein product [Porites evermanni] diamond 108 56.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Poritidae Porites Porites evermanni
29452047 29452047 PRJNA734313_S_NODE_10650_length_288_cov_1.481328_g10537_i0 PRJNA734313 10650 288 1.481328 4.26622464 Argiope bruennichi 94029 Arthropoda Arthropoda 117 2.9299999999999993e-28   NR XP_055928046.1 94029 g10537 i0 52.2 5.76041666666667 92 44 95.8 0 286 11 485 576 XP_055928046.1 macrophage mannose receptor 1-like [Argiope bruennichi] diamond 1659 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Argiope Argiope bruennichi
29494183 29494183 PRJNA734313_S_NODE_20370_length_207_cov_0.956250_g20257_i0 PRJNA734313 20370 207 0.95625 1.9794375 Metazoa 33208 Arthropoda Arthropoda 62 3.85e-9   NR CAD7232757.1 163714 g20257 i0 46.4 2 69 36 98.6 1 4 207 55 123 CAD7232757.1 unnamed protein product [Cyprideis torosa] diamond 414 62.4 0.993589743589744 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cytherideidae Cyprideis Cyprideis torosa
29515324 29515324 PRJNA734313_S_NODE_22070_length_198_cov_1.927152_g21957_i0 PRJNA734313 22070 198 1.927152 3.81576096 Ptychodera flava 63121 Hemichordata other_Eukaryota 60.5 1.19e-8   NR XP_070532596.1 63121 g21957 i0 50 1.45454545454545 48 24 72.7 0 1 144 122 169 XP_070532596.1 uncharacterized abhydrolase domain-containing protein DDB_G0269086-like isoform X5 [Ptychodera flava] diamond 288 60.5 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
29704549 29704549 PRJNA734313_S_NODE_22830_length_195_cov_1.033784_g22717_i0 PRJNA734313 22830 195 1.033784 2.0158788 Brachionus calyciflorus 104777 Rotifera other_Eukaryota 42 0.0374   NR CAF0712133.1 104777 g22717 i0 40.9 0.676923076923077 44 23 66.2 2 138 10 220 261 CAF0712133.1 unnamed protein product [Brachionus calyciflorus] diamond 132 42 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Brachionidae Brachionus Brachionus calyciflorus
29989242 29989242 PRJNA734313_S_NODE_19951_length_209_cov_1.259259_g19838_i0 PRJNA734313 19951 209 1.259259 2.63185131 Capra hircus 9925 Chordata Chordata 55.8 5.73e-7   NR XDB48057.1 9925 g19838 i0 65.2 0.990430622009569 69 23 97.6 1 4 207 717 785 XDB48057.1 hypothetical protein ABFV05_001673 [Capra hircus] diamond 207 55.8 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Bovidae Capra Capra hircus
30463573 30463573 PRJNA734313_S_NODE_3233_length_454_cov_12.825553_g3125_i0 PRJNA734313 3233 454 12.825553 58.22801062 Uroleucon formosanum 796250 Arthropoda Arthropoda 47.4 0.00703   NR KAL4119326.1 796250 g3125 i0 29.4 0.786343612334802 119 72 73.3 5 103 435 3 117 KAL4119326.1 hypothetical protein QTP88_012147 [Uroleucon formosanum] diamond 357 47.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Uroleucon Uroleucon formosanum
30726084 30726084 PRJNA734313_S_NODE_35174_length_159_cov_2.276786_g35061_i0 PRJNA734313 35174 159 2.276786 3.62008974 root 1 Root_unresolved Root_unresolved 54.7 7.07e-7   NR KAJ8321611.1 220873 g35061 i0 48.1 3.69811320754717 52 27 98.1 0 2 157 219 270 KAJ8321611.1 hypothetical protein KUTeg_000082 [Tegillarca granosa] diamond 588 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Arcoida Arcidae Tegillarca Tegillarca granosa
31000355 31000355 PRJNA734313_S_NODE_16554_length_230_cov_7.442623_g16441_i0 PRJNA734313 16554 230 7.442623 17.1180329 Paragonimus westermani 34504 Platyhelminthes Platyhelminthes 42.4 0.0417   NR KAA3676573.1 34504 g16441 i0 41.1 0.730434782608696 56 31 73 1 174 7 276 329 KAA3676573.1 solute carrier family 39 (zinc transporter), member 11 [Paragonimus westermani] diamond 168 42.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Troglotrematidae Paragonimus Paragonimus westermani
31537946 31537946 PRJNA734313_S_NODE_8856_length_314_cov_13.588015_g8743_i0 PRJNA734313 8856 314 13.588015 42.6663671 Rangifer tarandus platyrhynchus 3082113 Chordata Chordata 57.4 6.13e-7   NR CAI9150999.1 3082113 g8743 i0 96.8 0.296178343949045 31 1 29.6 0 312 220 499 529 CAI9150999.1 unnamed protein product, partial [Rangifer tarandus platyrhynchus] diamond 93 57.4 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Cervidae Rangifer Rangifer tarandus
32707612 32707612 PRJNA734313_S_NODE_34900_length_160_cov_0.902655_g34787_i0 PRJNA734313 34900 160 0.902655 1.444248 Didymodactylos carnosus 1234261 Rotifera other_Eukaryota 90.5 3.3700000000000003e-22   NR CAF1621987.1 1234261 g34787 i0 90.4 2.925 52 5 97.5 0 3 158 25 76 CAF1621987.1 unnamed protein product, partial [Didymodactylos carnosus] diamond 468 90.5 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Didymodactylos Didymodactylos carnosus

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