RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA488043" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA488043 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
26727735 26727735 PRJNA488043_P_NODE_9561_length_355_cov_2.122699_g7325_i0 PRJNA488043 9561 355 2.122699 7.53558145 SAR202 cluster bacterium 2030829 Bacteria Bacteria 57.4 2.31e-8   NR MQG78522.1 2030829 g7325 i0 46.6 0.912676056338028 58 30 49 1 256 83 1 57 MQG78522.1 Cro/Cl family transcriptional regulator [SAR202 cluster bacterium] diamond 324 57.4 1 Bacteria SAR202 cluster Bacillati Chloroflexota Dehalococcoidia       SAR202 cluster bacterium
26759702 26759702 PRJNA488043_P_NODE_8961_length_375_cov_2.609827_g6740_i0 PRJNA488043 8961 375 2.609827 9.78685125 Chloroflexi bacterium RBG_16_56_8 1797650 Bacteria Bacteria 81.3 3.53e-17   NR OGO33086.1 1797650 g6740 i0 57.3 0.712 89 38 71.2 0 327 61 4 92 OGO33086.1 MAG: hypothetical protein A2Z03_02140 [Chloroflexi bacterium RBG_16_56_8] diamond 267 81.3 1 Bacteria   Bacillati Chloroflexota         Chloroflexi bacterium RBG_16_56_8
26855070 26855070 PRJNA488043_P_NODE_14181_length_240_cov_2.033175_g11939_i0 PRJNA488043 14181 240 2.033175 4.87962 Anaerolineae bacterium 2052143 Bacteria Bacteria 100 2.38e-22   NR MCB0246603.1 2052143 g11939 i0 58.8 1 80 32 100 1 1 240 720 798 MCB0246603.1 hypothetical protein [Anaerolineae bacterium] diamond 240 100 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
26949666 26949666 PRJNA488043_P_NODE_15722_length_217_cov_3.223404_g13480_i0 PRJNA488043 15722 217 3.223404 6.99478668 Candidatus Villigracilis vicinus 3140679 Bacteria Bacteria 121 3.2300000000000004e-33   NR MBK7450702.1 3140679 g13480 i0 95.8 0.995391705069124 72 3 99.5 0 216 1 57 128 MBK7450702.1 hypothetical protein [Candidatus Villigracilis vicinus] diamond 216 121 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Candidatus Villigracilaceae Candidatus Villigracilis Candidatus Villigracilis vicinus
26981367 26981367 PRJNA488043_P_NODE_18062_length_191_cov_2.290123_g15820_i0 PRJNA488043 18062 191 2.290123 4.37413493 Anaerolineaceae bacterium 2024896 Bacteria Bacteria 119 8.909999999999998e-32   NR HRS75264.1 2024896 g15820 i0 100 0.863874345549738 55 0 86.4 0 190 26 154 208 HRS75264.1 hypothetical protein [Anaerolineaceae bacterium] diamond 165 119 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Anaerolineaceae   Anaerolineaceae bacterium
27550161 27550161 PRJNA488043_P_NODE_20844_length_164_cov_1.429630_g18602_i0 PRJNA488043 20844 164 1.42963 2.3445932 Anaerolineaceae bacterium 2024896 Bacteria Bacteria 51.2 1.3e-5   NR RJP48800.1 2024896 g18602 i0 49.1 1.00609756097561 55 25 95.1 2 1 156 169 223 RJP48800.1 MAG: PLxRFG domain-containing protein [Anaerolineaceae bacterium] diamond 165 51.2 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Anaerolineaceae   Anaerolineaceae bacterium
27929231 27929231 PRJNA488043_P_NODE_9705_length_350_cov_2.252336_g7469_i0 PRJNA488043 9705 350 2.252336 7.883176 Candidatus Villigracilis vicinus 3140679 Bacteria Bacteria 89 9.21e-20   NR MBK7450710.1 3140679 g7469 i0 76.2 0.54 63 15 54 0 191 3 1 63 MBK7450710.1 hypothetical protein [Candidatus Villigracilis vicinus] diamond 189 89 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Candidatus Villigracilaceae Candidatus Villigracilis Candidatus Villigracilis vicinus
28055314 28055314 PRJNA488043_P_NODE_13065_length_260_cov_1.978355_g10824_i0 PRJNA488043 13065 260 1.978355 5.143723 Caldilinea sp. 2293560 Bacteria Bacteria 87.8 2.81e-20   NR WP_343405317.1 2293560 g10824 i0 74.6 0.680769230769231 59 15 68.1 0 258 82 49 107 WP_343405317.1 hypothetical protein [Caldilinea sp.] diamond 177 87.8 1 Bacteria   Bacillati Chloroflexota Caldilineae Caldilineales Caldilineaceae Caldilinea Caldilinea sp.
28118491 28118491 PRJNA488043_P_NODE_10845_length_313_cov_3.035211_g8604_i0 PRJNA488043 10845 313 3.035211 9.50021043 Candidatus Villigracilis vicinus 3140679 Bacteria Bacteria 50.1 8.26e-5   NR MBK7450702.1 3140679 g8604 i0 52.9 0.488817891373802 51 24 48.9 0 160 312 15 65 MBK7450702.1 hypothetical protein [Candidatus Villigracilis vicinus] diamond 153 50.1 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Candidatus Villigracilaceae Candidatus Villigracilis Candidatus Villigracilis vicinus
28434388 28434388 PRJNA488043_P_NODE_20286_length_169_cov_1.750000_g18044_i0 PRJNA488043 20286 169 1.75 2.9575 Anaerolineae bacterium 2052143 Bacteria Bacteria 51.6 9.76e-6   NR HUW15286.1 2052143 g18044 i0 38.5 0.923076923076923 52 32 92.3 0 12 167 104 155 HUW15286.1 hypothetical protein [Anaerolineae bacterium] diamond 156 51.6 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
28655453 28655453 PRJNA488043_P_NODE_22627_length_150_cov_1.471074_g20385_i0 PRJNA488043 22627 150 1.471074 2.206611 Candidatus Villigracilis vicinus 3140679 Bacteria Bacteria 73.6 1.38e-13   NR MBK7450706.1 3140679 g20385 i0 85.1 0.94 47 7 94 0 143 3 1 47 MBK7450706.1 hypothetical protein [Candidatus Villigracilis vicinus] diamond 141 73.6 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Candidatus Villigracilaceae Candidatus Villigracilis Candidatus Villigracilis vicinus
29633772 29633772 PRJNA488043_P_NODE_7210_length_454_cov_9.541176_g836_i2 PRJNA488043 7210 454 9.541176 43.31693904 Anaerolineae bacterium 2052143 Bacteria Bacteria 97.8 1.75e-22   NR MCI0556170.1 2052143 g836 i2 75 1.34801762114537 68 17 44.9 0 1 204 101 168 MCI0556170.1 hypothetical protein [Anaerolineae bacterium] diamond 612 97.8 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
29981560 29981560 PRJNA488043_P_NODE_10111_length_336_cov_2.820847_g7870_i0 PRJNA488043 10111 336 2.820847 9.47804592 Anaerolineaceae bacterium 2024896 Bacteria Bacteria 218 1.4899999999999998e-69   NR HRS75265.1 2024896 g7870 i0 97.3 0.991071428571429 111 3 99.1 0 335 3 55 165 HRS75265.1 hypothetical protein [Anaerolineaceae bacterium] diamond 333 218 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Anaerolineaceae   Anaerolineaceae bacterium
32226214 32226214 PRJNA488043_P_NODE_19858_length_173_cov_2.076389_g17616_i0 PRJNA488043 19858 173 2.076389 3.59215297 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 47.4 9.42e-5   NR MDO8614615.1 2026734 g17616 i0 63 0.797687861271676 46 16 79.8 1 171 34 40 84 MDO8614615.1 hypothetical protein [Dehalococcoidia bacterium] diamond 138 47.4 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
32542677 32542677 PRJNA488043_P_NODE_11379_length_298_cov_2.579926_g9138_i0 PRJNA488043 11379 298 2.579926 7.68817948 Anaerolineaceae bacterium 2024896 Bacteria Bacteria 194 1.09e-60   NR HRS75264.1 2024896 g9138 i0 98 0.996644295302013 99 2 99.7 0 2 298 99 197 HRS75264.1 hypothetical protein [Anaerolineaceae bacterium] diamond 297 194 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Anaerolineaceae   Anaerolineaceae bacterium
32636788 32636788 PRJNA488043_P_NODE_19520_length_177_cov_1.263514_g17278_i0 PRJNA488043 19520 177 1.263514 2.23641978 Dehalococcoidales bacterium 2026733 Bacteria Bacteria 79.3 1.56e-15   NR MDA8189602.1 2026733 g17278 i0 66.1 1 59 18 96.6 1 172 2 323 381 MDA8189602.1 phage terminase large subunit [Dehalococcoidales bacterium] diamond 177 79.3 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia Dehalococcoidales     Dehalococcoidales bacterium
32794236 32794236 PRJNA488043_P_NODE_9560_length_355_cov_2.122699_g7324_i0 PRJNA488043 9560 355 2.122699 7.53558145 Caldilineaceae bacterium 2614250 Bacteria Bacteria 194 5.25e-62   NR MBP8294340.1 2614250 g7324 i0 100 0.845070422535211 100 0 84.5 0 333 34 1 100 MBP8294340.1 hypothetical protein [Caldilineaceae bacterium] diamond 300 194 1 Bacteria   Bacillati Chloroflexota Caldilineae Caldilineales Caldilineaceae   Caldilineaceae 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);;