RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA758770" and tax_phylum = "Chordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chordata · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA758770 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
28862728 28862728 PRJNA758770_S_NODE_29848_length_245_cov_0.906977_g29722_i0 PRJNA758770 29848 245 0.906977 2.22209365 Carnivora 33554 Chordata Chordata 58.5 1.03e-7   NR XP_008706472.1 29073 g29722 i0 65.8 1.82448979591837 38 13 46.5 0 190 77 69 106 XP_008706472.1 protein mono-ADP-ribosyltransferase PARP15 [Ursus maritimus] diamond 447 58.9 0.99320882852292 Eukaryota Opisthokonta Metazoa Chordata Mammalia Carnivora Ursidae Ursus Ursus maritimus
28894311 28894311 PRJNA758770_S_NODE_21788_length_260_cov_2.497326_g21662_i0 PRJNA758770 21788 260 2.497326 6.4930476 Chordata 7711 Chordata Chordata 178 4.46e-56   NR KAF6475981.1 9407 g21662 i0 98.8 20.8384615384615 86 1 99.2 0 259 2 4 89 KAF6475981.1 ribosomal protein L15 [Rousettus aegyptiacus] diamond 5418 179 0.994413407821229 Eukaryota Opisthokonta Metazoa Chordata Mammalia Chiroptera Pteropodidae Rousettus Rousettus aegyptiacus
30716484 30716484 PRJNA758770_S_NODE_31194_length_244_cov_0.912281_g31068_i0 PRJNA758770 31194 244 0.912281 2.22596564 Chiloscyllium punctatum 137246 Chordata Chordata 42.7 0.0364   NR GCC41064.1 137246 g31068 i0 39.7 0.836065573770492 68 33 83.6 1 32 235 72 131 GCC41064.1 hypothetical protein [Chiloscyllium punctatum] diamond 204 42.7 1 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Orectolobiformes Hemiscylliidae Chiloscyllium Chiloscyllium punctatum
31095659 31095659 PRJNA758770_S_NODE_26635_length_249_cov_0.886364_g26509_i0 PRJNA758770 26635 249 0.886364 2.20704636 Camelus dromedarius 9838 Chordata Chordata 52 2.26e-5   NR KAB1260743.1 9838 g26509 i0 62.7 0.614457831325301 51 19 61.4 0 211 59 329 379 KAB1260743.1 Spermatogenesis-associated protein 31E1 [Camelus dromedarius] diamond 153 52 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Camelidae Camelus Camelus dromedarius
32370887 32370887 PRJNA758770_S_NODE_33359_length_227_cov_6.032468_g33233_i0 PRJNA758770 33359 227 6.032468 13.69370236 Chordata 7711 Chordata Chordata 156 1.39e-47   NR KAF6475981.1 9407 g33233 i0 100 26.7621145374449 75 0 99.1 0 1 225 13 87 KAF6475981.1 ribosomal protein L15 [Rousettus aegyptiacus] diamond 6075 156 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Chiroptera Pteropodidae Rousettus Rousettus aegyptiacus
32906828 32906828 PRJNA758770_S_NODE_33140_length_235_cov_2.302469_g33014_i0 PRJNA758770 33140 235 2.302469 5.41080215 root 1 Root_unresolved Root_unresolved 69.3 4.89e-13   NR NP_008530.1 7797 g33014 i0 100 666.829787234043 36 0 46 0 1 108 42 77 NP_008530.1 NADH dehydrogenase subunit 3 [Squalus acanthias] diamond 156705 69.3 1 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Squaliformes Squalidae Squalus Squalus acanthias

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