RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where bioproject = "PRJDB12134" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 32 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJDB12134 · 32 ✖
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
980608 980608 PRJDB12134_P_NODE_11881_length_260_cov_1.315508_g11746_i0 PRJDB12134 11881 260 1.315508 3.4203208 Hymenoptera 7399 Arthropoda Arthropoda 76.8 1.41e-9   NTclustered gi|1772570794|ref|XM_006607720.2| 7462 g11746 i0 97.727 2.35769230769231 44 1 17 0 1 44 1410 1453 PREDICTED: Apis dorsata actin, clone 205-like (LOC102673579), transcript variant X1, mRNA blastn 613 76.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Apis Apis dorsata
1274249 1274249 PRJDB12134_P_NODE_12782_length_250_cov_0.881356_g12647_i0 PRJDB12134 12782 250 0.881356 2.20339 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 462 8.83e-126   NTclustered gi|1535907958|ref|XM_027339861.1| 6956 g12647 i0 100 1 250 0 100 0 1 250 956 707 PREDICTED: Dermatophagoides pteronyssinus cytoplasmic dynein 2 heavy chain 1-like (LOC113790226), partial mRNA blastn 250 462 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
3531251 3531251 PRJDB12134_P_NODE_12223_length_254_cov_1.281768_g12088_i0 PRJDB12134 12223 254 1.281768 3.25569072 Pacifastacus 6719 Arthropoda Arthropoda 176 1.31e-39   NTclustered gi|2787301476|gb|PQ186824.1| 6720 g12088 i0 93.277 47.751968503937 119 8 47 0 1 119 4152 4270 Pacifastacus leniusculus isolate F122014 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 12129 176 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Astacidae Pacifastacus Pacifastacus leniusculus
5102398 5102398 PRJDB12134_P_NODE_10525_length_281_cov_1.495192_g10390_i0 PRJDB12134 10525 281 1.495192 4.20148952 Shinkaia crosnieri 480484 Arthropoda Arthropoda 501 2.14e-137   NTclustered gi|168202708|gb|EU420129.1| 480484 g10390 i0 99.635 67.7473309608541 274 1 98 0 8 281 4471 4198 Shinkaia crosnieri mitochondrion, complete genome blastn 19037 501 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Munidopsidae Shinkaia Shinkaia crosnieri
5102433 5102433 PRJDB12134_P_NODE_12605_length_251_cov_0.876404_g12470_i0 PRJDB12134 12605 251 0.876404 2.19977404 Homarus americanus 6706 Arthropoda Arthropoda 69.4 2.26e-7   NTclustered gi|2068710019|ref|XM_042347675.1| 6706 g12470 i0 97.5 6.17529880478088 40 1 16 0 212 251 1195 1156 PREDICTED: Homarus americanus actin-like (LOC121853519), transcript variant X1, mRNA blastn 1550 69.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Nephropidae Homarus Homarus americanus
7652310 7652310 PRJDB12134_P_NODE_14027_length_244_cov_0.906433_g13892_i0 PRJDB12134 14027 244 0.906433 2.21169652 Timema douglasi 61478 Arthropoda Arthropoda 374 4.1399999999999986e-99   NTclustered gi|1936674691|emb|OA587848.1| 61478 g13892 i0 94.262 1.98770491803279 244 14 100 0 1 244 1969 2212 1_Tdi_b3v08 blastn 485 374 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
8927201 8927201 PRJDB12134_P_NODE_7168_length_371_cov_1.073826_g7033_i0 PRJDB12134 7168 371 1.073826 3.98389446 Loxosceles arizonica 196454 Arthropoda Arthropoda 545 1.33e-150   NTclustered gi|31296493|gb|AF512954.1| 196454 g7033 i0 93.46 3.49326145552561 367 24 99 0 1 367 3737 4103 Loxosceles arizonica clone 1 sphingomyelinase D - like protein gene, exon 1 and partial cds blastn 1296 545 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Sicariidae Loxosceles Loxosceles arizonica
10202891 10202891 PRJDB12134_P_NODE_11609_length_264_cov_1.633508_g11474_i0 PRJDB12134 11609 264 1.633508 4.31246112 Shinkaia crosnieri 480484 Arthropoda Arthropoda 488 1.5499999999999999e-133   NTclustered gi|168202708|gb|EU420129.1| 480484 g11474 i0 100 85.9128787878788 264 0 100 0 1 264 5254 4991 Shinkaia crosnieri mitochondrion, complete genome blastn 22681 488 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Munidopsidae Shinkaia Shinkaia crosnieri
10202992 10202992 PRJDB12134_P_NODE_469_length_1358_cov_18.701167_g408_i0 PRJDB12134 469 1358 18.701167 253.96184786 Shinkaia crosnieri 480484 Arthropoda Arthropoda 2403 0   NTclustered gi|168202708|gb|EU420129.1| 480484 g408 i0 99.847 45.060382916053 1307 2 99 0 50 1356 6567 7873 Shinkaia crosnieri mitochondrion, complete genome blastn 61192 2403 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Munidopsidae Shinkaia Shinkaia crosnieri
11478140 11478140 PRJDB12134_P_NODE_8870_length_316_cov_1.572016_g8735_i0 PRJDB12134 8870 316 1.572016 4.96757056 Aphis gossypii 80765 Arthropoda Arthropoda 62.1 4.92e-5   NTclustered gi|2288480372|ref|XM_027986787.2| 80765 g8735 i0 95 11.5284810126582 40 0 13 2 18 57 5604 5567 PREDICTED: Aphis gossypii transcriptional repressor scratch 2-like (LOC114123722), mRNA blastn 3643 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis gossypii
12753701 12753701 PRJDB12134_P_NODE_8831_length_317_cov_1.758197_g8696_i0 PRJDB12134 8831 317 1.758197 5.57348449 Timema poppense 170557 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1946896637|emb|OD014535.1| 170557 g8696 i0 96.97 0.10410094637224 33 1 10 0 74 106 7407 7375 1_Tps_b3v08 blastn 33 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema poppense
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
15008550 15008550 PRJDB12134_P_NODE_9212_length_305_cov_1.340517_g9077_i0 PRJDB12134 9212 305 1.340517 4.08857685 Panulirus 6734 Arthropoda Arthropoda 65.8 3.65e-6   NTclustered gi|1938737253|gb|MW252173.1| 6737 g9077 i0 97.368 0.485245901639344 38 1 12 0 268 305 8145 8182 Panulirus argus isolate JB1 external transcribed spacer, partial sequence; small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence; and external transcribed spacer, partial sequence blastn 148 65.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palinuridae Panulirus Panulirus argus
15302124 15302124 PRJDB12134_P_NODE_10553_length_281_cov_0.918269_g10418_i0 PRJDB12134 10553 281 0.918269 2.58033589 Argiope trifasciata 156845 Arthropoda Arthropoda 385 2.25e-102   NTclustered gi|1699450979|gb|MK138561.1| 156845 g10418 i0 91.697 4.56227758007117 277 23 99 0 4 280 34933 34657 Argiope trifasciata aggregate spidroin 1 (AgSp1) gene, complete cds blastn 1282 385 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Argiope Argiope trifasciata
17558498 17558498 PRJDB12134_P_NODE_10774_length_277_cov_1.897059_g10639_i0 PRJDB12134 10774 277 1.897059 5.25485343 Timema 61471 Arthropoda Arthropoda 52.8 0.025   NTclustered gi|1946859053|emb|OC316503.1| 61476 g10639 i0 100 0.202166064981949 28 0 10 0 10 37 69452 69479 3_Tce_b3v08 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema cristinae
17851974 17851974 PRJDB12134_P_NODE_2355_length_728_cov_1.650382_g2233_i0 PRJDB12134 2355 728 1.650382 12.01478096 Diuraphis noxia 143948 Arthropoda Arthropoda 56.5 0.006   NTclustered gi|985399333|ref|XM_015511795.1| 143948 g2233 i0 100 0.214285714285714 30 0 4 0 174 203 868 839 PREDICTED: Diuraphis noxia protein grainyhead (LOC107164101), mRNA blastn 156 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
20400763 20400763 PRJDB12134_P_NODE_8937_length_313_cov_3.300000_g8802_i0 PRJDB12134 8937 313 3.3 10.329 Procambarus clarkii 6728 Arthropoda Arthropoda 189 2.1399999999999993e-43   NTclustered gi|255964841|gb|GQ369797.1| 6728 g8802 i0 87.135 39.3514376996805 171 17 54 4 99 266 686 854 Procambarus clarkii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 12317 189 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
21676793 21676793 PRJDB12134_P_NODE_9958_length_289_cov_4.300926_g9823_i0 PRJDB12134 9958 289 4.300926 12.42967614 Samia ricini 63990 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|2883230270|dbj|AP038904.1| 63990 g9823 i0 100 0.100346020761246 29 0 10 0 209 237 22303131 22303103 Samia ricini White GU1 DNA, chromosome 09, complete sequence blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Saturniidae Samia Samia ricini
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);;