contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJEB11748" and tax_clade = "Nitrospinota/Tectimicrobiota group"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3843156 | 3843156 | PRJEB11748_P_NODE_25844_length_886_cov_2.192727_g24146_i0 | PRJEB11748 | 25844 | 886 | 2.192727 | 19.42756122 | Bacteria | 2 | Bacteria | Bacteria | 315 | 1.21e-104 | NR | HEY5869205.1 | 2528274 | g24146 | i0 | 70.1 | 7.47291196388262 | 221 | 66 | 74.8 | 0 | 199 | 861 | 1 | 221 | HEY5869205.1 glucose-6-phosphate isomerase [Candidatus Tectimicrobiota bacterium] | diamond | 6621 | 315 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 8944425 | 8944425 | PRJEB11748_P_NODE_285488_length_226_cov_32.533333_g283305_i0 | PRJEB11748 | 285488 | 226 | 32.533333 | 73.52533258 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 112 | 8.29e-29 | NR | HEX9868220.1 | 2528274 | g283305 | i0 | 77.6 | 0.889380530973451 | 67 | 15 | 88.9 | 0 | 206 | 6 | 142 | 208 | HEX9868220.1 hypothetical protein [Candidatus Tectimicrobiota bacterium] | diamond | 201 | 112 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 21694030 | 21694030 | PRJEB11748_P_NODE_277438_length_231_cov_1.747059_g275255_i0 | PRJEB11748 | 277438 | 231 | 1.747059 | 4.03570629 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 129 | 7.65e-33 | NR | HEY5865126.1 | 2528274 | g275255 | i0 | 93.9 | 0.857142857142857 | 66 | 4 | 85.7 | 0 | 11 | 208 | 486 | 551 | HEY5865126.1 aminomethyl-transferring glycine dehydrogenase subunit GcvPB [Candidatus Tectimicrobiota bacterium] | diamond | 198 | 129 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 26589504 | 26589504 | PRJEB11748_P_NODE_97981_length_422_cov_4.504155_g95811_i0 | PRJEB11748 | 97981 | 422 | 4.504155 | 19.0075341 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 96.3 | 2.61e-20 | NR | GIX47257.1 | 2528274 | g95811 | i0 | 45.7 | 0.824644549763033 | 116 | 62 | 82.5 | 1 | 409 | 62 | 293 | 407 | GIX47257.1 MAG: glutamate--cysteine ligase [Candidatus Tectimicrobiota bacterium] | diamond | 348 | 96.3 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 26621177 | 26621177 | PRJEB11748_P_NODE_107681_length_401_cov_19.364706_g105507_i0 | PRJEB11748 | 107681 | 401 | 19.364706 | 77.65247106 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 145 | 7.21e-40 | NR | MEE8303461.1 | 2528274 | g105507 | i0 | 65.4 | 2.53615960099751 | 107 | 36 | 79.3 | 1 | 383 | 66 | 35 | 141 | MEE8303461.1 16S rRNA (cytosine(1402)-N(4))-methyltransferase RsmH [Candidatus Tectimicrobiota bacterium] | diamond | 1017 | 145 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 26684520 | 26684520 | PRJEB11748_P_NODE_215221_length_271_cov_3.542857_g213038_i0 | PRJEB11748 | 215221 | 271 | 3.542857 | 9.60114247 | Nitrospinota bacterium | 2026769 | Bacteria | Bacteria | 45.1 | 0.00758 | NR | MBI5427517.1 | 2026769 | g213038 | i0 | 31.3 | 1.5830258302583 | 80 | 47 | 85.2 | 3 | 18 | 248 | 74 | 148 | MBI5427517.1 SEC-C domain-containing protein [Nitrospinota bacterium] | diamond | 429 | 45.1 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinota bacterium | |||||
| 26874959 | 26874959 | PRJEB11748_P_NODE_221041_length_267_cov_1.135922_g218858_i0 | PRJEB11748 | 221041 | 267 | 1.135922 | 3.03291174 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 115 | 4.42e-29 | NR | MBI3092392.1 | 2528274 | g218858 | i0 | 67.9 | 1.82022471910112 | 81 | 26 | 91 | 0 | 20 | 262 | 194 | 274 | MBI3092392.1 TIGR01777 family protein [Candidatus Tectimicrobiota bacterium] | diamond | 486 | 115 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 27158983 | 27158983 | PRJEB11748_P_NODE_247562_length_248_cov_5.604278_g245379_i0 | PRJEB11748 | 247562 | 248 | 5.604278 | 13.89860944 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 119 | 9.86e-30 | NR | MEE8291317.1 | 2528274 | g245379 | i0 | 72.5 | 0.967741935483871 | 80 | 22 | 96.8 | 0 | 246 | 7 | 109 | 188 | MEE8291317.1 glycosyltransferase [Candidatus Tectimicrobiota bacterium] | diamond | 240 | 119 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 27538571 | 27538571 | PRJEB11748_P_NODE_326484_length_208_cov_0.863946_g324301_i0 | PRJEB11748 | 326484 | 208 | 0.863946 | 1.79700768 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 60.5 | 7.35e-9 | NR | HEY5865443.1 | 2528274 | g324301 | i0 | 44.3 | 1.70192307692308 | 61 | 34 | 88 | 0 | 194 | 12 | 1 | 61 | HEY5865443.1 hypothetical protein [Candidatus Tectimicrobiota bacterium] | diamond | 354 | 60.5 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 27601684 | 27601684 | PRJEB11748_P_NODE_135824_length_354_cov_3.324232_g133646_i0 | PRJEB11748 | 135824 | 354 | 3.324232 | 11.76778128 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 169 | 2.32e-46 | NR | MBM3223914.1 | 2528274 | g133646 | i0 | 74.8 | 1.83898305084746 | 107 | 27 | 90.7 | 0 | 341 | 21 | 208 | 314 | MBM3223914.1 CoA transferase [Candidatus Tectimicrobiota bacterium] | diamond | 651 | 169 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 29496091 | 29496091 | PRJEB11748_P_NODE_59230_length_552_cov_14.896130_g57100_i0 | PRJEB11748 | 59230 | 552 | 14.89613 | 82.2266376 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 179 | 1.5599999999999999e-52 | NR | HEY5865154.1 | 2528274 | g57100 | i0 | 60.4 | 0.864130434782609 | 159 | 63 | 86.4 | 0 | 500 | 24 | 1 | 159 | HEY5865154.1 rod shape-determining protein MreC [Candidatus Tectimicrobiota bacterium] | diamond | 477 | 179 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 30286164 | 30286164 | PRJEB11748_P_NODE_48352_length_618_cov_8.378815_g46256_i0 | PRJEB11748 | 48352 | 618 | 8.378815 | 51.7810767 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 119 | 3.16e-29 | NR | HSF29346.1 | 2528274 | g46256 | i0 | 57 | 1.10679611650485 | 114 | 49 | 55.3 | 0 | 42 | 383 | 150 | 263 | HSF29346.1 ABC transporter permease [Candidatus Tectimicrobiota bacterium] | diamond | 684 | 119 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 30822835 | 30822835 | PRJEB11748_P_NODE_364674_length_190_cov_4.596899_g362491_i0 | PRJEB11748 | 364674 | 190 | 4.596899 | 8.7341081 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 61.6 | 4.04e-9 | NR | MEE9148592.1 | 2528274 | g362491 | i0 | 100 | 2.28947368421053 | 29 | 0 | 45.8 | 0 | 171 | 85 | 318 | 346 | MEE9148592.1 radical SAM protein [Candidatus Tectimicrobiota bacterium] | diamond | 435 | 61.6 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 31106875 | 31106875 | PRJEB11748_P_NODE_125975_length_369_cov_3.613636_g123799_i0 | PRJEB11748 | 125975 | 369 | 3.613636 | 13.33431684 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 154 | 4.98e-44 | NR | MDH3599468.1 | 2528274 | g123799 | i0 | 77.7 | 0.764227642276423 | 94 | 21 | 76.4 | 0 | 345 | 64 | 175 | 268 | MDH3599468.1 SDR family oxidoreductase [Candidatus Tectimicrobiota bacterium] | diamond | 282 | 154 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 31227181 | 31227181 | PRJEB11748_P_NODE_299875_length_219_cov_9.487342_g297692_i0 | PRJEB11748 | 299875 | 219 | 9.487342 | 20.77727898 | Bacteria | 2 | Bacteria | Bacteria | 92 | 8.21e-20 | NR | MBM3223683.1 | 2528274 | g297692 | i0 | 72.3 | 1.78082191780822 | 65 | 18 | 89 | 0 | 23 | 217 | 353 | 417 | MBM3223683.1 tRNA (N(6)-L-threonylcarbamoyladenosine(37)-C(2))-methylthiotransferase MtaB [Candidatus Tectimicrobiota bacterium] | diamond | 390 | 92.8 | 0.991379310344828 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 31265113 | 31265113 | PRJEB11748_P_NODE_173435_length_308_cov_9.797571_g171252_i0 | PRJEB11748 | 173435 | 308 | 9.797571 | 30.17651868 | Nitrospinaceae bacterium | 2358456 | Bacteria | Bacteria | 61.6 | 1.98e-9 | NR | MEO2043881.1 | 2358456 | g171252 | i0 | 61.7 | 0.457792207792208 | 47 | 18 | 45.8 | 0 | 167 | 307 | 77 | 123 | MEO2043881.1 6-carboxytetrahydropterin synthase [Nitrospinaceae bacterium] | diamond | 141 | 61.6 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinia | Nitrospinales | Nitrospinaceae | Nitrospinaceae bacterium | ||
| 31644562 | 31644562 | PRJEB11748_P_NODE_242717_length_251_cov_10.736842_g240534_i0 | PRJEB11748 | 242717 | 251 | 10.736842 | 26.94947342 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 101 | 3.36e-24 | NR | HEX9872128.1 | 2528274 | g240534 | i0 | 70.4 | 0.848605577689243 | 71 | 21 | 84.9 | 0 | 10 | 222 | 168 | 238 | HEX9872128.1 IS6 family transposase [Candidatus Tectimicrobiota bacterium] | diamond | 213 | 101 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 31701767 | 31701767 | PRJEB11748_P_NODE_218997_length_268_cov_3.768116_g216814_i0 | PRJEB11748 | 218997 | 268 | 3.768116 | 10.09855088 | Bacteria | 2 | Bacteria | Bacteria | 79 | 7.97e-16 | NR | WP_306296772.1 | 93172 | g216814 | i0 | 51.3 | 6.22388059701493 | 80 | 39 | 89.6 | 0 | 5 | 244 | 43 | 122 | WP_306296772.1 Uma2 family endonuclease [Candidatus Entotheonella palauensis] | diamond | 1668 | 79 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Entotheonellia | Candidatus Entotheonellales | Candidatus Entotheonellaceae | Candidatus Entotheonella | Candidatus Entotheonella palauensis | |
| 31834343 | 31834343 | PRJEB11748_P_NODE_308737_length_215_cov_5.707792_g306554_i0 | PRJEB11748 | 308737 | 215 | 5.707792 | 12.2717528 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 109 | 3.04e-26 | NR | MEE8304615.1 | 2528274 | g306554 | i0 | 89.5 | 1.5906976744186 | 57 | 6 | 79.5 | 0 | 213 | 43 | 257 | 313 | MEE8304615.1 hydantoinase B/oxoprolinase family protein [Candidatus Tectimicrobiota bacterium] | diamond | 342 | 109 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 31897815 | 31897815 | PRJEB11748_P_NODE_340377_length_202_cov_3.964539_g338194_i0 | PRJEB11748 | 340377 | 202 | 3.964539 | 8.00836878 | Nitrospinaceae bacterium | 2358456 | Bacteria | Bacteria | 42.4 | 0.00433 | NR | GJL78700.1 | 2358456 | g338194 | i0 | 78.3 | 0.920792079207921 | 23 | 5 | 34.2 | 0 | 102 | 170 | 12 | 34 | GJL78700.1 MAG: hypothetical protein NPINA01_16890 [Nitrospinaceae bacterium] | diamond | 186 | 42.4 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinia | Nitrospinales | Nitrospinaceae | Nitrospinaceae bacterium | ||
| 32309413 | 32309413 | PRJEB11748_P_NODE_248519_length_248_cov_1.187166_g246336_i0 | PRJEB11748 | 248519 | 248 | 1.187166 | 2.94417168 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 127 | 2.19e-32 | NR | HEY7490215.1 | 2528274 | g246336 | i0 | 81.3 | 2.72177419354839 | 75 | 14 | 90.7 | 0 | 225 | 1 | 109 | 183 | HEY7490215.1 IS21 family transposase [Candidatus Tectimicrobiota bacterium] | diamond | 675 | 127 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 32467489 | 32467489 | PRJEB11748_P_NODE_144339_length_342_cov_10.701068_g142160_i0 | PRJEB11748 | 144339 | 342 | 10.701068 | 36.59765256 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 147 | 1.6999999999999996e-38 | NR | HEY5867568.1 | 2528274 | g142160 | i0 | 71.3 | 0.885964912280702 | 101 | 29 | 88.6 | 0 | 324 | 22 | 230 | 330 | HEY5867568.1 ATP-dependent RecD-like DNA helicase [Candidatus Tectimicrobiota bacterium] | diamond | 303 | 147 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium |
Advanced export
JSON shape: default, array, newline-delimited
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);;