RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA861969", tax_clade = "Opisthokonta" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 22 ✖

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 22 ✖

bioproject 1

  • PRJNA861969 · 22 ✖
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
4674937 4674937 PRJNA861969_P_NODE_35084_length_247_cov_0.885057_g34853_i0 PRJNA861969 35084 247 0.885057 2.18609079 Dermatophagoides farinae 6954 Arthropoda Arthropoda 274 4.38e-69   NTclustered gi|2205500772|ref|XR_006959499.1| 6954 g34853 i0 88.745 14.8663967611336 231 16 94 4 3 233 298 518 PREDICTED: Dermatophagoides farinae uncharacterized LOC124498605 (LOC124498605), transcript variant X3, ncRNA blastn 3672 274 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
8499488 8499488 PRJNA861969_P_NODE_3847_length_668_cov_2.147899_g3623_i0 PRJNA861969 3847 668 2.147899 14.34796532 Pseudoterpna coronillaria 1007376 Arthropoda Arthropoda 60.2 3.98e-4   NTclustered gi|2918369770|emb|OZ237837.1| 1007376 g3623 i0 87.273 0.0823353293413174 55 4 8 3 228 281 5854565 5854513 Pseudoterpna coronillaria genome assembly, chromosome: 12 blastn 55 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Pseudoterpna Pseudoterpna coronillaria
10164994 10164994 PRJNA861969_P_NODE_29728_length_254_cov_1.701657_g29497_i0 PRJNA861969 29728 254 1.701657 4.32220878 Bourletiella 574227 Arthropoda Arthropoda 431 2.539999999999999e-116   NTclustered gi|213054527|gb|FJ411426.1| 574228 g29497 i0 97.244 100.61811023622 254 7 100 0 1 254 903 1156 Bourletiella hortensis internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 25557 431 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Bourletiellidae Bourletiella Bourletiella hortensis
10165032 10165032 PRJNA861969_P_NODE_34268_length_248_cov_0.880000_g34037_i0 PRJNA861969 34268 248 0.88 2.1824 root 1 Root_unresolved Root_unresolved 448 2.4499999999999996e-121   NTclustered gi|1964807365|emb|OC914831.1| 334625 g34037 i0 99.194 18.7056451612903 248 2 100 0 1 248 15884 15637 Oppiella nova blastn 4639 448 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
11050061 11050061 PRJNA861969_P_NODE_29689_length_254_cov_2.270718_g29458_i0 PRJNA861969 29689 254 2.270718 5.76762372 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g29458 i0 100 0.110236220472441 28 0 11 0 102 129 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
11050245 11050245 PRJNA861969_P_NODE_38609_length_244_cov_0.900585_g38378_i0 PRJNA861969 38609 244 0.900585 2.1974274 Frankliniella occidentalis 133901 Arthropoda Arthropoda 283 7.17e-72   NTclustered gi|2347664860|ref|XM_026416899.2| 133901 g38378 i0 97.59 1.32786885245902 166 3 68 1 79 244 2232 2396 PREDICTED: Frankliniella occidentalis centrobin (LOC113202598), transcript variant X1, mRNA blastn 324 283 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Frankliniella Frankliniella occidentalis
12325461 12325461 PRJNA861969_P_NODE_24470_length_278_cov_1.307317_g24239_i0 PRJNA861969 24470 278 1.307317 3.63434126 Drosophila melanogaster 7227 Arthropoda Arthropoda 470 5.959999999999998e-128   NTclustered gi|22094311|gb|AC093435.3| 7227 g24239 i0 97.133 1.40647482014388 279 6 100 2 1 278 66833 66556 Drosophila melanogaster 3L BAC RP98-7A5 (Roswell Park Cancer Institute Drosophila BAC Library) complete sequence blastn 391 470 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
13599977 13599977 PRJNA861969_P_NODE_23331_length_283_cov_1.466667_g23100_i0 PRJNA861969 23331 283 1.466667 4.15066761 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.026   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g23100 i0 100 0.0989399293286219 28 0 10 0 101 128 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
13600034 13600034 PRJNA861969_P_NODE_27071_length_266_cov_1.466321_g26840_i0 PRJNA861969 27071 266 1.466321 3.90041386 Ostrinia furnacalis 93504 Arthropoda Arthropoda 483 7.28e-132   NTclustered gi|1590285369|ref|XM_028310772.1| 93504 g26840 i0 99.621 0.992481203007519 264 1 99 0 3 266 279 16 PREDICTED: Ostrinia furnacalis beta sliding clamp-like (LOC114357250), mRNA blastn 264 483 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Crambidae Ostrinia Ostrinia furnacalis
13990291 13990291 PRJNA861969_P_NODE_28351_length_260_cov_1.647059_g28120_i0 PRJNA861969 28351 260 1.647059 4.2823534 Opisthokonta 33154 Arthropoda Arthropoda 62.1 3.94e-5   NTclustered gi|2788970408|ref|XM_067354168.1| 83485 g28120 i0 95 15.2153846153846 40 0 15 2 69 107 10015 9977 PREDICTED: Linepithema humile histone-lysine N-methyltransferase 2D (LOC105673337), transcript variant X13, mRNA blastn 3956 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Linepithema Linepithema humile
15264412 15264412 PRJNA861969_P_NODE_35952_length_246_cov_0.890173_g35721_i0 PRJNA861969 35952 246 0.890173 2.18982558 root 1 Root_unresolved Root_unresolved 438 1.4599999999999996e-118   NTclustered gi|1964807194|emb|OC914826.1| 334625 g35721 i0 98.78 12.719512195122 246 3 100 0 1 246 340661 340416 Oppiella nova blastn 3129 438 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
16149411 16149411 PRJNA861969_P_NODE_9253_length_424_cov_3.131054_g9022_i0 PRJNA861969 9253 424 3.131054 13.27566896 Teleiodes vulgella 1594352 Arthropoda Arthropoda 54.7 0.011   NTclustered gi|2918369950|emb|OZ237932.1| 1594352 g9022 i0 100 0.0683962264150943 29 0 7 0 71 99 14486095 14486067 Teleiodes vulgella genome assembly, chromosome: 13 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Gelechiidae Teleiodes Teleiodes vulgella
21248343 21248343 PRJNA861969_P_NODE_20177_length_301_cov_2.000000_g19946_i0 PRJNA861969 20177 301 2 6.02 Rhopalosiphum maidis 43146 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1503147672|ref|XM_026952196.1| 43146 g19946 i0 96.97 0.32890365448505 33 1 11 0 265 297 2743 2775 PREDICTED: Rhopalosiphum maidis protein melted (LOC113550400), transcript variant X2, mRNA blastn 99 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Rhopalosiphum Rhopalosiphum maidis
23798680 23798680 PRJNA861969_P_NODE_33319_length_249_cov_0.875000_g33088_i0 PRJNA861969 33319 249 0.875 2.17875 Helicoverpa armigera 29058 Arthropoda Arthropoda 180 9.91e-41   NTclustered gi|2705319121|ref|XM_021333179.3| 29058 g33088 i0 81.448 79.4056224899598 221 39 88 2 30 249 342 561 PREDICTED: Helicoverpa armigera thioredoxin-like protein 4A (LOC110375160), mRNA blastn 19772 180 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa armigera
25072274 25072274 PRJNA861969_P_NODE_15580_length_336_cov_3.631179_g15349_i0 PRJNA861969 15580 336 3.631179 12.20076144 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.032   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g15349 i0 100 0.0833333333333333 28 0 8 0 35 62 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
25072401 25072401 PRJNA861969_P_NODE_22820_length_285_cov_2.080189_g22589_i0 PRJNA861969 22820 285 2.080189 5.92853865 Oppiella nova 334625 Arthropoda Arthropoda 516 7.77e-142   NTclustered gi|1964807391|emb|OC914832.1| 334625 g22589 i0 99.298 7 285 2 100 0 1 285 15874 15590 Oppiella nova blastn 1995 516 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
26991611 26991611 PRJNA861969_P_NODE_40982_length_242_cov_0.911243_g40751_i0 PRJNA861969 40982 242 0.911243 2.20520806 Tetranychus urticae 32264 Arthropoda Arthropoda 100 1.29e-22   NR XP_015782828.1 32264 g40751 i0 76.6 0.793388429752066 64 15 79.3 0 49 240 20 83 XP_015782828.1 regulator of nonsense transcripts 2 [Tetranychus urticae] diamond 192 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
27505837 27505837 PRJNA861969_P_NODE_37863_length_244_cov_1.801170_g37632_i0 PRJNA861969 37863 244 1.80117 4.3948548 Tetranychidae 32262 Arthropoda Arthropoda 85.9 2.55e-17   NR XP_015781585.1 32264 g37632 i0 64.8 1.77049180327869 71 21 87.3 1 32 244 1121 1187 XP_015781585.1 uncharacterized protein LOC107359591 [Tetranychus urticae] diamond 432 86.3 0.995365005793743 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
31200246 31200246 PRJNA861969_P_NODE_715_length_1725_cov_14.657990_g602_i0 PRJNA861969 715 1725 14.65799 252.8503275 Culicidae 7157 Arthropoda Arthropoda 138 5.02e-34   NR XP_053685040.1 53552 g602 i0 50.4 5.47478260869565 137 62 23.8 1 188 598 33 163 XP_053685040.1 ADP-ribose glycohydrolase OARD1-like [Sabethes cyaneus] diamond 9444 138 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Sabethes Sabethes cyaneus
31413974 31413974 PRJNA861969_P_NODE_41576_length_241_cov_0.916667_g41345_i0 PRJNA861969 41576 241 0.916667 2.20916747 Orchesella cincta 48709 Arthropoda Arthropoda 67 9.71e-11   NR ODN02055.1 48709 g41345 i0 72.7 0.547717842323652 44 12 54.8 0 9 140 370 413 ODN02055.1 Cation channel sperm-associated protein 4 [Orchesella cincta] diamond 132 67 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
31856674 31856674 PRJNA861969_P_NODE_26177_length_270_cov_1.543147_g25946_i0 PRJNA861969 26177 270 1.543147 4.1664969 Panonychus citri 50023 Arthropoda Arthropoda 51.6 3.91e-5   NR XP_053208042.1 50023 g25946 i0 100 1.04444444444444 23 0 25.6 0 66 134 671 693 XP_053208042.1 calcium-transporting ATPase type 2C member 1-like [Panonychus citri] diamond 282 51.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Panonychus Panonychus citri
32426338 32426338 PRJNA861969_P_NODE_25279_length_274_cov_1.532338_g25048_i0 PRJNA861969 25279 274 1.532338 4.19860612 Moina brachiata 675436 Arthropoda Arthropoda 62.8 1.25e-9   NR CAG4648284.1 675436 g25048 i0 35.2 2.89051094890511 88 57 96.4 0 272 9 72 159 CAG4648284.1 EOG090X0EPM [Moina brachiata] diamond 792 62.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Moinidae Moina Moina brachiata

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