RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA942359" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA942359 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
10187546 10187546 PRJNA942359_P_NODE_20768_length_207_cov_4.455224_g20653_i0 PRJNA942359 20768 207 4.455224 9.22231368 Methanosarcina 2207 Archaea Archaea 383 5.65e-102   NTclustered gi|827396966|gb|CP008746.1| 796385 g20653 i0 100 40.9227053140097 207 0 100 0 1 207 4158541 4158747 Methanosarcina barkeri CM1, complete genome blastn 8471 383 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina barkeri
22599965 22599965 PRJNA942359_P_NODE_16058_length_248_cov_0.891429_g15943_i0 PRJNA942359 16058 248 0.891429 2.21074392 Methanothrix sp. 90426 Archaea Archaea 436 5.3e-118   NTclustered gi|2621703957|emb|OY762912.1| 90426 g15943 i0 98.387 1 248 4 100 0 1 248 1275697 1275944 MAG: Methanothrix sp. isolate 80880379-7421-4bc7-b5fd-f9f5169ec620 genome assembly, chromosome: 1 blastn 248 436 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix sp.
25485403 25485403 PRJNA942359_P_NODE_20220_length_242_cov_0.923077_g20105_i0 PRJNA942359 20220 242 0.923077 2.23384634 Methanosarcina 2207 Archaea Archaea 448 2.3799999999999995e-121   NTclustered gi|827396966|gb|CP008746.1| 796385 g20105 i0 100 12 242 0 100 0 1 242 4371282 4371041 Methanosarcina barkeri CM1, complete genome blastn 2904 448 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina barkeri

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