RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA745923" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA745923 · 13 ✖

analysis 1

  • blastn · 13 ✖
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
3275821 3275821 PRJNA745923_S_NODE_10903_length_313_cov_1.600000_g10571_i0 PRJNA745923 10903 313 1.6 5.008 Bactrocera dorsalis 27457 Arthropoda Arthropoda 58.4 6.29e-4   NTclustered gi|2273979271|ref|XR_007423258.1| 27457 g10571 i0 100 0.396166134185303 31 0 10 0 282 312 6285 6255 PREDICTED: Bactrocera dorsalis uncharacterized LOC125779335 (LOC125779335), transcript variant X1, misc_RNA blastn 124 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera dorsalis
3750592 3750592 PRJNA745923_S_NODE_23023_length_202_cov_1.735849_g22691_i0 PRJNA745923 23023 202 1.735849 3.50641498 root 1 Root_unresolved Root_unresolved 52.8 0.018   NTclustered gi|1184387702|emb|LT835105.1| 85552 g22691 i0 100 0.277227722772277 28 0 14 0 1 28 6 33 Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene) blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
5828275 5828275 PRJNA745923_S_NODE_18305_length_231_cov_2.042553_g17973_i0 PRJNA745923 18305 231 2.042553 4.71829743 Timema californicum 61474 Arthropoda Arthropoda 52.8 0.021   NTclustered gi|1962683356|emb|OE185345.1| 61474 g17973 i0 100 0.121212121212121 28 0 12 0 34 61 6361 6388 2_Tcm_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
6302997 6302997 PRJNA745923_S_NODE_7725_length_379_cov_25.419643_g7393_i0 PRJNA745923 7725 379 25.419643 96.34044697 Arthropoda 6656 Arthropoda Arthropoda 54.7 0.01   NTclustered gi|1026137028|emb|LT560377.1| 85552 g7393 i0 100 0.598944591029024 29 0 8 0 1 29 6 34 Scylla paramamosain ALF6 gene for anti-lipopolysaccharide factor 6 blastn 227 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
8377893 8377893 PRJNA745923_S_NODE_12227_length_293_cov_1.920000_g11895_i0 PRJNA745923 12227 293 1.92 5.6256 Timema californicum 61474 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1965181363|emb|OE475415.1| 61474 g11895 i0 90.909 0.150170648464164 44 1 14 2 233 273 266 309 2_Tcm_b3v08 blastn 44 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
9653183 9653183 PRJNA745923_S_NODE_24848_length_194_cov_1.509934_g24516_i0 PRJNA745923 24848 194 1.509934 2.92927196 Daphnia pulex 6669 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|2192734159|ref|XM_046600325.1| 6669 g24516 i0 94.595 0.762886597938144 37 0 18 2 75 109 8498 8462 PREDICTED: Daphnia pulex serine/arginine repetitive matrix protein 2-like (LOC124203620), transcript variant X3, mRNA blastn 148 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
12204161 12204161 PRJNA745923_S_NODE_22730_length_203_cov_5.981250_g22398_i0 PRJNA745923 22730 203 5.98125 12.1419375 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|2919553660|emb|OZ238364.1| 1002887 g22398 i0 96.875 0.315270935960591 32 1 16 0 67 98 24059124 24059155 Glaucopsyche melanops genome assembly, chromosome: W blastn 64 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
16027519 16027519 PRJNA745923_S_NODE_35673_length_158_cov_1.252174_g35341_i0 PRJNA745923 35673 158 1.252174 1.97843492 Ctenocephalides felis 7515 Arthropoda Arthropoda 52.8 0.013   NTclustered gi|1484478782|ref|XM_026612584.1| 7515 g35341 i0 100 0.177215189873418 28 0 18 0 95 122 2484 2511 PREDICTED: Ctenocephalides felis serine/threonine-protein kinase 24-like (LOC113372259), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Siphonaptera Pulicidae Ctenocephalides Ctenocephalides felis
17302961 17302961 PRJNA745923_S_NODE_35234_length_159_cov_1.586207_g34902_i0 PRJNA745923 35234 159 1.586207 2.52206913 Satyrium ilicis 876074 Arthropoda Arthropoda 58.4 2.83e-4   NTclustered gi|2918386101|emb|OZ238115.1| 876074 g34902 i0 90.698 0.270440251572327 43 4 27 0 33 75 56559237 56559195 Satyrium ilicis genome assembly, chromosome: 6 blastn 43 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
17776527 17776527 PRJNA745923_S_NODE_13354_length_278_cov_2.042553_g13022_i0 PRJNA745923 13354 278 2.042553 5.67829734 Timema 61471 Arthropoda Arthropoda 52.8 0.026   NTclustered gi|1962715900|emb|OE213409.1| 61474 g13022 i0 94.286 0.226618705035971 35 0 12 2 211 243 2371 2405 2_Tcm_b3v08 blastn 63 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
21127297 21127297 PRJNA745923_S_NODE_23177_length_201_cov_3.575949_g22845_i0 PRJNA745923 23177 201 3.575949 7.18765749 Platynothrus peltifer 128015 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|2579718320|gb|CP133309.1| 128015 g22845 i0 94.444 0.17910447761194 36 1 17 1 12 46 16604718 16604683 Platynothrus peltifer isolate 155_3 chromosome 4 blastn 36 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Camisiidae Platynothrus Platynothrus peltifer
22402040 22402040 PRJNA745923_S_NODE_17378_length_238_cov_2.461538_g17046_i0 PRJNA745923 17378 238 2.461538 5.85846044 Drymonia dodonaea 988176 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|2918369734|emb|OZ237800.1| 988176 g17046 i0 87.755 0.205882352941176 49 2 20 4 152 198 10958875 10958829 Drymonia dodonaea genome assembly, chromosome: 7 blastn 49 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Notodontidae Drymonia Drymonia dodonaea
22402297 22402297 PRJNA745923_S_NODE_33838_length_163_cov_1.200000_g33506_i0 PRJNA745923 33838 163 1.2 1.956 Oppiella nova 334625 Arthropoda Arthropoda 52.8 0.014   NTclustered gi|1962586414|emb|OC916738.1| 334625 g33506 i0 91.892 0.226993865030675 37 3 23 0 21 57 871 907 Oppiella nova blastn 37 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova

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