RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA488043" and tax_clade = "Stenosarchaea group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Stenosarchaea group · 4 ✖

bioproject 1

  • PRJNA488043 · 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
29286725 29286725 PRJNA488043_P_NODE_16909_length_203_cov_2.655172_g14667_i0 PRJNA488043 16909 203 2.655172 5.38999916 Methanosarcina sp. 2213 Archaea Archaea 51.6 1.53e-6   NR HET8686851.1 2213 g14667 i0 69 0.428571428571429 29 9 42.9 0 114 200 1 29 HET8686851.1 hypothetical protein [Methanosarcina sp.] diamond 87 51.6 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
29855262 29855262 PRJNA488043_P_NODE_16011_length_214_cov_1.610811_g13769_i0 PRJNA488043 16011 214 1.610811 3.44713554 Methanosarcina sp. 2213 Archaea Archaea 67.8 1.3e-12   NR HET8689073.1 2213 g13769 i0 47.9 0.995327102803738 71 37 99.5 0 1 213 12 82 HET8689073.1 hypothetical protein [Methanosarcina sp.] diamond 213 67.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
31609454 31609454 PRJNA488043_P_NODE_10676_length_318_cov_2.356401_g8435_i0 PRJNA488043 10676 318 2.356401 7.49335518 root 1 Root_unresolved Root_unresolved 90.9 4.3e-19   NR HET8686349.1 2213 g8435 i0 83.6 2.07547169811321 55 9 51.9 0 1 165 286 340 HET8686349.1 DNA methyltransferase [Methanosarcina sp.] diamond 660 90.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
32004599 32004599 PRJNA488043_P_NODE_21678_length_157_cov_1.640625_g19436_i0 PRJNA488043 21678 157 1.640625 2.57578125 Methanosarcina sp. 2213 Archaea Archaea 62 6.73e-11   NR HET8689436.1 2213 g19436 i0 51 0.974522292993631 51 25 97.5 0 5 157 34 84 HET8689436.1 hypothetical protein [Methanosarcina sp.] diamond 153 62 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina 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);;