RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "blastn", bioproject = "PRJNA1218816" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1218816 · 19 ✖

analysis 1

  • blastn · 19 ✖
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
333390 333390 PRJNA1218816_P_NODE_47861_length_272_cov_1.040201_g47428_i0 PRJNA1218816 47861 272 1.040201 2.82934672 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.025   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g47428 i0 100 0.102941176470588 28 0 10 0 85 112 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
1608075 1608075 PRJNA1218816_P_NODE_40742_length_302_cov_1.126638_g40309_i0 PRJNA1218816 40742 302 1.126638 3.40244676 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.028   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g40309 i0 100 0.0927152317880795 28 0 9 0 108 135 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
4160185 4160185 PRJNA1218816_P_NODE_10444_length_793_cov_2.491667_g10051_i0 PRJNA1218816 10444 793 2.491667 19.75891931 Papilio polytes 76194 Arthropoda Arthropoda 1345 0   NTclustered gi|389615034|dbj|AK405121.1| 76194 g10051 i0 99.863 20.5662042875158 730 1 92 0 1 730 730 1 Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis blastn 16309 1345 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
4160279 4160279 PRJNA1218816_P_NODE_27864_length_387_cov_1.815287_g27431_i0 PRJNA1218816 27864 387 1.815287 7.02516069 Sympiezomias velatus 2044628 Arthropoda Arthropoda 254 9.44e-63   NTclustered gi|2294362794|gb|OM417063.1| 2044628 g27431 i0 78.663 84.1705426356589 389 77 99 6 2 387 1271 886 Sympiezomias velatus elongation factor 1-alpha (EF1a) mRNA, complete cds blastn 32574 254 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Sympiezomias Sympiezomias velatus
6149086 6149086 PRJNA1218816_P_NODE_43665_length_289_cov_1.328704_g43232_i0 PRJNA1218816 43665 289 1.328704 3.83995456 Artemia 6660 Arthropoda Arthropoda 534 2.18e-147   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g43232 i0 100 31.5086505190311 289 0 100 0 1 289 2149 2437 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 9106 534 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
6711304 6711304 PRJNA1218816_P_NODE_57126_length_247_cov_1.413793_g56693_i0 PRJNA1218816 57126 247 1.413793 3.49206871 Lophocorona astiptica 753361 Arthropoda Arthropoda 152 2.1399999999999998e-32   NTclustered gi|307645070|gb|GU830495.1| 753361 g56693 i0 84.277 5.66396761133603 159 22 64 3 26 183 33 189 Lophocorona astiptica voucher MM07597 cytosolic malate dehydrogenase (MDH) gene, partial cds blastn 1399 152 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lophocoronidae Lophocorona Lophocorona astiptica
6711337 6711337 PRJNA1218816_P_NODE_60926_length_243_cov_0.905882_g60493_i0 PRJNA1218816 60926 243 0.905882 2.20129326 Musca vetustissima 27455 Arthropoda Arthropoda 231 2.6199999999999997e-56   NTclustered gi|2635636407|ref|XM_061530016.1| 27455 g60493 i0 83.884 157.349794238683 242 39 99 0 1 242 2269 2028 PREDICTED: Musca vetustissima polyubiquitin-C-like (LOC133320907), mRNA blastn 38236 231 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Musca Musca vetustissima
7424162 7424162 PRJNA1218816_P_NODE_39986_length_305_cov_1.844828_g39553_i0 PRJNA1218816 39986 305 1.844828 5.6267254 Artemia 6660 Arthropoda Arthropoda 558 1.37e-154   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g39553 i0 99.672 9.0655737704918 305 1 100 0 1 305 3315 3619 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 2765 558 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
7424207 7424207 PRJNA1218816_P_NODE_63306_length_238_cov_2.515152_g62873_i0 PRJNA1218816 63306 238 2.515152 5.98606176 Hesperiidae 40093 Arthropoda Arthropoda 167 7.319999999999999e-37   NTclustered gi|2567321592|gb|OK804622.1| 2839275 g62873 i0 82 23.7142857142857 200 32 83 4 41 238 1085 888 Mimia phidyle voucher MGCL:LEP-61291 heat shock cognate protein gene, partial cds blastn 5644 167 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Hesperiidae Mimia Mimia phidyle
8699326 8699326 PRJNA1218816_P_NODE_63227_length_239_cov_4.114458_g62794_i0 PRJNA1218816 63227 239 4.114458 9.83355462 Artemia 6660 Arthropoda Arthropoda 442 1.0899999999999994e-119   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g62794 i0 100 85.4560669456067 239 0 100 0 1 239 784 1022 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 20424 442 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
11812079 11812079 PRJNA1218816_P_NODE_45590_length_281_cov_1.480769_g45157_i0 PRJNA1218816 45590 281 1.480769 4.16096089 Trichogramma pretiosum 7493 Arthropoda Arthropoda 150 8.929999999999999e-32   NTclustered gi|936709804|ref|XM_014377377.1| 7493 g45157 i0 80.729 18.9750889679715 192 37 68 0 42 233 332 141 PREDICTED: Trichogramma pretiosum 40S ribosomal protein S14 (LOC106656422), transcript variant X1, mRNA blastn 5332 150 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma pretiosum
13087216 13087216 PRJNA1218816_P_NODE_54271_length_251_cov_0.865169_g53838_i0 PRJNA1218816 54271 251 0.865169 2.17157419 Stilobezzia antennalis 209713 Arthropoda Arthropoda 211 3.55e-50   NTclustered gi|425869758|gb|KC177657.1| 209713 g53838 i0 87.701 47.3426294820717 187 15 73 8 1 184 2748 2929 Stilobezzia antennalis 28S ribosomal RNA gene, partial sequence blastn 11883 211 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Stilobezzia Stilobezzia antennalis
15636316 15636316 PRJNA1218816_P_NODE_41433_length_298_cov_2.368889_g41000_i0 PRJNA1218816 41433 298 2.368889 7.05928922 Megaselia scalaris 36166 Arthropoda Arthropoda 551 2.239999999999999e-152   NTclustered gi|1825679527|gb|MT254755.1| 36166 g41000 i0 100 99.7046979865772 298 0 100 0 1 298 42 339 Megaselia scalaris voucher YN-1 large subunit ribosomal RNA gene, partial sequence blastn 29712 551 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Phoridae Megaselia Megaselia scalaris
16910563 16910563 PRJNA1218816_P_NODE_47974_length_271_cov_1.565657_g47541_i0 PRJNA1218816 47974 271 1.565657 4.24293047 Aethina tumida 116153 Arthropoda Arthropoda 165 3.0600000000000004e-36   NTclustered gi|2284705343|ref|XM_049964852.1| 116153 g47541 i0 82.383 7.52767527675277 193 30 70 4 4 194 511 321 PREDICTED: Aethina tumida 40S ribosomal protein S16 (LOC109604658), transcript variant X2, mRNA blastn 2040 165 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Nitidulidae Aethina Aethina tumida
20734751 20734751 PRJNA1218816_P_NODE_29297_length_374_cov_1.485050_g28864_i0 PRJNA1218816 29297 374 1.48505 5.554087 Adrastia sp. DDM0781 1541304 Arthropoda Arthropoda 209 2e-49   NTclustered gi|946578915|gb|KP419342.1| 1541304 g28864 i0 86.458 54.3983957219251 192 24 59 2 45 236 1177 988 Adrastia sp. DDM0781 28S ribosomal RNA gene, partial sequence blastn 20345 209 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Adrastia Adrastia sp. DDM0781
20734838 20734838 PRJNA1218816_P_NODE_42757_length_292_cov_5.301370_g42324_i0 PRJNA1218816 42757 292 5.30137 15.4800004 Chironomus tepperi 113505 Arthropoda Arthropoda 292 1.46e-74   NTclustered gi|2874203045|ref|XM_070635283.1| 113505 g42324 i0 84.88 97.2020547945205 291 42 99 2 1 290 938 1227 PREDICTED: Chironomus tepperi actin-5C (LOC139086705), transcript variant X1, mRNA blastn 28383 292 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tepperi
20734986 20734986 PRJNA1218816_P_NODE_57897_length_246_cov_1.878613_g57464_i0 PRJNA1218816 57897 246 1.878613 4.62138798 Timema genevievae 629358 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1963345359|emb|OE839378.1| 629358 g57464 i0 100 0.569105691056911 29 0 12 0 204 232 6912 6940 5_Tge_b3v08 blastn 140 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
23285578 23285578 PRJNA1218816_P_NODE_37479_length_318_cov_1.702041_g37046_i0 PRJNA1218816 37479 318 1.702041 5.41249038 Contarinia nasturtii 265458 Arthropoda Arthropoda 193 1.68e-44   NTclustered gi|1779648040|ref|XM_031774719.1| 265458 g37046 i0 79.643 8.62893081761006 280 47 86 9 39 313 120 394 PREDICTED: Contarinia nasturtii 40S ribosomal protein S23 (LOC116345403), mRNA blastn 2744 193 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Contarinia Contarinia nasturtii
24559565 24559565 PRJNA1218816_P_NODE_43320_length_290_cov_1.774194_g42887_i0 PRJNA1218816 43320 290 1.774194 5.1451626 Tetranychus urticae 32264 Arthropoda Arthropoda 75 5.73e-9   NTclustered gi|1390639169|ref|XM_015929023.2| 32264 g42887 i0 87.5 0.658620689655172 64 8 22 0 192 255 378 441 PREDICTED: Tetranychus urticae calreticulin (LOC107362028), mRNA blastn 191 75 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae

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