RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJEB75227" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 21 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB75227 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
135638 135638 PRJEB75227_P_NODE_3801_length_368_cov_1.047458_g3630_i0 PRJEB75227 3801 368 1.047458 3.85464544 Hymenoptera 7399 Arthropoda Arthropoda 228 2.4999999999999997e-69   NR XP_011877293.1 411798 g3630 i0 85.8 11.8451086956522 120 16 97.8 1 361 2 380 498 XP_011877293.1 PREDICTED: catalase isoform X3 [Vollenhovia emeryi] diamond 4359 229 0.995633187772926 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Vollenhovia Vollenhovia emeryi
3961746 3961746 PRJEB75227_P_NODE_10404_length_246_cov_0.901734_g10233_i0 PRJEB75227 10404 246 0.901734 2.21826564 Metazoa 33208 Arthropoda Arthropoda 87.4 7.52e-18   NR XP_050731858.1 95602 g10233 i0 53.6 14.3414634146341 84 37 100 1 246 1 548 631 XP_050731858.1 DNA-directed RNA polymerase II subunit RPB1-like, partial [Eriocheir sinensis] diamond 3528 87.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Varunidae Eriocheir Eriocheir sinensis
9062966 9062966 PRJEB75227_P_NODE_9308_length_250_cov_0.881356_g9137_i0 PRJEB75227 9308 250 0.881356 2.20339 Hymenoptera 7399 Arthropoda Arthropoda 159 1.24e-43   NR XP_043473277.1 63436 g9137 i0 95.2 12.948 83 4 99.6 0 1 249 422 504 XP_043473277.1 heat shock protein 70 B2-like [Leptopilina heterotoma] diamond 3237 160 0.99375 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Figitidae Leptopilina Leptopilina heterotoma
26748880 26748880 PRJEB75227_P_NODE_10161_length_247_cov_0.896552_g9990_i0 PRJEB75227 10161 247 0.896552 2.21448344 Sitodiplosis mosellana 263140 Arthropoda Arthropoda 114 1.56e-28   NR XP_055299726.1 263140 g9990 i0 61.7 0.983805668016194 81 30 98.4 1 2 244 75 154 XP_055299726.1 zinc finger protein 468-like [Sitodiplosis mosellana] diamond 243 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana
26812721 26812721 PRJEB75227_P_NODE_8201_length_253_cov_0.866667_g8030_i0 PRJEB75227 8201 253 0.866667 2.19266751 Aphis craccivora 307492 Arthropoda Arthropoda 49.7 1.51e-4   NR KAF0770257.1 307492 g8030 i0 44.1 2.79841897233202 59 31 70 1 189 13 323 379 KAF0770257.1 dynein intermediate chain 3, ciliary-like isoform X1 [Aphis craccivora] diamond 708 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis craccivora
26970766 26970766 PRJEB75227_P_NODE_10442_length_246_cov_0.901734_g10271_i0 PRJEB75227 10442 246 0.901734 2.21826564 Toxorhynchites rutilus septentrionalis 329112 Arthropoda Arthropoda 48.1 5.06e-4   NR XP_055615150.1 329112 g10271 i0 50 0.536585365853659 44 20 52.4 2 243 115 405 447 XP_055615150.1 uncharacterized protein LOC129761453 [Toxorhynchites rutilus septentrionalis] diamond 132 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Toxorhynchites Toxorhynchites rutilus
27065710 27065710 PRJEB75227_P_NODE_9922_length_248_cov_0.891429_g9751_i0 PRJEB75227 9922 248 0.891429 2.21074392 Zophobas morio 2755281 Arthropoda Arthropoda 56.2 7.08e-7   NR XP_063901617.1 2755281 g9751 i0 40.3 0.810483870967742 67 40 81 0 223 23 448 514 XP_063901617.1 sodium/potassium-transporting ATPase subunit alpha-2-like [Zophobas morio] diamond 201 56.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Zophobas Zophobas morio
27501118 27501118 PRJEB75227_P_NODE_8943_length_251_cov_0.876404_g8772_i0 PRJEB75227 8943 251 0.876404 2.19977404 Opisthokonta 33154 Arthropoda Arthropoda 102 2.36e-26   NR XP_055603447.1 190385 g8772 i0 59 10.2908366533865 78 32 93.2 0 235 2 7 84 XP_055603447.1 acyl-CoA-binding protein homolog 1-like [Uranotaenia lowii] diamond 2583 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Uranotaenia Uranotaenia lowii
27595823 27595823 PRJEB75227_P_NODE_7584_length_262_cov_1.449735_g7413_i0 PRJEB75227 7584 262 1.449735 3.7983057 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 42.7 0.0305   NR MCL4147870.1 82763 g7413 i0 39.7 1.78625954198473 78 45 89.3 1 259 26 101 176 MCL4147870.1 hypothetical protein [Idotea baltica] diamond 468 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
28013544 28013544 PRJEB75227_P_NODE_11745_length_242_cov_0.923077_g11574_i0 PRJEB75227 11745 242 0.923077 2.23384634 Ilyocryptus agilis 435267 Arthropoda Arthropoda 72 1.18e-13   NR CAG4643623.1 435267 g11574 i0 91.9 0.91735537190082606 37 3 45.9 0 241 131 120 156 CAG4643623.1 EOG090X0ILG [Ilyocryptus agilis] diamond 222 72 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Macrotrichidae Ilyocryptus Ilyocryptus agilis
28329006 28329006 PRJEB75227_P_NODE_5686_length_292_cov_1.278539_g5515_i0 PRJEB75227 5686 292 1.278539 3.73333388 Halyomorpha halys 286706 Arthropoda Arthropoda 59.7 7.48e-8   NR XP_014276207.1 286706 g5515 i0 69.6 0.708904109589041 69 21 70.9 0 84 290 1740 1808 XP_014276207.1 serine/threonine-protein kinase SMG1 isoform X1 [Halyomorpha halys] diamond 207 59.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pentatomidae Halyomorpha Halyomorpha halys
29276175 29276175 PRJEB75227_P_NODE_10049_length_247_cov_0.896552_g9878_i0 PRJEB75227 10049 247 0.896552 2.21448344 Frankliniella fusca 407009 Arthropoda Arthropoda 42.7 0.00575   NR KAK3928659.1 407009 g9878 i0 55.6 0.437246963562753 36 16 43.7 0 15 122 12 47 KAK3928659.1 Bifunctional chorismate mutase/prephenate dehydratase, partial [Frankliniella fusca] diamond 108 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Frankliniella Frankliniella fusca
29332242 29332242 PRJEB75227_P_NODE_4989_length_315_cov_0.888430_g4818_i0 PRJEB75227 4989 315 0.88843 2.7985545 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 50.1 1.21e-4   NR XP_059090628.1 6832 g4818 i0 36.7 1.14285714285714 60 38 57.1 0 136 315 77 136 XP_059090628.1 calmodulin-A-like [Tigriopus californicus] diamond 360 50.4 0.994047619047619 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
29529025 29529025 PRJEB75227_P_NODE_8670_length_252_cov_0.871508_g8499_i0 PRJEB75227 8670 252 0.871508 2.19620016 Cherax quadricarinatus 27406 Arthropoda Arthropoda 51.6 3.09e-5   NR XP_069943342.1 27406 g8499 i0 56.8 1.04761904761905 44 19 52.4 0 95 226 225 268 XP_069943342.1 uncharacterized protein [Cherax quadricarinatus] diamond 264 51.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Parastacidae Cherax Cherax quadricarinatus
30002761 30002761 PRJEB75227_P_NODE_6151_length_285_cov_1.169811_g5980_i0 PRJEB75227 6151 285 1.169811 3.33396135 Holotrichia oblita 644536 Arthropoda Arthropoda 43.9 0.0233   NR KAI4456280.1 644536 g5980 i0 48 0.526315789473684 50 22 52.6 2 12 161 190 235 KAI4456280.1 fatty-acid amide hydrolase [Holotrichia oblita] diamond 150 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Scarabaeidae Holotrichia Holotrichia oblita
30413627 30413627 PRJEB75227_P_NODE_9813_length_248_cov_0.891429_g9642_i0 PRJEB75227 9813 248 0.891429 2.21074392 Halyomorpha halys 286706 Arthropoda Arthropoda 84.3 6.81e-17   NR XP_066901529.1 286706 g9642 i0 53.3 1.76612903225806 75 35 90.7 0 2 226 284 358 XP_066901529.1 uncharacterized protein [Halyomorpha halys] diamond 438 84.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pentatomidae Halyomorpha Halyomorpha halys
30508128 30508128 PRJEB75227_P_NODE_5893_length_289_cov_1.078704_g5722_i0 PRJEB75227 5893 289 1.078704 3.11745456 Allacma fusca 39272 Arthropoda Arthropoda 43.1 0.0452   NR CAG7726884.1 39272 g5722 i0 31.3 0.830449826989619 80 41 68.5 2 211 14 42 121 CAG7726884.1 unnamed protein product [Allacma fusca] diamond 240 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
30792440 30792440 PRJEB75227_P_NODE_9014_length_251_cov_0.786517_g8843_i0 PRJEB75227 9014 251 0.786517 1.97415767 Ilyocryptus agilis 435267 Arthropoda Arthropoda 175 1.88e-49   NR CAG4643002.1 435267 g8843 i0 97.6 10.9123505976096 83 2 99.2 0 249 1 356 438 CAG4643002.1 EOG090X00JH [Ilyocryptus agilis] diamond 2739 175 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Macrotrichidae Ilyocryptus Ilyocryptus agilis
31322416 31322416 PRJEB75227_P_NODE_9115_length_250_cov_0.881356_g8944_i0 PRJEB75227 9115 250 0.881356 2.20339 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 115 3.61e-29   NR XP_025833010.1 224129 g8944 i0 62.5 10.26 80 30 96 0 9 248 8 87 XP_025833010.1 ADP,ATP carrier protein 1 [Agrilus planipennis] diamond 2565 116 0.991379310344828 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Buprestidae Agrilus Agrilus planipennis
32461487 32461487 PRJEB75227_P_NODE_8579_length_252_cov_0.871508_g8408_i0 PRJEB75227 8579 252 0.871508 2.19620016 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 112 8.860000000000001e-27   NR XP_003740769.1 34638 g8408 i0 59.8 10.75 82 33 97.6 0 249 4 32 113 XP_003740769.1 sec1 family domain-containing protein 1 [Galendromus occidentalis] diamond 2709 112 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
32532117 32532117 PRJEB75227_P_NODE_6439_length_281_cov_0.966346_g6268_i0 PRJEB75227 6439 281 0.966346 2.71543226 Portunus trituberculatus 210409 Arthropoda Arthropoda 57.8 2.41e-7   NR MPC31243.1 210409 g6268 i0 40 0.640569395017794 60 34 64.1 1 264 85 94 151 MPC31243.1 Furin-like protease 2 [Portunus trituberculatus] diamond 180 57.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus

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