RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Sysuimicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Sysuimicrobiota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1148190 · 14 ✖

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
27481755 27481755 PRJNA1148190_P_NODE_288903_length_324_cov_2.466135_g277732_i0 PRJNA1148190 288903 324 2.466135 7.9902774 Candidatus Fervidifonticultor quartus 3378015 Bacteria Bacteria 93.6 8.72e-20   NR MDR7420026.1 3378015 g277732 i0 45.5 1.12037037037037 121 42 89.8 1 1 291 75 195 MDR7420026.1 hypothetical protein [Candidatus Fervidifonticultor quartus] diamond 363 93.6 1 Bacteria   Bacillati Candidatus Sysuimicrobiota Candidatus Sysuimicrobiia Candidatus Sysuimicrobiales Candidatus Humicultoraceae Candidatus Fervidifonticultor Candidatus Fervidifonticultor quartus
27671431 27671431 PRJNA1148190_P_NODE_328944_length_308_cov_1.642553_g317771_i0 PRJNA1148190 328944 308 1.642553 5.05906324 Candidatus Geohabitans tengchongensis 3378011 Bacteria Bacteria 60.8 2.95e-8   NR MDR7492256.1 3378011 g317771 i0 46.7 0.730519480519481 75 33 73.1 1 55 279 138 205 MDR7492256.1 hypothetical protein [Candidatus Geohabitans tengchongensis] diamond 225 60.8 1 Bacteria   Bacillati Candidatus Sysuimicrobiota Candidatus Sysuimicrobiia Candidatus Sysuimicrobiales Candidatus Humicultoraceae Candidatus Geohabitans Candidatus Geohabitans tengchongensis
27702943 27702943 PRJNA1148190_P_NODE_206324_length_371_cov_3.798658_g195154_i0 PRJNA1148190 206324 371 3.798658 14.09302118 Candidatus Fervidifonticultor quartus 3378015 Bacteria Bacteria 49.7 4.95e-4   NR MDR7420824.1 3378015 g195154 i0 38.1 2.02964959568733 84 45 67.9 2 4 255 234 310 MDR7420824.1 contractile injection system protein, VgrG/Pvc8 family [Candidatus Fervidifonticultor quartus] diamond 753 49.7 1 Bacteria   Bacillati Candidatus Sysuimicrobiota Candidatus Sysuimicrobiia Candidatus Sysuimicrobiales Candidatus Humicultoraceae Candidatus Fervidifonticultor Candidatus Fervidifonticultor quartus
27892110 27892110 PRJNA1148190_P_NODE_303465_length_318_cov_1.648980_g292292_i0 PRJNA1148190 303465 318 1.64898 5.2437564 Candidatus Fervidifonticultor octavus 3378019 Bacteria Bacteria 125 6.0000000000000005e-31   NR MDR7487184.1 3378019 g292292 i0 52.2 1.06603773584906 113 46 100 3 1 318 521 632 MDR7487184.1 pyridoxal-phosphate dependent enzyme [Candidatus Fervidifonticultor octavus] diamond 339 125 1 Bacteria   Bacillati Candidatus Sysuimicrobiota Candidatus Sysuimicrobiia Candidatus Sysuimicrobiales Candidatus Humicultoraceae Candidatus Fervidifonticultor Candidatus Fervidifonticultor octavus
27987666 27987666 PRJNA1148190_P_NODE_678245_length_246_cov_1.265896_g667072_i0 PRJNA1148190 678245 246 1.265896 3.11410416 Candidatus Fervidifonticultor quartus 3378015 Bacteria Bacteria 57.4 2.65e-7   NR MDR7420025.1 3378015 g667072 i0 42.5 2.80487804878049 73 41 87.8 1 6 221 346 418 MDR7420025.1 hypothetical protein [Candidatus Fervidifonticultor quartus] diamond 690 57.4 1 Bacteria   Bacillati Candidatus Sysuimicrobiota Candidatus Sysuimicrobiia Candidatus Sysuimicrobiales Candidatus Humicultoraceae Candidatus Fervidifonticultor Candidatus Fervidifonticultor quartus
28081255 28081255 PRJNA1148190_P_NODE_125605_length_470_cov_2.360202_g114442_i0 PRJNA1148190 125605 470 2.360202 11.0929494 Candidatus Fervidifonticultor quartus 3378015 Bacteria Bacteria 56.2 7.93e-6   NR MDR7420025.1 3378015 g114442 i0 62.5 0.357446808510638 56 20 35.1 1 169 5 1 56 MDR7420025.1 hypothetical protein [Candidatus Fervidifonticultor quartus] diamond 168 56.2 1 Bacteria   Bacillati Candidatus Sysuimicrobiota Candidatus Sysuimicrobiia Candidatus Sysuimicrobiales Candidatus Humicultoraceae Candidatus Fervidifonticultor Candidatus Fervidifonticultor quartus
28807435 28807435 PRJNA1148190_P_NODE_218328_length_363_cov_1.027586_g207158_i0 PRJNA1148190 218328 363 1.027586 3.73013718 Candidatus Fervidifonticultor quartus 3378015 Bacteria Bacteria 71.2 1.38e-11   NR MDR7420026.1 3378015 g207158 i0 35.8 1.01652892561983 123 74 100 3 1 363 208 327 MDR7420026.1 hypothetical protein [Candidatus Fervidifonticultor quartus] diamond 369 71.2 1 Bacteria   Bacillati Candidatus Sysuimicrobiota Candidatus Sysuimicrobiia Candidatus Sysuimicrobiales Candidatus Humicultoraceae Candidatus Fervidifonticultor Candidatus Fervidifonticultor quartus
29945564 29945564 PRJNA1148190_P_NODE_80471_length_609_cov_2.746269_g69346_i0 PRJNA1148190 80471 609 2.746269 16.72477821 Candidatus Fervidifonticultor secundus 3378013 Bacteria Bacteria 69.3 4.9e-10   NR MDR7534527.1 3378013 g69346 i0 34.7 0.610837438423645 124 70 60.6 2 138 506 113 226 MDR7534527.1 PD-(D/E)XK nuclease family protein [Candidatus Fervidifonticultor secundus] diamond 372 69.3 1 Bacteria   Bacillati Candidatus Sysuimicrobiota Candidatus Sysuimicrobiia Candidatus Sysuimicrobiales Candidatus Humicultoraceae Candidatus Fervidifonticultor Candidatus Fervidifonticultor secundus
30007959 30007959 PRJNA1148190_P_NODE_310071_length_315_cov_3.020661_g298898_i0 PRJNA1148190 310071 315 3.020661 9.51508215 Candidatus Fervidifonticultor quartus 3378015 Bacteria Bacteria 46.6 0.00157   NR MDR7420020.1 3378015 g298898 i0 35.6 0.695238095238095 73 43 67.6 2 299 87 56 126 MDR7420020.1 hypothetical protein [Candidatus Fervidifonticultor quartus] diamond 219 46.6 1 Bacteria   Bacillati Candidatus Sysuimicrobiota Candidatus Sysuimicrobiia Candidatus Sysuimicrobiales Candidatus Humicultoraceae Candidatus Fervidifonticultor Candidatus Fervidifonticultor quartus
31050437 31050437 PRJNA1148190_P_NODE_151195_length_428_cov_0.867606_g140028_i0 PRJNA1148190 151195 428 0.867606 3.71335368 Candidatus Fervidifonticultor quartus 3378015 Bacteria Bacteria 67.4 4.46e-10   NR MDR7420824.1 3378015 g140028 i0 34.8 0.80607476635514 115 65 80.6 2 419 75 162 266 MDR7420824.1 contractile injection system protein, VgrG/Pvc8 family [Candidatus Fervidifonticultor quartus] diamond 345 67.4 1 Bacteria   Bacillati Candidatus Sysuimicrobiota Candidatus Sysuimicrobiia Candidatus Sysuimicrobiales Candidatus Humicultoraceae Candidatus Fervidifonticultor Candidatus Fervidifonticultor quartus
31525432 31525432 PRJNA1148190_P_NODE_66016_length_694_cov_1.747182_g54965_i0 PRJNA1148190 66016 694 1.747182 12.12544308 Candidatus Fervidifonticultor quartus 3378015 Bacteria Bacteria 51.2 0.0018600000000000001   NR MDR7420025.1 3378015 g54965 i0 28.8 0.959654178674352 222 147 91.6 5 57 692 485 705 MDR7420025.1 hypothetical protein [Candidatus Fervidifonticultor quartus] diamond 666 51.2 1 Bacteria   Bacillati Candidatus Sysuimicrobiota Candidatus Sysuimicrobiia Candidatus Sysuimicrobiales Candidatus Humicultoraceae Candidatus Fervidifonticultor Candidatus Fervidifonticultor quartus
31650828 31650828 PRJNA1148190_P_NODE_19497_length_1879_cov_7.953488_g392_i15 PRJNA1148190 19497 1879 7.953488 149.44603952 Candidatus Fervidifonticultor tertius 3378014 Bacteria Bacteria 273 1.82e-80   NR MDR7496825.1 3378014 g392 i15 36.6 0.728046833422033 456 236 64.7 7 1217 3 10 463 MDR7496825.1 DNA modification methylase [Candidatus Fervidifonticultor tertius] diamond 1368 273 1 Bacteria   Bacillati Candidatus Sysuimicrobiota Candidatus Sysuimicrobiia Candidatus Sysuimicrobiales Candidatus Humicultoraceae Candidatus Fervidifonticultor Candidatus Fervidifonticultor tertius
32125752 32125752 PRJNA1148190_P_NODE_183898_length_390_cov_2.047319_g172729_i0 PRJNA1148190 183898 390 2.047319 7.9845441 Candidatus Tepidifontimicrobium thermophilum 3377999 Bacteria Bacteria 102 3.11e-22   NR MDR7461763.1 3377999 g172729 i0 50 2.02307692307692 132 58 99.2 3 3 389 372 498 MDR7461763.1 DEAD/DEAH box helicase [Candidatus Tepidifontimicrobium thermophilum] diamond 789 102 1 Bacteria   Bacillati Candidatus Sysuimicrobiota Candidatus Sysuimicrobiia Candidatus Sysuimicrobiales Candidatus Sysuimicrobiaceae Candidatus Tepidifontimicrobium Candidatus Tepidifontimicrobium thermophilum
32788942 32788942 PRJNA1148190_P_NODE_300700_length_319_cov_2.105691_g289527_i0 PRJNA1148190 300700 319 2.105691 6.71715429 Candidatus Sysuimicrobiota bacterium CSP1-3 1640515 Bacteria Bacteria 102 1e-22   NR KRT76726.1 1640515 g289527 i0 50.5 0.987460815047022 105 51 97.8 1 314 3 11 115 KRT76726.1 MAG: hypothetical protein XU14_C0033G0024 [Candidatus Sysuimicrobiota bacterium CSP1-3] diamond 315 102 1 Bacteria   Bacillati Candidatus Sysuimicrobiota         Candidatus Sysuimicrobiota bacterium CSP1-3

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