RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA1093008" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1093008 · 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
28520430 28520430 PRJNA1093008_S_NODE_56087_length_284_cov_1.459716_g55760_i0 PRJNA1093008 56087 284 1.459716 4.14559344 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 45.1 0.00903   NR MYD37068.1 2026734 g55760 i0 42.6 1.14084507042254 54 27 57 1 47 208 120 169 MYD37068.1 MFS transporter [Dehalococcoidia bacterium] diamond 324 45.1 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
28741360 28741360 PRJNA1093008_S_NODE_58007_length_281_cov_1.793269_g57680_i0 PRJNA1093008 58007 281 1.793269 5.03908589 Chloroflexota bacterium 2026724 Bacteria Bacteria 43.5 0.0309   NR HLH23589.1 2026724 g57680 i0 39 0.437722419928826 41 25 43.8 0 133 255 501 541 HLH23589.1 hypothetical protein [Chloroflexota bacterium] diamond 123 43.5 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
29688271 29688271 PRJNA1093008_S_NODE_67310_length_268_cov_1.579487_g66983_i0 PRJNA1093008 67310 268 1.579487 4.23302516 Dehalococcoidales bacterium 2026733 Bacteria Bacteria 42 0.018   NR MFQ5996235.1 2026733 g66983 i0 33.9 0.626865671641791 56 37 62.7 0 176 9 4 59 MFQ5996235.1 hypothetical protein [Dehalococcoidales bacterium] diamond 168 42 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia Dehalococcoidales     Dehalococcoidales bacterium
29878179 29878179 PRJNA1093008_S_NODE_78711_length_254_cov_1.331492_g78384_i0 PRJNA1093008 78711 254 1.331492 3.38198968 Chloroflexota bacterium 2026724 Bacteria Bacteria 46.2 0.00249   NR MBI4498881.1 2026724 g78384 i0 43.9 0.673228346456693 57 26 67.3 1 82 252 367 417 MBI4498881.1 ammonium transporter [Chloroflexota bacterium] diamond 171 46.2 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
30289139 30289139 PRJNA1093008_S_NODE_45032_length_303_cov_1.339130_g44705_i0 PRJNA1093008 45032 303 1.33913 4.0575639 Chloroflexota bacterium 2026724 Bacteria Bacteria 43.5 0.0166   NR MXX47315.1 2026724 g44705 i0 35.7 0.554455445544555 56 29 48.5 2 58 204 17 72 MXX47315.1 hypothetical protein [Chloroflexota bacterium] diamond 168 43.5 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
30920865 30920865 PRJNA1093008_S_NODE_97414_length_237_cov_2.682927_g97087_i0 PRJNA1093008 97414 237 2.682927 6.35853699 Chloroflexota bacterium 2026724 Bacteria Bacteria 42 0.0446   NR PID86748.1 2026724 g97087 i0 38 1 79 44 93.7 2 6 227 84 162 PID86748.1 MAG: D-glycero-beta-D-manno-heptose-1,7-bisphosphate 7-phosphatase [Chloroflexota bacterium] diamond 237 42 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31647665 31647665 PRJNA1093008_S_NODE_46917_length_299_cov_3.066372_g46590_i0 PRJNA1093008 46917 299 3.066372 9.16845228 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 50.1 8.53e-5   NR HZA23224.1 2026734 g46590 i0 33.3 0.662207357859532 66 44 66.2 0 226 29 74 139 HZA23224.1 DUF417 family protein [Dehalococcoidia bacterium] diamond 198 50.1 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
32154077 32154077 PRJNA1093008_S_NODE_81058_length_251_cov_2.404494_g80731_i0 PRJNA1093008 81058 251 2.404494 6.03527994 Chloroflexi bacterium OLB15 1617416 Bacteria Bacteria 42.7 0.0391   NR KXK14127.1 1617416 g80731 i0 31.4 0.836653386454183 70 47 83.7 1 11 220 178 246 KXK14127.1 MAG: hypothetical protein UZ15_CFX003003107 [Chloroflexi bacterium OLB15] diamond 210 42.7 1 Bacteria   Bacillati Chloroflexota         Chloroflexi bacterium OLB15
32785623 32785623 PRJNA1093008_S_NODE_43000_length_307_cov_1.316239_g42673_i0 PRJNA1093008 43000 307 1.316239 4.04085373 Dehalococcoidales bacterium 2026733 Bacteria Bacteria 44.7 0.00903   NR MDD5339545.1 2026733 g42673 i0 51.2 0.400651465798046 41 17 37.1 1 166 279 93 133 MDD5339545.1 MarR family transcriptional regulator [Dehalococcoidales bacterium] diamond 123 44.7 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia Dehalococcoidales     Dehalococcoidales 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);;