RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA1218816" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 23 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1218816 · 23 ✖

analysis 1

  • diamond · 23 ✖
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
14362484 14362484 PRJNA1218816_P_NODE_51132_length_260_cov_1.229947_g50699_i0 PRJNA1218816 51132 260 1.229947 3.1978622 Opisthokonta 33154 Arthropoda Arthropoda 131 9.9e-38   NR XP_063231537.1 93214 g50699 i0 81.6 4.43076923076923 76 14 87.7 0 32 259 15 90 XP_063231537.1 small ribosomal subunit protein eS27 [Bacillus rossius redtenbacheri] diamond 1152 132 0.992424242424242 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Bacillidae Bacillus Bacillus rossius
23285706 23285706 PRJNA1218816_P_NODE_50719_length_261_cov_1.638298_g50286_i0 PRJNA1218816 50719 261 1.638298 4.27595778 Metazoa 33208 Arthropoda Arthropoda 159 1.86e-43   NR RXG55144.1 13347 g50286 i0 86.2 18 87 12 100 0 261 1 525 611 RXG55144.1 Transitional endoplasmic reticulum ATPase TER94 [Armadillidium vulgare] diamond 4698 159 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Armadillidiidae Armadillidium Armadillidium vulgare
26870322 26870322 PRJNA1218816_P_NODE_56761_length_248_cov_0.880000_g56328_i0 PRJNA1218816 56761 248 0.88 2.1824 Arthropoda 6656 Arthropoda Arthropoda 94.7 3.59e-22   NR RWS28229.1 299467 g56328 i0 56.3 10.6814516129032 80 34 95.6 1 10 246 1 80 RWS28229.1 60S ribosomal protein L9-like protein [Leptotrombidium deliense] diamond 2649 94.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombiculidae Leptotrombidium Leptotrombidium deliense
27009312 27009312 PRJNA1218816_P_NODE_62222_length_242_cov_0.911243_g61789_i0 PRJNA1218816 62222 242 0.911243 2.20520806 Idotea baltica 82763 Arthropoda Arthropoda 140 2.55e-38   NR MCL4123734.1 82763 g61789 i0 85 0.991735537190083 80 12 99.2 0 241 2 1 80 MCL4123734.1 hypothetical protein [Idotea baltica] diamond 240 140 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
27452158 27452158 PRJNA1218816_P_NODE_42723_length_293_cov_1.050000_g42290_i0 PRJNA1218816 42723 293 1.05 3.0765 Idotea baltica 82763 Arthropoda Arthropoda 165 2.08e-50   NR MCL4171346.1 82763 g42290 i0 81.3 0.982935153583618 96 18 98.3 0 290 3 1 96 MCL4171346.1 hypothetical protein [Idotea baltica] diamond 288 165 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
27830778 27830778 PRJNA1218816_P_NODE_56844_length_248_cov_0.880000_g56411_i0 PRJNA1218816 56844 248 0.88 2.1824 Trichogramma pretiosum 7493 Arthropoda Arthropoda 49.7 1.44e-4   NR XP_014221125.1 7493 g56411 i0 45.9 1.4758064516129 61 33 73.8 0 185 3 751 811 XP_014221125.1 sterile alpha and TIR motif-containing protein 1 [Trichogramma pretiosum] diamond 366 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma pretiosum
27988734 27988734 PRJNA1218816_P_NODE_38005_length_315_cov_2.574380_g37572_i0 PRJNA1218816 38005 315 2.57438 8.109297 Amphibalanus amphitrite 1232801 Arthropoda Arthropoda 47.4 0.00192   NR KAF0286650.1 1232801 g37572 i0 36 2.39047619047619 86 52 81.9 1 13 270 268 350 KAF0286650.1 Protein P [Amphibalanus amphitrite] diamond 753 47.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Balanomorpha Balanidae Amphibalanus Amphibalanus amphitrite
28083331 28083331 PRJNA1218816_P_NODE_60605_length_243_cov_1.811765_g60172_i0 PRJNA1218816 60605 243 1.811765 4.40258895 Zophobas morio 2755281 Arthropoda Arthropoda 59.3 5.29e-8   NR XP_063902575.1 2755281 g60172 i0 41.8 1.95061728395062 79 43 96.3 2 239 6 107 183 XP_063902575.1 uncharacterized protein LOC135122309 [Zophobas morio] diamond 474 59.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Zophobas Zophobas morio
28683495 28683495 PRJNA1218816_P_NODE_39867_length_306_cov_1.317597_g39434_i0 PRJNA1218816 39867 306 1.317597 4.03184682 Idotea baltica 82763 Arthropoda Arthropoda 62 4.53e-10   NR MCL4128028.1 82763 g39434 i0 78.6 0.549019607843137 56 12 54.9 0 169 2 1 56 MCL4128028.1 hypothetical protein [Idotea baltica] diamond 168 62 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
28702204 28702204 PRJNA1218816_P_NODE_54987_length_250_cov_0.870056_g54554_i0 PRJNA1218816 54987 250 0.870056 2.17514 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 44.7 0.00829   NR RVE54491.1 168631 g54554 i0 35.9 2.88 78 48 93.6 1 11 244 38 113 RVE54491.1 hypothetical protein evm_000976 [Chilo suppressalis] diamond 720 45.1 0.991130820399113 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Crambidae Chilo Chilo suppressalis
28714973 28714973 PRJNA1218816_P_NODE_58847_length_245_cov_1.680233_g58414_i0 PRJNA1218816 58847 245 1.680233 4.11657085 Idotea baltica 82763 Arthropoda Arthropoda 136 3.16e-38   NR MCL4117824.1 82763 g58414 i0 75.9 0.96734693877551 79 19 96.7 0 8 244 12 90 MCL4117824.1 hypothetical protein [Idotea baltica] diamond 237 136 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
30104195 30104195 PRJNA1218816_P_NODE_59172_length_245_cov_0.895349_g58739_i0 PRJNA1218816 59172 245 0.895349 2.19360505 Caligus rogercresseyi 217165 Arthropoda Arthropoda 41.2 0.0244   NR QQP40395.1 217165 g58739 i0 55 0.489795918367347 40 12 41.6 1 103 2 1 40 QQP40395.1 Uncharacterized protein FKW44_014416, partial [Caligus rogercresseyi] diamond 120 41.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Caligus Caligus rogercresseyi
30641271 30641271 PRJNA1218816_P_NODE_41613_length_298_cov_0.906667_g41180_i0 PRJNA1218816 41613 298 0.906667 2.70186766 Dermacentor andersoni 34620 Arthropoda Arthropoda 44.3 0.019   NR XP_054934251.1 34620 g41180 i0 46.7 0.453020134228188 45 22 45.3 1 151 17 21 63 XP_054934251.1 polycystic kidney disease protein 1-like 3 isoform X2 [Dermacentor andersoni] diamond 135 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Dermacentor Dermacentor andersoni
30957567 30957567 PRJNA1218816_P_NODE_48554_length_269_cov_1.571429_g48121_i0 PRJNA1218816 48554 269 1.571429 4.22714401 Daphnia pulex 6669 Arthropoda Arthropoda 159 1.1699999999999998e-47   NR EFX61388.1 6669 g48121 i0 93.3 0.992565055762082 89 6 99.3 0 268 2 28 116 EFX61388.1 hypothetical protein DAPPUDRAFT_69734, partial [Daphnia pulex] diamond 267 159 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
31336532 31336532 PRJNA1218816_P_NODE_46636_length_277_cov_1.098039_g46203_i0 PRJNA1218816 46636 277 1.098039 3.04156803 Amyelois transitella 680683 Arthropoda Arthropoda 70.1 1.37e-11   NR XP_060806193.1 680683 g46203 i0 53.8 2.66425992779783 65 30 70.4 0 202 8 600 664 XP_060806193.1 E3 ubiquitin-protein ligase SH3RF1 isoform X2 [Amyelois transitella] diamond 738 70.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pyralidae Amyelois Amyelois transitella
31368536 31368536 PRJNA1218816_P_NODE_55816_length_249_cov_0.875000_g55383_i0 PRJNA1218816 55816 249 0.875 2.17875 Orchesella cincta 48709 Arthropoda Arthropoda 43.9 0.0157   NR ODM96344.1 48709 g55383 i0 43.1 0.867469879518072 72 39 84.3 2 38 247 140 211 ODM96344.1 WD repeat-containing protein 3 [Orchesella cincta] diamond 216 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
31463376 31463376 PRJNA1218816_P_NODE_38316_length_314_cov_0.883817_g37883_i0 PRJNA1218816 38316 314 0.883817 2.77518538 Idotea baltica 82763 Arthropoda Arthropoda 172 6.43e-51   NR MCL4129251.1 82763 g37883 i0 79.8 0.993630573248408 104 21 99.4 0 1 312 78 181 MCL4129251.1 hypothetical protein [Idotea baltica] diamond 312 172 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
31684427 31684427 PRJNA1218816_P_NODE_47497_length_273_cov_1.540000_g47064_i0 PRJNA1218816 47497 273 1.54 4.2042 Idotea baltica 82763 Arthropoda Arthropoda 144 1.0699999999999998e-41   NR MCL4122748.1 82763 g47064 i0 90.1 0.89010989010989 81 8 89 0 29 271 1 81 MCL4122748.1 hypothetical protein [Idotea baltica] diamond 243 144 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
32000935 32000935 PRJNA1218816_P_NODE_51638_length_258_cov_1.454054_g51205_i0 PRJNA1218816 51638 258 1.454054 3.75145932 Idotea baltica 82763 Arthropoda Arthropoda 134 2.32e-38   NR MCL4122273.1 82763 g51205 i0 78.5 1.82558139534884 79 17 91.9 0 3 239 3 81 MCL4122273.1 hypothetical protein [Idotea baltica] diamond 471 134 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
32399561 32399561 PRJNA1218816_P_NODE_27479_length_391_cov_1.452830_g27046_i0 PRJNA1218816 27479 391 1.45283 5.6805653 Opisthokonta 33154 Arthropoda Arthropoda 192 2.84e-57   NR XP_015790521.1 32264 g27046 i0 73.6 34.6419437340153 129 34 99 0 389 3 199 327 XP_015790521.1 eukaryotic initiation factor 4A-I [Tetranychus urticae] diamond 13545 192 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
32444196 32444196 PRJNA1218816_P_NODE_58659_length_246_cov_0.890173_g58226_i0 PRJNA1218816 58659 246 0.890173 2.18982558 Penaeus vannamei 6689 Arthropoda Arthropoda 78.2 1.28e-14   NR XP_069996417.1 6689 g58226 i0 52.1 5.19512195121951 71 33 85.4 1 246 37 189 259 XP_069996417.1 adenylyl cyclase-associated protein 1 isoform X8 [Penaeus vannamei] diamond 1278 78.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
32475732 32475732 PRJNA1218816_P_NODE_21239_length_471_cov_2.701005_g20806_i0 PRJNA1218816 21239 471 2.701005 12.72173355 Diploptera punctata 6984 Arthropoda Arthropoda 256 1.65e-84   NR KAJ9601621.1 6984 g20806 i0 72.7 12.7515923566879 154 42 98.1 0 9 470 5 158 KAJ9601621.1 hypothetical protein L9F63_000229, partial [Diploptera punctata] diamond 6006 256 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blaberidae Diploptera Diploptera punctata
32822344 32822344 PRJNA1218816_P_NODE_58480_length_246_cov_0.890173_g58047_i0 PRJNA1218816 58480 246 0.890173 2.18982558 Leptodora kindtii 77707 Arthropoda Arthropoda 62.4 1.06e-9   NR CAG4645127.1 77707 g58047 i0 40.5 1.02439024390244 84 44 95.1 1 11 244 8 91 CAG4645127.1 EOG090X0DWG [Leptodora kindtii] diamond 252 62.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Leptodoridae Leptodora Leptodora kindtii

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