RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1237347" and tax_clade = "CRuMs"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • CRuMs · 5 ✖

bioproject 1

  • PRJNA1237347 · 5 ✖

analysis 1

  • diamond · 5 ✖

tax_phylum 0

tax_kingdom 0

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
2896505 2896505 PRJNA1237347_P_NODE_5963_length_3189_cov_8.916881_g5127_i0 PRJNA1237347 5963 3189 8.916881 284.35933509 Diphylleia rotans 190327 Root_unresolved Root_unresolved 215 2.4200000000000008e-59   NR YP_009245594.1 190327 g5127 i0 47.6 0.473189087488241 252 116 23.6 4 843 91 6 242 YP_009245594.1 cytochrome c oxydase subunit 2 [Diphylleia rotans] diamond 1509 215 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
5442257 5442257 PRJNA1237347_P_NODE_21885_length_1686_cov_8.623063_g5127_i2 PRJNA1237347 21885 1686 8.623063 145.38484218 Diphylleia rotans 190327 Root_unresolved Root_unresolved 215 4.3999999999999995e-62   NR YP_009245594.1 190327 g5127 i2 47.6 0.895017793594306 252 116 44.7 4 84 836 6 242 YP_009245594.1 cytochrome c oxydase subunit 2 [Diphylleia rotans] diamond 1509 215 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
9270714 9270714 PRJNA1237347_P_NODE_40548_length_1197_cov_9.782918_g5127_i3 PRJNA1237347 40548 1197 9.782918 117.10152846 Diphylleia rotans 190327 Root_unresolved Root_unresolved 215 7.05e-64   NR YP_009245594.1 190327 g5127 i3 47.6 1.26065162907268 252 116 62.9 4 843 91 6 242 YP_009245594.1 cytochrome c oxydase subunit 2 [Diphylleia rotans] diamond 1509 215 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
19462994 19462994 PRJNA1237347_P_NODE_13056_length_2199_cov_9.753057_g5127_i1 PRJNA1237347 13056 2199 9.753057 214.46972343 Diphylleia rotans 190327 Root_unresolved Root_unresolved 215 1.0699999999999999e-60   NR YP_009245594.1 190327 g5127 i1 47.6 0.686221009549795 252 116 34.2 4 2116 1364 6 242 YP_009245594.1 cytochrome c oxydase subunit 2 [Diphylleia rotans] diamond 1509 215 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
24568704 24568704 PRJNA1237347_P_NODE_399540_length_280_cov_1.115942_g392967_i0 PRJNA1237347 399540 280 1.115942 3.1246376 Diphylleia rotans 190327 Root_unresolved Root_unresolved 116 6.71e-30   NR YP_009245594.1 190327 g392967 i0 65.2 0.953571428571429 89 27 95.4 1 13 279 129 213 YP_009245594.1 cytochrome c oxydase subunit 2 [Diphylleia rotans] diamond 267 116 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans

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