contig_metadata
13 rows where bioproject = "PRJNA758087" and tax_phylum = "Gemmatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2009023 | 2009023 | PRJNA758087_P_NODE_12962_length_851_cov_4.670951_g11781_i0 | PRJNA758087 | 12962 | 851 | 4.670951 | 39.74979301 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 939 | 0 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g11781 | i0 | 87.5 | 81.2326674500588 | 832 | 80 | 96 | 21 | 32 | 851 | 3042306 | 3043125 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 69129 | 939 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 4561952 | 4561952 | PRJNA758087_P_NODE_31544_length_387_cov_1.726115_g30224_i0 | PRJNA758087 | 31544 | 387 | 1.726115 | 6.68006505 | Gemmatimonas groenlandica | 2732249 | Bacteria | Bacteria | 292 | 2e-74 | NTclustered | gi|1839994010|gb|CP053085.1| | 2732249 | g30224 | i0 | 87.649 | 49.7984496124031 | 251 | 31 | 65 | 0 | 27 | 277 | 1104175 | 1104425 | Gemmatimonas groenlandica strain TET16 chromosome, complete genome | blastn | 19272 | 292 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas groenlandica | |
| 22410784 | 22410784 | PRJNA758087_P_NODE_28318_length_440_cov_3.356948_g26998_i0 | PRJNA758087 | 28318 | 440 | 3.356948 | 14.7705712 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 407 | 7.88e-109 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g26998 | i0 | 84.783 | 25.0818181818182 | 414 | 54 | 93 | 8 | 1 | 411 | 3043865 | 3043458 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 11036 | 407 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 27400740 | 27400740 | PRJNA758087_P_NODE_22043_length_565_cov_21.855691_g20729_i0 | PRJNA758087 | 22043 | 565 | 21.855691 | 123.48465415 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 114 | 1.34e-29 | NR | HEX6910714.1 | 2029185 | g20729 | i0 | 90 | 0.31858407079646 | 60 | 6 | 31.9 | 0 | 294 | 115 | 1 | 60 | HEX6910714.1 hypothetical protein [Longimicrobium sp.] | diamond | 180 | 114 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 28221381 | 28221381 | PRJNA758087_P_NODE_29686_length_416_cov_4.297376_g28366_i0 | PRJNA758087 | 29686 | 416 | 4.297376 | 17.87708416 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 241 | 1.4e-77 | NR | HEX6912734.1 | 2029185 | g28366 | i0 | 90 | 0.9375 | 130 | 13 | 93.8 | 0 | 3 | 392 | 141 | 270 | HEX6912734.1 hypothetical protein [Longimicrobium sp.] | diamond | 390 | 241 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 28789734 | 28789734 | PRJNA758087_P_NODE_41607_length_251_cov_1.134831_g40287_i0 | PRJNA758087 | 41607 | 251 | 1.134831 | 2.84842581 | Gemmatirosa sp. | 2510638 | Bacteria | Bacteria | 57 | 3.7e-7 | NR | HEY0779517.1 | 2510638 | g40287 | i0 | 85.7 | 0.741035856573705 | 28 | 4 | 33.5 | 0 | 250 | 167 | 359 | 386 | HEY0779517.1 IS481 family transposase [Gemmatirosa sp.] | diamond | 186 | 57 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa sp. | |
| 28821148 | 28821148 | PRJNA758087_P_NODE_37948_length_297_cov_1.642857_g36628_i0 | PRJNA758087 | 37948 | 297 | 1.642857 | 4.87928529 | Gemmatirosa sp. | 2510638 | Bacteria | Bacteria | 200 | 5.1899999999999995e-62 | NR | HZF66553.1 | 2510638 | g36628 | i0 | 91.8 | 0.98989898989899 | 98 | 8 | 99 | 0 | 296 | 3 | 43 | 140 | HZF66553.1 protein kinase [Gemmatirosa sp.] | diamond | 294 | 200 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa sp. | |
| 29137459 | 29137459 | PRJNA758087_P_NODE_37069_length_308_cov_1.893617_g35749_i0 | PRJNA758087 | 37069 | 308 | 1.893617 | 5.83234036 | Gemmatirosa sp. | 2510638 | Bacteria | Bacteria | 92.4 | 2.2e-20 | NR | HZF68683.1 | 2510638 | g35749 | i0 | 100 | 0.409090909090909 | 42 | 0 | 40.9 | 0 | 307 | 182 | 206 | 247 | HZF68683.1 hypothetical protein [Gemmatirosa sp.] | diamond | 126 | 92.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa sp. | |
| 29232028 | 29232028 | PRJNA758087_P_NODE_28509_length_437_cov_1.115385_g27189_i0 | PRJNA758087 | 28509 | 437 | 1.115385 | 4.87423245 | Gemmatimonadetes bacterium T265 | 2839016 | Bacteria | Bacteria | 179 | 1.18e-49 | NR | GJG87148.1 | 2839016 | g27189 | i0 | 72.1 | 1.86727688787185 | 136 | 37 | 92.7 | 1 | 3 | 407 | 226 | 361 | GJG87148.1 fatty acid oxidation complex subunit alpha [Gemmatimonadetes bacterium T265] | diamond | 816 | 179 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadetes bacterium T265 | |||||
| 29484248 | 29484248 | PRJNA758087_P_NODE_25470_length_493_cov_1.328571_g24150_i0 | PRJNA758087 | 25470 | 493 | 1.328571 | 6.54985503 | Gemmatimonas sp. | 1962908 | Bacteria | Bacteria | 201 | 1.85e-56 | NR | WP_291263654.1 | 1962908 | g24150 | i0 | 62.3 | 4.68559837728195 | 154 | 58 | 93.7 | 0 | 463 | 2 | 460 | 613 | WP_291263654.1 SusC/RagA family TonB-linked outer membrane protein [Gemmatimonas sp.] | diamond | 2310 | 201 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas sp. | |
| 30179223 | 30179223 | PRJNA758087_P_NODE_6532_length_1312_cov_13.832930_g5683_i0 | PRJNA758087 | 6532 | 1312 | 13.83293 | 181.4880416 | Longimicrobiaceae bacterium | 3047548 | Bacteria | Bacteria | 143 | 1.2e-36 | NR | HEX6926041.1 | 3047548 | g5683 | i0 | 57.1 | 0.240091463414634 | 105 | 45 | 24 | 0 | 814 | 500 | 90 | 194 | HEX6926041.1 hypothetical protein [Longimicrobiaceae bacterium] | diamond | 315 | 143 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobiaceae bacterium | ||
| 30274394 | 30274394 | PRJNA758087_P_NODE_18032_length_667_cov_9.841751_g16749_i0 | PRJNA758087 | 18032 | 667 | 9.841751 | 65.64447917 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 287 | 6.19e-93 | NR | HVH11520.1 | 2029185 | g16749 | i0 | 86.2 | 0.782608695652174 | 174 | 24 | 78.3 | 0 | 643 | 122 | 206 | 379 | HVH11520.1 IS4 family transposase [Longimicrobium sp.] | diamond | 522 | 287 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 31759686 | 31759686 | PRJNA758087_P_NODE_42377_length_248_cov_0.880000_g41057_i0 | PRJNA758087 | 42377 | 248 | 0.88 | 2.1824 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 117 | 1.56e-28 | NR | HUR94818.1 | 2448054 | g41057 | i0 | 69.1 | 1.95967741935484 | 81 | 25 | 98 | 0 | 3 | 245 | 75 | 155 | HUR94818.1 molybdopterin cofactor-binding domain-containing protein [Gemmatimonadales bacterium] | diamond | 486 | 117 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales 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);;