RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1196438 · 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
3593667 3593667 PRJNA1196438_P_NODE_20343_length_312_cov_2.979079_g19917_i0 PRJNA1196438 20343 312 2.979079 9.29472648 Methanobrevibacter 2172 Archaea Archaea 115 3.6700000000000006e-21   NTclustered gi|2791693311|gb|CP144200.1| 2173 g19917 i0 86.538 2 104 14 33 0 170 273 948944 949047 Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome blastn 624 115 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
6146141 6146141 PRJNA1196438_P_NODE_37305_length_293_cov_2.054545_g36879_i0 PRJNA1196438 37305 293 2.054545 6.01981685 Methanobrevibacter 2172 Archaea Archaea 82.4 3.47e-11   NTclustered gi|2791693311|gb|CP144200.1| 2173 g36879 i0 83.721 1.92150170648464 86 14 29 0 205 290 1482544 1482629 Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome blastn 563 82.4 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
6700990 6700990 PRJNA1196438_P_NODE_42946_length_284_cov_2.516588_g42519_i0 PRJNA1196438 42946 284 2.516588 7.14710992 Methanobrevibacter millerae 230361 Archaea Archaea 171 6.94e-38   NTclustered gi|968564921|gb|CP011266.1| 230361 g42519 i0 86.842 1.06338028169014 152 20 54 0 130 281 1557574 1557725 Methanobrevibacter millerae strain SM9, complete genome blastn 302 171 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter millerae
13077015 13077015 PRJNA1196438_P_NODE_64731_length_252_cov_1.737430_g64304_i0 PRJNA1196438 64731 252 1.73743 4.3783236 Methanobrevibacter sp. YE315 1609968 Archaea Archaea 243 1.2600000000000001e-59   NTclustered gi|985614202|gb|CP010834.1| 1609968 g64304 i0 85.903 1.54761904761905 227 32 90 0 6 232 1914934 1914708 Methanobrevibacter sp. YE315, complete genome blastn 390 243 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp. YE315
18174817 18174817 PRJNA1196438_P_NODE_49135_length_274_cov_3.094527_g48708_i0 PRJNA1196438 49135 274 3.094527 8.47900398 Methanobrevibacter acididurans 120963 Archaea Archaea 209 1.41e-49   NTclustered gi|2871247231|gb|CP166991.1| 120963 g48708 i0 81.369 3.26277372262774 263 43 95 5 1 260 1449879 1450138 Methanobrevibacter acididurans strain DSM 15163 chromosome, complete genome blastn 894 209 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter acididurans

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