RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where bioproject = "PRJNA380416" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 28 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA380416 · 28 ✖
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
402043 402043 PRJNA380416_P_NODE_11681_length_166_cov_0.871795_g11534_i0 PRJNA380416 11681 166 0.871795 1.4471797 Necrodes littoralis 414927 Arthropoda Arthropoda 124 2.9e-24   NTclustered gi|1339552205|gb|MG623491.1| 414927 g11534 i0 80.588 83.2228915662651 170 25 100 5 1 166 570 405 Necrodes littoralis isocitrate dehydrogenase (Idh) gene, partial cds blastn 13815 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Silphidae Necrodes Necrodes littoralis
402052 402052 PRJNA380416_P_NODE_2921_length_353_cov_1.006579_g2774_i0 PRJNA380416 2921 353 1.006579 3.55322387 Euthrix potatoria 624169 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|2918370014|emb|OZ237901.1| 624169 g2774 i0 97.059 0.0963172804532578 34 0 9 1 191 223 1424873 1424840 Euthrix potatoria genome assembly, chromosome: 29 blastn 34 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lasiocampidae Euthrix Euthrix potatoria
1676767 1676767 PRJNA380416_P_NODE_13362_length_162_cov_0.902655_g13215_i0 PRJNA380416 13362 162 0.902655 1.4623011 Timema douglasi 61478 Arthropoda Arthropoda 272 9.51e-69   NTclustered gi|1936739480|emb|OA691908.1| 61478 g13215 i0 96.914 1 162 5 100 0 1 162 313 152 1_Tdi_b3v08 blastn 162 272 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
1676780 1676780 PRJNA380416_P_NODE_6542_length_225_cov_0.903409_g6395_i0 PRJNA380416 6542 225 0.903409 2.03267025 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.02   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g6395 i0 100 0.124444444444444 28 0 12 0 195 222 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
4229177 4229177 PRJNA380416_P_NODE_12184_length_165_cov_0.879310_g12037_i0 PRJNA380416 12184 165 0.87931 1.4508615 Frankliniella occidentalis 133901 Arthropoda Arthropoda 300 4.46e-77   NTclustered gi|2347691774|ref|XM_026425516.2| 133901 g12037 i0 99.394 1 165 1 100 0 1 165 2081 1917 PREDICTED: Frankliniella occidentalis uncharacterized LOC113208501 (LOC113208501), mRNA blastn 165 300 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Frankliniella Frankliniella occidentalis
5505662 5505662 PRJNA380416_P_NODE_10925_length_170_cov_0.900826_g10778_i0 PRJNA380416 10925 170 0.900826 1.5314042 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.014   NTclustered gi|2919545581|emb|OZ238355.1| 1002887 g10778 i0 100 0.164705882352941 28 0 16 0 72 99 15905093 15905120 Glaucopsyche melanops genome assembly, chromosome: 14 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
5505678 5505678 PRJNA380416_P_NODE_5505_length_247_cov_2.388889_g5358_i0 PRJNA380416 5505 247 2.388889 5.90055583 Papilio polytes 76194 Arthropoda Arthropoda 412 8.89e-111   NTclustered gi|389615034|dbj|AK405121.1| 76194 g5358 i0 96.761 2.67206477732794 247 8 100 0 1 247 640 394 Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis blastn 660 412 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
6779758 6779758 PRJNA380416_P_NODE_4506_length_277_cov_4.429825_g4359_i0 PRJNA380416 4506 277 4.429825 12.27061525 Bradysia coprophila 38358 Arthropoda Arthropoda 289 1.78e-73   NTclustered gi|1928074112|ref|XM_037184666.1| 38358 g4359 i0 85.714 207.642599277978 273 39 99 0 5 277 488 216 PREDICTED: Bradysia coprophila polyubiquitin-C (LOC119077460), transcript variant X6, mRNA blastn 57517 289 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
9330107 9330107 PRJNA380416_P_NODE_2248_length_406_cov_1.563025_g2101_i0 PRJNA380416 2248 406 1.563025 6.3458815 Timema genevievae 629358 Arthropoda Arthropoda 54.7 0.011   NTclustered gi|1963350700|emb|OE839616.1| 629358 g2101 i0 100 0.0714285714285714 29 0 7 0 78 106 38081 38109 5_Tge_b3v08 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
10605756 10605756 PRJNA380416_P_NODE_10169_length_178_cov_1.155039_g10022_i0 PRJNA380416 10169 178 1.155039 2.05596942 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.015   NTclustered gi|2919545581|emb|OZ238355.1| 1002887 g10022 i0 100 0.157303370786517 28 0 16 0 17 44 15905093 15905120 Glaucopsyche melanops genome assembly, chromosome: 14 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
11880732 11880732 PRJNA380416_P_NODE_12110_length_165_cov_0.879310_g11963_i0 PRJNA380416 12110 165 0.87931 1.4508615 Thrips palmi 161013 Arthropoda Arthropoda 215 1.66e-51   NTclustered gi|1841838100|ref|XM_034393157.1| 161013 g11963 i0 92.157 3.70909090909091 153 10 92 2 1 152 9275 9426 PREDICTED: Thrips palmi kinesin-like protein KIF13A (LOC117649950), transcript variant X3, mRNA blastn 612 215 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Thrips Thrips palmi
13155746 13155746 PRJNA380416_P_NODE_12311_length_165_cov_0.879310_g12164_i0 PRJNA380416 12311 165 0.87931 1.4508615 Panonychus citri 50023 Arthropoda Arthropoda 93.2 2.24e-20   NR XP_053209079.1 50023 g12164 i0 76.4 1 55 13 100 0 165 1 959 1013 XP_053209079.1 LOW QUALITY PROTEIN: DNA mismatch repair protein Msh6-like, partial [Panonychus citri] diamond 165 93.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Panonychus Panonychus citri
18253670 18253670 PRJNA380416_P_NODE_3295_length_332_cov_1.685512_g3148_i0 PRJNA380416 3295 332 1.685512 5.59589984 Anabrus simplex 316456 Arthropoda Arthropoda 614 3.1799999999999995e-171   NTclustered gi|2801205913|ref|XR_011019255.1| 316456 g3148 i0 100 100 332 0 100 0 1 332 431 762 PREDICTED: Anabrus simplex large subunit ribosomal RNA (LOC137503585), rRNA blastn 33200 614 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Tettigoniidae Anabrus Anabrus simplex
19527870 19527870 PRJNA380416_P_NODE_7556_length_208_cov_1.924528_g7409_i0 PRJNA380416 7556 208 1.924528 4.00301824 Anabrus simplex 316456 Arthropoda Arthropoda 385 1.58e-102   NTclustered gi|2801205913|ref|XR_011019255.1| 316456 g7409 i0 100 100 208 0 100 0 1 208 2543 2336 PREDICTED: Anabrus simplex large subunit ribosomal RNA (LOC137503585), rRNA blastn 20800 385 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Tettigoniidae Anabrus Anabrus simplex
20803497 20803497 PRJNA380416_P_NODE_12337_length_165_cov_0.879310_g12190_i0 PRJNA380416 12337 165 0.87931 1.4508615 Frankliniella occidentalis 133901 Arthropoda Arthropoda 289 9.66e-74   NTclustered gi|2347693589|ref|XM_052272497.1| 133901 g12190 i0 98.182 1 165 3 100 0 1 165 165 1 PREDICTED: Frankliniella occidentalis serine/arginine repetitive matrix protein 1 (LOC113215101), mRNA blastn 165 289 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Frankliniella Frankliniella occidentalis
20803503 20803503 PRJNA380416_P_NODE_1617_length_481_cov_2.400463_g1471_i0 PRJNA380416 1617 481 2.400463 11.54622703 Papilio polytes 76194 Arthropoda Arthropoda 717 0   NTclustered gi|389615034|dbj|AK405121.1| 76194 g1471 i0 98.997 31.2162162162162 399 4 83 0 83 481 1 399 Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis blastn 15015 717 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
22078551 22078551 PRJNA380416_P_NODE_2478_length_386_cov_1.744807_g2331_i0 PRJNA380416 2478 386 1.744807 6.73495502 Oppiella nova 334625 Arthropoda Arthropoda 52.8 0.037   NTclustered gi|1962594841|emb|OC922882.1| 334625 g2331 i0 100 0.0725388601036269 28 0 7 0 111 138 5046 5019 Oppiella nova blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
23354058 23354058 PRJNA380416_P_NODE_11299_length_167_cov_0.864407_g11152_i0 PRJNA380416 11299 167 0.864407 1.44355969 Timema cristinae 61476 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|1947107762|emb|OC321394.1| 61476 g11152 i0 96.97 1.24550898203593 33 0 19 1 136 167 24669 24701 3_Tce_b3v08 blastn 208 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema cristinae
23354079 23354079 PRJNA380416_P_NODE_8199_length_199_cov_2.926667_g8052_i0 PRJNA380416 8199 199 2.926667 5.82406733 Anabrus simplex 316456 Arthropoda Arthropoda 368 1.51e-97   NTclustered gi|2801205913|ref|XR_011019255.1| 316456 g8052 i0 100 100 199 0 100 0 1 199 3836 3638 PREDICTED: Anabrus simplex large subunit ribosomal RNA (LOC137503585), rRNA blastn 19900 368 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Tettigoniidae Anabrus Anabrus simplex
25300326 25300326 PRJNA380416_P_NODE_12400_length_164_cov_2.217391_g12253_i0 PRJNA380416 12400 164 2.217391 3.63652124 Lucilia 7374 Arthropoda Arthropoda 135 1.32e-27   NTclustered gi|2202985638|ref|XM_023449373.2| 7375 g12253 i0 88.991 83.1829268292683 109 12 66 0 2 110 273 381 PREDICTED: Lucilia cuprina ubiquitin-60S ribosomal protein L40 (LOC111686969), mRNA blastn 13642 135 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia cuprina
28338357 28338357 PRJNA380416_P_NODE_11026_length_169_cov_0.966667_g10879_i0 PRJNA380416 11026 169 0.966667 1.63366723 Petrolisthes manimaculis 1843537 Arthropoda Arthropoda 40.4 0.0417   NR KAK4304497.1 1843537 g10879 i0 56.5 0.408284023668639 23 10 40.8 0 37 105 38 60 KAK4304497.1 hypothetical protein Pmani_023549 [Petrolisthes manimaculis] diamond 69 40.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Porcellanidae Petrolisthes Petrolisthes manimaculis
28639684 28639684 PRJNA380416_P_NODE_11287_length_167_cov_0.864407_g11140_i0 PRJNA380416 11287 167 0.864407 1.44355969 Hemiptera 7524 Arthropoda Arthropoda 85.9 6.55e-19   NR XP_046686827.1 197043 g11140 i0 71.4 11.1197604790419 56 15 98.8 1 3 167 151 206 XP_046686827.1 peroxiredoxin-2-like, partial [Homalodisca vitripennis] diamond 1857 85.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
29822054 29822054 PRJNA380416_P_NODE_3451_length_324_cov_1.654545_g3304_i0 PRJNA380416 3451 324 1.654545 5.3607258 Bemisia tabaci 7038 Arthropoda Arthropoda 87 7.59e-19   NR XP_018910361.1 7038 g3304 i0 43.9 8.49074074074074 98 55 90.7 0 314 21 40 137 XP_018910361.1 PREDICTED: 60S ribosomal protein L18a [Bemisia tabaci] diamond 2751 87 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
30186697 30186697 PRJNA380416_P_NODE_7392_length_211_cov_1.067901_g7245_i0 PRJNA380416 7392 211 1.067901 2.25327111 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 99.8 2.59e-25   NR XP_027194304.1 6956 g7245 i0 75.4 1.84834123222749 65 16 92.4 0 209 15 16 80 XP_027194304.1 60S ribosomal protein L44 [Dermatophagoides pteronyssinus] diamond 390 100 0.998 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
30517362 30517362 PRJNA380416_P_NODE_13933_length_161_cov_0.910714_g13786_i0 PRJNA380416 13933 161 0.910714 1.46624954 Palaemon carinicauda 392227 Arthropoda Arthropoda 46.6 4.57e-4   NR XP_068223990.1 392227 g13786 i0 48.2 1.84472049689441 56 23 95 2 5 157 133 187 XP_068223990.1 ran-specific GTPase-activating protein-like isoform X2 [Palaemon carinicauda] diamond 297 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Palaemon Palaemon carinicauda
30864830 30864830 PRJNA380416_P_NODE_11814_length_166_cov_0.871795_g11667_i0 PRJNA380416 11814 166 0.871795 1.4471797 Frankliniella occidentalis 133901 Arthropoda Arthropoda 75.5 3.62e-14   NR KAE8739074.1 133901 g11667 i0 77.8 0.975903614457831 54 12 97.6 0 3 164 801 854 KAE8739074.1 hypothetical protein FOCC_FOCC015430 [Frankliniella occidentalis] diamond 162 75.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Frankliniella Frankliniella occidentalis
30896669 30896669 PRJNA380416_P_NODE_12994_length_163_cov_0.894737_g12847_i0 PRJNA380416 12994 163 0.894737 1.45842131 Acanthoscelides obtectus 200917 Arthropoda Arthropoda 63.9 2.76e-10   NR CAH2021287.1 200917 g12847 i0 59.6 3.4601226993865 47 19 86.5 0 3 143 59 105 CAH2021287.1 unnamed protein product [Acanthoscelides obtectus] diamond 564 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Acanthoscelides Acanthoscelides obtectus
31212013 31212013 PRJNA380416_P_NODE_4855_length_265_cov_0.944444_g4708_i0 PRJNA380416 4855 265 0.944444 2.5027766 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 84 8.2e-18   NR ADD38186.1 72036 g4708 i0 48.7 0.883018867924528 78 40 88.3 0 245 12 59 136 ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis] diamond 234 84 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis

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