RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA911178" and tax_phylum = "Methanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Methanobacteriota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA911178 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
4720379 4720379 PRJNA911178_P_NODE_171844_length_288_cov_1.158140_g169371_i0 PRJNA911178 171844 288 1.15814 3.3354432 Halorubrum sp. CBA1229 1853699 Archaea Archaea 462 1.04e-125   NTclustered gi|1861358827|gb|CP054585.1| 1853699 g169371 i0 96.429 8.16666666666667 280 10 97 0 9 288 1483314 1483593 Halorubrum sp. CBA1229 chromosome, complete genome blastn 2352 462 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum sp. CBA1229
5996473 5996473 PRJNA911178_P_NODE_52505_length_479_cov_1.312808_g50070_i0 PRJNA911178 52505 479 1.312808 6.28835032 Methanobacterium palustre 2171 Archaea Archaea 800 0   NTclustered gi|584298062|gb|KF882001.1| 2171 g50070 i0 96.875 131.254697286013 480 11 99 2 4 479 599 1078 Methanobacterium palustre strain F 23S ribosomal RNA gene, partial sequence blastn 62871 800 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium palustre
15278204 15278204 PRJNA911178_P_NODE_275312_length_244_cov_1.456140_g272838_i0 PRJNA911178 275312 244 1.45614 3.5529816 Methanomada group 2283794 Archaea Archaea 113 9.95e-21   NTclustered gi|2891700162|gb|CP178165.1| 213231 g272838 i0 89.773 39.3688524590164 88 9 36 0 5 92 710149 710236 Methanocaldococcus indicus strain SL43 chromosome, complete genome blastn 9606 113 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanococci Methanococcales Methanocaldococcaceae Methanocaldococcus Methanocaldococcus indicus
17827903 17827903 PRJNA911178_P_NODE_304654_length_227_cov_3.071429_g302180_i0 PRJNA911178 304654 227 3.071429 6.97214383 Methanobacterium 2160 Archaea Archaea 353 4.95e-93   NTclustered gi|110180147|gb|DQ649333.1| 2171 g302180 i0 96.729 112.42731277533 214 3 93 2 1 210 214 1 Methanobacterium palustre strain 21 16S ribosomal RNA gene, partial sequence blastn 25521 353 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium palustre
21294304 21294304 PRJNA911178_P_NODE_231397_length_255_cov_1.653846_g228923_i0 PRJNA911178 231397 255 1.653846 4.2173073 Halorussus gelatinilyticus 2937524 Archaea Archaea 78.7 3.82e-10   NTclustered gi|2234308622|gb|CP096658.1| 2937524 g228923 i0 88.06 0.262745098039216 67 6 26 2 177 242 2188778 2188843 Halorussus gelatinilyticus strain XZYJT40 chromosome, complete genome blastn 67 78.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haladaptataceae Halorussus Halorussus gelatinilyticus

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