RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA859990" and tax_clade = "Methanomada group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Methanomada group · 6 ✖

bioproject 1

  • PRJNA859990 · 6 ✖

analysis 1

  • blastn · 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
845899 845899 PRJNA859990_S_NODE_2341_length_603_cov_1.967925_g2085_i0 PRJNA859990 2341 603 1.967925 11.86658775 Methanobrevibacter sp. YE315 1609968 Archaea Archaea 939 0   NTclustered gi|985614202|gb|CP010834.1| 1609968 g2085 i0 94.868 69.8789386401327 604 26 100 5 1 603 494571 495170 Methanobrevibacter sp. YE315, complete genome blastn 42137 939 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp. YE315
2511589 2511589 PRJNA859990_S_NODE_15862_length_263_cov_1.531579_g15601_i0 PRJNA859990 15862 263 1.531579 4.02805277 Methanobrevibacter 2172 Archaea Archaea 335 2.129999999999999e-87   NTclustered gi|1294447101|gb|CP017803.1| 2173 g15601 i0 100 89.106463878327 181 0 69 0 11 191 266547 266367 Methanobrevibacter smithii strain KB11 chromosome, complete genome blastn 23435 335 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
4674298 4674298 PRJNA859990_S_NODE_15724_length_264_cov_2.450262_g15463_i0 PRJNA859990 15724 264 2.450262 6.46869168 Methanobrevibacter sp. YE315 1609968 Archaea Archaea 399 7.479999999999998e-107   NTclustered gi|985614202|gb|CP010834.1| 1609968 g15463 i0 93.962 96.1856060606061 265 14 100 2 1 264 496019 496282 Methanobrevibacter sp. YE315, complete genome blastn 25393 399 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp. YE315
12715654 12715654 PRJNA859990_S_NODE_19670_length_246_cov_1.537572_g19409_i0 PRJNA859990 19670 246 1.537572 3.78242712 Methanobrevibacter 2172 Archaea Archaea 444 3.14e-120   NTclustered gi|968564921|gb|CP011266.1| 230361 g19409 i0 99.187 161.979674796748 246 2 100 0 1 246 543076 543321 Methanobrevibacter millerae strain SM9, complete genome blastn 39847 444 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter millerae
17813684 17813684 PRJNA859990_S_NODE_6314_length_393_cov_1.593750_g6053_i0 PRJNA859990 6314 393 1.59375 6.2634375 Methanobrevibacter 2172 Archaea Archaea 704 0   NTclustered gi|968564921|gb|CP011266.1| 230361 g6053 i0 98.982 144.534351145038 393 4 100 0 1 393 542667 542275 Methanobrevibacter millerae strain SM9, complete genome blastn 56802 704 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter millerae
25072152 25072152 PRJNA859990_S_NODE_8300_length_348_cov_1.469091_g8039_i0 PRJNA859990 8300 348 1.469091 5.11243668 Methanobrevibacter sp. YE315 1609968 Archaea Archaea 204 8.599999999999999e-48   NTclustered gi|985614202|gb|CP010834.1| 1609968 g8039 i0 89.937 171.988505747126 159 15 46 1 124 282 1994660 1994503 Methanobrevibacter sp. YE315, complete genome blastn 59852 204 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp. YE315

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