RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "blastn", bioproject = "PRJNA757618" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 24 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA757618 · 24 ✖

analysis 1

  • blastn · 24 ✖
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
732608 732608 PRJNA757618_P_NODE_39481_length_246_cov_0.895954_g38429_i0 PRJNA757618 39481 246 0.895954 2.20404684 Formica selysi 208979 Arthropoda Arthropoda 366 6.99e-97   NTclustered gi|47522443|emb|AJ508847.1| 208979 g38429 i0 93.522 73.1869918699187 247 14 100 2 1 246 357 602 Formica selysi satellite DNA, clone pFOSE-3 blastn 18004 366 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Formica Formica selysi
732796 732796 PRJNA757618_P_NODE_8201_length_392_cov_419.874608_g7149_i0 PRJNA757618 8201 392 419.874608 1645.90846336 Parasteatoda tepidariorum 114398 Arthropoda Arthropoda 113 1.7e-20   NTclustered gi|2899174507|ref|XM_016049079.3| 114398 g7149 i0 98.438 2.00255102040816 64 1 71 0 192 255 315 252 PREDICTED: Parasteatoda tepidariorum uncharacterized protein (LOC107437169), mRNA blastn 785 113 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Theridiidae Parasteatoda Parasteatoda tepidariorum
2477953 2477953 PRJNA757618_P_NODE_46982_length_242_cov_0.923077_g45930_i0 PRJNA757618 46982 242 0.923077 2.23384634 Chironomidae 7149 Arthropoda Arthropoda 383 6.81e-102   NTclustered gi|2490581732|gb|OQ834354.1| 2044905 g45930 i0 96.537 95.5495867768595 231 8 95 0 1 231 1817 1587 Monodiamesa kamora isolate EAM256 large subunit ribosomal RNA gene, partial sequence blastn 23123 383 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Monodiamesa Monodiamesa kamora
3283471 3283471 PRJNA757618_P_NODE_10063_length_352_cov_2.308244_g9011_i0 PRJNA757618 10063 352 2.308244 8.12501888 Ilyocryptus agilis 435267 Arthropoda Arthropoda 651 0   NTclustered gi|2488180980|emb|OC986661.1| 435267 g9011 i0 100 2 352 0 100 0 1 352 2597 2948 Ilyocryptus agilis EOG090X08QZ gene for EOG090X08QZ blastn 704 651 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Macrotrichidae Ilyocryptus Ilyocryptus agilis
3284022 3284022 PRJNA757618_P_NODE_43163_length_244_cov_0.912281_g42111_i0 PRJNA757618 43163 244 0.912281 2.22596564 Lucilia sericata 13632 Arthropoda Arthropoda 115 2.77e-21   NTclustered gi|836552876|gb|KR133394.1| 13632 g42111 i0 94.667 4.22540983606557 75 3 30 1 119 192 3897 3971 Lucilia sericata 28S ribosomal RNA gene, complete sequence blastn 1031 115 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia sericata
4560600 4560600 PRJNA757618_P_NODE_11604_length_333_cov_0.776923_g10552_i0 PRJNA757618 11604 333 0.776923 2.58715359 Macrobrachium nipponense 159736 Arthropoda Arthropoda 303 7.85e-78   NTclustered gi|2708493235|ref|XM_064255188.1| 159736 g10552 i0 88.538 3.96096096096096 253 26 76 3 37 289 325 76 PREDICTED: Macrobrachium nipponense uncharacterized LOC135218738 (LOC135218738), mRNA blastn 1319 303 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium nipponense
4560909 4560909 PRJNA757618_P_NODE_26704_length_253_cov_0.866667_g25652_i0 PRJNA757618 26704 253 0.866667 2.19266751 Timema cristinae 61476 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1947364141|emb|OC329059.1| 61476 g25652 i0 92.308 0.154150197628458 39 1 15 2 8 45 2227 2190 3_Tce_b3v08 blastn 39 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema cristinae
5835888 5835888 PRJNA757618_P_NODE_20345_length_275_cov_1.514851_g19293_i0 PRJNA757618 20345 275 1.514851 4.16584025 Dermatophagoides farinae 6954 Arthropoda Arthropoda 508 1.2499999999999999e-139   NTclustered gi|2205472635|ref|XM_047055924.1| 6954 g19293 i0 100 2 275 0 100 0 1 275 2275 2549 PREDICTED: Dermatophagoides farinae transcriptional repressor NF-X1-like (LOC124492603), transcript variant X1, mRNA blastn 550 508 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
5836103 5836103 PRJNA757618_P_NODE_3285_length_1359_cov_2.146967_g2371_i0 PRJNA757618 3285 1359 2.146967 29.17728153 Oppiella nova 334625 Arthropoda Arthropoda 595 5.13e-165   NTclustered gi|1964613267|emb|OC975412.1| 334625 g2371 i0 98.806 0.246504782928624 335 3 25 1 1026 1359 533 199 Oppiella nova blastn 335 595 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
8386065 8386065 PRJNA757618_P_NODE_46407_length_243_cov_0.900000_g45355_i0 PRJNA757618 46407 243 0.9 2.187 Timema douglasi 61478 Arthropoda Arthropoda 316 7.03e-82   NTclustered gi|1936669430|emb|OA622568.1| 61478 g45355 i0 90.164 1.93415637860082 244 23 100 1 1 243 427 184 1_Tdi_b3v08 blastn 470 316 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
9660986 9660986 PRJNA757618_P_NODE_30548_length_251_cov_0.865169_g29496_i0 PRJNA757618 30548 251 0.865169 2.17157419 Drosophila rhopaloa 1041015 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|2118793391|ref|XM_017122079.2| 1041015 g29496 i0 100 0.111553784860558 28 0 11 0 32 59 1904 1931 PREDICTED: Drosophila rhopaloa neurogenic protein mastermind (LOC108043383), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila rhopaloa
10936867 10936867 PRJNA757618_P_NODE_49329_length_205_cov_3.856061_g48277_i0 PRJNA757618 49329 205 3.856061 7.90492505 Parasteatoda tepidariorum 114398 Arthropoda Arthropoda 270 4.54e-68   NTclustered gi|2899174507|ref|XM_016049079.3| 114398 g48277 i0 91.089 1.93658536585366 202 15 99 2 1 202 49 247 PREDICTED: Parasteatoda tepidariorum uncharacterized protein (LOC107437169), mRNA blastn 397 270 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Theridiidae Parasteatoda Parasteatoda tepidariorum
11406283 11406283 PRJNA757618_P_NODE_33189_length_249_cov_0.886364_g32137_i0 PRJNA757618 33189 249 0.886364 2.20704636 root 1 Root_unresolved Root_unresolved 460 3.16e-125   NTclustered gi|91176468|gb|AC167662.6| 7176 g32137 i0 100 9.00401606425703 249 0 100 0 1 249 60566 60814 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940141D9, complete sequence blastn 2242 460 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
11406396 11406396 PRJNA757618_P_NODE_6469_length_473_cov_1.060000_g5417_i0 PRJNA757618 6469 473 1.06 5.0138 root 1 Root_unresolved Root_unresolved 830 0   NTclustered gi|78190082|gb|AC168047.3| 7176 g5417 i0 98.309 71.9429175475687 473 8 100 0 1 473 66316 65844 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence blastn 34029 830 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
13486594 13486594 PRJNA757618_P_NODE_5531_length_566_cov_19.198783_g4481_i0 PRJNA757618 5531 566 19.198783 108.66511178 Timema monikensis 170555 Arthropoda Arthropoda 58.4 0.001   NTclustered gi|1946411097|emb|OB793204.1| 170555 g4481 i0 97.059 0.164310954063604 34 1 6 0 302 335 168543 168510 3_Tms_b3v08 blastn 93 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema monikensis
16035212 16035212 PRJNA757618_P_NODE_33373_length_249_cov_0.886364_g32321_i0 PRJNA757618 33373 249 0.886364 2.20704636 Shevtchenkella serrata 2883626 Arthropoda Arthropoda 143 1.3e-29   NTclustered gi|2112782721|gb|OK491613.1| 2883626 g32321 i0 78.03 20.9799196787149 264 33 100 17 1 249 2944 2691 Shevtchenkella serrata isolate d241proto large subunit ribosomal RNA gene, partial sequence blastn 5224 143 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Eriophyidae Shevtchenkella Shevtchenkella serrata
16035275 16035275 PRJNA757618_P_NODE_37773_length_247_cov_0.890805_g36721_i0 PRJNA757618 37773 247 0.890805 2.20028835 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 457 4.05e-124   NTclustered gi|1535895715|ref|XM_027343136.1| 6956 g36721 i0 100 3 247 0 100 0 1 247 3808 3562 PREDICTED: Dermatophagoides pteronyssinus zinc finger SWIM domain-containing protein 4-like (LOC113793150), mRNA blastn 741 457 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
19859477 19859477 PRJNA757618_P_NODE_25636_length_256_cov_1.213115_g24584_i0 PRJNA757618 25636 256 1.213115 3.1055744 Medioppia subpectinata 1979941 Arthropoda Arthropoda 372 1.57e-98   NTclustered gi|1964414875|emb|OC887612.1| 1979941 g24584 i0 92.941 0.99609375 255 18 99 0 2 256 1184 930 Medioppia subpectinata blastn 255 372 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
21604835 21604835 PRJNA757618_P_NODE_9757_length_358_cov_0.929825_g8705_i0 PRJNA757618 9757 358 0.929825 3.3287735 root 1 Root_unresolved Root_unresolved 645 1.2199999999999996e-180   NTclustered gi|78190082|gb|AC168047.3| 7176 g8705 i0 99.162 76.6201117318436 358 3 100 0 1 358 79077 79434 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence blastn 27430 645 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
22409969 22409969 PRJNA757618_P_NODE_36998_length_247_cov_0.896552_g35946_i0 PRJNA757618 36998 247 0.896552 2.21448344 Eriocheir sinensis 95602 Arthropoda Arthropoda 67.6 7.97e-7   NTclustered gi|2311918098|ref|XR_007755323.1| 95602 g35946 i0 74.074 4.34008097165992 189 38 87 8 64 245 2300 2116 PREDICTED: Eriocheir sinensis uncharacterized LOC127001525 (LOC127001525), transcript variant X4, ncRNA blastn 1072 67.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Varunidae Eriocheir Eriocheir sinensis
22880073 22880073 PRJNA757618_P_NODE_34338_length_249_cov_0.875000_g33286_i0 PRJNA757618 34338 249 0.875 2.17875 root 1 Root_unresolved Root_unresolved 455 1.47e-123   NTclustered gi|78190082|gb|AC168047.3| 7176 g33286 i0 99.598 30.8393574297189 249 1 100 0 1 249 33101 33349 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence blastn 7679 455 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
24959072 24959072 PRJNA757618_P_NODE_29340_length_251_cov_0.876404_g28288_i0 PRJNA757618 29340 251 0.876404 2.19977404 Limnephilus auricula 1271728 Arthropoda Arthropoda 65.8 2.92e-6   NTclustered gi|2518562593|emb|OX638418.1| 1271728 g28288 i0 88.889 0.215139442231076 54 4 21 2 18 70 11258 11206 Limnephilus auricula genome assembly, organelle: mitochondrion blastn 54 65.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Trichoptera Limnephilidae Limnephilus Limnephilus auricula
24959162 24959162 PRJNA757618_P_NODE_35360_length_248_cov_0.891429_g34308_i0 PRJNA757618 35360 248 0.891429 2.21074392 Platynothrus peltifer 128015 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2579718319|gb|CP133308.1| 128015 g34308 i0 94.595 0.149193548387097 37 0 14 1 142 176 19067765 19067801 Platynothrus peltifer isolate 155_3 chromosome 3 blastn 37 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Camisiidae Platynothrus Platynothrus peltifer
24959174 24959174 PRJNA757618_P_NODE_36140_length_248_cov_0.880000_g35088_i0 PRJNA757618 36140 248 0.88 2.1824 Macrobrachium rosenbergii 79674 Arthropoda Arthropoda 228 3.469999999999999e-55   NTclustered gi|2782967910|ref|XM_067100574.1| 79674 g35088 i0 86.512 0.866935483870968 215 20 85 5 23 232 3236 3446 PREDICTED: Macrobrachium rosenbergii protein mono-ADP-ribosyltransferase PARP12-like (LOC136836377), transcript variant X7, mRNA blastn 215 228 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium rosenbergii

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