RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA904835" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA904835 · 15 ✖

analysis 1

  • diamond · 15 ✖
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
26842167 26842167 PRJNA904835_P_NODE_48081_length_262_cov_0.952381_g47825_i0 PRJNA904835 48081 262 0.952381 2.49523822 Insecta 50557 Arthropoda Arthropoda 43.5 0.0255   NR KAF6204719.1 248454 g47825 i0 29.6 1.84351145038168 81 43 91.6 2 2 241 469 536 KAF6204719.1 hypothetical protein GE061_018880 [Apolygus lucorum] diamond 483 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Miridae Apolygus Apolygus lucorum
26929383 26929383 PRJNA904835_P_NODE_50562_length_251_cov_0.865169_g50306_i0 PRJNA904835 50562 251 0.865169 2.17157419 Daphnia pulex 6669 Arthropoda Arthropoda 61.6 8.4e-9   NR EFX60566.1 6669 g50306 i0 45.8 0.860557768924303 72 39 86.1 0 223 8 171 242 EFX60566.1 hypothetical protein DAPPUDRAFT_276763, partial [Daphnia pulex] diamond 216 61.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
27372284 27372284 PRJNA904835_P_NODE_40683_length_296_cov_1.381166_g40427_i0 PRJNA904835 40683 296 1.381166 4.08825136 Dermatophagoides farinae 6954 Arthropoda Arthropoda 61.2 2.24e-8   NR KAH9500988.1 6954 g40427 i0 41.3 1.52027027027027 75 41 73 1 240 25 174 248 KAH9500988.1 RCC1 and BTB domain-containing protein 2 [Dermatophagoides farinae] diamond 450 61.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
27474275 27474275 PRJNA904835_P_NODE_37843_length_311_cov_1.294118_g37587_i0 PRJNA904835 37843 311 1.294118 4.02470698 Arthropoda 6656 Arthropoda Arthropoda 49.7 3.07e-4   NR CAD7250536.1 69355 g37587 i0 38.6 1.03215434083601 57 34 54 1 302 135 417 473 CAD7250536.1 unnamed protein product [Darwinula stevensoni] diamond 321 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Darwinulidae Darwinula Darwinula stevensoni
28350704 28350704 PRJNA904835_P_NODE_46546_length_269_cov_1.178571_g46290_i0 PRJNA904835 46546 269 1.178571 3.17035599 Ixodes scapularis 6945 Arthropoda Arthropoda 49.3 2.54e-4   NR XP_040062790.1 6945 g46290 i0 29.5 4.89591078066915 88 61 97 1 269 9 396 483 XP_040062790.1 uncharacterized protein LOC115319652 isoform X1 [Ixodes scapularis] diamond 1317 49.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis
28389841 28389841 PRJNA904835_P_NODE_30266_length_357_cov_1.084507_g30010_i0 PRJNA904835 30266 357 1.084507 3.87168999 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 101 1.2500000000000001e-22   NR CAL4198643.1 48144 g30010 i0 41.7 12.9159663865546 120 69 100 1 1 357 6 125 CAL4198643.1 unnamed protein product [Meganyctiphanes norvegica] diamond 4611 102 0.990196078431373 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
28863416 28863416 PRJNA904835_P_NODE_33688_length_334_cov_2.042146_g33432_i0 PRJNA904835 33688 334 2.042146 6.82076764 Metazoa 33208 Arthropoda Arthropoda 48.5 9.55e-4   NR XP_061502374.1 7165 g33432 i0 31 2.16467065868263 87 59 78.1 1 59 319 264 349 XP_061502374.1 uncharacterized protein LOC133391534 isoform X1 [Anopheles gambiae] diamond 723 48.9 0.991820040899796 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles gambiae
29779113 29779113 PRJNA904835_P_NODE_24791_length_400_cov_1.412844_g24536_i0 PRJNA904835 24791 400 1.412844 5.651376 Metazoa 33208 Arthropoda Arthropoda 104 1.03e-23   NR XP_027220763.1 6689 g24536 i0 43.9 10.935 132 71 98.3 2 8 400 160 289 XP_027220763.1 uncharacterized protein [Penaeus vannamei] diamond 4374 105 0.990476190476191 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
29834720 29834720 PRJNA904835_P_NODE_37551_length_313_cov_0.925000_g37295_i0 PRJNA904835 37551 313 0.925 2.89525 Armadillidium vulgare 13347 Arthropoda Arthropoda 45.8 0.0034   NR RXG54364.1 13347 g37295 i0 64.5 3.21086261980831 31 11 29.7 0 95 3 13 43 RXG54364.1 Ras-related protein Rab-11A [Armadillidium vulgare] diamond 1005 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Armadillidiidae Armadillidium Armadillidium vulgare
29898042 29898042 PRJNA904835_P_NODE_54951_length_246_cov_0.890173_g54695_i0 PRJNA904835 54951 246 0.890173 2.18982558 Sabethes cyaneus 53552 Arthropoda Arthropoda 70.5 2.85e-12   NR XP_053695743.1 53552 g54695 i0 45.7 0.853658536585366 70 38 85.4 0 29 238 18 87 XP_053695743.1 trypsin-1-like [Sabethes cyaneus] diamond 210 70.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Sabethes Sabethes cyaneus
30150443 30150443 PRJNA904835_P_NODE_43192_length_284_cov_1.824645_g42936_i0 PRJNA904835 43192 284 1.824645 5.1819918 Diachasmimorpha longicaudata 58733 Arthropoda Arthropoda 47.4 0.00135   NR XP_063978042.1 58733 g42936 i0 37.5 1.85915492957746 88 49 89.8 3 280 26 140 224 XP_063978042.1 leucine-rich repeat-containing protein 19 [Diachasmimorpha longicaudata] diamond 528 47.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Diachasmimorpha Diachasmimorpha longicaudata
30245656 30245656 PRJNA904835_P_NODE_19612_length_457_cov_2.145833_g19357_i0 PRJNA904835 19612 457 2.145833 9.80645681 Carabus blaptoides fortunei 49296 Arthropoda Arthropoda 45.4 0.0338   NR GLV32812.1 49296 g19357 i0 35.2 0.577680525164114 88 50 53.2 3 251 9 347 434 GLV32812.1 S-phase kinase-associated protein 2 [Carabus blaptoides fortunei] diamond 264 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Carabidae Carabus Carabus blaptoides
30245670 30245670 PRJNA904835_P_NODE_42592_length_287_cov_1.079439_g42336_i0 PRJNA904835 42592 287 1.079439 3.09798993 Brassicogethes aeneus 1431903 Arthropoda Arthropoda 43.1 0.0245   NR CAH0559111.1 1431903 g42336 i0 35.1 0.59581881533101 57 30 59.6 1 111 281 57 106 CAH0559111.1 unnamed protein product [Brassicogethes aeneus] diamond 171 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Nitidulidae Brassicogethes Brassicogethes aeneus
31643502 31643502 PRJNA904835_P_NODE_12416_length_598_cov_1.544762_g12169_i0 PRJNA904835 12416 598 1.544762 9.23767676 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 65.1 1.9e-8   NR XP_059090240.1 6832 g12169 i0 28.8 7.37458193979933 219 106 93.8 8 561 1 251 451 XP_059090240.1 copine-8-like [Tigriopus californicus] diamond 4410 65.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
32427113 32427113 PRJNA904835_P_NODE_56399_length_244_cov_0.900585_g56143_i0 PRJNA904835 56399 244 0.900585 2.1974274 Medioppia subpectinata 1979941 Arthropoda Arthropoda 106 3.34e-27   NR CAD7651681.1 1979941 g56143 i0 63.8 1.9672131147541 80 29 98.4 0 241 2 37 116 CAD7651681.1 unnamed protein product, partial [Medioppia subpectinata] diamond 480 106 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata

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