RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJEB82358" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 15 ✖

tax_clade 1

bioproject 1

  • PRJEB82358 · 15 ✖

analysis 1

  • blastn · 15 ✖
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
2690920 2690920 PRJEB82358_P_NODE_22803_length_207_cov_7.679104_g22792_i0 PRJEB82358 22803 207 7.679104 15.89574528 Callophrys avis 700180 Arthropoda Arthropoda 52.8 0.018   NTclustered gi|2918385566|emb|OZ238083.1| 700180 g22792 i0 100 0.135265700483092 28 0 14 0 81 108 10789159 10789186 Callophrys avis genome assembly, chromosome: 16 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Callophrys Callophrys avis
7374943 7374943 PRJEB82358_P_NODE_12126_length_288_cov_1.427907_g12115_i0 PRJEB82358 12126 288 1.427907 4.11237216 Timema 61471 Arthropoda Arthropoda 52.8 0.027   NTclustered gi|1964671119|emb|OE183157.1| 61474 g12115 i0 100 0.875 28 0 10 0 8 35 35433 35460 2_Tcm_b3v08 blastn 252 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
7793239 7793239 PRJEB82358_P_NODE_9887_length_315_cov_2.599174_g9876_i0 PRJEB82358 9887 315 2.599174 8.1873981 Hyperolius riggenbachi 752182 Chordata Chordata 52.8 0.029   NTclustered gi|2801417439|ref|XM_068274716.1| 752182 g9876 i0 96.875 0.101587301587302 32 0 10 1 201 231 1894 1863 PREDICTED: Hyperolius riggenbachi beta-4C adrenergic receptor-like (LOC137562906), mRNA blastn 32 52.8 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Hyperoliidae Hyperolius Hyperolius riggenbachi
10343831 10343831 PRJEB82358_P_NODE_23949_length_196_cov_10.609756_g23938_i0 PRJEB82358 23949 196 10.609756 20.79512176 Bos javanicus 9906 Chordata Chordata 248 2.0099999999999997e-61   NTclustered gi|2633695114|ref|XR_009739007.1| 9906 g23938 i0 96.078 300.760204081633 153 4 77 2 46 196 1020 868 PREDICTED: Bos javanicus uncharacterized LOC133255677 (LOC133255677), transcript variant X2, ncRNA blastn 58949 248 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Bovidae Bos Bos javanicus
13750853 13750853 PRJEB82358_P_NODE_18651_length_242_cov_0.893491_g18640_i0 PRJEB82358 18651 242 0.893491 2.16224822 Bombus 28641 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2245572015|ref|XM_003394000.4| 30195 g18640 i0 100 0.462809917355372 28 0 12 0 143 170 734 707 PREDICTED: Bombus terrestris striatin-interacting protein 1 (LOC100642989), mRNA blastn 112 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus terrestris
14169177 14169177 PRJEB82358_P_NODE_13432_length_275_cov_6.846535_g13421_i0 PRJEB82358 13432 275 6.846535 18.82797125 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|1964819819|emb|OC862830.1| 1979941 g13421 i0 96.97 0.12 33 0 12 1 74 105 62 30 Medioppia subpectinata blastn 33 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
14169243 14169243 PRJEB82358_P_NODE_21792_length_218_cov_5.772414_g21781_i0 PRJEB82358 21792 218 5.772414 12.58386252 Bubalus bubalis 89462 Chordata Chordata 333 6.149999999999999e-87   NTclustered gi|2128315095|ref|XM_006056336.3| 89462 g21781 i0 97.449 40.0596330275229 196 4 89 1 24 218 312 117 PREDICTED: Bubalus bubalis phosphorylase kinase regulatory subunit alpha 2 (PHKA2), transcript variant X1, mRNA blastn 8733 333 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Bovidae Bubalus Bubalus bubalis
15443457 15443457 PRJEB82358_P_NODE_9853_length_315_cov_5.438017_g9842_i0 PRJEB82358 9853 315 5.438017 17.12975355 Bradybaena similaris 145626 Mollusca Mollusca 56.5 0.002   NTclustered gi|2912983111|dbj|AP039588.1| 145626 g9842 i0 94.595 0.758730158730159 37 0 11 2 171 206 8646731 8646696 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence blastn 239 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
16717486 16717486 PRJEB82358_P_NODE_12134_length_288_cov_1.120930_g12123_i0 PRJEB82358 12134 288 1.12093 3.2282784 Teleiodes vulgella 1594352 Arthropoda Arthropoda 52.8 0.027   NTclustered gi|2918369950|emb|OZ237932.1| 1594352 g12123 i0 100 0.0972222222222222 28 0 10 0 147 174 5440124 5440151 Teleiodes vulgella genome assembly, chromosome: 13 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Gelechiidae Teleiodes Teleiodes vulgella
16717574 16717574 PRJEB82358_P_NODE_23294_length_202_cov_8.023256_g23283_i0 PRJEB82358 23294 202 8.023256 16.20697712 Lampetra planeri 7750 Chordata Chordata 52.8 0.018   NTclustered gi|2814964231|emb|OZ078336.2| 7750 g23283 i0 100 0.415841584158416 28 0 14 0 37 64 15291749 15291776 Lampetra planeri genome assembly, chromosome: 13 blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Chordata Hyperoartia Petromyzontiformes Petromyzontidae Lampetra Lampetra planeri
17575392 17575392 PRJEB82358_P_NODE_7014_length_365_cov_2.821918_g7003_i0 PRJEB82358 7014 365 2.821918 10.3000007 Orectolobiformes 30503 Chordata Chordata 52.8 0.035   NTclustered gi|2618641569|ref|XR_009644699.1| 170820 g7003 i0 100 0.383561643835616 28 0 8 0 1 28 148 121 PREDICTED: Hemiscyllium ocellatum uncharacterized LOC132815721 (LOC132815721), transcript variant X2, ncRNA blastn 140 52.8 1 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Orectolobiformes Hemiscylliidae Hemiscyllium Hemiscyllium ocellatum
17992330 17992330 PRJEB82358_P_NODE_17055_length_249_cov_1.698864_g17044_i0 PRJEB82358 17055 249 1.698864 4.23017136 Callophrys avis 700180 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|2918386004|emb|OZ238075.1| 700180 g17044 i0 94.444 1.1566265060241 36 1 14 1 49 84 41843761 41843795 Callophrys avis genome assembly, chromosome: 8 blastn 288 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Callophrys Callophrys avis
17992351 17992351 PRJEB82358_P_NODE_20135_length_232_cov_2.880503_g20124_i0 PRJEB82358 20135 232 2.880503 6.68276696 Canis lupus 9612 Chordata Chordata 52.8 0.021   NTclustered gi|45736810|gb|AC147680.4| 9615 g20124 i0 100 0.120689655172414 28 0 12 0 35 62 71596 71569 Canis Familiaris, clone XX-10H12, complete sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Carnivora Canidae Canis Canis lupus
20541786 20541786 PRJEB82358_P_NODE_20497_length_229_cov_11.884615_g20486_i0 PRJEB82358 20497 229 11.884615 27.21576835 Medioppia subpectinata 1979941 Arthropoda Arthropoda 52.8 0.02   NTclustered gi|1962570271|emb|OC904162.1| 1979941 g20486 i0 100 0.122270742358079 28 0 12 0 104 131 261 288 Medioppia subpectinata blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
21817582 21817582 PRJEB82358_P_NODE_21298_length_224_cov_5.423841_g21287_i0 PRJEB82358 21298 224 5.423841 12.14940384 Bradybaena similaris 145626 Mollusca Mollusca 100 7.01e-17   NTclustered gi|2912988862|dbj|AP039593.1| 145626 g21287 i0 80.272 0.65625 147 18 64 10 80 222 24439650 24439789 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence blastn 147 100 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris

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