RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA1200128" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1200128 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
26996367 26996367 PRJNA1200128_S_NODE_6762_length_286_cov_1.547325_g6653_i0 PRJNA1200128 6762 286 1.547325 4.4253495 Metazoa 33208 Arthropoda Arthropoda 65.9 3.34e-11   NR XP_037775466.1 6687 g6653 i0 76.2 73.027972027972 42 10 44.1 0 188 63 34 75 XP_037775466.1 LOW QUALITY PROTEIN: ADP-ribosylation factor-like protein 8B-A [Penaeus monodon] diamond 20886 66.2 0.995468277945619 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus monodon
28493835 28493835 PRJNA1200128_S_NODE_6447_length_290_cov_1.259109_g6338_i0 PRJNA1200128 6447 290 1.259109 3.6514161 Penaeus vannamei 6689 Arthropoda Arthropoda 43.9 0.0245   NR ROT75154.1 6689 g6338 i0 53.6 1.00344827586207 97 31 90 6 28 288 122 214 ROT75154.1 hypothetical protein C7M84_006299 [Penaeus vannamei] diamond 291 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
28683345 28683345 PRJNA1200128_S_NODE_20427_length_202_cov_3.779874_g20318_i0 PRJNA1200128 20427 202 3.779874 7.63534548 Anthophora plagiata 597819 Arthropoda Arthropoda 43.9 0.00841   NR CAK9813121.1 597819 g20318 i0 48.6 2.5990099009901 35 18 52 0 148 44 222 256 CAK9813121.1 Transposable element Tc1 transposase [Anthophora plagiata] diamond 525 44.3 0.99097065462754 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Anthophora Anthophora plagiata
28796586 28796586 PRJNA1200128_S_NODE_19207_length_206_cov_1.460123_g19098_i0 PRJNA1200128 19207 206 1.460123 3.00785338 Arthropoda 6656 Arthropoda Arthropoda 53.9 2.64e-6   NR XP_053699373.1 53552 g19098 i0 39.7 5.14077669902913 58 35 84.5 0 19 192 559 616 XP_053699373.1 zinc finger protein 208-like [Sabethes cyaneus] diamond 1059 53.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Sabethes Sabethes cyaneus
29314675 29314675 PRJNA1200128_S_NODE_1189_length_635_cov_2.027027_g1100_i0 PRJNA1200128 1189 635 2.027027 12.87162145 Caligus rogercresseyi 217165 Arthropoda Arthropoda 99.4 4.14e-20   NR QQP50210.1 217165 g1100 i0 48.4 1.22834645669291 124 58 55.7 2 513 160 343 466 QQP50210.1 Uncharacterized protein FKW44_011137 [Caligus rogercresseyi] diamond 780 99.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Caligus Caligus rogercresseyi
29724857 29724857 PRJNA1200128_S_NODE_19110_length_206_cov_2.595092_g19001_i0 PRJNA1200128 19110 206 2.595092 5.34588952 Homalodisca vitripennis 197043 Arthropoda Arthropoda 41.2 0.0421   NR XP_046671182.1 197043 g19001 i0 43.9 1.10679611650485 41 22 59.7 1 22 144 51 90 XP_046671182.1 uncharacterized protein LOC124361187 [Homalodisca vitripennis] diamond 228 41.6 0.990384615384615 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
29977729 29977729 PRJNA1200128_S_NODE_34511_length_170_cov_2.590551_g34402_i0 PRJNA1200128 34511 170 2.590551 4.4039367 Danaus chrysippus 151541 Arthropoda Arthropoda 41.6 0.0346   NR CAG9560112.1 151541 g34402 i0 48.6 0.652941176470588 37 19 65.3 0 33 143 167 203 CAG9560112.1 unnamed protein product [Danaus chrysippus] diamond 111 41.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Danaus Danaus chrysippus
31368403 31368403 PRJNA1200128_S_NODE_13256_length_231_cov_1.765957_g13147_i0 PRJNA1200128 13256 231 1.765957 4.07936067 Homalodisca vitripennis 197043 Arthropoda Arthropoda 43.1 0.00891   NR KAG8276937.1 197043 g13147 i0 46.6 0.753246753246753 58 31 75.3 0 13 186 66 123 KAG8276937.1 hypothetical protein J6590_053745 [Homalodisca vitripennis] diamond 174 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
32063984 32063984 PRJNA1200128_S_NODE_15258_length_221_cov_1.573034_g15149_i0 PRJNA1200128 15258 221 1.573034 3.47640514 Penaeus vannamei 6689 Arthropoda Arthropoda 73.9 2.64e-13   NR XP_069971521.1 6689 g15149 i0 93.5 1.87330316742081 31 2 42.1 0 217 125 395 425 XP_069971521.1 general transcription factor II-I repeat domain-containing protein 2 [Penaeus vannamei] diamond 414 74.3 0.994616419919246 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
32222312 32222312 PRJNA1200128_S_NODE_23818_length_193_cov_1.253333_g23709_i0 PRJNA1200128 23818 193 1.253333 2.41893269 Dermatophagoides farinae 6954 Arthropoda Arthropoda 42.4 0.0262   NR XP_046918642.1 6954 g23709 i0 38.1 0.652849740932642 42 26 65.3 0 131 6 291 332 XP_046918642.1 serine-rich adhesin for platelets-like [Dermatophagoides farinae] diamond 126 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
32444070 32444070 PRJNA1200128_S_NODE_9159_length_260_cov_1.843318_g9050_i0 PRJNA1200128 9159 260 1.843318 4.7926268 Penaeus vannamei 6689 Arthropoda Arthropoda 42.7 0.0454   NR ROT78624.1 6689 g9050 i0 45.9 0.980769230769231 85 27 76.2 3 22 219 249 333 ROT78624.1 hypothetical protein C7M84_002659 [Penaeus vannamei] diamond 255 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
32633054 32633054 PRJNA1200128_S_NODE_22540_length_196_cov_2.764706_g22431_i0 PRJNA1200128 22540 196 2.764706 5.41882376 Vollenhovia emeryi 411798 Arthropoda Arthropoda 42.4 0.0263   NR XP_011876332.1 411798 g22431 i0 35.8 0.811224489795918 53 34 81.1 0 170 12 75 127 XP_011876332.1 PREDICTED: odorant receptor 85f-like isoform X2 [Vollenhovia emeryi] diamond 159 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Vollenhovia Vollenhovia emeryi

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