RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA939415" and tax_phylum = "Chordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chordata · 9 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA939415 · 9 ✖

analysis 1

  • diamond · 9 ✖
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
27119689 27119689 PRJNA939415_P_NODE_88582_length_246_cov_7.751445_g88160_i0 PRJNA939415 88582 246 7.751445 19.0685547 Ailuropoda melanoleuca 9646 Chordata Chordata 48.5 3.58e-4   NR XP_034499549.1 9646 g88160 i0 59.2 0.597560975609756 49 20 59.8 0 61 207 6 54 XP_034499549.1 basic proline-rich protein-like [Ailuropoda melanoleuca] diamond 147 48.5 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Carnivora Ursidae Ailuropoda Ailuropoda melanoleuca
27404515 27404515 PRJNA939415_P_NODE_67463_length_266_cov_2.792746_g67041_i0 PRJNA939415 67463 266 2.792746 7.42870436 Sus scrofa 9823 Chordata Chordata 63.9 1.67e-9   NR XP_020937686.1 9823 g67041 i0 53.1 0.721804511278195 64 30 72.2 0 192 1 4 67 XP_020937686.1 spidroin-2-like [Sus scrofa] diamond 192 63.9 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Suidae Sus Sus scrofa
27593883 27593883 PRJNA939415_P_NODE_108004_length_215_cov_5.619718_g107582_i0 PRJNA939415 108004 215 5.619718 12.0823937 Jaculus jaculus 51337 Chordata Chordata 42.4 0.0353   NR XP_045002131.1 51337 g107582 i0 41.8 0.767441860465116 55 29 76.7 2 213 49 376 427 XP_045002131.1 sialate O-acetylesterase isoform X2 [Jaculus jaculus] diamond 165 42.4 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Dipodidae Jaculus Jaculus jaculus
28288239 28288239 PRJNA939415_P_NODE_33246_length_310_cov_2.641350_g32824_i0 PRJNA939415 33246 310 2.64135 8.188185 Mimus melanotis 245851 Chordata Chordata 53.9 5.21e-6   NR KAL2302336.1 245851 g32824 i0 40.8 1.3741935483871 71 39 68.7 1 1 213 146 213 KAL2302336.1 hypothetical protein Nmel_009760, partial [Mimus melanotis] diamond 426 53.9 1 Eukaryota Opisthokonta Metazoa Chordata Aves Passeriformes Mimidae Mimus Mimus melanotis
28509424 28509424 PRJNA939415_P_NODE_15347_length_396_cov_2.770898_g14927_i0 PRJNA939415 15347 396 2.770898 10.97275608 Sus scrofa 9823 Chordata Chordata 265 4.89e-84   NR XP_020938199.1 9823 g14927 i0 100 1.98484848484848 131 0 99.2 0 3 395 141 271 XP_020938199.1 ribonuclease inhibitor isoform X2 [Sus scrofa] diamond 786 265 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Suidae Sus Sus scrofa
29362004 29362004 PRJNA939415_P_NODE_54369_length_279_cov_2.776699_g53947_i0 PRJNA939415 54369 279 2.776699 7.74699021 Ovis aries 9940 Chordata Chordata 59.3 7.28e-8   NR XDC64044.1 9940 g53947 i0 74.4 0.419354838709677 39 10 41.9 0 6 122 290 328 XDC64044.1 hypothetical protein R6Z07M_015226 [Ovis aries] diamond 117 59.3 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Bovidae Ovis Ovis aries
30814996 30814996 PRJNA939415_P_NODE_90234_length_245_cov_2.668605_g89812_i0 PRJNA939415 90234 245 2.668605 6.53808225 Eschrichtius robustus 9764 Chordata Chordata 44.3 0.0104   NR KAJ8797273.1 9764 g89812 i0 64.5 0.379591836734694 31 11 38 0 153 245 321 351 KAJ8797273.1 hypothetical protein J1605_017501 [Eschrichtius robustus] diamond 93 44.3 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Eschrichtiidae Eschrichtius Eschrichtius robustus
31415463 31415463 PRJNA939415_P_NODE_107096_length_219_cov_6.020548_g106674_i0 PRJNA939415 107096 219 6.020548 13.18500012 Sus scrofa 9823 Chordata Chordata 52.8 8.19e-6   NR XP_020946894.1 9823 g106674 i0 50 0.73972602739726 54 27 74 0 162 1 406 459 XP_020946894.1 collagen alpha-2(I) chain-like [Sus scrofa] diamond 162 52.8 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Suidae Sus Sus scrofa
32143195 32143195 PRJNA939415_P_NODE_75858_length_258_cov_2.356757_g75436_i0 PRJNA939415 75858 258 2.356757 6.08043306 Tympanuchus pallidicinctus 109042 Chordata Chordata 43.1 0.0264   NR XP_052541780.1 109042 g75436 i0 51.9 0.627906976744186 54 22 62.8 2 93 254 79 128 XP_052541780.1 protein FAM246C-like [Tympanuchus pallidicinctus] diamond 162 43.1 1 Eukaryota Opisthokonta Metazoa Chordata Aves Galliformes Phasianidae Tympanuchus Tympanuchus pallidicinctus

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