RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1120203" 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

  • PRJNA1120203 · 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
6131101 6131101 PRJNA1120203_P_NODE_94585_length_245_cov_0.895349_g93569_i0 PRJNA1120203 94585 245 0.895349 2.19360505 Methanobrevibacter 2172 Archaea Archaea 453 5.1900000000000006e-123   NTclustered gi|2791693311|gb|CP144200.1| 2173 g93569 i0 100 7 245 0 100 0 1 245 463916 464160 Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome blastn 1715 453 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
7405380 7405380 PRJNA1120203_P_NODE_103026_length_242_cov_0.911243_g102010_i0 PRJNA1120203 103026 242 0.911243 2.20520806 Methanobrevibacter 2172 Archaea Archaea 442 1.1099999999999995e-119   NTclustered gi|2791693311|gb|CP144200.1| 2173 g102010 i0 99.587 7.00826446280992 242 1 100 0 1 242 1052194 1052435 Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome blastn 1696 442 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
8681403 8681403 PRJNA1120203_P_NODE_89827_length_247_cov_0.885057_g88811_i0 PRJNA1120203 89827 247 0.885057 2.18609079 Methanobrevibacter 2172 Archaea Archaea 451 1.88e-122   NTclustered gi|2791693311|gb|CP144200.1| 2173 g88811 i0 99.595 7.0080971659919 247 1 100 0 1 247 799130 799376 Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome blastn 1731 451 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
10479014 10479014 PRJNA1120203_P_NODE_78209_length_251_cov_0.865169_g77193_i0 PRJNA1120203 78209 251 0.865169 2.17157419 Methanobrevibacter smithii 2173 Archaea Archaea 459 1.1499999999999996e-124   NTclustered gi|1294447101|gb|CP017803.1| 2173 g77193 i0 99.602 7 251 1 100 0 1 251 494346 494096 Methanobrevibacter smithii strain KB11 chromosome, complete genome blastn 1757 459 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
14304015 14304015 PRJNA1120203_P_NODE_63672_length_282_cov_1.430622_g62656_i0 PRJNA1120203 63672 282 1.430622 4.03435404 Methanobrevibacter smithii 2173 Archaea Archaea 505 1.6599999999999995e-138   NTclustered gi|2188913606|dbj|AP025587.1| 2173 g62656 i0 98.936 7.79787234042553 282 3 100 0 1 282 1166962 1167243 Methanobrevibacter smithii CE91-St68 DNA, complete genome blastn 2199 505 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
14304238 14304238 PRJNA1120203_P_NODE_79292_length_251_cov_0.865169_g78276_i0 PRJNA1120203 79292 251 0.865169 2.17157419 Methanobrevibacter smithii 2173 Archaea Archaea 453 5.34e-123   NTclustered gi|1294447101|gb|CP017803.1| 2173 g78276 i0 99.203 7 251 2 100 0 1 251 603627 603877 Methanobrevibacter smithii strain KB11 chromosome, complete genome blastn 1757 453 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii

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