RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA976345 · 2 ✖

analysis 1

  • blastn · 2 ✖
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
14975729 14975729 PRJNA976345_P_NODE_138692_length_171_cov_2.080882_g137084_i0 PRJNA976345 138692 171 2.080882 3.55830822 uncultured Methanobacterium sp. 176306 Archaea Archaea 54.7 0.004   NTclustered gi|2621703503|emb|OY762552.1| 176306 g137084 i0 96.97 0.192982456140351 33 0 19 1 21 53 1272314 1272283 MAG: uncultured Methanobacterium sp. isolate 3f2017ab-9e69-417f-80a5-32741c1572f8 genome assembly, chromosome: 1 blastn 33 54.7 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium uncultured Methanobacterium sp.
25174290 25174290 PRJNA976345_P_NODE_21620_length_362_cov_2.941896_g20020_i0 PRJNA976345 21620 362 2.941896 10.64966352 uncultured Methanobacteriaceae archaeon 176233 Archaea Archaea 58.4 7.38e-4   NTclustered gi|2874253858|emb|OY969914.1| 176233 g20020 i0 97.059 0.0939226519337017 34 1 9 0 252 285 2212723 2212690 MAG: uncultured Methanobacteriaceae archaeon isolate MFD02416.bin.1.248 genome assembly, chromosome: 1 blastn 34 58.4 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae   uncultured Methanobacteriaceae archaeon

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