RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA415856" 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 · 5 ✖

bioproject 1

  • PRJNA415856 · 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
419232 419232 PRJNA415856_P_NODE_23501_length_186_cov_1.489051_g23240_i0 PRJNA415856 23501 186 1.489051 2.76963486 Methanobrevibacter millerae 230361 Archaea Archaea 281 1.86e-71   NTclustered gi|968564921|gb|CP011266.1| 230361 g23240 i0 94.054 68.6881720430108 185 11 99 0 1 185 541982 542166 Methanobrevibacter millerae strain SM9, complete genome blastn 12776 281 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter millerae
4246344 4246344 PRJNA415856_P_NODE_28704_length_176_cov_2.425197_g28443_i0 PRJNA415856 28704 176 2.425197 4.26834672 Methanobrevibacter millerae 230361 Archaea Archaea 207 2.99e-49   NTclustered gi|968564921|gb|CP011266.1| 230361 g28443 i0 88.068 3.04545454545455 176 20 100 1 1 176 542826 543000 Methanobrevibacter millerae strain SM9, complete genome blastn 536 207 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter millerae
17660934 17660934 PRJNA415856_P_NODE_23354_length_186_cov_2.321168_g23093_i0 PRJNA415856 23354 186 2.321168 4.31737248 root 1 Root_unresolved Root_unresolved 344 2.34e-90   NTclustered gi|1294447101|gb|CP017803.1| 2173 g23093 i0 100 179.618279569892 186 0 100 0 1 186 266643 266458 Methanobrevibacter smithii strain KB11 chromosome, complete genome blastn 33409 344 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
20821033 20821033 PRJNA415856_P_NODE_30377_length_174_cov_1.224000_g30116_i0 PRJNA415856 30377 174 1.224 2.12976 Methanobrevibacter sp. YE315 1609968 Archaea Archaea 298 1.7e-76   NTclustered gi|985614202|gb|CP010834.1| 1609968 g30116 i0 97.701 105 174 3 100 1 1 174 497437 497265 Methanobrevibacter sp. YE315, complete genome blastn 18270 298 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp. YE315
25309718 25309718 PRJNA415856_P_NODE_52100_length_161_cov_0.910714_g51839_i0 PRJNA415856 52100 161 0.910714 1.46624954 Methanobrevibacter 2172 Archaea Archaea 298 1.56e-76   NTclustered gi|2791693311|gb|CP144200.1| 2173 g51839 i0 100 102.422360248447 161 0 100 0 1 161 1474687 1474527 Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome blastn 16490 298 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);;