RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJEB56027" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 27 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB56027 · 27 ✖

analysis 1

  • diamond · 27 ✖
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
27349909 27349909 PRJEB56027_P_NODE_138843_length_199_cov_4.396825_g136034_i0 PRJEB56027 138843 199 4.396825 8.74968175 Nilaparvata lugens 108931 Arthropoda Arthropoda 76.3 2.35e-14   NR XP_039298513.1 108931 g136034 i0 48.4 0.964824120603015 64 33 96.5 0 6 197 181 244 XP_039298513.1 uncharacterized protein LOC120354807 [Nilaparvata lugens] diamond 192 76.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
27949657 27949657 PRJEB56027_P_NODE_134305_length_239_cov_2.271084_g131496_i0 PRJEB56027 134305 239 2.271084 5.42789076 Medioppia subpectinata 1979941 Arthropoda Arthropoda 73.6 3e-13   NR CAD7631495.1 1979941 g131496 i0 56.9 1.45606694560669 58 25 72.8 0 66 239 34 91 CAD7631495.1 unnamed protein product [Medioppia subpectinata] diamond 348 73.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
27981229 27981229 PRJEB56027_P_NODE_108065_length_258_cov_1.475676_g105256_i0 PRJEB56027 108065 258 1.475676 3.80724408 Diaphorina citri 121845 Arthropoda Arthropoda 72.8 1.21e-12   NR KAI5743164.1 121845 g105256 i0 58.6 1.34883720930233 58 24 67.4 0 85 258 475 532 KAI5743164.1 hypothetical protein M8J77_015214 [Diaphorina citri] diamond 348 72.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
28328380 28328380 PRJEB56027_P_NODE_136486_length_231_cov_2.430380_g133677_i0 PRJEB56027 136486 231 2.43038 5.6141778 Plutella xylostella 51655 Arthropoda Arthropoda 46.2 0.00184   NR CAG9108432.1 51655 g133677 i0 53.1 1.71428571428571 32 15 41.6 0 230 135 395 426 CAG9108432.1 unnamed protein product [Plutella xylostella] diamond 396 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
28454976 28454976 PRJEB56027_P_NODE_137106_length_229_cov_2.166667_g134297_i0 PRJEB56027 137106 229 2.166667 4.96166743 Trichonephila clavipes 2585209 Arthropoda Arthropoda 134 4.35e-36   NR GFW83042.1 2585209 g134297 i0 85.3 109.061135371179 75 11 98.3 0 3 227 277 351 GFW83042.1 transposable element Tcb2 transposase [Trichonephila clavipes] diamond 24975 134 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
28581205 28581205 PRJEB56027_P_NODE_124387_length_245_cov_3.476744_g121578_i0 PRJEB56027 124387 245 3.476744 8.5180228 Bradysia odoriphaga 1564500 Arthropoda Arthropoda 72.4 1.36e-12   NR KAG4071565.1 1564500 g121578 i0 92.7 0.502040816326531 41 3 50.2 0 121 243 448 488 KAG4071565.1 hypothetical protein HA402_011719 [Bradysia odoriphaga] diamond 123 72.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia odoriphaga
28707488 28707488 PRJEB56027_P_NODE_101987_length_266_cov_1.440415_g99178_i0 PRJEB56027 101987 266 1.440415 3.8315039 Caligus rogercresseyi 217165 Arthropoda Arthropoda 42.7 0.0108   NR QQP50768.1 217165 g99178 i0 36.7 2.70676691729323 60 38 67.7 0 1 180 37 96 QQP50768.1 Mortality factor 4-like protein 1 [Caligus rogercresseyi] diamond 720 43.1 0.990719257540603 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Caligus Caligus rogercresseyi
29458099 29458099 PRJEB56027_P_NODE_86850_length_287_cov_1.901869_g84041_i0 PRJEB56027 86850 287 1.901869 5.45836403 Delphacidae 33362 Arthropoda Arthropoda 159 3.42e-44   NR AQT27075.1 108931 g84041 i0 92.2 2.83275261324042 90 7 94.1 0 16 285 364 453 AQT27075.1 putative dihydrolipoyllysine-residue acetyltransferase, partial [Nilaparvata lugens] diamond 813 160 0.99375 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
29591082 29591082 PRJEB56027_P_NODE_89190_length_284_cov_1.132701_g86381_i0 PRJEB56027 89190 284 1.132701 3.21687084 Diaphorina citri 121845 Arthropoda Arthropoda 134 4.09e-34   NR KAI5752166.1 121845 g86381 i0 70.5 2.00704225352113 95 27 99.3 1 283 2 789 883 KAI5752166.1 hypothetical protein M8J77_014468 [Diaphorina citri] diamond 570 134 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
29780856 29780856 PRJEB56027_P_NODE_94331_length_276_cov_2.256158_g91522_i0 PRJEB56027 94331 276 2.256158 6.22699608 Oedothorax gibbosus 931172 Arthropoda Arthropoda 71.2 5.29e-12   NR KAG8180647.1 931172 g91522 i0 42 0.956521739130435 88 47 92.4 2 4 258 339 425 KAG8180647.1 hypothetical protein JTE90_018262 [Oedothorax gibbosus] diamond 264 71.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Linyphiidae Oedothorax Oedothorax gibbosus
30002135 30002135 PRJEB56027_P_NODE_106871_length_259_cov_2.306452_g104062_i0 PRJEB56027 106871 259 2.306452 5.97371068 Periplaneta americana 6978 Arthropoda Arthropoda 62 3.53e-10   NR KAJ4450220.1 6978 g104062 i0 56.3 1.1003861003861 48 21 55.6 0 21 164 57 104 KAJ4450220.1 hypothetical protein ANN_01627 [Periplaneta americana] diamond 285 62 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
30002137 30002137 PRJEB56027_P_NODE_97451_length_272_cov_1.547739_g94642_i0 PRJEB56027 97451 272 1.547739 4.20985008 Stegodyphus dumicola 202533 Arthropoda Arthropoda 46.6 0.00229   NR XP_035204405.1 202533 g94642 i0 33.8 0.783088235294118 71 45 78.3 1 216 4 164 232 XP_035204405.1 uncharacterized protein LOC118179338, partial [Stegodyphus dumicola] diamond 213 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus dumicola
30033693 30033693 PRJEB56027_P_NODE_106891_length_259_cov_2.258065_g104082_i0 PRJEB56027 106891 259 2.258065 5.84838835 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 108 2.4e-25   NR KAH9393626.1 59818 g104082 i0 63.9 0.961389961389961 83 29 96.1 1 1 249 463 544 KAH9393626.1 hypothetical protein TYRP_021543, partial [Tyrophagus putrescentiae] diamond 249 108 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
30159725 30159725 PRJEB56027_P_NODE_117412_length_249_cov_1.585227_g114603_i0 PRJEB56027 117412 249 1.585227 3.94721523 Homalodisca vitripennis 197043 Arthropoda Arthropoda 50.1 4.94e-5   NR KAG8250740.1 197043 g114603 i0 54.5 1.1566265060241 33 15 39.8 0 187 89 63 95 KAG8250740.1 hypothetical protein J6590_108611 [Homalodisca vitripennis] diamond 288 50.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
30381543 30381543 PRJEB56027_P_NODE_135053_length_236_cov_2.343558_g132244_i0 PRJEB56027 135053 236 2.343558 5.53079688 Diaphorina citri 121845 Arthropoda Arthropoda 57.8 1.73e-7   NR KAI5752166.1 121845 g132244 i0 62.8 1.09322033898305 43 12 54.7 1 150 22 812 850 KAI5752166.1 hypothetical protein M8J77_014468 [Diaphorina citri] diamond 258 57.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
30981641 30981641 PRJEB56027_P_NODE_104114_length_263_cov_1.621053_g101305_i0 PRJEB56027 104114 263 1.621053 4.26336939 Araneus ventricosus 182803 Arthropoda Arthropoda 123 1.7699999999999996e-31   NR GBO13421.1 182803 g101305 i0 64.3 12.4562737642586 84 30 95.8 0 11 262 239 322 GBO13421.1 hypothetical protein AVEN_181947-1 [Araneus ventricosus] diamond 3276 123 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
31234065 31234065 PRJEB56027_P_NODE_127375_length_244_cov_0.900585_g124566_i0 PRJEB56027 127375 244 0.900585 2.1974274 Homalodisca vitripennis 197043 Arthropoda Arthropoda 61.2 1.28e-9   NR KAG8257227.1 197043 g124566 i0 100 1.65983606557377 27 0 33.2 0 162 242 1 27 KAG8257227.1 hypothetical protein J6590_053875 [Homalodisca vitripennis] diamond 405 61.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
31519036 31519036 PRJEB56027_P_NODE_124236_length_246_cov_0.890173_g121427_i0 PRJEB56027 124236 246 0.890173 2.18982558 Oppiella nova 334625 Arthropoda Arthropoda 73.2 7.41e-13   NR CAD7655788.1 334625 g121427 i0 56.3 2.42682926829268 64 28 78 0 3 194 1278 1341 CAD7655788.1 unnamed protein product, partial [Oppiella nova] diamond 597 73.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
31613779 31613779 PRJEB56027_P_NODE_95156_length_275_cov_1.787129_g92347_i0 PRJEB56027 95156 275 1.787129 4.91460475 Darwinula stevensoni 69355 Arthropoda Arthropoda 70.1 1.29e-11   NR CAD7244681.1 69355 g92347 i0 45 6.67636363636364 80 41 84 1 42 272 185 264 CAD7244681.1 unnamed protein product [Darwinula stevensoni] diamond 1836 70.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Darwinulidae Darwinula Darwinula stevensoni
31708684 31708684 PRJEB56027_P_NODE_114737_length_251_cov_0.865169_g111928_i0 PRJEB56027 114737 251 0.865169 2.17157419 Daphnia magna 35525 Arthropoda Arthropoda 40.4 0.0414   NR KZR97555.1 35525 g111928 i0 73.9 0.274900398406374 23 6 27.5 0 99 31 2 24 KZR97555.1 Uncharacterized protein APZ42_007495, partial [Daphnia magna] diamond 69 40.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
31740168 31740168 PRJEB56027_P_NODE_99637_length_269_cov_1.571429_g96828_i0 PRJEB56027 99637 269 1.571429 4.22714401 Rhagoletis zephyria 28612 Arthropoda Arthropoda 139 4.37e-36   NR XP_017487318.1 28612 g96828 i0 74.2 2.95539033457249 89 23 99.3 0 267 1 1965 2053 XP_017487318.1 PREDICTED: fatty acid synthase-like [Rhagoletis zephyria] diamond 795 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
31930040 31930040 PRJEB56027_P_NODE_103557_length_264_cov_1.293194_g100748_i0 PRJEB56027 103557 264 1.293194 3.41403216 Allacma fusca 39272 Arthropoda Arthropoda 48.9 3.03e-4   NR CAG7834611.1 39272 g100748 i0 67.6 0.386363636363636 34 10 37.5 1 262 164 178 211 CAG7834611.1 unnamed protein product [Allacma fusca] diamond 102 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
31993374 31993374 PRJEB56027_P_NODE_128458_length_243_cov_1.811765_g125649_i0 PRJEB56027 128458 243 1.811765 4.40258895 Cyamophila willieti 2604842 Arthropoda Arthropoda 48.5 3.54e-4   NR KAL1447418.1 2604842 g125649 i0 59.5 1.39506172839506 37 15 45.7 0 243 133 722 758 KAL1447418.1 hypothetical protein WDU94_003530 [Cyamophila willieti] diamond 339 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Cyamophila Cyamophila willieti
32366526 32366526 PRJEB56027_P_NODE_135359_length_235_cov_2.265432_g132550_i0 PRJEB56027 135359 235 2.265432 5.3237652 Arthropoda 6656 Arthropoda Arthropoda 127 7.799999999999999e-32   NR XP_017487346.1 28612 g132550 i0 78.2 3.98297872340426 78 17 99.6 0 234 1 1277 1354 XP_017487346.1 PREDICTED: eIF-2-alpha kinase activator GCN1-like [Rhagoletis zephyria] diamond 936 127 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
32398091 32398091 PRJEB56027_P_NODE_102879_length_265_cov_1.276042_g100070_i0 PRJEB56027 102879 265 1.276042 3.3815113 Araneae 6893 Arthropoda Arthropoda 104 1.0099999999999999e-23   NR XP_042911793.1 114398 g100070 i0 60 5.88679245283019 85 34 96.2 0 6 260 381 465 XP_042911793.1 uncharacterized protein [Parasteatoda tepidariorum] diamond 1560 105 0.990476190476191 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Theridiidae Parasteatoda Parasteatoda tepidariorum
32556500 32556500 PRJEB56027_P_NODE_125979_length_245_cov_0.895349_g123170_i0 PRJEB56027 125979 245 0.895349 2.19360505 Sarcoptiformes 83137 Arthropoda Arthropoda 71.6 2.62e-12   NR KAH7642036.1 6954 g123170 i0 48.1 5.97551020408163 81 41 99.2 1 244 2 2526 2605 KAH7642036.1 hypothetical protein HUG17_5081 [Dermatophagoides farinae] diamond 1464 72 0.994444444444444 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
32902435 32902435 PRJEB56027_P_NODE_131100_length_242_cov_0.911243_g128291_i0 PRJEB56027 131100 242 0.911243 2.20520806 Formicidae 36668 Arthropoda Arthropoda 58.9 2.65e-8   NR KYQ53938.1 64791 g128291 i0 70.3 5.71487603305785 37 11 45.9 0 25 135 112 148 KYQ53938.1 hypothetical protein ALC60_07151, partial [Trachymyrmex zeteki] diamond 1383 58.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Mycetomoellerius Mycetomoellerius zeteki

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