RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA312107" and tax_clade = "Stenosarchaea group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Stenosarchaea group · 4 ✖

bioproject 1

  • PRJNA312107 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
27453705 27453705 PRJNA312107_P_NODE_22143_length_166_cov_0.888889_g21977_i0 PRJNA312107 22143 166 0.888889 1.47555574 Methanosarcina sp. 2213 Archaea Archaea 53.9 1.35e-6   NR HET8685954.1 2213 g21977 i0 80 1.08433734939759 30 6 54.2 0 6 95 279 308 HET8685954.1 Mu-like prophage major head subunit gpT family protein [Methanosarcina sp.] diamond 180 53.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
28495564 28495564 PRJNA312107_P_NODE_24367_length_163_cov_1.570175_g24201_i0 PRJNA312107 24367 163 1.570175 2.55938525 Methanosarcina sp. 2213 Archaea Archaea 67 3.33e-11   NR HET8685110.1 2213 g24201 i0 75 1.91411042944785 52 13 95.7 0 161 6 345 396 HET8685110.1 hypothetical protein [Methanosarcina sp.] diamond 312 67 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
29821268 29821268 PRJNA312107_P_NODE_14671_length_191_cov_0.760563_g14505_i0 PRJNA312107 14671 191 0.760563 1.45267533 Haloarchaeobius amylolyticus 1198296 Archaea Archaea 42.7 0.0186   NR WP_267639183.1 1198296 g14505 i0 54.1 0.581151832460733 37 17 58.1 0 7 117 342 378 WP_267639183.1 DUF3179 domain-containing protein [Haloarchaeobius amylolyticus] diamond 111 42.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halorubellaceae Haloarchaeobius Haloarchaeobius amylolyticus
32477268 32477268 PRJNA312107_P_NODE_5619_length_299_cov_1.060000_g5453_i0 PRJNA312107 5619 299 1.06 3.1694 Halobacterium hubeiense 1407499 Archaea Archaea 43.1 0.0458   NR WP_143416443.1 1407499 g5453 i0 30.4 0.692307692307692 69 46 67.2 1 18 218 112 180 WP_143416443.1 hypothetical protein [Halobacterium hubeiense] diamond 207 43.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halobacterium Halobacterium hubeiense

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