RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA675638" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA675638 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
26650388 26650388 PRJNA675638_P_NODE_21661_length_162_cov_0.902655_g21464_i0 PRJNA675638 21661 162 0.902655 1.4623011 Arthropoda 6656 Arthropoda Arthropoda 47.8 2.14e-4   NR YP_010254291.1 1504851 g21464 i0 58.8 2.55555555555556 34 14 63 0 141 40 149 182 YP_010254291.1 NADH dehydrogenase subunit 2 [Micromus paganus] diamond 414 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Neuroptera Hemerobiidae Micromus Micromus paganus
27081949 27081949 PRJNA675638_P_NODE_19282_length_165_cov_1.318966_g19085_i0 PRJNA675638 19282 165 1.318966 2.1762939 Orchesella cincta 48709 Arthropoda Arthropoda 105 1.0099999999999999e-24   NR ODN03788.1 48709 g19085 i0 83.3 0.981818181818182 54 9 98.2 0 163 2 1474 1527 ODN03788.1 Vitellogenin-2 [Orchesella cincta] diamond 162 105 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
27124978 27124978 PRJNA675638_P_NODE_16482_length_177_cov_0.796875_g16285_i0 PRJNA675638 16482 177 0.796875 1.41046875 Metazoa 33208 Arthropoda Arthropoda 45.1 0.00233   NR KXJ83924.1 7160 g16285 i0 46.2 3.10169491525424 39 21 66.1 0 170 54 372 410 KXJ83924.1 hypothetical protein RP20_CCG026951 [Aedes albopictus] diamond 549 45.4 0.993392070484582 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
27587559 27587559 PRJNA675638_P_NODE_8644_length_236_cov_1.363636_g8447_i0 PRJNA675638 8644 236 1.363636 3.21818096 Orchesella cincta 48709 Arthropoda Arthropoda 62.8 3.01e-9   NR ODN01242.1 48709 g8447 i0 44.3 0.889830508474576 70 36 89 1 227 18 1423 1489 ODN01242.1 Vitellogenin [Orchesella cincta] diamond 210 62.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
27714173 27714173 PRJNA675638_P_NODE_16364_length_177_cov_1.593750_g16167_i0 PRJNA675638 16364 177 1.59375 2.8209375 Daphnia magna 35525 Arthropoda Arthropoda 40.8 0.0121   NR KZR97555.1 35525 g16167 i0 73.9 0.389830508474576 23 6 39 0 158 90 2 24 KZR97555.1 Uncharacterized protein APZ42_007495, partial [Daphnia magna] diamond 69 40.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
28787059 28787059 PRJNA675638_S_NODE_8207_length_165_cov_0.879310_g8145_i0 PRJNA675638 8207 165 0.87931 1.4508615 Hyposmocoma kahamanoa 1477025 Arthropoda Arthropoda 51.6 8.56e-6   NR XP_026317310.1 1477025 g8145 i0 50 0.909090909090909 50 25 90.9 0 2 151 209 258 XP_026317310.1 zinc finger protein 77-like [Hyposmocoma kahamanoa] diamond 150 51.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Cosmopterigidae Hyposmocoma Hyposmocoma kahamanoa
29166359 29166359 PRJNA675638_S_NODE_9189_length_161_cov_0.910714_g9127_i0 PRJNA675638 9189 161 0.910714 1.46624954 Chelonus insularis 460826 Arthropoda Arthropoda 41.2 0.0437   NR XP_034944548.1 460826 g9127 i0 48.6 0.68944099378882 37 19 68.9 0 4 114 154 190 XP_034944548.1 uncharacterized protein [Chelonus insularis] diamond 111 41.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Chelonus Chelonus insularis
30050169 30050169 PRJNA675638_P_NODE_18691_length_166_cov_1.205128_g18494_i0 PRJNA675638 18691 166 1.205128 2.00051248 Stegodyphus dumicola 202533 Arthropoda Arthropoda 40.8 0.0191   NR XP_035223309.1 202533 g18494 i0 80 0.903614457831325 20 4 36.1 0 31 90 40 59 XP_035223309.1 cystatin-A2-like [Stegodyphus dumicola] diamond 150 40.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus dumicola
30347033 30347033 PRJNA675638_P_NODE_19512_length_165_cov_0.879310_g19315_i0 PRJNA675638 19512 165 0.87931 1.4508615 Orchesella 48705 Arthropoda Arthropoda 78.6 1.32e-15   NR ODM94878.1 48709 g19315 i0 57.4 1.96363636363636 54 23 98.2 0 162 1 44 97 ODM94878.1 28S ribosomal protein S15, mitochondrial [Orchesella cincta] diamond 324 79 0.994936708860759 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
30587313 30587313 PRJNA675638_P_NODE_14593_length_188_cov_0.971223_g14396_i0 PRJNA675638 14593 188 0.971223 1.82589924 Ornithodoros turicata 34597 Arthropoda Arthropoda 42.4 0.00862   NR XP_064469462.1 34597 g14396 i0 39.3 0.973404255319149 61 32 89.4 1 4 171 46 106 XP_064469462.1 uncharacterized protein LOC135384166 [Ornithodoros turicata] diamond 183 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Argasidae Ornithodoros Ornithodoros turicata
31662016 31662016 PRJNA675638_S_NODE_9197_length_161_cov_0.910714_g9135_i0 PRJNA675638 9197 161 0.910714 1.46624954 Hermetia illucens 343691 Arthropoda Arthropoda 46.6 5.28e-4   NR XP_037921804.1 343691 g9135 i0 46.7 1.58385093167702 45 24 83.9 0 2 136 190 234 XP_037921804.1 zinc finger protein 112-like isoform X2 [Hermetia illucens] diamond 255 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Stratiomyidae Hermetia Hermetia illucens
32453445 32453445 PRJNA675638_P_NODE_7939_length_245_cov_1.229592_g7742_i0 PRJNA675638 7939 245 1.229592 3.0125004 Orchesella cincta 48709 Arthropoda Arthropoda 58.2 1.44e-7   NR ODN01242.1 48709 g7742 i0 40.3 1.8734693877551 77 41 93.1 4 245 18 1620 1692 ODN01242.1 Vitellogenin [Orchesella cincta] diamond 459 58.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
32831553 32831553 PRJNA675638_S_NODE_5880_length_187_cov_1.043478_g5818_i0 PRJNA675638 5880 187 1.043478 1.95130386 Trichonephila clavipes 2585209 Arthropoda Arthropoda 40.8 0.0471   NR GFU75740.1 2585209 g5818 i0 56.7 0.481283422459893 30 13 48.1 0 59 148 110 139 GFU75740.1 hypothetical protein TNCV_1652001 [Trichonephila clavipes] diamond 90 40.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes

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