RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "blastn", bioproject = "PRJNA753704" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 28 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA753704 · 28 ✖

analysis 1

  • blastn · 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
730985 730985 PRJNA753704_P_NODE_21661_length_262_cov_2.269841_g21300_i0 PRJNA753704 21661 262 2.269841 5.94698342 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.024   NTclustered gi|2919539186|emb|OZ238349.1| 1002887 g21300 i0 100 0.106870229007634 28 0 11 0 216 243 13857175 13857202 Glaucopsyche melanops genome assembly, chromosome: 8 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
731029 731029 PRJNA753704_P_NODE_25121_length_249_cov_1.170455_g24760_i0 PRJNA753704 25121 249 1.170455 2.91443295 Anopheles nili 185578 Arthropoda Arthropoda 63.9 1.04e-5   NTclustered gi|2449484023|ref|XM_053823634.1| 185578 g24760 i0 97.297 0.437751004016064 37 1 15 0 4 40 817 853 PREDICTED: Anopheles nili protein DEK (LOC128730566), transcript variant X1, mRNA blastn 109 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles nili
1202065 1202065 PRJNA753704_P_NODE_5021_length_508_cov_1.760920_g4660_i0 PRJNA753704 5021 508 1.76092 8.9454736 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 52.8 0.05   NTclustered gi|1936999732|emb|OA570574.1| 61478 g4660 i0 100 0.165354330708661 28 0 6 0 49 76 8976 8949 1_Tdi_b3v08 blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
2007049 2007049 PRJNA753704_P_NODE_20082_length_271_cov_2.262626_g19721_i0 PRJNA753704 20082 271 2.262626 6.13171646 Centruroides sculpturatus 218467 Arthropoda Arthropoda 111 4.04e-20   NTclustered gi|1316158401|ref|XM_023368565.1| 218467 g19721 i0 89.888 0.656826568265683 89 5 32 4 25 111 107 21 PREDICTED: Centruroides sculpturatus heat shock 70 kDa protein cognate 4 (LOC111625425), transcript variant X2, mRNA blastn 178 111 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides sculpturatus
3282249 3282249 PRJNA753704_P_NODE_11363_length_351_cov_2.507194_g11002_i0 PRJNA753704 11363 351 2.507194 8.80025094 Papilio polytes 76194 Arthropoda Arthropoda 492 1.6499999999999999e-134   NTclustered gi|389615034|dbj|AK405121.1| 76194 g11002 i0 98.905 0.780626780626781 274 3 78 0 1 274 274 1 Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis blastn 274 492 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
3282427 3282427 PRJNA753704_P_NODE_26163_length_247_cov_0.896552_g25802_i0 PRJNA753704 26163 247 0.896552 2.21448344 Uranotaenia lowii 190385 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2499584421|ref|XM_055733801.1| 190385 g25802 i0 100 0.11336032388664 28 0 11 0 125 152 2272 2245 PREDICTED: Uranotaenia lowii uncharacterized LOC129741966 (LOC129741966), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Uranotaenia Uranotaenia lowii
3282466 3282466 PRJNA753704_P_NODE_29623_length_232_cov_2.635220_g29262_i0 PRJNA753704 29623 232 2.63522 6.1137104 Drosophila ficusphila 30025 Arthropoda Arthropoda 209 1.16e-49   NTclustered gi|2085101051|ref|XM_017205697.2| 30025 g29262 i0 85.294 62.2198275862069 204 28 88 2 30 232 753 955 PREDICTED: Drosophila ficusphila V-type proton ATPase catalytic subunit A (LOC108101380), mRNA blastn 14435 209 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila ficusphila
4559590 4559590 PRJNA753704_P_NODE_30524_length_219_cov_6.123288_g30163_i0 PRJNA753704 30524 219 6.123288 13.41000072 Nicrophorus vespilloides 110193 Arthropoda Arthropoda 182 2.37e-41   NTclustered gi|1059385930|ref|XM_017912695.1| 110193 g30163 i0 81.735 56.8036529680365 219 38 99 2 2 219 2257 2040 PREDICTED: Nicrophorus vespilloides polyubiquitin-C (LOC108556541), mRNA blastn 12440 182 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Silphidae Nicrophorus Nicrophorus vespilloides
5834533 5834533 PRJNA753704_P_NODE_12225_length_340_cov_1.168539_g11864_i0 PRJNA753704 12225 340 1.168539 3.9730326 Photinus pyralis 7054 Arthropoda Arthropoda 52.8 0.032   NTclustered gi|1770365324|ref|XM_031496064.1| 7054 g11864 i0 100 0.247058823529412 28 0 8 0 90 117 3490 3517 PREDICTED: Photinus pyralis uncharacterized LOC116177171 (LOC116177171), transcript variant X2, mRNA blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Photinus Photinus pyralis
5834757 5834757 PRJNA753704_P_NODE_3745_length_579_cov_7.160079_g3388_i0 PRJNA753704 3745 579 7.160079 41.45685741 Ceutorhynchus obstrictus 307131 Arthropoda Arthropoda 54.7 0.016   NTclustered gi|2918376580|emb|OZ238010.1| 307131 g3388 i0 96.875 0.542314335060449 32 1 6 0 377 408 7913943 7913974 Ceutorhynchus obstrictus genome assembly, chromosome: 1 blastn 314 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Ceutorhynchus Ceutorhynchus obstrictus
7109637 7109637 PRJNA753704_P_NODE_10766_length_360_cov_6.393728_g10405_i0 PRJNA753704 10766 360 6.393728 23.0174208 Palaemon carinicauda 392227 Arthropoda Arthropoda 52.8 0.034   NTclustered gi|2804919397|ref|XR_011044301.1| 392227 g10405 i0 100 0.388888888888889 28 0 8 0 199 226 901 928 PREDICTED: Palaemon carinicauda uncharacterized lncRNA (LOC137640098), ncRNA blastn 140 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Palaemon Palaemon carinicauda
7109813 7109813 PRJNA753704_P_NODE_26346_length_246_cov_1.901734_g25985_i0 PRJNA753704 26346 246 1.901734 4.67826564 Rhagoletis zephyria 28612 Arthropoda Arthropoda 93.5 1.31e-14   NTclustered gi|1048031821|ref|XM_017634379.1| 28612 g25985 i0 86.747 7.23577235772358 83 11 34 0 163 245 419 337 PREDICTED: Rhagoletis zephyria 60S ribosomal protein L19-like (LOC108378078), mRNA blastn 1780 93.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
7109816 7109816 PRJNA753704_P_NODE_26566_length_246_cov_0.901734_g26205_i0 PRJNA753704 26566 246 0.901734 2.21826564 Oppiella nova 334625 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|1962586414|emb|OC916738.1| 334625 g26205 i0 91.892 0.150406504065041 37 3 15 0 29 65 871 907 Oppiella nova blastn 37 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
8384220 8384220 PRJNA753704_P_NODE_10287_length_368_cov_3.515254_g9926_i0 PRJNA753704 10287 368 3.515254 12.93613472 Longitarsus dorsalis 346795 Arthropoda Arthropoda 52.8 0.035   NTclustered gi|2918386054|emb|OZ238097.1| 346795 g9926 i0 96.774 0.0842391304347826 31 1 8 0 120 150 16006740 16006770 Longitarsus dorsalis genome assembly, chromosome: 4 blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Longitarsus Longitarsus dorsalis
8384438 8384438 PRJNA753704_P_NODE_30047_length_228_cov_3.425806_g29686_i0 PRJNA753704 30047 228 3.425806 7.81083768 Macrothrix elegans 527138 Arthropoda Arthropoda 411 2.909999999999999e-110   NTclustered gi|2488187296|emb|OC989411.1| 527138 g29686 i0 99.123 11.4210526315789 228 2 100 0 1 228 5422 5195 Macrothrix elegans EOG090X01U4 gene for EOG090X01U4 blastn 2604 411 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Macrotrichidae Macrothrix Macrothrix elegans
8855034 8855034 PRJNA753704_P_NODE_20787_length_267_cov_1.608247_g20426_i0 PRJNA753704 20787 267 1.608247 4.29401949 root 1 Root_unresolved Root_unresolved 494 3.38e-135   NTclustered gi|76443734|gb|AC164954.3| 7176 g20426 i0 100 108.955056179775 267 0 100 0 1 267 54979 54713 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940128D9, complete sequence blastn 29091 494 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
9659484 9659484 PRJNA753704_P_NODE_14908_length_310_cov_2.253165_g14547_i0 PRJNA753704 14908 310 2.253165 6.9848115 Phronia biarcuata 2565953 Arthropoda Arthropoda 226 1.6099999999999998e-54   NTclustered gi|1624435184|gb|MK190947.1| 2565953 g14547 i0 83.74 87.8225806451613 246 32 78 6 1 242 145 386 Phronia biarcuata voucher JSPhBi elongation factor 1-alpha (EF1a) gene, partial cds blastn 27225 226 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Mycetophilidae Phronia Phronia biarcuata
9659560 9659560 PRJNA753704_P_NODE_22328_length_258_cov_4.491892_g21967_i0 PRJNA753704 22328 258 4.491892 11.58908136 Satyrium ilicis 876074 Arthropoda Arthropoda 58.4 5.05e-4   NTclustered gi|2918386101|emb|OZ238115.1| 876074 g21967 i0 90.698 0.166666666666667 43 4 17 0 125 167 56559237 56559195 Satyrium ilicis genome assembly, chromosome: 6 blastn 43 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
10935077 10935077 PRJNA753704_P_NODE_21729_length_262_cov_1.333333_g21368_i0 PRJNA753704 21729 262 1.333333 3.49333246 Samia ricini 63990 Arthropoda Arthropoda 180 1.0499999999999999e-40   NTclustered gi|2883230270|dbj|AP038904.1| 63990 g21368 i0 79.762 80.3282442748092 252 47 95 4 1 250 9569667 9569418 Samia ricini White GU1 DNA, chromosome 09, complete sequence blastn 21046 180 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Saturniidae Samia Samia ricini
10935136 10935136 PRJNA753704_P_NODE_26549_length_246_cov_0.901734_g26188_i0 PRJNA753704 26549 246 0.901734 2.21826564 Armigeres subalbatus 124917 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2668996364|ref|XM_062689881.1| 124917 g26188 i0 100 0.113821138211382 28 0 11 0 208 235 1076 1103 PREDICTED: Armigeres subalbatus diencephalon/mesencephalon homeobox protein 1 (LOC134212219), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Armigeres Armigeres subalbatus
16033649 16033649 PRJNA753704_P_NODE_19653_length_274_cov_1.442786_g19292_i0 PRJNA753704 19653 274 1.442786 3.95323364 Culex quinquefasciatus 7176 Arthropoda Arthropoda 490 4.499999999999999e-134   NTclustered gi|76443734|gb|AC164954.3| 7176 g19292 i0 98.905 7.99270072992701 274 3 100 0 1 274 52143 52416 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940128D9, complete sequence blastn 2190 490 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
16033712 16033712 PRJNA753704_P_NODE_24773_length_250_cov_0.881356_g24412_i0 PRJNA753704 24773 250 0.881356 2.20339 Timema poppense 170557 Arthropoda Arthropoda 60.2 1.35e-4   NTclustered gi|1946148679|emb|OD000257.1| 170557 g24412 i0 97.222 1.152 36 0 14 1 11 46 130204 130238 1_Tps_b3v08 blastn 288 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema poppense
17779868 17779868 PRJNA753704_P_NODE_9114_length_387_cov_4.458599_g8753_i0 PRJNA753704 9114 387 4.458599 17.25477813 Diptera 7147 Arthropoda Arthropoda 224 7.399999999999998e-54   NTclustered gi|2202985638|ref|XM_023449373.2| 7375 g8753 i0 84.12 70.1266149870801 233 35 60 2 8 239 150 381 PREDICTED: Lucilia cuprina ubiquitin-60S ribosomal protein L40 (LOC111686969), mRNA blastn 27139 226 0.991150442477876 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia cuprina
18582849 18582849 PRJNA753704_P_NODE_15435_length_305_cov_2.297414_g15074_i0 PRJNA753704 15435 305 2.297414 7.0071127 Papilio polytes 76194 Arthropoda Arthropoda 525 1.39e-144   NTclustered gi|389615034|dbj|AK405121.1| 76194 g15074 i0 97.705 3.77704918032787 305 7 100 0 1 305 306 610 Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis blastn 1152 525 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
18582990 18582990 PRJNA753704_P_NODE_28515_length_242_cov_0.923077_g28154_i0 PRJNA753704 28515 242 0.923077 2.23384634 Ctenocephalides felis 7515 Arthropoda Arthropoda 102 2.13e-17   NTclustered gi|1484486398|ref|XM_026616753.1| 7515 g28154 i0 95.312 0.65702479338843 64 3 39 0 4 67 5064 5001 PREDICTED: Ctenocephalides felis protein split ends (LOC113376723), mRNA blastn 159 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Siphonaptera Pulicidae Ctenocephalides Ctenocephalides felis
19858211 19858211 PRJNA753704_P_NODE_6256_length_460_cov_2.098191_g5895_i0 PRJNA753704 6256 460 2.098191 9.6516786 Timema californicum 61474 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|1965181363|emb|OE475415.1| 61474 g5895 i0 90.909 0.0956521739130435 44 1 9 2 2 42 266 309 2_Tcm_b3v08 blastn 44 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
20328461 20328461 PRJNA753704_P_NODE_19276_length_276_cov_2.177340_g18915_i0 PRJNA753704 19276 276 2.17734 6.0094584 Opisthokonta 33154 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|2205476841|ref|XM_047062996.1| 6954 g18915 i0 100 6.25 29 0 11 0 239 267 94 122 PREDICTED: Dermatophagoides farinae rac GTPase-activating protein 1-like (LOC124499128), mRNA blastn 1725 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
21133685 21133685 PRJNA753704_P_NODE_29757_length_231_cov_2.556962_g29396_i0 PRJNA753704 29757 231 2.556962 5.90658222 Schistocerca piceifrons 274613 Arthropoda Arthropoda 62.1 3.43e-5   NTclustered gi|2213221137|ref|XM_047256101.1| 274613 g29396 i0 100 5.80952380952381 33 0 14 0 90 122 1960 1928 PREDICTED: Schistocerca piceifrons ubiquitin carboxyl-terminal hydrolase 34 (LOC124788817), mRNA blastn 1342 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca piceifrons

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