RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA229468" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA229468 · 18 ✖
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
2917899 2917899 PRJNA229468_S_NODE_1083_length_166_cov_1.307692_g1070_i0 PRJNA229468 1083 166 1.307692 2.17076872 Cotesia glomerata 32391 Arthropoda Arthropoda 128 2.25e-25   NTclustered gi|2120545063|ref|XM_044719895.1| 32391 g1070 i0 81.132 69.4638554216867 159 30 96 0 6 164 846 1004 PREDICTED: Cotesia glomerata polyubiquitin (LOC123259399), mRNA blastn 11531 128 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Cotesia Cotesia glomerata
4194371 4194371 PRJNA229468_S_NODE_404_length_247_cov_1.171717_g391_i0 PRJNA229468 404 247 1.171717 2.89414099 Amphibalanus amphitrite 1232801 Arthropoda Arthropoda 126 2.78e-33   NR KAF0291935.1 1232801 g391 i0 68.3 1.9919028340081 82 26 99.6 0 247 2 113 194 KAF0291935.1 Cathepsin L [Amphibalanus amphitrite] diamond 492 126 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Balanomorpha Balanidae Amphibalanus Amphibalanus amphitrite
8709274 8709274 PRJNA229468_S_NODE_967_length_172_cov_2.479675_g954_i0 PRJNA229468 967 172 2.479675 4.265041 Lepidoptera 7088 Arthropoda Arthropoda 191 2.93e-44   NTclustered gi|1905483641|gb|MK295902.1| 282318 g954 i0 87.135 99.4418604651163 171 18 98 4 1 169 37 205 Leptotes pirithous voucher LYC076 elongation factor 1 alpha (Ef1a) gene, partial cds blastn 17104 191 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Leptotes Leptotes pirithous
10571338 10571338 PRJNA229468_S_NODE_589_length_211_cov_1.259259_g576_i0 PRJNA229468 589 211 1.259259 2.65703649 Aphidius gifuensis 684658 Arthropoda Arthropoda 207 3.7400000000000004e-49   NTclustered gi|2106734177|ref|XM_044149429.1| 684658 g576 i0 84.434 84.9336492890995 212 31 100 2 1 211 205 415 PREDICTED: Aphidius gifuensis actin-5C (LOC122850281), transcript variant X2, mRNA blastn 17921 207 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Aphidius Aphidius gifuensis
12535170 12535170 PRJNA229468_S_NODE_1110_length_165_cov_3.732759_g1097_i0 PRJNA229468 1110 165 3.732759 6.15905235 root 1 Root_unresolved Root_unresolved 305 9.59e-79   NTclustered gi|78097480|gb|AC167666.4| 7176 g1097 i0 100 293 165 0 100 0 1 165 1184 1020 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940120D9, complete sequence blastn 48345 305 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
15670085 15670085 PRJNA229468_S_NODE_1213_length_162_cov_1.353982_g1200_i0 PRJNA229468 1213 162 1.353982 2.19345084 Allacma fusca 39272 Arthropoda Arthropoda 78.2 4.58e-16   NR CAG7724150.1 39272 g1200 i0 76.9 1.87037037037037 52 12 96.3 0 160 5 144 195 CAG7724150.1 unnamed protein product [Allacma fusca] diamond 303 78.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
20768807 20768807 PRJNA229468_S_NODE_1217_length_162_cov_1.336283_g1204_i0 PRJNA229468 1217 162 1.336283 2.16477846 Pseudoterpna coronillaria 1007376 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|2918369759|emb|OZ237826.1| 1007376 g1204 i0 100 0.537037037037037 30 0 19 0 102 131 2879577 2879548 Pseudoterpna coronillaria genome assembly, chromosome: 1 blastn 87 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Pseudoterpna Pseudoterpna coronillaria
20768809 20768809 PRJNA229468_S_NODE_517_length_220_cov_1.783626_g504_i0 PRJNA229468 517 220 1.783626 3.9239772 Belonocnema kinseyi 2817044 Arthropoda Arthropoda 113 8.810000000000001e-21   NTclustered gi|1830529047|ref|XM_033358781.1| 2817044 g504 i0 81.295 11.9409090909091 139 26 63 0 5 143 743 881 PREDICTED: Belonocnema kinseyi 60S ribosomal protein L3 (LOC117171447), mRNA blastn 2627 113 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Cynipidae Belonocnema Belonocnema kinseyi
24008523 24008523 PRJNA229468_S_NODE_1239_length_161_cov_1.821429_g1226_i0 PRJNA229468 1239 161 1.821429 2.93250069 Formicidae 36668 Arthropoda Arthropoda 95.3 2.19e-15   NTclustered gi|780621847|ref|XM_011709211.1| 64793 g1226 i0 80.992 7.08695652173913 121 21 75 2 33 152 1066 947 PREDICTED: Wasmannia auropunctata 60S ribosomal protein L3 (LOC105462542), mRNA blastn 1141 95.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Wasmannia Wasmannia auropunctata
27313225 27313225 PRJNA229468_S_NODE_1043_length_167_cov_2.161017_g1030_i0 PRJNA229468 1043 167 2.161017 3.60889839 Opisthokonta 33154 Arthropoda Arthropoda 47.8 2.27e-4   NR KAJ8679391.1 131215 g1030 i0 47.3 6.62874251497006 55 23 98.8 2 167 3 14 62 KAJ8679391.1 hypothetical protein QAD02_015178 [Eretmocerus hayati] diamond 1107 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Aphelinidae Eretmocerus Eretmocerus hayati
28621579 28621579 PRJNA229468_S_NODE_867_length_180_cov_1.137405_g854_i0 PRJNA229468 867 180 1.137405 2.047329 Blomia tropicalis 40697 Arthropoda Arthropoda 77.4 9.46e-15   NR KAJ6223651.1 40697 g854 i0 67.3 12.6833333333333 49 16 81.7 0 149 3 152 200 KAJ6223651.1 hypothetical protein RDWZM_002196 [Blomia tropicalis] diamond 2283 77.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Echimyopodidae Blomia Blomia tropicalis
28653060 28653060 PRJNA229468_S_NODE_567_length_213_cov_0.932927_g554_i0 PRJNA229468 567 213 0.932927 1.98713451 Apolygus lucorum 248454 Arthropoda Arthropoda 57.4 1.74e-7   NR KAF6208424.1 248454 g554 i0 50.9 0.774647887323944 55 27 77.5 0 174 10 35 89 KAF6208424.1 hypothetical protein GE061_016880 [Apolygus lucorum] diamond 165 57.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Miridae Apolygus Apolygus lucorum
29018415 29018415 PRJNA229468_S_NODE_948_length_174_cov_0.976000_g935_i0 PRJNA229468 948 174 0.976 1.69824 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 83.6 1.5700000000000001e-19   NR MCL4169634.1 82763 g935 i0 71.9 2.98275862068966 57 16 98.3 0 171 1 8 64 MCL4169634.1 hypothetical protein [Idotea baltica] diamond 519 83.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
29997123 29997123 PRJNA229468_S_NODE_231_length_322_cov_1.860806_g218_i0 PRJNA229468 231 322 1.860806 5.99179532 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 126 6.389999999999998e-35   NR XP_014219446.1 29053 g218 i0 62.9 30.111801242236 97 34 90.4 1 291 1 5 99 XP_014219446.1 60S ribosomal protein L31 [Copidosoma floridanum] diamond 9696 126 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Encyrtidae Copidosoma Copidosoma floridanum
30913387 30913387 PRJNA229468_S_NODE_894_length_178_cov_1.480620_g881_i0 PRJNA229468 894 178 1.48062 2.6355036 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 50.1 3.94e-5   NR RWS23232.1 299467 g881 i0 43.4 6.42134831460674 53 30 89.3 0 18 176 439 491 RWS23232.1 ABC transporter-like protein 12 [Leptotrombidium deliense] diamond 1143 50.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombiculidae Leptotrombidium Leptotrombidium deliense
31116397 31116397 PRJNA229468_S_NODE_435_length_237_cov_1.904255_g422_i0 PRJNA229468 435 237 1.904255 4.51308435 Anoplophora glabripennis 217634 Arthropoda Arthropoda 86.7 1.2e-19   NR XP_018578213.1 217634 g422 i0 83.3 6.0253164556962 54 9 68.4 0 3 164 80 133 XP_018578213.1 ubiquitin-like protein FUBI [Anoplophora glabripennis] diamond 1428 86.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Anoplophora Anoplophora glabripennis
31401408 31401408 PRJNA229468_S_NODE_316_length_279_cov_1.795652_g303_i0 PRJNA229468 316 279 1.795652 5.00986908 Idotea baltica 82763 Arthropoda Arthropoda 147 3.2599999999999995e-42   NR MCL4121308.1 82763 g303 i0 68.8 2 93 29 100 0 279 1 41 133 MCL4121308.1 hypothetical protein [Idotea baltica] diamond 558 147 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
31685715 31685715 PRJNA229468_S_NODE_1157_length_164_cov_0.886957_g1144_i0 PRJNA229468 1157 164 0.886957 1.45460948 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 69.7 6.92e-13   NR ADD38186.1 72036 g1144 i0 53.7 0.98780487804878 54 25 98.8 0 163 2 77 130 ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis] diamond 162 69.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis

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