RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA533623" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA533623 · 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
4333204 4333204 PRJNA533623_P_NODE_29744_length_416_cov_9.859155_g27974_i0 PRJNA533623 29744 416 9.859155 41.0140848 Halococcus qingdaonensis 224402 Archaea Archaea 691 0   NTclustered gi|2281256326|gb|CP101943.1| 224402 g27974 i0 98.966 1.90384615384615 387 2 93 2 8 394 2477290 2477674 Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome blastn 792 691 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus qingdaonensis
5609693 5609693 PRJNA533623_P_NODE_15605_length_597_cov_9.809701_g13894_i0 PRJNA533623 15605 597 9.809701 58.56391497 Salinirubellus litoreus 3131999 Archaea Archaea 54.7 0.016   NTclustered gi|2700494409|gb|CP147841.1| 3131999 g13894 i0 100 0.0485762144053601 29 0 5 0 483 511 2445208 2445236 Salinirubellus litoreus strain SYNS196 chromosome, complete genome blastn 29 54.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Salinirubellus Salinirubellus litoreus
7496058 7496058 PRJNA533623_P_NODE_45586_length_315_cov_3.913386_g43810_i0 PRJNA533623 45586 315 3.913386 12.3271659 Methanothrix 2222 Archaea Archaea 505 1.8799999999999995e-138   NTclustered gi|2133328945|gb|CP086219.1| 90426 g43810 i0 99.283 1.77142857142857 279 2 89 0 14 292 1633763 1633485 MAG: Methanothrix sp. isolate MAG 281 chromosome blastn 558 505 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix sp.
8158758 8158758 PRJNA533623_P_NODE_15707_length_595_cov_8.595506_g13996_i0 PRJNA533623 15707 595 8.595506 51.1432607 Haloferax sp. S1W 3377110 Archaea Archaea 84.2 2.09e-11   NTclustered gi|2845109985|gb|CP172595.1| 3377110 g13996 i0 90.476 0.105882352941176 63 6 11 0 481 543 648036 648098 Haloferax sp. S1W chromosome, complete genome blastn 63 84.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloferax Haloferax sp. S1W
20908970 20908970 PRJNA533623_P_NODE_60997_length_250_cov_4.238095_g59217_i0 PRJNA533623 60997 250 4.238095 10.5952375 Halobaculum halobium 3032281 Archaea Archaea 176 1.2899999999999999e-39   NTclustered gi|2511738011|gb|CP126159.1| 3032281 g59217 i0 83 11.928 200 28 79 4 13 209 286422 286618 Halobaculum halobium strain SYNS20 plasmid unnamed1, complete sequence blastn 2982 176 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halobaculum Halobaculum halobium

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