RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA674048" 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

  • PRJNA674048 · 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
5746532 5746532 PRJNA674048_P_NODE_18265_length_207_cov_1.924051_g18062_i0 PRJNA674048 18265 207 1.924051 3.98278557 Metazoa 33208 Arthropoda Arthropoda 86.3 6.41e-19   NR CAG7724150.1 39272 g18062 i0 75.4 3.63768115942029 61 15 88.4 0 185 3 140 200 CAG7724150.1 unnamed protein product [Allacma fusca] diamond 753 86.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
7543858 7543858 PRJNA674048_P_NODE_21426_length_190_cov_1.475177_g21223_i0 PRJNA674048 21426 190 1.475177 2.8028363 Culicoides brevitarsis 469753 Arthropoda Arthropoda 100 2.4699999999999994e-23   NR XP_063706923.1 469753 g21223 i0 71.4 0.994736842105263 63 18 99.5 0 189 1 310 372 XP_063706923.1 obg-like ATPase 1 [Culicoides brevitarsis] diamond 189 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides brevitarsis
13397168 13397168 PRJNA674048_P_NODE_17231_length_214_cov_1.569697_g17028_i0 PRJNA674048 17231 214 1.569697 3.35915158 Harmonia axyridis 115357 Arthropoda Arthropoda 110 2.7600000000000004e-27   NR XP_045463351.1 115357 g17028 i0 86.5 0.728971962616822 52 7 72.9 0 2 157 285 336 XP_045463351.1 cathepsin B [Harmonia axyridis] diamond 156 110 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Harmonia Harmonia axyridis
25392492 25392492 PRJNA674048_P_NODE_26780_length_169_cov_1.733333_g26577_i0 PRJNA674048 26780 169 1.733333 2.92933277 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 93.6 1.01e-22   NR EDW49508.1 7238 g26577 i0 83.9 27.5680473372781 56 9 99.4 0 1 168 82 137 EDW49508.1 GM12998 [Drosophila sechellia] diamond 4659 94 0.995744680851064 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila sechellia
26650329 26650329 PRJNA674048_P_NODE_21901_length_188_cov_1.474820_g21698_i0 PRJNA674048 21901 188 1.47482 2.7726616 Metazoa 33208 Arthropoda Arthropoda 58.5 4.8e-8   NR ODN05821.1 48709 g21698 i0 46.9 3.03191489361702 64 32 98.9 1 187 2 622 685 ODN05821.1 Indole-3-acetaldehyde oxidase [Orchesella cincta] diamond 570 58.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
26967062 26967062 PRJNA674048_P_NODE_30642_length_164_cov_1.808696_g30439_i0 PRJNA674048 30642 164 1.808696 2.96626144 Arthropoda 6656 Arthropoda Arthropoda 77.8 6.73e-16   NR CAD7245222.1 69355 g30439 i0 57.4 5.90853658536585 54 23 98.8 0 1 162 93 146 CAD7245222.1 unnamed protein product [Darwinula stevensoni] diamond 969 77.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Darwinulidae Darwinula Darwinula stevensoni
27219887 27219887 PRJNA674048_P_NODE_20362_length_195_cov_1.780822_g20159_i0 PRJNA674048 20362 195 1.780822 3.4726029 Diptera 7147 Arthropoda Arthropoda 95.1 1.98e-22   NR XP_061392136.1 27455 g20159 i0 78.1 5.90769230769231 64 14 98.5 0 2 193 2 65 XP_061392136.1 small ribosomal subunit protein eS8-like, partial [Musca vetustissima] diamond 1152 95.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Musca Musca vetustissima
27555480 27555480 PRJNA674048_P_NODE_31104_length_164_cov_0.904348_g30901_i0 PRJNA674048 31104 164 0.904348 1.48313072 Acromyrmex insinuator 230686 Arthropoda Arthropoda 52.4 5.08e-6   NR KAG5310177.1 230686 g30901 i0 48.1 0.98780487804878 54 27 98.8 1 2 163 179 231 KAG5310177.1 MY61F protein, partial [Acromyrmex insinuator] diamond 162 52.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Acromyrmex Acromyrmex insinuator
27694214 27694214 PRJNA674048_P_NODE_29144_length_166_cov_1.401709_g28941_i0 PRJNA674048 29144 166 1.401709 2.32683694 Metazoa 33208 Arthropoda Arthropoda 81.6 2.77e-17   NR TRY62750.1 6832 g28941 i0 70.6 2.76506024096386 51 15 92.2 0 166 14 168 218 TRY62750.1 hypothetical protein TCAL_04938, partial [Tigriopus californicus] diamond 459 82 0.995121951219512 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
27978023 27978023 PRJNA674048_P_NODE_23725_length_180_cov_2.694656_g23522_i0 PRJNA674048 23725 180 2.694656 4.8503808 Arthropoda 6656 Arthropoda Arthropoda 81.3 1.01e-16   NR YP_009652506.1 411872 g23522 i0 61 15.65 59 23 98.3 0 3 179 136 194 YP_009652506.1 cytochrome c oxidase subunit III [Sarcophaga princeps] diamond 2817 81.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sarcophagidae Sarcophaga Sarcophaga princeps
28735900 28735900 PRJNA674048_P_NODE_19187_length_202_cov_1.019608_g18984_i0 PRJNA674048 19187 202 1.019608 2.05960816 Opisthokonta 33154 Arthropoda Arthropoda 116 6.289999999999999e-31   NR KAJ9601621.1 6984 g18984 i0 77.3 45.0891089108911 66 15 98 0 3 200 83 148 KAJ9601621.1 hypothetical protein L9F63_000229, partial [Diploptera punctata] diamond 9108 116 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blaberidae Diploptera Diploptera punctata
28913124 28913124 PRJNA674048_P_NODE_24348_length_178_cov_1.612403_g24145_i0 PRJNA674048 24348 178 1.612403 2.87007734 Phlebotomus papatasi 29031 Arthropoda Arthropoda 70.9 9.49e-13   NR XP_055712420.1 29031 g24145 i0 64.4 0.99438202247191 59 21 99.4 0 178 2 87 145 XP_055712420.1 60S ribosomal protein L7a [Phlebotomus papatasi] diamond 177 70.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Phlebotomus Phlebotomus papatasi
29544722 29544722 PRJNA674048_P_NODE_8370_length_334_cov_1.824561_g8167_i0 PRJNA674048 8370 334 1.824561 6.09403374 Zophobas morio 2755281 Arthropoda Arthropoda 93.6 3.29e-20   NR XP_063933621.1 2755281 g8167 i0 53.5 0.772455089820359 86 31 77.2 1 12 269 124 200 XP_063933621.1 uncharacterized protein LOC135145439 [Zophobas morio] diamond 258 93.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Zophobas Zophobas morio
29765713 29765713 PRJNA674048_P_NODE_19331_length_201_cov_1.368421_g19128_i0 PRJNA674048 19331 201 1.368421 2.75052621 Hyalomma asiaticum 266040 Arthropoda Arthropoda 57.8 1.02e-7   NR KAH6948244.1 266040 g19128 i0 45.5 1.67164179104478 55 28 82.1 1 167 3 90 142 KAH6948244.1 hypothetical protein HPB50_023292 [Hyalomma asiaticum] diamond 336 57.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Hyalomma Hyalomma asiaticum
29840987 29840987 PRJNA674048_P_NODE_14191_length_239_cov_1.431579_g13988_i0 PRJNA674048 14191 239 1.431579 3.42147381 Metazoa 33208 Arthropoda Arthropoda 51.6 1.73e-5   NR XP_019760172.1 77166 g13988 i0 68.8 0.828451882845188 32 10 40.2 0 238 143 175 206 XP_019760172.1 60S ribosomal protein L10 [Dendroctonus ponderosae] diamond 198 51.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Dendroctonus Dendroctonus ponderosae
30524078 30524078 PRJNA674048_P_NODE_30273_length_165_cov_0.896552_g30070_i0 PRJNA674048 30273 165 0.896552 1.4793108 Aricia agestis 91739 Arthropoda Arthropoda 50.8 1.47e-5   NR XP_041975438.1 91739 g30070 i0 42.6 0.981818181818182 54 27 98.2 1 3 164 50 99 XP_041975438.1 GILT-like protein 2 [Aricia agestis] diamond 162 50.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Aricia Aricia agestis
31061459 31061459 PRJNA674048_P_NODE_30715_length_164_cov_1.356522_g30512_i0 PRJNA674048 30715 164 1.356522 2.22469608 Idotea baltica 82763 Arthropoda Arthropoda 82.8 1.05e-18   NR MCL4116823.1 82763 g30512 i0 81.1 2.8719512195122 53 10 97 0 164 6 32 84 MCL4116823.1 hypothetical protein [Idotea baltica] diamond 471 82.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
31092825 31092825 PRJNA674048_P_NODE_22835_length_184_cov_1.437037_g22632_i0 PRJNA674048 22835 184 1.437037 2.64414808 Eciton burchellii 213866 Arthropoda Arthropoda 60.8 6.99e-9   NR KAH0946776.1 213866 g22632 i0 46.9 4.72826086956522 64 30 97.8 1 5 184 673 736 KAH0946776.1 hypothetical protein HN011_012233 [Eciton burchellii] diamond 870 60.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Eciton Eciton burchellii
31484420 31484420 PRJNA674048_P_NODE_31396_length_163_cov_1.824561_g31193_i0 PRJNA674048 31396 163 1.824561 2.97403443 Metazoa 33208 Arthropoda Arthropoda 96.3 1.7700000000000003e-21   NR AAR01305.1 85135 g31193 i0 72.2 35.5950920245399 54 15 99.4 0 162 1 619 672 AAR01305.1 elongation factor-2, partial [Nebalia hessleri] diamond 5802 97.1 0.991761071060762 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Leptostraca Nebaliidae Nebalia Nebalia hessleri
32168424 32168424 PRJNA674048_P_NODE_24898_length_176_cov_1.566929_g24695_i0 PRJNA674048 24898 176 1.566929 2.75779504 Ctenocephalides felis 7515 Arthropoda Arthropoda 84.3 3.1e-17   NR XP_026470148.1 7515 g24695 i0 77.2 3.88636363636364 57 13 97.2 0 176 6 20 76 XP_026470148.1 retinal dehydrogenase 2-like [Ctenocephalides felis] diamond 684 84.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Siphonaptera Pulicidae Ctenocephalides Ctenocephalides felis
32263410 32263410 PRJNA674048_P_NODE_1098_length_1115_cov_6.290807_g997_i0 PRJNA674048 1098 1115 6.290807 70.14249805 Caligus rogercresseyi 217165 Arthropoda Arthropoda 132 1.4799999999999998e-32   NR QQP41656.1 217165 g997 i0 33.2 0.559641255605381 208 127 54.3 4 785 180 14 215 QQP41656.1 Hypothetical protein FKW44_016099, partial [Caligus rogercresseyi] diamond 624 132 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Caligus Caligus rogercresseyi
32465056 32465056 PRJNA674048_P_NODE_12459_length_259_cov_0.990476_g12256_i0 PRJNA674048 12459 259 0.990476 2.56533284 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 69.7 1.2e-11   NR KAK7605420.1 536013 g12256 i0 50 3.06949806949807 70 33 81.1 2 255 46 284 351 KAK7605420.1 hypothetical protein V9T40_007278 [Parthenolecanium corni] diamond 795 69.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Coccidae Parthenolecanium Parthenolecanium corni
32579664 32579664 PRJNA674048_P_NODE_28079_length_168_cov_0.873950_g27876_i0 PRJNA674048 28079 168 0.87395 1.468236 Pseudolycoriella hygida 35572 Arthropoda Arthropoda 66.6 5e-11   NR KAJ6644053.1 35572 g27876 i0 86.1 1.92857142857143 36 5 64.3 0 109 2 246 281 KAJ6644053.1 Xanthine dehydrogenase [Pseudolycoriella hygida] diamond 324 66.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida

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