RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA575566" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Methanobacteriati · 4 ✖

bioproject 1

  • PRJNA575566 · 4 ✖

analysis 1

  • diamond · 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
4387678 4387678 PRJNA575566_P_NODE_524_length_1322_cov_3.300555_g437_i0 PRJNA575566 524 1322 3.300555 43.6333371 Methanobacteriaceae archaeon 2099680 Archaea Archaea 488 1.6299999999999995e-166   NR MBX7076496.1 2099680 g437 i0 58.6 0.953101361573374 420 173 95.3 1 1262 3 27 445 MBX7076496.1 F0F1 ATP synthase subunit alpha [Methanobacteriaceae archaeon] diamond 1260 488 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae   Methanobacteriaceae archaeon
10764194 10764194 PRJNA575566_P_NODE_1389_length_870_cov_1.688504_g1229_i0 PRJNA575566 1389 870 1.688504 14.6899848 Methanosarcinales archaeon 2250255 Archaea Archaea 532 5.59e-188   NR RYE83110.1 2250255 g1229 i0 92.1 0.96551724137931 280 22 96.6 0 3 842 137 416 RYE83110.1 MAG: translation elongation factor EF-1 subunit alpha, partial [Methanosarcinales archaeon] diamond 840 532 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales archaeon
13314124 13314124 PRJNA575566_P_NODE_27111_length_205_cov_0.888889_g26914_i0 PRJNA575566 27111 205 0.888889 1.82222245 Methanosarcinales archaeon 2250255 Archaea Archaea 126 3.01e-34   NR RYE83291.1 2250255 g26914 i0 86.8 0.995121951219512 68 9 99.5 0 1 204 122 189 RYE83291.1 MAG: hypothetical protein EOO65_04195, partial [Methanosarcinales archaeon] diamond 204 126 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales archaeon
32261211 32261211 PRJNA575566_P_NODE_10218_length_327_cov_1.736842_g10021_i0 PRJNA575566 10218 327 1.736842 5.67947334 Candidatus Methanomethylophilaceae archaeon 2517205 Archaea Archaea 91.3 8.74e-19   NR MBR4685556.1 2517205 g10021 i0 47.3 1.6605504587156 91 48 83.5 0 32 304 189 279 MBR4685556.1 AAA family ATPase [Candidatus Methanomethylophilaceae archaeon] diamond 543 91.3 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae   Candidatus Methanomethylophilaceae 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);;