RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA431371", tax_kingdom = "Methanobacteriati" and tax_phylum = "Methanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Methanobacteriota · 4 ✖

tax_kingdom 1

  • Methanobacteriati · 4 ✖

bioproject 1

  • PRJNA431371 · 4 ✖
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
5532264 5532264 PRJNA431371_P_NODE_8325_length_429_cov_1.297753_g8252_i0 PRJNA431371 8325 429 1.297753 5.56736037 Haloarcula marismortui 2238 Archaea Archaea 56.5 0.003   NTclustered gi|2030483455|gb|CP073366.1| 662476 g8252 i0 100 0.0699300699300699 30 0 7 0 83 112 1702540 1702511 Haloarcula sinaiiensis ATCC 33800 chromosome, complete genome blastn 30 56.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Haloarcula Haloarcula marismortui
23380692 23380692 PRJNA431371_P_NODE_6719_length_471_cov_1.871859_g6646_i0 PRJNA431371 6719 471 1.871859 8.81645589 root 1 Root_unresolved Root_unresolved 192 1.2399999999999998e-55   NR MBX7076496.1 2099680 g6646 i0 68.9 1.68152866242038 132 41 84.1 0 396 1 192 323 MBX7076496.1 F0F1 ATP synthase subunit alpha [Methanobacteriaceae archaeon] diamond 792 192 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae   Methanobacteriaceae archaeon
27281982 27281982 PRJNA431371_P_NODE_5263_length_521_cov_2.308036_g5190_i0 PRJNA431371 5263 521 2.308036 12.02486756 root 1 Root_unresolved Root_unresolved 77 6.65e-13   NR MBJ35148.1 2026739 g5190 i0 44.7 2.15930902111324 94 43 48.9 3 396 142 320 413 MBJ35148.1 hypothetical protein [Methanobacteriota archaeon] diamond 1125 77 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
29981015 29981015 PRJNA431371_P_NODE_23891_length_257_cov_1.255435_g23818_i0 PRJNA431371 23891 257 1.255435 3.22646795 Methanobrevibacter sp. 66852 Archaea Archaea 43.9 0.0179   NR WP_292742990.1 66852 g23818 i0 39.4 4.27237354085603 66 39 75.9 1 61 255 649 714 WP_292742990.1 DUF1565 domain-containing protein [Methanobrevibacter sp.] diamond 1098 43.9 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp.

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