RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB11523" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Methanobacteriati · 6 ✖

bioproject 1

  • PRJEB11523 · 6 ✖

analysis 1

  • diamond · 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
26747446 26747446 PRJEB11523_P_NODE_3421_length_266_cov_2.244240_g3343_i0 PRJEB11523 3421 266 2.24424 5.9696784 Methanobacteriota archaeon 2026739 Archaea Archaea 90.5 1.58e-20   NR RZD43308.1 2026739 g3343 i0 51.4 2.83082706766917 74 35 82.3 1 254 36 57 130 RZD43308.1 MAG: hypothetical protein CXT73_00935 [Methanobacteriota archaeon] diamond 753 90.5 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
26811258 26811258 PRJEB11523_P_NODE_681_length_735_cov_3.696793_g618_i0 PRJEB11523 681 735 3.696793 27.17142855 Methanosarcina sp. 2213 Archaea Archaea 139 3.76e-37   NR HET8685212.1 2213 g618 i0 45.9 0.604081632653061 148 77 59.6 2 470 33 13 159 HET8685212.1 NUDIX domain-containing protein [Methanosarcina sp.] diamond 444 139 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
27247891 27247891 PRJEB11523_P_NODE_943_length_613_cov_21.790780_g870_i0 PRJEB11523 943 613 21.79078 133.5774814 root 1 Root_unresolved Root_unresolved 117 1.8700000000000003e-27   NR MBP04528.1 2026739 g870 i0 32.9 2.09951060358891 228 108 97.9 7 609 10 15 225 MBP04528.1 hypothetical protein [Methanobacteriota archaeon] diamond 1287 118 0.991525423728814 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
29716641 29716641 PRJEB11523_P_NODE_4650_length_218_cov_5.106509_g4572_i0 PRJEB11523 4650 218 5.106509 11.13218962 Candidatus Methanogaster sp. 3386292 Archaea Archaea 49.7 6.95e-5   NR PXF61762.1 3386292 g4572 i0 39.4 0.908256880733945 66 40 90.8 0 1 198 71 136 PXF61762.1 MAG: hypothetical protein C4B59_02605 [Candidatus Methanogaster sp.] diamond 198 49.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Candidatus Methanogasteraceae Candidatus Methanogaster Candidatus Methanogaster sp.
29932063 29932063 PRJEB11523_P_NODE_1851_length_404_cov_13.188732_g1773_i0 PRJEB11523 1851 404 13.188732 53.28247728 root 1 Root_unresolved Root_unresolved 84.7 2.33e-17   NR MDD3986020.1 2164 g1773 i0 52.9 1.72277227722772 70 30 49.8 1 201 1 93 162 MDD3986020.1 hypothetical protein [Methanobacterium sp.] diamond 696 84.7 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium sp.
31897643 31897643 PRJEB11523_P_NODE_8517_length_162_cov_0.902655_g8439_i0 PRJEB11523 8517 162 0.902655 1.4623011 Candidatus Poseidoniales archaeon 2163009 Archaea Archaea 104 8.989999999999999e-28   NR MEK9694590.1 2163009 g8439 i0 92.5 0.981481481481482 53 4 98.1 0 3 161 27 79 MEK9694590.1 hypothetical protein [Candidatus Poseidoniales archaeon] diamond 159 104 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales     Candidatus Poseidoniales 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);;