RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB82358" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB82358 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
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
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
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
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

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