RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA1137393" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 25 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1137393 · 25 ✖

analysis 1

  • diamond · 25 ✖
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
2835339 2835339 PRJNA1137393_P_NODE_20203_length_201_cov_2.072368_g19687_i0 PRJNA1137393 20203 201 2.072368 4.16545968 Insecta 50557 Arthropoda Arthropoda 100 2.14e-25   NR ADE22675.1 695781 g19687 i0 73.1 33 67 18 100 0 201 1 28 94 ADE22675.1 cytochrome oxidase subunit 1, partial [Ceromya sp. Wood02] diamond 6633 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tachinidae Ceromya Ceromya sp. Wood02
26753533 26753533 PRJNA1137393_P_NODE_11061_length_250_cov_1.383085_g10545_i0 PRJNA1137393 11061 250 1.383085 3.4577125 Leguminivora glycinivorella 1035111 Arthropoda Arthropoda 43.5 0.0214   NR XP_047985352.1 1035111 g10545 i0 46.8 0.564 47 24 55.2 1 197 60 181 227 XP_047985352.1 LOW QUALITY PROTEIN: eukaryotic translation initiation factor 2-alpha kinase-like [Leguminivora glycinivorella] diamond 141 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Leguminivora Leguminivora glycinivorella
26753535 26753535 PRJNA1137393_P_NODE_16101_length_217_cov_1.172619_g15585_i0 PRJNA1137393 16101 217 1.172619 2.54458323 Orchesella cincta 48709 Arthropoda Arthropoda 43.1 0.0195   NR ODM96837.1 48709 g15585 i0 42.5 0.552995391705069 40 23 55.3 0 157 38 308 347 ODM96837.1 hypothetical protein Ocin01_09844 [Orchesella cincta] diamond 120 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
28080991 28080991 PRJNA1137393_P_NODE_50765_length_167_cov_0.881356_g50249_i0 PRJNA1137393 50765 167 0.881356 1.47186452 Orchesella dallaii 48710 Arthropoda Arthropoda 72.4 4.61e-13   NR CAL8130483.1 48710 g50249 i0 69.8 0.952095808383233 53 16 95.2 0 8 166 1063 1115 CAL8130483.1 unnamed protein product [Orchesella dallaii] diamond 159 72.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella dallaii
28333656 28333656 PRJNA1137393_P_NODE_55326_length_166_cov_0.888889_g54810_i0 PRJNA1137393 55326 166 0.888889 1.47555574 Carabus blaptoides fortunei 49296 Arthropoda Arthropoda 63.5 4.44e-11   NR GLV40676.1 49296 g54810 i0 70.5 1.53614457831325 44 13 79.5 0 33 164 82 125 GLV40676.1 G protein alpha o subunit [Carabus blaptoides fortunei] diamond 255 63.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Carabidae Carabus Carabus blaptoides
28428503 28428503 PRJNA1137393_P_NODE_50366_length_167_cov_0.881356_g49850_i0 PRJNA1137393 50366 167 0.881356 1.47186452 Nymphon striatum 424472 Arthropoda Arthropoda 69.3 2.52e-12   NR KAG1655198.1 424472 g49850 i0 55.6 5.82035928143713 54 24 97 0 5 166 202 255 KAG1655198.1 Proteasome activator complex subunit 3 [Nymphon striatum] diamond 972 69.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Pycnogonida Pantopoda Nymphonidae Nymphon Nymphon striatum
28649548 28649548 PRJNA1137393_P_NODE_44307_length_168_cov_0.873950_g43791_i0 PRJNA1137393 44307 168 0.87395 1.468236 Aphis gossypii 80765 Arthropoda Arthropoda 52.8 1.96e-6   NR CAH1725358.1 80765 g43791 i0 100 0.571428571428571 32 0 57.1 0 73 168 4 35 CAH1725358.1 unnamed protein product [Aphis gossypii] diamond 96 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis gossypii
28838760 28838760 PRJNA1137393_P_NODE_23748_length_192_cov_1.251748_g23232_i0 PRJNA1137393 23748 192 1.251748 2.40335616 Allacma fusca 39272 Arthropoda Arthropoda 63.2 1.18e-9   NR CAG7818474.1 39272 g23232 i0 83.8 0.578125 37 6 57.8 0 140 30 1337 1373 CAG7818474.1 unnamed protein product [Allacma fusca] diamond 111 63.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
29080611 29080611 PRJNA1137393_P_NODE_67328_length_163_cov_0.912281_g66812_i0 PRJNA1137393 67328 163 0.912281 1.48701803 Entomobryomorpha 730330 Arthropoda Arthropoda 91.7 7.13e-20   NR CAL8093609.1 48710 g66812 i0 81.1 3.86503067484663 53 10 97.5 0 3 161 544 596 CAL8093609.1 unnamed protein product [Orchesella dallaii] diamond 630 92.4 0.992424242424242 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella dallaii
29301610 29301610 PRJNA1137393_P_NODE_72869_length_162_cov_0.920354_g72353_i0 PRJNA1137393 72869 162 0.920354 1.49097348 Arachnida 6854 Arthropoda Arthropoda 46.2 7.32e-4   NR XP_040358414.2 6945 g72353 i0 46.3 6.01851851851852 54 28 98.1 1 3 161 218 271 XP_040358414.2 long-chain-fatty-acid--CoA ligase 4 isoform X1 [Ixodes scapularis] diamond 975 46.6 0.991416309012876 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis
29754365 29754365 PRJNA1137393_P_NODE_46431_length_168_cov_0.873950_g45915_i0 PRJNA1137393 46431 168 0.87395 1.468236 Dermacentor andersoni 34620 Arthropoda Arthropoda 62 2.25e-10   NR XP_050039096.1 34620 g45915 i0 60 0.982142857142857 55 15 98.2 2 2 166 65 112 XP_050039096.1 histone H3.1-like [Dermacentor andersoni] diamond 165 62 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Dermacentor Dermacentor andersoni
29775015 29775015 PRJNA1137393_P_NODE_68751_length_163_cov_0.912281_g68235_i0 PRJNA1137393 68751 163 0.912281 1.48701803 Aphididae 27482 Arthropoda Arthropoda 62 1.93e-9   NR CAH1736497.1 80765 g68235 i0 54.9 19.9693251533742 51 23 93.9 0 161 9 145 195 CAH1736497.1 unnamed protein product [Aphis gossypii] diamond 3255 62 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis gossypii
30027986 30027986 PRJNA1137393_P_NODE_53631_length_166_cov_0.888889_g53115_i0 PRJNA1137393 53631 166 0.888889 1.47555574 Drosophila 7215 Arthropoda Arthropoda 61.2 3.77e-9   NR XP_051864351.1 7291 g53115 i0 73.2 15.9397590361446 41 11 74.1 0 42 164 513 553 XP_051864351.1 uncharacterized protein LOC127566365 [Drosophila albomicans] diamond 2646 61.6 0.993506493506494 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila albomicans
30038770 30038770 PRJNA1137393_P_NODE_54791_length_166_cov_0.888889_g54275_i0 PRJNA1137393 54791 166 0.888889 1.47555574 Aphis craccivora 307492 Arthropoda Arthropoda 57.8 2.69e-8   NR KAF0711388.1 307492 g54275 i0 59.2 0.885542168674699 49 20 88.6 0 10 156 17 65 KAF0711388.1 Reverse transcriptase domain-containing protein, partial [Aphis craccivora] diamond 147 57.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis craccivora
30228282 30228282 PRJNA1137393_P_NODE_54832_length_166_cov_0.888889_g54316_i0 PRJNA1137393 54832 166 0.888889 1.47555574 Uroleucon formosanum 796250 Arthropoda Arthropoda 65.1 1.74e-10   NR KAL4141337.1 796250 g54316 i0 56.4 5.96385542168675 55 24 99.4 0 166 2 935 989 KAL4141337.1 hypothetical protein QTP88_003992 [Uroleucon formosanum] diamond 990 65.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Uroleucon Uroleucon formosanum
30449781 30449781 PRJNA1137393_P_NODE_65573_length_163_cov_0.912281_g65057_i0 PRJNA1137393 65573 163 0.912281 1.48701803 Penaeus japonicus 27405 Arthropoda Arthropoda 42.4 0.0177   NR XP_042883565.1 27405 g65057 i0 70.8 0.441717791411043 24 7 44.2 0 72 1 103 126 XP_042883565.1 venom carboxylesterase-6-like [Penaeus japonicus] diamond 72 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus japonicus
30481171 30481171 PRJNA1137393_P_NODE_50173_length_167_cov_0.881356_g49657_i0 PRJNA1137393 50173 167 0.881356 1.47186452 Metopolophium dirhodum 44670 Arthropoda Arthropoda 46.6 4.89e-4   NR XP_060860386.1 44670 g49657 i0 63.3 0.538922155688623 30 11 53.9 0 67 156 124 153 XP_060860386.1 uncharacterized protein LOC132937810 [Metopolophium dirhodum] diamond 90 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Metopolophium Metopolophium dirhodum
31039186 31039186 PRJNA1137393_P_NODE_66515_length_163_cov_0.912281_g65999_i0 PRJNA1137393 66515 163 0.912281 1.48701803 Daphnia 6668 Arthropoda Arthropoda 64.7 6.6e-11   NR KZS05488.1 35525 g65999 i0 60.9 13.3067484662577 46 18 84.7 0 161 24 39 84 KZS05488.1 Chromobox protein [Daphnia magna] diamond 2169 64.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
31366160 31366160 PRJNA1137393_P_NODE_21596_length_197_cov_1.716216_g21080_i0 PRJNA1137393 21596 197 1.716216 3.38094552 Drosophila guanche 7266 Arthropoda Arthropoda 42.4 0.0287   NR XP_034120015.1 7266 g21080 i0 53.6 0.426395939086294 28 13 42.6 0 70 153 2873 2900 XP_034120015.1 uncharacterized protein LOC117578553 isoform X1 [Drosophila guanche] diamond 84 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila guanche
31513349 31513349 PRJNA1137393_P_NODE_54136_length_166_cov_0.888889_g53620_i0 PRJNA1137393 54136 166 0.888889 1.47555574 Arachnida 6854 Arthropoda Arthropoda 78.2 3.45e-16   NR XP_015791340.1 32264 g53620 i0 70.8 11.3493975903614 48 14 86.7 0 22 165 56 103 XP_015791340.1 trafficking protein particle complex subunit 5 [Tetranychus urticae] diamond 1884 78.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
31682038 31682038 PRJNA1137393_P_NODE_44997_length_168_cov_0.873950_g44481_i0 PRJNA1137393 44997 168 0.87395 1.468236 Uroleucon formosanum 796250 Arthropoda Arthropoda 87 3.42e-18   NR KAL4141829.1 796250 g44481 i0 71.4 2 56 16 100 0 1 168 1040 1095 KAL4141829.1 hypothetical protein QTP88_004386 [Uroleucon formosanum] diamond 336 87 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Uroleucon Uroleucon formosanum
31745409 31745409 PRJNA1137393_P_NODE_46277_length_168_cov_0.873950_g45761_i0 PRJNA1137393 46277 168 0.87395 1.468236 Orchesella cincta 48709 Arthropoda Arthropoda 58.9 2.57e-8   NR ODM96943.1 48709 g45761 i0 85.7 0.625 35 5 62.5 0 107 3 283 317 ODM96943.1 Transmembrane 9 superfamily member 4 [Orchesella cincta] diamond 105 58.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
31871969 31871969 PRJNA1137393_P_NODE_69637_length_162_cov_1.522124_g69121_i0 PRJNA1137393 69637 162 1.522124 2.46584088 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 57 1.13e-7   NR KAH9409907.1 59818 g69121 i0 52.2 0.851851851851852 46 22 85.2 0 23 160 434 479 KAH9409907.1 hypothetical protein TYRP_009654 [Tyrophagus putrescentiae] diamond 138 57 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
32693977 32693977 PRJNA1137393_P_NODE_57660_length_165_cov_0.896552_g57144_i0 PRJNA1137393 57660 165 0.896552 1.4793108 Dryococelus australis 614101 Arthropoda Arthropoda 47.4 2.96e-4   NR KAJ8896564.1 614101 g57144 i0 62.2 1.38181818181818 37 14 67.3 0 139 29 300 336 KAJ8896564.1 hypothetical protein PR048_001908 [Dryococelus australis] diamond 228 47.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Phasmatidae Dryococelus Dryococelus australis
32820027 32820027 PRJNA1137393_P_NODE_42020_length_169_cov_0.866667_g41504_i0 PRJNA1137393 42020 169 0.866667 1.46466723 Tribolium castaneum 7070 Arthropoda Arthropoda 52.8 3.88e-6   NR EFA13491.1 7070 g41504 i0 47.2 0.940828402366864 53 28 94.1 0 164 6 157 209 EFA13491.1 hypothetical protein TcasGA2_TC006914 [Tribolium castaneum] diamond 159 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum

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