RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA879314" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA879314 · 6 ✖

analysis 1

tax_clade 0

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
30213142 30213142 PRJNA879314_P_NODE_8312_length_247_cov_0.896552_g8262_i0 PRJNA879314 8312 247 0.896552 2.21448344 Armatimonadia bacterium 2663015 Bacteria Bacteria 153 5.24e-43   NR MEN6402576.1 2663015 g8262 i0 82.9 1.9919028340081 82 14 99.6 0 2 247 239 320 MEN6402576.1 hypothetical protein [Armatimonadia bacterium] diamond 492 153 1 Bacteria   Bacillati Armatimonadota Armatimonadia       Armatimonadia bacterium
30592338 30592338 PRJNA879314_P_NODE_8373_length_247_cov_0.896552_g8323_i0 PRJNA879314 8373 247 0.896552 2.21448344 Armatimonadota bacterium 2033014 Bacteria Bacteria 117 3.53e-29   NR MCC6485385.1 2033014 g8323 i0 100 0.753036437246964 62 0 75.3 0 247 62 316 377 MCC6485385.1 hypothetical protein [Armatimonadota bacterium] diamond 186 117 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
31485621 31485621 PRJNA879314_P_NODE_5056_length_252_cov_0.871508_g5006_i0 PRJNA879314 5056 252 0.871508 2.19620016 Fimbriimonas 1005038 Bacteria Bacteria 87.8 2.64e-20   NR WP_025225281.1 1005039 g5006 i0 77.2 1.35714285714286 57 13 67.9 0 251 81 53 109 WP_025225281.1 FmdB family zinc ribbon protein [Fimbriimonas ginsengisoli] diamond 342 87.8 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli
31770023 31770023 PRJNA879314_P_NODE_8537_length_246_cov_0.901734_g8487_i0 PRJNA879314 8537 246 0.901734 2.21826564 PVC group 1783257 Bacteria Bacteria 88.2 2.59e-18   NR MBI2301746.1 2033014 g8487 i0 58.6 1.68292682926829 70 29 85.4 0 244 35 333 402 MBI2301746.1 hypothetical protein [Armatimonadota bacterium] diamond 414 88.2 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
32141752 32141752 PRJNA879314_P_NODE_2918_length_289_cov_1.314815_g2868_i0 PRJNA879314 2918 289 1.314815 3.79981535 Armatimonadota bacterium 2033014 Bacteria Bacteria 191 9.34e-59   NR HAZ62516.1 2033014 g2868 i0 100 0.996539792387543 96 0 99.7 0 289 2 75 170 HAZ62516.1 50S ribosomal protein L2 [Armatimonadota bacterium] diamond 288 191 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
32394965 32394965 PRJNA879314_P_NODE_9239_length_245_cov_0.906977_g9189_i0 PRJNA879314 9239 245 0.906977 2.22209365 Armatimonadota bacterium 2033014 Bacteria Bacteria 160 7.32e-44   NR HAZ62113.1 2033014 g9189 i0 100 0.991836734693878 81 0 99.2 0 3 245 320 400 HAZ62113.1 hypothetical protein [Armatimonadota bacterium] diamond 243 160 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium

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