RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1089179" and tax_phylum = "Chordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chordata · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1089179 · 7 ✖

analysis 1

  • diamond · 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
12496345 12496345 PRJNA1089179_P_NODE_3490_length_436_cov_99.451791_g3472_i0 PRJNA1089179 3490 436 99.451791 433.60980876 Bufo bufo 8384 Chordata Chordata 137 6.69e-39   NR XP_040290996.1 8384 g3472 i0 67.3 8.72477064220183 104 31 69.5 1 87 389 6 109 XP_040290996.1 eukaryotic translation initiation factor 1-like [Bufo bufo] diamond 3804 137 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Bufonidae Bufo Bufo bufo
26900883 26900883 PRJNA1089179_P_NODE_1681_length_567_cov_1.965587_g1664_i0 PRJNA1089179 1681 567 1.965587 11.14487829 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 209 1.74e-65   NR KAI8495949.1 7741 g1664 i0 78.1 48.989417989418 128 28 67.7 0 5 388 63 190 KAI8495949.1 ribosomal protein S18, S13 [Branchiostoma belcheri] diamond 27777 211 0.990521327014218 Eukaryota Opisthokonta Metazoa Chordata Leptocardii Amphioxiformes Branchiostomatidae Branchiostoma Branchiostoma belcheri
27478331 27478331 PRJNA1089179_P_NODE_10503_length_286_cov_4.164319_g10485_i0 PRJNA1089179 10503 286 4.164319 11.90995234 Chiloscyllium plagiosum 36176 Chordata Chordata 85.1 1.62e-17   NR XP_043571982.1 36176 g10485 i0 70.4 3.3986013986014 81 20 85 2 1 243 197 273 XP_043571982.1 60S acidic ribosomal protein P0 isoform X2 [Chiloscyllium plagiosum] diamond 972 85.1 1 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Orectolobiformes Hemiscylliidae Chiloscyllium Chiloscyllium plagiosum
27501504 27501504 PRJNA1089179_P_NODE_5983_length_356_cov_69.003534_g5965_i0 PRJNA1089179 5983 356 69.003534 245.65258104 Aves 8782 Chordata Chordata 110 1.6e-27   NR XP_043932453.1 7888 g5965 i0 49.5 28.1376404494382 105 46 82.6 1 1 294 89 193 XP_043932453.1 cysteine and glycine-rich protein 1 [Protopterus annectens] diamond 10017 111 0.990990990990991 Eukaryota Opisthokonta Metazoa Chordata   Ceratodontiformes Protopteridae Protopterus Protopterus annectens
27857157 27857157 PRJNA1089179_P_NODE_4045_length_413_cov_2.641176_g4027_i0 PRJNA1089179 4045 413 2.641176 10.90805688 Polypterus senegalus 55291 Chordata Chordata 43.5 0.0385   NR KAG2471189.1 55291 g4027 i0 57.1 0.254237288135593 35 15 25.4 0 225 329 92 126 KAG2471189.1 TCB1 transposase, partial [Polypterus senegalus] diamond 105 43.5 1 Eukaryota Opisthokonta Metazoa Chordata Cladistia Polypteriformes Polypteridae Polypterus Polypterus senegalus
29751396 29751396 PRJNA1089179_P_NODE_11011_length_281_cov_549.721154_g10993_i0 PRJNA1089179 11011 281 549.721154 1544.71644274 Heterodontus francisci 7792 Chordata Chordata 49.7 7.94e-6   NR XP_067885022.1 7792 g10993 i0 56.8 1.68683274021352 37 16 39.5 0 72 182 3 39 XP_067885022.1 thymosin beta-10-like [Heterodontus francisci] diamond 474 49.7 1 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Heterodontiformes Heterodontidae Heterodontus Heterodontus francisci
30193811 30193811 PRJNA1089179_P_NODE_7152_length_333_cov_2.092308_g7134_i0 PRJNA1089179 7152 333 2.092308 6.96738564 Staurois parvus 386267 Chordata Chordata 55.1 6.72e-7   NR CAI9548327.1 386267 g7134 i0 57.4 1.9009009009009 54 18 44.1 1 258 112 47 100 CAI9548327.1 unnamed protein product [Staurois parvus] diamond 633 55.1 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus

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