RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "blastn", bioproject = "PRJNA807347" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 21 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA807347 · 21 ✖

analysis 1

  • blastn · 21 ✖
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
2082014 2082014 PRJNA807347_P_NODE_12842_length_250_cov_0.881356_g12739_i0 PRJNA807347 12842 250 0.881356 2.20339 Medioppia subpectinata 1979941 Arthropoda Arthropoda 350 7.17e-92   NTclustered gi|1964571811|emb|OC898266.1| 1979941 g12739 i0 98.492 0.796 199 2 80 1 1 199 663 860 Medioppia subpectinata blastn 199 350 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
2082062 2082062 PRJNA807347_P_NODE_4002_length_415_cov_1.394737_g3899_i0 PRJNA807347 4002 415 1.394737 5.78815855 Medioppia subpectinata 1979941 Arthropoda Arthropoda 448 4.3599999999999986e-121   NTclustered gi|1964414875|emb|OC887612.1| 1979941 g3899 i0 89.326 1.30120481927711 356 38 99 0 3 358 1122 1477 Medioppia subpectinata blastn 540 448 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
4634755 4634755 PRJNA807347_P_NODE_5204_length_361_cov_1.055556_g5101_i0 PRJNA807347 5204 361 1.055556 3.81055716 Medioppia subpectinata 1979941 Arthropoda Arthropoda 667 0   NTclustered gi|1964414875|emb|OC887612.1| 1979941 g5101 i0 100 1 361 0 100 0 1 361 647 1007 Medioppia subpectinata blastn 361 667 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
4634766 4634766 PRJNA807347_P_NODE_7764_length_294_cov_1.117647_g7661_i0 PRJNA807347 7764 294 1.117647 3.28588218 Medioppia subpectinata 1979941 Arthropoda Arthropoda 239 1.95e-58   NTclustered gi|1964697451|emb|OC907926.1| 1979941 g7661 i0 100 0.438775510204082 129 0 44 0 1 129 129 1 Medioppia subpectinata blastn 129 239 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
5050660 5050660 PRJNA807347_P_NODE_4944_length_370_cov_3.481481_g4841_i0 PRJNA807347 4944 370 3.481481 12.8814797 root 1 Root_unresolved Root_unresolved 654 0   NTclustered gi|78097480|gb|AC167666.4| 7176 g4841 i0 98.645 280.697297297297 369 5 99 0 2 370 1249 881 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940120D9, complete sequence blastn 103858 656 0.996951219512195 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
8459325 8459325 PRJNA807347_P_NODE_6787_length_314_cov_1.597510_g6684_i0 PRJNA807347 6787 314 1.59751 5.0161814 Drymonia dodonaea 988176 Arthropoda Arthropoda 52.8 0.029   NTclustered gi|2918369752|emb|OZ237818.1| 988176 g6684 i0 94.286 0.200636942675159 35 0 11 2 226 258 1063289 1063323 Drymonia dodonaea genome assembly, chromosome: 25 blastn 63 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Notodontidae Drymonia Drymonia dodonaea
9734269 9734269 PRJNA807347_P_NODE_10588_length_262_cov_1.560847_g10485_i0 PRJNA807347 10588 262 1.560847 4.08941914 Timema genevievae 629358 Arthropoda Arthropoda 102 2.34e-17   NTclustered gi|1965355231|emb|OE846699.1| 629358 g10485 i0 87.778 0.343511450381679 90 8 34 3 175 262 11194 11106 5_Tge_b3v08 blastn 90 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
9734346 9734346 PRJNA807347_P_NODE_3908_length_421_cov_1.149425_g3805_i0 PRJNA807347 3908 421 1.149425 4.83907925 Macrobrachium rosenbergii 79674 Arthropoda Arthropoda 52.8 0.041   NTclustered gi|2782975314|ref|XM_067106207.1| 79674 g3805 i0 96.875 0.0760095011876485 32 0 8 1 75 106 95 125 PREDICTED: Macrobrachium rosenbergii uncharacterized protein (LOC136839932), mRNA blastn 32 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium rosenbergii
11010165 11010165 PRJNA807347_P_NODE_17969_length_211_cov_4.144928_g17866_i0 PRJNA807347 17969 211 4.144928 8.74579808 Anarta stigmosa 1869462 Arthropoda Arthropoda 58.4 3.98e-4   NTclustered gi|2918376415|emb|OZ237984.1| 1869462 g17866 i0 100 0.303317535545024 31 0 15 0 158 188 2906898 2906928 Anarta stigmosa genome assembly, chromosome: 8 blastn 64 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Anarta Anarta stigmosa
12285668 12285668 PRJNA807347_P_NODE_11490_length_254_cov_1.497238_g11387_i0 PRJNA807347 11490 254 1.497238 3.80298452 Drosophila guttifera 66368 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|188501857|gb|EU493604.1| 66368 g11387 i0 100 0.110236220472441 28 0 11 0 13 40 166 139 Drosophila guttifera voucher 103968 NADH dehydrogenase subunit 2 (ND2) gene, partial cds; tRNA-Trp and tRNA-Cys genes, complete sequence; tRNA-Tyr gene, partial sequence; and cytochrome c oxidase subunit I (COI) gene, partial cds; mitochondrial blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila guttifera
12285728 12285728 PRJNA807347_P_NODE_4210_length_404_cov_0.969789_g4107_i0 PRJNA807347 4210 404 0.969789 3.91794756 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.039   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g4107 i0 100 0.0693069306930693 28 0 7 0 260 287 14100628 14100601 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
14834561 14834561 PRJNA807347_P_NODE_6952_length_311_cov_0.936975_g6849_i0 PRJNA807347 6952 311 0.936975 2.91399225 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.029   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g6849 i0 100 0.090032154340836 28 0 9 0 107 134 14100628 14100601 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
17384561 17384561 PRJNA807347_P_NODE_12614_length_251_cov_0.870787_g12511_i0 PRJNA807347 12614 251 0.870787 2.18567537 Oppiella nova 334625 Arthropoda Arthropoda 459 1.1499999999999996e-124   NTclustered gi|1964807365|emb|OC914831.1| 334625 g12511 i0 99.602 33.3505976095618 251 1 100 0 1 251 17433 17683 Oppiella nova blastn 8371 459 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
18657729 18657729 PRJNA807347_P_NODE_6255_length_328_cov_1.219608_g6152_i0 PRJNA807347 6255 328 1.219608 4.00031424 Oppiella nova 334625 Arthropoda Arthropoda 52.8 0.031   NTclustered gi|1964085647|emb|OC941541.1| 334625 g6152 i0 100 0.0853658536585366 28 0 9 0 238 265 972 945 Oppiella nova blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
21208585 21208585 PRJNA807347_P_NODE_16137_length_244_cov_0.888889_g16034_i0 PRJNA807347 16137 244 0.888889 2.16888916 Timema tahoe 61484 Arthropoda Arthropoda 130 9.88e-26   NTclustered gi|1948135830|emb|OE002248.1| 61484 g16034 i0 78.537 0.840163934426229 205 39 82 3 45 244 84599 84803 4_Tte_b3v08 blastn 205 130 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
21208618 21208618 PRJNA807347_P_NODE_5677_length_344_cov_1.793358_g5574_i0 PRJNA807347 5677 344 1.793358 6.16915152 Drosophila bipectinata 42026 Arthropoda Arthropoda 54.7 0.009   NTclustered gi|2867867655|ref|XM_070283165.1| 42026 g5574 i0 100 0.674418604651163 29 0 8 0 69 97 736 764 PREDICTED: Drosophila bipectinata uncharacterized protein (LOC108132457), transcript variant X5, mRNA blastn 232 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila bipectinata
21208634 21208634 PRJNA807347_P_NODE_9177_length_276_cov_1.773399_g9074_i0 PRJNA807347 9177 276 1.773399 4.89458124 Charissa obscurata 204503 Arthropoda Arthropoda 52.8 0.025   NTclustered gi|2919567361|emb|OZ238376.1| 204503 g9074 i0 100 0.101449275362319 28 0 10 0 140 167 18753008 18752981 Charissa obscurata genome assembly, chromosome: 10 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Charissa Charissa obscurata
22483155 22483155 PRJNA807347_P_NODE_12778_length_250_cov_1.316384_g12675_i0 PRJNA807347 12778 250 1.316384 3.29096 Medioppia subpectinata 1979941 Arthropoda Arthropoda 333 7.219999999999999e-87   NTclustered gi|1964697451|emb|OC907926.1| 1979941 g12675 i0 90.763 0.996 249 23 99 0 2 250 227 475 Medioppia subpectinata blastn 249 333 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
22483189 22483189 PRJNA807347_P_NODE_16818_length_242_cov_1.366864_g16715_i0 PRJNA807347 16818 242 1.366864 3.30781088 Medioppia subpectinata 1979941 Arthropoda Arthropoda 230 9.38e-56   NTclustered gi|1964571811|emb|OC898266.1| 1979941 g16715 i0 97.744 0.549586776859504 133 3 55 0 110 242 1 133 Medioppia subpectinata blastn 133 230 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
25032708 25032708 PRJNA807347_P_NODE_12300_length_251_cov_1.438202_g12197_i0 PRJNA807347 12300 251 1.438202 3.60988702 Periplaneta americana 6978 Arthropoda Arthropoda 364 2.57e-96   NTclustered gi|2852206118|ref|XR_011332570.1| 6978 g12197 i0 92.857 44.2509960159363 252 17 100 1 1 251 524 775 PREDICTED: Periplaneta americana uncharacterized lncRNA (LOC138701441), ncRNA blastn 11107 364 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
25449149 25449149 PRJNA807347_P_NODE_16740_length_242_cov_1.834320_g16637_i0 PRJNA807347 16740 242 1.83432 4.4390544 Timema 61471 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1936992576|emb|OA570236.1| 61478 g16637 i0 100 0.247933884297521 30 0 12 0 96 125 5761 5732 1_Tdi_b3v08 blastn 60 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi

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