RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA1247234" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1247234 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
22028299 22028299 PRJNA1247234_P_NODE_27778_length_242_cov_0.923077_g27622_i0 PRJNA1247234 27778 242 0.923077 2.23384634 Metazoa 33208 Arthropoda Arthropoda 144 7.109999999999999e-38   NR CAK1545824.1 320188 g27622 i0 77.5 48.5826446280992 80 18 99.2 0 240 1 519 598 CAK1545824.1 unnamed protein product [Leptosia nina] diamond 11757 145 0.993103448275862 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pieridae Leptosia Leptosia nina
26616857 26616857 PRJNA1247234_P_NODE_17541_length_271_cov_1.181818_g17385_i0 PRJNA1247234 17541 271 1.181818 3.20272678 Metazoa 33208 Arthropoda Arthropoda 118 5.309999999999999e-31   NR XP_037040187.1 38358 g17385 i0 61.1 3.98523985239852 90 35 99.6 0 1 270 110 199 XP_037040187.1 protein D2-like [Bradysia coprophila] diamond 1080 118 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
26978633 26978633 PRJNA1247234_P_NODE_10242_length_339_cov_0.879699_g10086_i0 PRJNA1247234 10242 339 0.879699 2.98217961 Diaphorina citri 121845 Arthropoda Arthropoda 216 1.67e-62   NR XP_026687174.1 121845 g10086 i0 98.2 16.646017699115 112 2 99.1 0 338 3 1013 1124 XP_026687174.1 splicing factor 3B subunit 1 [Diaphorina citri] diamond 5643 216 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
27028445 27028445 PRJNA1247234_P_NODE_27482_length_242_cov_1.207101_g27326_i0 PRJNA1247234 27482 242 1.207101 2.92118442 Metazoa 33208 Arthropoda Arthropoda 80.1 2.56e-15   NR CAG4640192.1 6669 g27326 i0 97.5 147.768595041322 40 1 49.6 0 120 1 294 333 CAG4640192.1 EOG090X09LE [Daphnia pulex] diamond 35760 80.9 0.990111248454882 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
27186327 27186327 PRJNA1247234_P_NODE_12842_length_309_cov_1.322034_g12686_i0 PRJNA1247234 12842 309 1.322034 4.08508506 Metazoa 33208 Arthropoda Arthropoda 202 9e-63   NR KAK2713525.1 6661 g12686 i0 98 207.961165048544 102 2 99 0 308 3 23 124 KAK2713525.1 hypothetical protein QYM36_009412 [Artemia franciscana] diamond 64260 204 0.990196078431373 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
27926424 27926424 PRJNA1247234_P_NODE_26125_length_244_cov_0.912281_g25969_i0 PRJNA1247234 26125 244 0.912281 2.22596564 Bicyclus anynana 110368 Arthropoda Arthropoda 42.7 0.0386   NR XP_052737499.1 110368 g25969 i0 42.3 0.639344262295082 52 27 60.2 1 41 187 250 301 XP_052737499.1 uncharacterized protein LOC112044118 isoform X4 [Bicyclus anynana] diamond 156 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Bicyclus Bicyclus anynana
28178765 28178765 PRJNA1247234_P_NODE_3366_length_533_cov_5.067391_g3215_i0 PRJNA1247234 3366 533 5.067391 27.00919403 Dinothrombium tinctorium 1965070 Arthropoda Arthropoda 48.5 0.00333   NR RWS01221.1 1965070 g3215 i0 70.6 0.574108818011257 34 10 19.1 0 432 533 50 83 RWS01221.1 26S protease regulatory subunit 7-like protein, partial [Dinothrombium tinctorium] diamond 306 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombidiidae Dinothrombium Dinothrombium tinctorium
28652666 28652666 PRJNA1247234_P_NODE_6647_length_403_cov_0.945455_g6491_i0 PRJNA1247234 6647 403 0.945455 3.81018365 Trichonephila clavata 2740835 Arthropoda Arthropoda 53.9 2.69e-5   NR GFQ91725.1 2740835 g6491 i0 58.8 1.9727047146402 34 14 25.3 0 402 301 732 765 GFQ91725.1 zinc finger protein [Trichonephila clavata] diamond 795 53.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavata
29283926 29283926 PRJNA1247234_P_NODE_24569_length_247_cov_0.896552_g24413_i0 PRJNA1247234 24569 247 0.896552 2.21448344 Anopheles maculipalpis 1496333 Arthropoda Arthropoda 45.4 0.00432   NR XP_050074624.1 1496333 g24413 i0 40 0.668016194331984 55 27 66.8 1 177 13 216 264 XP_050074624.1 uncharacterized protein LOC126562222 [Anopheles maculipalpis] diamond 165 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles maculipalpis
29473262 29473262 PRJNA1247234_P_NODE_19810_length_254_cov_1.712707_g19654_i0 PRJNA1247234 19810 254 1.712707 4.35027578 Nicrophorus vespilloides 110193 Arthropoda Arthropoda 50.4 8.01e-5   NR XP_017773676.1 110193 g19654 i0 66.7 0.696850393700787 30 10 35.4 0 253 164 447 476 XP_017773676.1 PREDICTED: zinc finger protein 271-like isoform X2 [Nicrophorus vespilloides] diamond 177 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Silphidae Nicrophorus Nicrophorus vespilloides
29789134 29789134 PRJNA1247234_P_NODE_9831_length_344_cov_1.439114_g9675_i0 PRJNA1247234 9831 344 1.439114 4.95055216 Cinara cedri 506608 Arthropoda Arthropoda 85.9 7.69e-17   NR VVC37549.1 506608 g9675 i0 36.3 0.88953488372093 102 64 89 1 8 313 359 459 VVC37549.1 Major facilitator superfamily,Major facilitator superfamily domain [Cinara cedri] diamond 306 85.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Cinara Cinara cedri
29902227 29902227 PRJNA1247234_P_NODE_27091_length_243_cov_0.917647_g26935_i0 PRJNA1247234 27091 243 0.917647 2.22988221 Ixodidae 6939 Arthropoda Arthropoda 107 1.75e-28   NR XP_050036737.1 34620 g26935 i0 69.4 6.09876543209877 72 22 88.9 0 28 243 1 72 XP_050036737.1 barrier-to-autointegration factor-like [Dermacentor andersoni] diamond 1482 108 0.990740740740741 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Dermacentor Dermacentor andersoni
30091483 30091483 PRJNA1247234_P_NODE_11692_length_322_cov_1.160643_g11536_i0 PRJNA1247234 11692 322 1.160643 3.73727046 Metazoa 33208 Arthropoda Arthropoda 229 1.93e-72   NR XP_022250218.1 6850 g11536 i0 100 156.037267080745 106 0 98.8 0 3 320 196 301 XP_022250218.1 serine/threonine-protein phosphatase PP1-beta catalytic subunit-like [Limulus polyphemus] diamond 50244 229 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
30628591 30628591 PRJNA1247234_P_NODE_21433_length_251_cov_0.876404_g21277_i0 PRJNA1247234 21433 251 0.876404 2.19977404 Metazoa 33208 Arthropoda Arthropoda 181 9.39e-52   NR XP_065581290.1 6661 g21277 i0 97.6 441.454183266932 83 2 99.2 0 2 250 116 198 XP_065581290.1 mothers against decapentaplegic homolog 4-like isoform X3 [Artemia franciscana] diamond 110805 182 0.994505494505495 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
31355775 31355775 PRJNA1247234_P_NODE_24756_length_246_cov_0.901734_g24600_i0 PRJNA1247234 24756 246 0.901734 2.21826564 Metazoa 33208 Arthropoda Arthropoda 73.6 3.81e-14   NR XP_037088835.1 41117 g24600 i0 56.7 1.48780487804878 60 26 73.2 0 181 2 1 60 XP_037088835.1 LOW QUALITY PROTEIN: SOSS complex subunit B2-like [Pollicipes pollicipes] diamond 366 73.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Pollicipedomorpha Pollicipedidae Pollicipes Pollicipes pollicipes
31464297 31464297 PRJNA1247234_P_NODE_8056_length_372_cov_1.043478_g7900_i0 PRJNA1247234 8056 372 1.043478 3.88173816 Habropoda laboriosa 597456 Arthropoda Arthropoda 67 5.36e-10   NR KOC58549.1 597456 g7900 i0 61.5 0.419354838709677 52 20 41.9 0 203 358 1992 2043 KOC58549.1 DNA ligase [Habropoda laboriosa] diamond 156 67 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Habropoda Habropoda laboriosa
32001806 32001806 PRJNA1247234_P_NODE_22138_length_250_cov_0.881356_g21982_i0 PRJNA1247234 22138 250 0.881356 2.20339 Operophtera brumata 104452 Arthropoda Arthropoda 105 4.73e-25   NR KOB79179.1 104452 g21982 i0 67.1 8.556 70 23 84 0 39 248 2 71 KOB79179.1 Alanine aminotransferase [Operophtera brumata] diamond 2139 105 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Operophtera Operophtera brumata
32350051 32350051 PRJNA1247234_P_NODE_3999_length_497_cov_1.165094_g3848_i0 PRJNA1247234 3999 497 1.165094 5.79051718 Glossina fuscipes 7396 Arthropoda Arthropoda 83.6 3.35e-15   NR KAI9585798.1 7396 g3848 i0 31.7 2.7102615694165 145 97 87.5 1 28 462 499 641 KAI9585798.1 hypothetical protein GQX74_001645 [Glossina fuscipes] diamond 1347 83.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina fuscipes
32634028 32634028 PRJNA1247234_P_NODE_16560_length_278_cov_1.482927_g16404_i0 PRJNA1247234 16560 278 1.482927 4.12253706 Zophobas morio 2755281 Arthropoda Arthropoda 124 1.6499999999999998e-30   NR KAJ3634396.1 2755281 g16404 i0 70.1 4.65107913669065 87 26 93.9 0 1 261 797 883 KAJ3634396.1 hypothetical protein Zmor_019115, partial [Zophobas morio] diamond 1293 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Zophobas Zophobas morio
32715284 32715284 PRJNA1247234_P_NODE_25640_length_245_cov_0.906977_g25484_i0 PRJNA1247234 25640 245 0.906977 2.22209365 Opisthokonta 33154 Arthropoda Arthropoda 135 7.45e-35   NR XP_014600815.1 91411 g25484 i0 78.8 21.5510204081633 80 17 98 0 243 4 276 355 XP_014600815.1 PREDICTED: lysine--tRNA ligase isoform X1 [Polistes canadensis] diamond 5280 136 0.992647058823529 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Polistes Polistes canadensis

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