RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJDB12134" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJDB12134 · 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
14028032 14028032 PRJDB12134_P_NODE_10012_length_289_cov_1.162037_g9877_i0 PRJDB12134 10012 289 1.162037 3.35828693 Homarus americanus 6706 Arthropoda Arthropoda 149 4.34e-44   NR KAG7167476.1 6706 g9877 i0 85.4 0.85121107266436 82 12 85.1 0 2 247 50 131 KAG7167476.1 60S ribosomal protein L27a-like, partial [Homarus americanus] diamond 246 149 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Nephropidae Homarus Homarus americanus
26937312 26937312 PRJDB12134_P_NODE_11502_length_266_cov_1.253886_g11367_i0 PRJDB12134 11502 266 1.253886 3.33533676 Stegodyphus dumicola 202533 Arthropoda Arthropoda 48.1 6.08e-4   NR XP_035219410.1 202533 g11367 i0 63.6 0.37218045112782 33 12 37.2 0 207 109 1 33 XP_035219410.1 endosome/lysosome-associated apoptosis and autophagy regulator family member 2-like [Stegodyphus dumicola] diamond 99 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus dumicola
27538027 27538027 PRJDB12134_P_NODE_6624_length_393_cov_1.290625_g6489_i0 PRJDB12134 6624 393 1.290625 5.07215625 Trinorchestia longiramus 1923959 Arthropoda Arthropoda 124 5.429999999999999e-31   NR KAF2367561.1 1923959 g6489 i0 58.7 1.6412213740458 104 42 78.6 1 49 357 257 360 KAF2367561.1 Reverse transcriptase domain [Trinorchestia longiramus] diamond 645 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Talitridae Trinorchestia Trinorchestia longiramus
27727740 27727740 PRJDB12134_P_NODE_8864_length_316_cov_1.901235_g8729_i0 PRJDB12134 8864 316 1.901235 6.0079026 Petrolisthes manimaculis 1843537 Arthropoda Arthropoda 62 1.42e-8   NR KAK4315231.1 1843537 g8729 i0 39.2 0.920886075949367 97 49 85.4 3 2 271 314 407 KAK4315231.1 hypothetical protein Pmani_013537 [Petrolisthes manimaculis] diamond 291 62 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Porcellanidae Petrolisthes Petrolisthes manimaculis
27790648 27790648 PRJDB12134_P_NODE_6584_length_395_cov_1.419255_g6449_i0 PRJDB12134 6584 395 1.419255 5.60605725 Petrolisthes cinctipes 88211 Arthropoda Arthropoda 120 1.9e-32   NR KAK3890218.1 88211 g6449 i0 61.1 0.721518987341772 95 37 72.2 0 394 110 24 118 KAK3890218.1 hypothetical protein Pcinc_005753 [Petrolisthes cinctipes] diamond 285 120 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Porcellanidae Petrolisthes Petrolisthes cinctipes
28011754 28011754 PRJDB12134_P_NODE_2865_length_661_cov_2.824830_g2739_i0 PRJDB12134 2865 661 2.82483 18.6721263 Chionoecetes opilio 41210 Arthropoda Arthropoda 46.6 0.0485   NR KAG0699337.1 41210 g2739 i0 39.7 0.354009077155825 78 33 30.4 3 102 302 446 520 KAG0699337.1 Solute carrier family 22 member 13 [Chionoecetes opilio] diamond 234 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Majidae Chionoecetes Chionoecetes opilio
28422194 28422194 PRJDB12134_P_NODE_11166_length_271_cov_1.666667_g11031_i0 PRJDB12134 11166 271 1.666667 4.51666757 Procambarus clarkii 6728 Arthropoda Arthropoda 53.1 1.16e-5   NR XP_069186597.1 6728 g11031 i0 75.8 0.365313653136531 33 8 36.5 0 99 1 543 575 XP_069186597.1 uncharacterized protein [Procambarus clarkii] diamond 99 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
29621331 29621331 PRJDB12134_P_NODE_10870_length_276_cov_1.221675_g10735_i0 PRJDB12134 10870 276 1.221675 3.371823 Trachymyrmex zeteki 64791 Arthropoda Arthropoda 48.5 3.89e-5   NR KYQ51146.1 64791 g10735 i0 70 0.793478260869565 40 12 43.5 0 201 82 1 40 KYQ51146.1 hypothetical protein ALC60_09794 [Trachymyrmex zeteki] diamond 219 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Mycetomoellerius Mycetomoellerius zeteki
29653059 29653059 PRJDB12134_P_NODE_8610_length_324_cov_2.167331_g8475_i0 PRJDB12134 8610 324 2.167331 7.02215244 Portunus trituberculatus 210409 Arthropoda Arthropoda 64.7 3.75e-10   NR MPC32819.1 210409 g8475 i0 50 0.555555555555556 60 30 55.6 0 141 320 47 106 MPC32819.1 hypothetical protein [Portunus trituberculatus] diamond 180 64.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus
30285542 30285542 PRJDB12134_P_NODE_10852_length_276_cov_1.458128_g10717_i0 PRJDB12134 10852 276 1.458128 4.02443328 Petrolisthes cinctipes 88211 Arthropoda Arthropoda 62 9.22e-9   NR KAK3890060.1 88211 g10717 i0 71.1 0.41304347826087 38 11 41.3 0 149 262 751 788 KAK3890060.1 hypothetical protein Pcinc_005975 [Petrolisthes cinctipes] diamond 114 62 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Porcellanidae Petrolisthes Petrolisthes cinctipes
30348872 30348872 PRJDB12134_P_NODE_13092_length_249_cov_0.880682_g12957_i0 PRJDB12134 13092 249 0.880682 2.19289818 Stegodyphus dumicola 202533 Arthropoda Arthropoda 73.6 5.66e-13   NR XP_035210635.1 202533 g12957 i0 44.4 0.867469879518072 72 40 86.7 0 217 2 668 739 XP_035210635.1 uncharacterized protein LOC118184981 [Stegodyphus dumicola] diamond 216 73.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus dumicola
30695805 30695805 PRJDB12134_P_NODE_5454_length_450_cov_1.490716_g5320_i0 PRJDB12134 5454 450 1.490716 6.708222 Eriocheir sinensis 95602 Arthropoda Arthropoda 139 1.67e-36   NR XP_050695649.1 95602 g5320 i0 49.3 1.97333333333333 148 75 98.7 0 450 7 224 371 XP_050695649.1 uncharacterized protein LOC126985138 [Eriocheir sinensis] diamond 888 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Varunidae Eriocheir Eriocheir sinensis
31992161 31992161 PRJDB12134_P_NODE_14258_length_242_cov_1.668639_g14123_i0 PRJDB12134 14258 242 1.668639 4.03810638 Petrolisthes cinctipes 88211 Arthropoda Arthropoda 57.4 2.55e-7   NR KAK3887192.1 88211 g14123 i0 67.3 0.607438016528926 49 10 60.7 2 232 86 177 219 KAK3887192.1 hypothetical protein Pcinc_008673 [Petrolisthes cinctipes] diamond 147 57.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Porcellanidae Petrolisthes Petrolisthes cinctipes
32467077 32467077 PRJDB12134_P_NODE_10159_length_287_cov_1.271028_g10024_i0 PRJDB12134 10159 287 1.271028 3.64785036 Portunus trituberculatus 210409 Arthropoda Arthropoda 62.4 4.02e-10   NR MPC31817.1 210409 g10024 i0 48.4 1.27526132404181 62 31 64.8 1 102 287 31 91 MPC31817.1 hypothetical protein [Portunus trituberculatus] diamond 366 62.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus
32813600 32813600 PRJDB12134_P_NODE_6620_length_393_cov_1.696875_g6485_i0 PRJDB12134 6620 393 1.696875 6.66871875 Petrolisthes cinctipes 88211 Arthropoda Arthropoda 62.8 2.08e-8   NR KAK3871028.1 88211 g6485 i0 60.6 4.33587786259542 71 27 53.4 1 212 3 933 1003 KAK3871028.1 hypothetical protein Pcinc_023796, partial [Petrolisthes cinctipes] diamond 1704 62.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Porcellanidae Petrolisthes Petrolisthes cinctipes

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