RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "blastn", bioproject = "PRJNA804229" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 23 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA804229 · 23 ✖

analysis 1

  • blastn · 23 ✖
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
2077779 2077779 PRJNA804229_S_NODE_123502_length_183_cov_15.078571_g122544_i0 PRJNA804229 123502 183 15.078571 27.59378493 Timema cristinae 61476 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|1947004354|emb|OC319116.1| 61476 g122544 i0 100 0.316939890710383 29 0 16 0 155 183 57669 57697 3_Tce_b3v08 blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema cristinae
2078982 2078982 PRJNA804229_S_NODE_173282_length_154_cov_3.459459_g172324_i0 PRJNA804229 173282 154 3.459459 5.32756686 Leiobunum subalpinum 3086104 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2920024126|emb|OZ239121.1| 3086104 g172324 i0 96.875 0.415584415584416 32 1 21 0 79 110 54110156 54110187 Leiobunum subalpinum genome assembly, chromosome: 4 blastn 64 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Opiliones Sclerosomatidae Leiobunum Leiobunum subalpinum
3773750 3773750 PRJNA804229_S_NODE_13723_length_449_cov_1.748768_g12780_i0 PRJNA804229 13723 449 1.748768 7.85196832 Insecta 50557 Arthropoda Arthropoda 52.8 0.043   NTclustered gi|2919985595|emb|OZ208568.1| 7091 g12780 i0 100 0.249443207126949 28 0 6 0 1 28 2067914 2067887 Bombyx mori genome assembly, chromosome: 19 blastn 112 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
5906529 5906529 PRJNA804229_S_NODE_168425_length_157_cov_1.263158_g167467_i0 PRJNA804229 168425 157 1.263158 1.98315806 Microplitis mediator 375433 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2520960774|ref|XR_008989464.1| 375433 g167467 i0 100 0.369426751592357 29 0 18 0 31 59 5417 5389 PREDICTED: Microplitis mediator calcium-transporting ATPase sarcoplasmic/endoplasmic reticulum type (LOC130664762), transcript variant X2, misc_RNA blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Microplitis Microplitis mediator
5907701 5907701 PRJNA804229_S_NODE_48605_length_285_cov_23.442149_g47647_i0 PRJNA804229 48605 285 23.442149 66.81012465 Centruroides edwardsii 2565419 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|1761173678|gb|MK932020.1| 2565419 g47647 i0 100 0.101754385964912 29 0 10 0 257 285 59 31 Centruroides edwardsii antimicrobial non-disulfide-bridged peptide (CR13_25) mRNA, partial cds blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides edwardsii
5908858 5908858 PRJNA804229_S_NODE_90165_length_214_cov_2.040936_g89207_i0 PRJNA804229 90165 214 2.040936 4.36760304 Penaeus monodon 6687 Arthropoda Arthropoda 58.4 4.05e-4   NTclustered gi|1832334880|gb|MK599468.1| 6687 g89207 i0 100 0.668224299065421 31 0 14 0 184 214 117 87 Penaeus monodon C-type lectin mRNA, complete cds blastn 143 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus monodon
7181582 7181582 PRJNA804229_S_NODE_178346_length_153_cov_0.872727_g177388_i0 PRJNA804229 178346 153 0.872727 1.33527231 Timema shepardi 629360 Arthropoda Arthropoda 54.7 0.003   NTclustered gi|1937847262|emb|OC002191.1| 629360 g177388 i0 100 0.189542483660131 29 0 19 0 96 124 1773 1745 2_Tsi_b3v08 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema shepardi
8456446 8456446 PRJNA804229_S_NODE_186747_length_151_cov_0.888889_g185789_i0 PRJNA804229 186747 151 0.888889 1.34222239 Tigriopus californicus 6832 Arthropoda Arthropoda 58.4 2.65e-4   NTclustered gi|2571342124|ref|XM_059231319.1| 6832 g185789 i0 100 0.205298013245033 31 0 21 0 22 52 1448 1478 PREDICTED: Tigriopus californicus prolow-density lipoprotein receptor-related protein 1-like (LOC131883766), mRNA blastn 31 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
9729992 9729992 PRJNA804229_S_NODE_121308_length_185_cov_1.690141_g120350_i0 PRJNA804229 121308 185 1.690141 3.12676085 Vespula vulgaris 7454 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2313468068|ref|XM_050993551.1| 7454 g120350 i0 96.875 0.345945945945946 32 1 17 0 145 176 909 940 PREDICTED: Vespula vulgaris G protein-coupled receptor kinase 2 (LOC127063573), transcript variant X3, mRNA blastn 64 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Vespula Vespula vulgaris
10150624 10150624 PRJNA804229_S_NODE_62048_length_256_cov_4.910798_g61090_i0 PRJNA804229 62048 256 4.910798 12.57164288 Arthropoda 6656 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|1026137028|emb|LT560377.1| 85552 g61090 i0 100 0.328125 28 0 11 0 1 28 7 34 Scylla paramamosain ALF6 gene for anti-lipopolysaccharide factor 6 blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
11007422 11007422 PRJNA804229_S_NODE_188489_length_150_cov_1.345794_g187531_i0 PRJNA804229 188489 150 1.345794 2.018691 Timema bartmani 61472 Arthropoda Arthropoda 52.8 0.012   NTclustered gi|1947880527|emb|OD571572.1| 61472 g187531 i0 100 0.186666666666667 28 0 19 0 34 61 5675 5648 4_Tbi_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
13556937 13556937 PRJNA804229_S_NODE_179231_length_152_cov_9.596330_g178273_i0 PRJNA804229 179231 152 9.59633 14.5864216 Prorops nasuta 863751 Arthropoda Arthropoda 52.8 0.012   NTclustered gi|2781159700|ref|XM_066742737.1| 863751 g178273 i0 100 0.184210526315789 28 0 18 0 13 40 1657 1630 PREDICTED: Prorops nasuta scaffold attachment factor B2-like (LOC136782956), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Bethylidae Prorops Prorops nasuta
14830309 14830309 PRJNA804229_S_NODE_120972_length_185_cov_2.683099_g120014_i0 PRJNA804229 120972 185 2.683099 4.96373315 Rhynchophorus ferrugineus 354439 Arthropoda Arthropoda 52.8 0.016   NTclustered gi|1044897043|gb|KT223635.1| 354439 g120014 i0 100 0.151351351351351 28 0 15 0 1 28 32 59 Rhynchophorus ferrugineus isolate RPWSSHCyp60 cathepsin L mRNA, partial cds blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Rhynchophorus Rhynchophorus ferrugineus
16104417 16104417 PRJNA804229_S_NODE_122733_length_184_cov_1.702128_g121775_i0 PRJNA804229 122733 184 1.702128 3.13191552 Scylla paramamosain 85552 Arthropoda Arthropoda 52.8 0.016   NTclustered gi|1184387702|emb|LT835105.1| 85552 g121775 i0 100 0.152173913043478 28 0 15 0 1 28 8 35 Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene) blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
16524867 16524867 PRJNA804229_S_NODE_36913_length_320_cov_1.451264_g35955_i0 PRJNA804229 36913 320 1.451264 4.6440448 Arthropoda 6656 Arthropoda Arthropoda 52.8 0.03   NTclustered gi|1026137028|emb|LT560377.1| 85552 g35955 i0 100 0.2625 28 0 9 0 293 320 34 7 Scylla paramamosain ALF6 gene for anti-lipopolysaccharide factor 6 blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
17799656 17799656 PRJNA804229_S_NODE_50814_length_280_cov_2.831224_g49856_i0 PRJNA804229 50814 280 2.831224 7.9274272 Timema 61471 Arthropoda Arthropoda 62.1 4.29e-5   NTclustered gi|1947838656|emb|OD567419.1| 61472 g49856 i0 94.872 1.4 39 2 14 0 9 47 82863 82825 4_Tbi_b3v08 blastn 392 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
21624137 21624137 PRJNA804229_S_NODE_60677_length_259_cov_2.208333_g59719_i0 PRJNA804229 60677 259 2.208333 5.71958247 Timema 61471 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|1947819235|emb|OD566261.1| 61472 g59719 i0 100 0.223938223938224 29 0 11 0 17 45 111477 111505 4_Tbi_b3v08 blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
21624154 21624154 PRJNA804229_S_NODE_82057_length_224_cov_4.900552_g81099_i0 PRJNA804229 82057 224 4.900552 10.97723648 Arthropoda 6656 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1026137028|emb|LT560377.1| 85552 g81099 i0 100 0.901785714285714 30 0 13 0 195 224 35 6 Scylla paramamosain ALF6 gene for anti-lipopolysaccharide factor 6 blastn 202 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
22479453 22479453 PRJNA804229_S_NODE_14138_length_444_cov_8.119701_g13191_i0 PRJNA804229 14138 444 8.119701 36.05147244 Timema monikensis 170555 Arthropoda Arthropoda 58.4 0.001   NTclustered gi|1946411097|emb|OB793204.1| 170555 g13191 i0 97.059 0.202702702702703 34 1 8 0 88 121 168510 168543 3_Tms_b3v08 blastn 90 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema monikensis
23758219 23758219 PRJNA804229_S_NODE_95999_length_208_cov_0.872727_g95041_i0 PRJNA804229 95999 208 0.872727 1.81527216 Satyrium ilicis 876074 Arthropoda Arthropoda 52.8 0.018   NTclustered gi|2918386087|emb|OZ238120.1| 876074 g95041 i0 100 0.134615384615385 28 0 13 0 119 146 33846095 33846122 Satyrium ilicis genome assembly, chromosome: 11 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
25028813 25028813 PRJNA804229_S_NODE_136940_length_174_cov_2.198473_g135982_i0 PRJNA804229 136940 174 2.198473 3.82534302 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 60.2 8.75e-5   NTclustered gi|2919538070|emb|OZ238348.1| 1002887 g135982 i0 97.222 0.551724137931034 36 0 21 1 119 154 23637965 23637999 Glaucopsyche melanops genome assembly, chromosome: 7 blastn 96 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
25028826 25028826 PRJNA804229_S_NODE_13740_length_448_cov_12.520988_g12797_i0 PRJNA804229 13740 448 12.520988 56.09402624 Timema californicum 61474 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|1965181363|emb|OE475415.1| 61474 g12797 i0 90.909 0.0982142857142857 44 1 9 2 293 333 266 309 2_Tcm_b3v08 blastn 44 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
25029215 25029215 PRJNA804229_S_NODE_152980_length_165_cov_1.180328_g152022_i0 PRJNA804229 152980 165 1.180328 1.9475412 Leiobunum subalpinum 3086104 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2920023453|emb|OZ239118.1| 3086104 g152022 i0 100 0.175757575757576 29 0 18 0 54 82 55820326 55820354 Leiobunum subalpinum genome assembly, chromosome: 1 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Opiliones Sclerosomatidae Leiobunum Leiobunum subalpinum

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