RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where analysis = "diamond", bioproject = "PRJNA1240804" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 33 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1240804 · 33 ✖

analysis 1

  • diamond · 33 ✖
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
26661666 26661666 PRJNA1240804_P_NODE_139361_length_164_cov_0.904348_g138995_i0 PRJNA1240804 139361 164 0.904348 1.48313072 Eurytemora carolleeae 1294199 Arthropoda Arthropoda 53.5 1.98e-6   NR XP_023332432.1 1294199 g138995 i0 49 1.79268292682927 49 25 89.6 0 17 163 161 209 XP_023332432.1 uncharacterized protein LOC111704428 [Eurytemora carolleeae] diamond 294 53.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Temoridae Eurytemora Eurytemora carolleeae
26756811 26756811 PRJNA1240804_P_NODE_28001_length_273_cov_2.075893_g27635_i0 PRJNA1240804 28001 273 2.075893 5.66718789 Aedes albopictus 7160 Arthropoda Arthropoda 83.2 1.57e-18   NR KXJ76875.1 7160 g27635 i0 50 3.48351648351648 84 41 91.2 1 2 250 4 87 KXJ76875.1 hypothetical protein RP20_CCG008711 [Aedes albopictus] diamond 951 83.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
26756826 26756826 PRJNA1240804_P_NODE_42761_length_232_cov_1.005464_g42395_i0 PRJNA1240804 42761 232 1.005464 2.33267648 Anthophora quadrimaculata 597840 Arthropoda Arthropoda 45.4 0.00376   NR CAK9795062.1 597840 g42395 i0 33 1.13793103448276 88 44 95.7 3 2 223 320 406 CAK9795062.1 HMCN2 [Anthophora quadrimaculata] diamond 264 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Anthophora Anthophora quadrimaculata
26978539 26978539 PRJNA1240804_P_NODE_138822_length_164_cov_0.904348_g138456_i0 PRJNA1240804 138822 164 0.904348 1.48313072 Panonychus citri 50023 Arthropoda Arthropoda 79 2.19e-15   NR XP_053200690.1 50023 g138456 i0 72.9 1.71951219512195 48 13 87.8 0 14 157 384 431 XP_053200690.1 twitchin-like isoform X3 [Panonychus citri] diamond 282 79 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Panonychus Panonychus citri
27136294 27136294 PRJNA1240804_P_NODE_36742_length_245_cov_2.673469_g36376_i0 PRJNA1240804 36742 245 2.673469 6.54999905 Diaphorina citri 121845 Arthropoda Arthropoda 87.4 4.41e-18   NR KAI5732385.1 121845 g36376 i0 57.4 0.83265306122449 68 29 83.3 0 41 244 241 308 KAI5732385.1 hypothetical protein M8J77_026089 [Diaphorina citri] diamond 204 87.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
27199659 27199659 PRJNA1240804_P_NODE_131702_length_165_cov_0.896552_g131336_i0 PRJNA1240804 131702 165 0.896552 1.4793108 Folsomia candida 158441 Arthropoda Arthropoda 57 1.16e-7   NR OXA62068.1 158441 g131336 i0 87.5 0.872727272727273 24 3 43.6 0 57 128 167 190 OXA62068.1 hypothetical protein Fcan01_03631 [Folsomia candida] diamond 144 57 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Isotomidae Folsomia Folsomia candida
27294691 27294691 PRJNA1240804_P_NODE_104843_length_170_cov_1.578512_g104477_i0 PRJNA1240804 104843 170 1.578512 2.6834704 Scaptodrosophila lebanonensis 7225 Arthropoda Arthropoda 75.1 5.41e-14   NR XP_030374698.1 7225 g104477 i0 70 0.882352941176471 50 15 88.2 0 157 8 734 783 XP_030374698.1 LOW QUALITY PROTEIN: protein grainyhead [Scaptodrosophila lebanonensis] diamond 150 75.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Scaptodrosophila Scaptodrosophila lebanonensis
27578962 27578962 PRJNA1240804_P_NODE_20524_length_309_cov_0.961538_g20158_i0 PRJNA1240804 20524 309 0.961538 2.97115242 Daphnia pulex 6669 Arthropoda Arthropoda 52.8 2.41e-5   NR ACB38661.1 6669 g20158 i0 33 1.75728155339806 91 54 87.4 2 283 14 302 386 ACB38661.1 integrase [Daphnia pulex] diamond 543 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
27989584 27989584 PRJNA1240804_P_NODE_55125_length_211_cov_3.672840_g54759_i0 PRJNA1240804 55125 211 3.67284 7.7496924 Rhynchophorus ferrugineus 354439 Arthropoda Arthropoda 87.4 1.83e-18   NR KAF7277658.1 354439 g54759 i0 79.2 0.682464454976303 48 10 68.2 0 53 196 1 48 KAF7277658.1 hypothetical protein GWI33_000987, partial [Rhynchophorus ferrugineus] diamond 144 87.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Rhynchophorus Rhynchophorus ferrugineus
28084170 28084170 PRJNA1240804_P_NODE_95645_length_176_cov_1.488189_g95279_i0 PRJNA1240804 95645 176 1.488189 2.61921264 Ignelater luminosus 2038154 Arthropoda Arthropoda 43.1 0.011   NR KAF2887598.1 2038154 g95279 i0 45.3 1.77272727272727 53 28 90.3 1 17 175 208 259 KAF2887598.1 hypothetical protein ILUMI_18575 [Ignelater luminosus] diamond 312 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Elateridae Ignelater Ignelater luminosus
28494790 28494790 PRJNA1240804_P_NODE_42727_length_232_cov_1.049180_g42361_i0 PRJNA1240804 42727 232 1.04918 2.4340976 Sarcoptes scabiei 52283 Arthropoda Arthropoda 43.1 0.0171   NR KAF7496260.1 52283 g42361 i0 52.2 0.594827586206897 46 21 58.2 1 14 148 108 153 KAF7496260.1 hypothetical protein SSS_09555 [Sarcoptes scabiei] diamond 138 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Sarcoptidae Sarcoptes Sarcoptes scabiei
28526464 28526464 PRJNA1240804_P_NODE_78927_length_187_cov_1.463768_g78561_i0 PRJNA1240804 78927 187 1.463768 2.73724616 Orchesella cincta 48709 Arthropoda Arthropoda 53.1 1.86e-6   NR ODM95627.1 48709 g78561 i0 71 0.497326203208556 31 9 49.7 0 95 3 149 179 ODM95627.1 Transmembrane protein [Orchesella cincta] diamond 93 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
28904893 28904893 PRJNA1240804_P_NODE_47408_length_223_cov_1.534483_g47042_i0 PRJNA1240804 47408 223 1.534483 3.42189709 Rhipicephalus microplus 6941 Arthropoda Arthropoda 43.1 0.0198   NR XP_037289607.1 6941 g47042 i0 38.6 1.53363228699552 57 31 76.7 1 2 172 56 108 XP_037289607.1 THAP domain-containing protein 1-like [Rhipicephalus microplus] diamond 342 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
29252204 29252204 PRJNA1240804_P_NODE_30569_length_264_cov_1.711628_g30203_i0 PRJNA1240804 30569 264 1.711628 4.51869792 Trichonephila clavipes 2585209 Arthropoda Arthropoda 50.4 9.35e-5   NR GFV75940.1 2585209 g30203 i0 42.6 4.45454545454545 47 26 53.4 1 114 254 126 171 GFV75940.1 retrovirus-related Pol polyprotein from transposon TNT 1-94 [Trichonephila clavipes] diamond 1176 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
29554586 29554586 PRJNA1240804_P_NODE_79150_length_187_cov_1.398551_g78784_i0 PRJNA1240804 79150 187 1.398551 2.61529037 Insecta 50557 Arthropoda Arthropoda 101 4.409999999999999e-23   NR XP_055677242.1 7200 g78784 i0 78.6 13.427807486631 56 12 89.8 0 16 183 988 1043 XP_055677242.1 PH-interacting protein [Lutzomyia longipalpis] diamond 2511 101 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Lutzomyia Lutzomyia longipalpis
29599532 29599532 PRJNA1240804_P_NODE_69730_length_194_cov_1.179310_g69364_i0 PRJNA1240804 69730 194 1.17931 2.2878614 Orchesella dallaii 48710 Arthropoda Arthropoda 61.6 4.19e-9   NR CAL8097700.1 48710 g69364 i0 56.7 2.69072164948454 60 25 91.2 1 194 18 38 97 CAL8097700.1 unnamed protein product [Orchesella dallaii] diamond 522 61.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella dallaii
29820516 29820516 PRJNA1240804_P_NODE_118371_length_167_cov_1.203390_g118005_i0 PRJNA1240804 118371 167 1.20339 2.0096613 Odontomachus brunneus 486640 Arthropoda Arthropoda 41.2 0.0479   NR XP_032674617.1 486640 g118005 i0 45 0.718562874251497 40 17 71.9 1 13 132 817 851 XP_032674617.1 zinc finger protein 91-like [Odontomachus brunneus] diamond 120 41.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Odontomachus Odontomachus brunneus
29870516 29870516 PRJNA1240804_P_NODE_120171_length_167_cov_0.881356_g119805_i0 PRJNA1240804 120171 167 0.881356 1.47186452 Opisthokonta 33154 Arthropoda Arthropoda 45.4 0.00147   NR XP_040570723.1 72036 g119805 i0 45.1 21.2694610778443 51 28 91.6 0 167 15 261 311 XP_040570723.1 phosphorylase b kinase gamma catalytic chain, liver/testis isoform-like [Lepeophtheirus salmonis] diamond 3552 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
30199627 30199627 PRJNA1240804_P_NODE_130692_length_165_cov_0.896552_g130326_i0 PRJNA1240804 130692 165 0.896552 1.4793108 Laodelphax striatellus 195883 Arthropoda Arthropoda 64.3 3.09e-10   NR RZF39726.1 195883 g130326 i0 60 1.98181818181818 55 18 96.4 2 5 163 299 351 RZF39726.1 hypothetical protein LSTR_LSTR011135 [Laodelphax striatellus] diamond 327 64.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Laodelphax Laodelphax striatellus
30231410 30231410 PRJNA1240804_P_NODE_100532_length_173_cov_1.338710_g100166_i0 PRJNA1240804 100532 173 1.33871 2.3159683 Aphis glycines 307491 Arthropoda Arthropoda 66.2 4.3e-11   NR KAE9522492.1 307491 g100166 i0 71.9 0.988439306358382 57 12 98.8 1 2 172 158 210 KAE9522492.1 hypothetical protein AGLY_017153, partial [Aphis glycines] diamond 171 66.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis glycines
30452874 30452874 PRJNA1240804_P_NODE_147473_length_162_cov_0.920354_g147107_i0 PRJNA1240804 147473 162 0.920354 1.49097348 Aedes albopictus 7160 Arthropoda Arthropoda 45.8 2.34e-4   NR KXJ62421.1 7160 g147107 i0 82.6 1.94444444444444 23 4 42.6 0 15 83 36 58 KXJ62421.1 hypothetical protein RP20_CCG010456 [Aedes albopictus] diamond 315 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
30881490 30881490 PRJNA1240804_P_NODE_83334_length_184_cov_1.459259_g82968_i0 PRJNA1240804 83334 184 1.459259 2.68503656 Tetranychidae 32262 Arthropoda Arthropoda 107 2.13e-25   NR XP_015782449.1 32264 g82968 i0 89.1 1.79347826086957 55 6 89.7 0 16 180 1109 1163 XP_015782449.1 ubiquitin carboxyl-terminal hydrolase 34 [Tetranychus urticae] diamond 330 108 0.990740740740741 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
30895202 30895202 PRJNA1240804_P_NODE_71354_length_192_cov_2.048951_g70988_i0 PRJNA1240804 71354 192 2.048951 3.93398592 Ladona fulva 123851 Arthropoda Arthropoda 42 0.0356   NR KAG8229230.1 123851 g70988 i0 48.8 0.640625 41 19 60.9 1 182 66 125 165 KAG8229230.1 hypothetical protein J437_LFUL001475 [Ladona fulva] diamond 123 42 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Libellulidae Ladona Ladona fulva
31115865 31115865 PRJNA1240804_P_NODE_120795_length_167_cov_0.881356_g120429_i0 PRJNA1240804 120795 167 0.881356 1.47186452 Macrosiphum euphorbiae 13131 Arthropoda Arthropoda 90.9 1.45e-19   NR CAI6377344.1 13131 g120429 i0 82 2.69461077844311 50 9 89.8 0 151 2 1189 1238 CAI6377344.1 unnamed protein product [Macrosiphum euphorbiae] diamond 450 90.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Macrosiphum Macrosiphum euphorbiae
31387443 31387443 PRJNA1240804_P_NODE_113756_length_168_cov_0.873950_g113390_i0 PRJNA1240804 113756 168 0.87395 1.468236 Metazoa 33208 Arthropoda Arthropoda 88.6 9.42e-19   NR XP_063822618.1 29057 g113390 i0 84 16.9464285714286 50 8 89.3 0 14 163 1189 1238 XP_063822618.1 xanthine dehydrogenase [Ostrinia nubilalis] diamond 2847 89.4 0.991051454138702 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Crambidae Ostrinia Ostrinia nubilalis
31432335 31432335 PRJNA1240804_P_NODE_68576_length_195_cov_1.315068_g68210_i0 PRJNA1240804 68576 195 1.315068 2.5643826 Orchesella dallaii 48710 Arthropoda Arthropoda 111 1.07e-26   NR CAL8090728.1 48710 g68210 i0 81 1.93846153846154 63 12 96.9 0 193 5 306 368 CAL8090728.1 unnamed protein product [Orchesella dallaii] diamond 378 111 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella dallaii
31811885 31811885 PRJNA1240804_P_NODE_127177_length_166_cov_0.888889_g126811_i0 PRJNA1240804 127177 166 0.888889 1.47555574 Uroleucon formosanum 796250 Arthropoda Arthropoda 58.9 2.48e-8   NR KAL4098692.1 796250 g126811 i0 65.9 0.740963855421687 41 14 74.1 0 143 21 1005 1045 KAL4098692.1 hypothetical protein QTP88_023242 [Uroleucon formosanum] diamond 123 58.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Uroleucon Uroleucon formosanum
31906830 31906830 PRJNA1240804_P_NODE_72917_length_191_cov_1.781690_g72551_i0 PRJNA1240804 72917 191 1.78169 3.4030279 Dryococelus australis 614101 Arthropoda Arthropoda 53.9 2.14e-6   NR KAJ8887680.1 614101 g72551 i0 58.1 1.53926701570681 43 18 67.5 0 158 30 1085 1127 KAJ8887680.1 hypothetical protein PR048_013898 [Dryococelus australis] diamond 294 53.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Phasmatidae Dryococelus Dryococelus australis
32160067 32160067 PRJNA1240804_P_NODE_119778_length_167_cov_0.881356_g119412_i0 PRJNA1240804 119778 167 0.881356 1.47186452 Daphnia pulex 6669 Arthropoda Arthropoda 58.5 3.5e-8   NR EFX64342.1 6669 g119412 i0 81.1 0.664670658682635 37 6 64.7 1 3 110 362 398 EFX64342.1 hypothetical protein DAPPUDRAFT_334303 [Daphnia pulex] diamond 111 58.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
32191702 32191702 PRJNA1240804_P_NODE_76378_length_189_cov_1.285714_g76012_i0 PRJNA1240804 76378 189 1.285714 2.42999946 Eurosta solidaginis 178769 Arthropoda Arthropoda 46.6 7.75e-4   NR XP_067636852.1 178769 g76012 i0 42.4 2.79365079365079 59 34 93.7 0 179 3 50 108 XP_067636852.1 acid phosphatase type 7 isoform X2 [Eurosta solidaginis] diamond 528 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Eurosta Eurosta solidaginis
32349937 32349937 PRJNA1240804_P_NODE_127339_length_166_cov_0.888889_g126973_i0 PRJNA1240804 127339 166 0.888889 1.47555574 Trichomalopsis sarcophagae 543379 Arthropoda Arthropoda 41.6 0.0346   NR OXU19503.1 543379 g126973 i0 48.5 0.596385542168675 33 17 59.6 0 13 111 75 107 OXU19503.1 hypothetical protein TSAR_013315, partial [Trichomalopsis sarcophagae] diamond 99 41.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Trichomalopsis Trichomalopsis sarcophagae
32431336 32431336 PRJNA1240804_P_NODE_72219_length_192_cov_1.167832_g71853_i0 PRJNA1240804 72219 192 1.167832 2.24223744 Orchesella 48705 Arthropoda Arthropoda 68.6 1.45e-11   NR ODN03721.1 48709 g71853 i0 97.1 1.09375 35 1 54.7 0 106 2 1 35 ODN03721.1 hypothetical protein Ocin01_02951 [Orchesella cincta] diamond 210 68.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
32652023 32652023 PRJNA1240804_P_NODE_148980_length_162_cov_0.920354_g148614_i0 PRJNA1240804 148980 162 0.920354 1.49097348 Tetranychidae 32262 Arthropoda Arthropoda 60.8 4.94e-9   NR XP_015785189.1 32264 g148614 i0 57.7 1.92592592592593 52 16 88.9 2 152 9 450 499 XP_015785189.1 polyadenylate-binding protein 4-like [Tetranychus urticae] diamond 312 61.2 0.993464052287582 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae

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