RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA1004255" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1004255 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
26812955 26812955 PRJNA1004255_S_NODE_3641_length_293_cov_2.820000_g3433_i0 PRJNA1004255 3641 293 2.82 8.2626 Mycobacteriaceae 1762 Bacteria Bacteria 154 2e-45   NR WP_061009747.1 1762 g3433 i0 91.2 0.931740614334471 91 8 93.2 0 2 274 80 170 WP_061009747.1 MULTISPECIES: YkgB family protein [Mycobacteriaceae] diamond 273 154 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae    
26876527 26876527 PRJNA1004255_S_NODE_19121_length_150_cov_0.878505_g18913_i0 PRJNA1004255 19121 150 0.878505 1.3177575 Mycolicibacterium phocaicum 319706 Bacteria Bacteria 62.4 2.04e-10   NR WP_226518891.1 319706 g18913 i0 63 0.92 46 15 88 1 150 19 62 107 WP_226518891.1 HK97 gp10 family phage protein [Mycolicibacterium phocaicum] diamond 138 62.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycolicibacterium Mycolicibacterium phocaicum
28108191 28108191 PRJNA1004255_S_NODE_6845_length_234_cov_3.115183_g6637_i0 PRJNA1004255 6845 234 3.115183 7.28952822 Branchiibius sp. NY16-3462-2 1807500 Bacteria Bacteria 42.4 0.0456   NR WP_291523468.1 1807500 g6637 i0 40.7 0.692307692307692 54 26 69.2 1 39 200 85 132 WP_291523468.1 ABC transporter permease [Branchiibius sp. NY16-3462-2] diamond 162 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermacoccaceae Branchiibius Branchiibius sp. NY16-3462-2
30887541 30887541 PRJNA1004255_S_NODE_16974_length_158_cov_1.226087_g16766_i0 PRJNA1004255 16974 158 1.226087 1.93721746 Calidifontibacter indicus 419650 Bacteria Bacteria 60.5 3.62e-9   NR WP_115921678.1 419650 g16766 i0 100 0.550632911392405 29 0 55.1 0 1 87 211 239 WP_115921678.1 FadR/GntR family transcriptional regulator [Calidifontibacter indicus] diamond 87 60.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermacoccaceae Calidifontibacter Calidifontibacter indicus
31077263 31077263 PRJNA1004255_S_NODE_12015_length_185_cov_5.401408_g11807_i0 PRJNA1004255 12015 185 5.401408 9.9926048 Streptosporangium amethystogenes subsp. fukuiense 698418 Bacteria Bacteria 43.1 0.00154   NR GAA0855943.1 698418 g11807 i0 43.6 0.891891891891892 55 31 89.2 0 10 174 1 55 GAA0855943.1 hypothetical protein GCM10009525_88480 [Streptosporangium amethystogenes subsp. fukuiense] diamond 165 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Streptosporangium Streptosporangium amethystogenes
31646139 31646139 PRJNA1004255_S_NODE_10417_length_198_cov_1.516129_g10209_i0 PRJNA1004255 10417 198 1.516129 3.00193542 Lawsonella sp. 2041415 Bacteria Bacteria 129 3.94e-37   NR WP_298577507.1 2041415 g10209 i0 89.2 0.984848484848485 65 7 98.5 0 2 196 10 74 WP_298577507.1 hypothetical protein [Lawsonella sp.] diamond 195 129 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella sp.
32089199 32089199 PRJNA1004255_S_NODE_13338_length_177_cov_1.753731_g13130_i0 PRJNA1004255 13338 177 1.753731 3.10410387 Dermacoccus nishinomiyaensis 1274 Bacteria Bacteria 80.1 2.94e-18   NR WP_241725315.1 1274 g13130 i0 100 0.711864406779661 42 0 71.2 0 176 51 20 61 WP_241725315.1 hypothetical protein [Dermacoccus nishinomiyaensis] diamond 126 80.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermacoccaceae Dermacoccus Dermacoccus nishinomiyaensis
32437524 32437524 PRJNA1004255_S_NODE_3979_length_284_cov_5.825726_g3771_i0 PRJNA1004255 3979 284 5.825726 16.54506184 Cutibacterium acnes 1747 Bacteria Bacteria 52 3.24e-5   NR MES8310468.1 1747 g3771 i0 50 2.11267605633803 50 25 52.8 0 3 152 28 77 MES8310468.1 hypothetical protein [Cutibacterium acnes] diamond 600 52 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
32556692 32556692 PRJNA1004255_S_NODE_13199_length_178_cov_1.392593_g12991_i0 PRJNA1004255 13199 178 1.392593 2.47881554 root 1 Root_unresolved Root_unresolved 61.2 1.08e-9   NR MES6385480.1 1747 g12991 i0 66 3.96067415730337 47 14 77.5 2 151 14 58 103 MES6385480.1 hypothetical protein [Cutibacterium acnes] diamond 705 61.6 0.993506493506494 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes

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