RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA800053" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA800053 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
12699459 12699459 PRJNA800053_P_NODE_25170_length_209_cov_4.154412_g25006_i0 PRJNA800053 25170 209 4.154412 8.68272108 Anaerolineae bacterium 2052143 Bacteria Bacteria 93.6 1.88e-20   NR MCZ2113676.1 2052143 g25006 i0 67.1 1.00478468899522 70 21 97.6 1 4 207 319 388 MCZ2113676.1 hypothetical protein [Anaerolineae bacterium] diamond 210 93.6 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
16098742 16098742 PRJNA800053_P_NODE_19813_length_247_cov_0.885057_g19649_i0 PRJNA800053 19813 247 0.885057 2.18609079 Chloroflexota bacterium 2026724 Bacteria Bacteria 114 8.07e-29   NR MCC6628758.1 2026724 g19649 i0 80.2 2.95141700404858 81 16 98.4 0 3 245 181 261 MCC6628758.1 type II secretion system F family protein [Chloroflexota bacterium] diamond 729 114 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
26673880 26673880 PRJNA800053_P_NODE_24141_length_239_cov_3.259036_g23977_i0 PRJNA800053 24141 239 3.259036 7.7890960400000004 Candidatus Amarobacter glycogenicus 3140699 Bacteria Bacteria 92 7.17e-20   NR WP_343391887.1 3140699 g23977 i0 79.6 1.36820083682008 54 11 67.8 0 233 72 117 170 WP_343391887.1 hypothetical protein [Candidatus Amarobacter glycogenicus] diamond 327 92 1 Bacteria   Bacillati Chloroflexota Tepidiformia Tepidiformales Tepidiformaceae Candidatus Amarobacter Candidatus Amarobacter glycogenicus
27243690 27243690 PRJNA800053_P_NODE_22883_length_242_cov_1.431953_g22719_i0 PRJNA800053 22883 242 1.431953 3.46532626 Anaerolineae bacterium 2052143 Bacteria Bacteria 50.1 1.21e-5   NR HEY4720248.1 2052143 g22719 i0 64.9 0.45867768595041303 37 13 45.9 0 113 3 1 37 HEY4720248.1 hypothetical protein [Anaerolineae bacterium] diamond 111 50.1 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
27465042 27465042 PRJNA800053_P_NODE_15643_length_261_cov_1.585106_g15479_i0 PRJNA800053 15643 261 1.585106 4.13712666 Anaerolineae bacterium 2052143 Bacteria Bacteria 120 2.02e-31   NR MEZ4667702.1 2052143 g15479 i0 70.7 4.68965517241379 82 24 94.3 0 258 13 176 257 MEZ4667702.1 imidazole glycerol phosphate synthase subunit HisF [Anaerolineae bacterium] diamond 1224 120 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
27465043 27465043 PRJNA800053_P_NODE_17063_length_252_cov_1.715084_g16899_i0 PRJNA800053 17063 252 1.715084 4.32201168 Candidatus Amarobacter glycogenicus 3140699 Bacteria Bacteria 80.5 1.18e-17   NR WP_343391890.1 3140699 g16899 i0 61.4 0.678571428571429 57 22 67.9 0 184 14 9 65 WP_343391890.1 hypothetical protein [Candidatus Amarobacter glycogenicus] diamond 171 80.5 1 Bacteria   Bacillati Chloroflexota Tepidiformia Tepidiformales Tepidiformaceae Candidatus Amarobacter Candidatus Amarobacter glycogenicus
28317398 28317398 PRJNA800053_P_NODE_23986_length_241_cov_0.916667_g23822_i0 PRJNA800053 23986 241 0.916667 2.20916747 Dehalococcoidales bacterium 2026733 Bacteria Bacteria 68.6 2.83e-11   NR MEE9367106.1 2026733 g23822 i0 62.7 1.29460580912863 51 19 63.5 0 84 236 494 544 MEE9367106.1 hypothetical protein [Dehalococcoidales bacterium] diamond 312 68.6 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia Dehalococcoidales     Dehalococcoidales bacterium
28790844 28790844 PRJNA800053_P_NODE_21787_length_244_cov_0.900585_g21623_i0 PRJNA800053 21787 244 0.900585 2.1974274 Ornatilinea apprima 1134406 Bacteria Bacteria 104 4.64e-24   NR WP_152966388.1 1134406 g21623 i0 58.4 0.94672131147541 77 32 94.7 0 237 7 112 188 WP_152966388.1 hypothetical protein [Ornatilinea apprima] diamond 231 104 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Anaerolineaceae Ornatilinea Ornatilinea apprima
28885607 28885607 PRJNA800053_P_NODE_23288_length_242_cov_0.911243_g23124_i0 PRJNA800053 23288 242 0.911243 2.20520806 Anaerolineae bacterium 2052143 Bacteria Bacteria 53.5 5.98e-6   NR MCB0252174.1 2052143 g23124 i0 39.5 0.942148760330578 76 38 93 3 232 8 3889 3957 MCB0252174.1 strawberry notch family protein [Anaerolineae bacterium] diamond 228 53.5 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
29138542 29138542 PRJNA800053_P_NODE_13109_length_279_cov_1.247573_g12945_i0 PRJNA800053 13109 279 1.247573 3.48072867 Candidatus Limnocylindrales bacterium 2952938 Bacteria Bacteria 47.4 0.00131   NR HYB97522.1 2952938 g12945 i0 57.6 0.354838709677419 33 14 35.5 0 277 179 513 545 HYB97522.1 terminase family protein [Candidatus Limnocylindrales bacterium] diamond 99 47.4 1 Bacteria   Bacillati Chloroflexota Candidatus Limnocylindria Candidatus Limnocylindrales     Candidatus Limnocylindrales bacterium
29422267 29422267 PRJNA800053_P_NODE_21249_length_245_cov_0.895349_g21085_i0 PRJNA800053 21249 245 0.895349 2.19360505 Anaerolineales bacterium 2073117 Bacteria Bacteria 105 2.26e-26   NR HSB01632.1 2073117 g21085 i0 72.2 0.881632653061225 72 20 88.2 0 29 244 16 87 HSB01632.1 NUDIX domain-containing protein [Anaerolineales bacterium] diamond 216 105 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
30338875 30338875 PRJNA800053_P_NODE_22612_length_243_cov_0.905882_g22448_i0 PRJNA800053 22612 243 0.905882 2.20129326 Anaerolineales bacterium 2073117 Bacteria Bacteria 63.5 1.67e-9   NR HLA87362.1 2073117 g22448 i0 39.2 0.91358024691358 74 45 91.4 0 21 242 152 225 HLA87362.1 hypothetical protein [Anaerolineales bacterium] diamond 222 63.5 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
30465186 30465186 PRJNA800053_P_NODE_18613_length_249_cov_0.875000_g18449_i0 PRJNA800053 18613 249 0.875 2.17875 Anaerolineae bacterium 2052143 Bacteria Bacteria 48.9 2.74e-4   NR MBX3082952.1 2052143 g18449 i0 40.6 0.771084337349398 64 29 74.7 3 246 61 25 81 MBX3082952.1 bifunctional DNA primase/polymerase [Anaerolineae bacterium] diamond 192 48.9 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
30527938 30527938 PRJNA800053_P_NODE_19453_length_248_cov_0.880000_g19289_i0 PRJNA800053 19453 248 0.88 2.1824 Anaerolineales bacterium 2073117 Bacteria Bacteria 65.1 1.23e-10   NR HQX18256.1 2073117 g19289 i0 73.2 0.495967741935484 41 9 49.6 1 125 3 2 40 HQX18256.1 hypothetical protein [Anaerolineales bacterium] diamond 123 65.1 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
30717463 30717463 PRJNA800053_P_NODE_15474_length_262_cov_1.608466_g15310_i0 PRJNA800053 15474 262 1.608466 4.21418092 Caldilineaceae bacterium 2614250 Bacteria Bacteria 43.1 0.0328   NR MBP8291836.1 2614250 g15310 i0 43.8 0.549618320610687 48 27 55 0 85 228 9 56 MBP8291836.1 hypothetical protein [Caldilineaceae bacterium] diamond 144 43.1 1 Bacteria   Bacillati Chloroflexota Caldilineae Caldilineales Caldilineaceae   Caldilineaceae bacterium
30812304 30812304 PRJNA800053_P_NODE_23254_length_242_cov_0.911243_g23090_i0 PRJNA800053 23254 242 0.911243 2.20520806 Candidatus Amarolinea dominans 3140696 Bacteria Bacteria 119 9.62e-31   NR WP_343407613.1 3140696 g23090 i0 72.4 0.942148760330578 76 21 94.2 0 6 233 97 172 WP_343407613.1 carbonic anhydrase family protein [Candidatus Amarolinea dominans] diamond 228 119 1 Bacteria   Bacillati Chloroflexota Caldilineae Caldilineales Candidatus Amarolineaceae Candidatus Amarolinea Candidatus Amarolinea dominans
30907353 30907353 PRJNA800053_P_NODE_15334_length_263_cov_1.573684_g15170_i0 PRJNA800053 15334 263 1.573684 4.13878892 Dehalococcoidales bacterium 2026733 Bacteria Bacteria 52 1.74e-5   NR MEE9365298.1 2026733 g15170 i0 34.1 0.96958174904943 85 55 97 1 8 262 20 103 MEE9365298.1 hypothetical protein [Dehalococcoidales bacterium] diamond 255 52 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia Dehalococcoidales     Dehalococcoidales bacterium
31855659 31855659 PRJNA800053_P_NODE_20137_length_247_cov_0.885057_g19973_i0 PRJNA800053 20137 247 0.885057 2.18609079 Chloroflexota bacterium 2026724 Bacteria Bacteria 60.8 1.55e-8   NR MBU6287642.1 2026724 g19973 i0 55.2 0.704453441295547 58 19 64.4 2 3 161 124 179 MBU6287642.1 DEAD/DEAH box helicase [Chloroflexota bacterium] diamond 174 60.8 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32520451 32520451 PRJNA800053_P_NODE_21399_length_245_cov_0.895349_g21235_i0 PRJNA800053 21399 245 0.895349 2.19360505 Chloroflexota bacterium 2026724 Bacteria Bacteria 74.7 7.95e-14   NR TMD08293.1 2026724 g21235 i0 57.6 0.722448979591837 59 24 72.2 1 3 179 93 150 TMD08293.1 MAG: class I SAM-dependent methyltransferase [Chloroflexota bacterium] diamond 177 74.7 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32709222 32709222 PRJNA800053_P_NODE_16780_length_254_cov_1.585635_g16616_i0 PRJNA800053 16780 254 1.585635 4.0275129 Anaerolineales bacterium 2073117 Bacteria Bacteria 119 3.49e-29   NR MBF8281280.1 2073117 g16616 i0 70.7 0.968503937007874 82 24 96.9 0 4 249 34 115 MBF8281280.1 hypothetical protein [Anaerolineales bacterium] diamond 246 119 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales 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);;