contig_metadata
23 rows where bioproject = "PRJNA745553", tax_clade = "FCB group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 724283 | 724283 | PRJNA745553_S_NODE_28201_length_231_cov_3.898734_g28006_i0 | PRJNA745553 | 28201 | 231 | 3.898734 | 9.00607554 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 121 | 5.579999999999999e-23 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g28006 | i0 | 77.103 | 12.3766233766234 | 214 | 45 | 91 | 3 | 15 | 225 | 1904534 | 1904746 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 2859 | 121 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 3275373 | 3275373 | PRJNA745553_S_NODE_12523_length_347_cov_2.678832_g12328_i0 | PRJNA745553 | 12523 | 347 | 2.678832 | 9.29554704 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 468 | 2.75e-127 | NTclustered | gi|2874254107|emb|OY970192.1| | 412054 | g12328 | i0 | 91.765 | 162.587896253602 | 340 | 23 | 97 | 5 | 1 | 338 | 1594241 | 1593905 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1 | blastn | 56418 | 468 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 7102974 | 7102974 | PRJNA745553_S_NODE_26746_length_241_cov_1.833333_g26551_i0 | PRJNA745553 | 26746 | 241 | 1.833333 | 4.41833253 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 267 | 7.12e-67 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g26551 | i0 | 88.789 | 210.174273858921 | 223 | 18 | 91 | 7 | 22 | 241 | 1904760 | 1904542 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 50652 | 267 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 7576675 | 7576675 | PRJNA745553_S_NODE_5686_length_482_cov_4.090465_g5492_i0 | PRJNA745553 | 5686 | 482 | 4.090465 | 19.7160413 | Gemmatimonas | 173479 | Bacteria | Bacteria | 505 | 3e-138 | NTclustered | gi|470475286|ref|NR_076270.1| | 173480 | g5492 | i0 | 86.229 | 42.2385892116183 | 472 | 57 | 97 | 7 | 3 | 471 | 468 | 2 | Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence | blastn | 20359 | 505 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas aurantiaca | |
| 9652476 | 9652476 | PRJNA745553_S_NODE_11568_length_360_cov_1.878049_g11373_i0 | PRJNA745553 | 11568 | 360 | 1.878049 | 6.7609764 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 544 | 4.6199999999999996e-150 | NTclustered | gi|2874253938|emb|OY970263.1| | 412054 | g11373 | i0 | 93.889 | 387.266666666667 | 360 | 22 | 100 | 0 | 1 | 360 | 802045 | 801686 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 | blastn | 139416 | 544 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 10928344 | 10928344 | PRJNA745553_S_NODE_4209_length_532_cov_45.283224_g4019_i0 | PRJNA745553 | 4209 | 532 | 45.283224 | 240.90675168 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 555 | 3.269999999999999e-153 | NTclustered | gi|2874253789|emb|OY969773.1| | 412054 | g4019 | i0 | 86.471 | 85.7669172932331 | 510 | 63 | 95 | 6 | 26 | 532 | 420758 | 421264 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 | blastn | 45628 | 555 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 10928404 | 10928404 | PRJNA745553_S_NODE_6949_length_448_cov_4.904000_g6755_i0 | PRJNA745553 | 6949 | 448 | 4.904 | 21.96992 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 416 | 1.34e-111 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g6755 | i0 | 85.238 | 52.8794642857143 | 420 | 44 | 92 | 15 | 23 | 432 | 3042713 | 3042302 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 23690 | 416 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 12203591 | 12203591 | PRJNA745553_S_NODE_17510_length_295_cov_2.054054_g17315_i0 | PRJNA745553 | 17510 | 295 | 2.054054 | 6.0594593 | Gemmatimonas phototrophica | 1379270 | Bacteria | Bacteria | 457 | 4.97e-124 | NTclustered | gi|1015602748|gb|CP011454.1| | 1379270 | g17315 | i0 | 94.613 | 78.9966101694915 | 297 | 12 | 100 | 4 | 1 | 295 | 2075070 | 2074776 | Gemmatimonas phototrophica strain AP64, complete genome | blastn | 23304 | 457 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas phototrophica | |
| 12203820 | 12203820 | PRJNA745553_S_NODE_30690_length_197_cov_4.080645_g30495_i0 | PRJNA745553 | 30690 | 197 | 4.080645 | 8.03887065 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 193 | 9.63e-45 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g30495 | i0 | 86.667 | 21.8324873096447 | 180 | 17 | 89 | 7 | 2 | 177 | 1904538 | 1904714 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 4301 | 193 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 13952664 | 13952664 | PRJNA745553_S_NODE_26611_length_241_cov_7.708333_g26416_i0 | PRJNA745553 | 26611 | 241 | 7.708333 | 18.57708253 | Gemmatimonas | 173479 | Bacteria | Bacteria | 324 | 4.16e-84 | NTclustered | gi|470475286|ref|NR_076270.1| | 173480 | g26416 | i0 | 96.429 | 38.7261410788382 | 196 | 7 | 81 | 0 | 22 | 217 | 196 | 1 | Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence | blastn | 9333 | 326 | 0.993865030674847 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas aurantiaca | |
| 14752989 | 14752989 | PRJNA745553_S_NODE_15592_length_312_cov_2.523013_g15397_i0 | PRJNA745553 | 15592 | 312 | 2.523013 | 7.87180056 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 412 | 1.1599999999999999e-110 | NTclustered | gi|2874253938|emb|OY970263.1| | 412054 | g15397 | i0 | 92.44 | 96.8108974358974 | 291 | 19 | 92 | 1 | 1 | 288 | 802609 | 802319 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 | blastn | 30205 | 412 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 14753228 | 14753228 | PRJNA745553_S_NODE_30212_length_205_cov_5.325758_g30017_i0 | PRJNA745553 | 30212 | 205 | 5.325758 | 10.9178039 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 67 | 6.38e-11 | NR | HEU0016457.1 | 2029185 | g30017 | i0 | 51.7 | 2.5609756097561 | 60 | 29 | 87.8 | 0 | 16 | 195 | 968 | 1027 | HEU0016457.1 amino acid adenylation domain-containing protein [Longimicrobium sp.] | diamond | 525 | 67 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 15227263 | 15227263 | PRJNA745553_S_NODE_8852_length_405_cov_3.963855_g8657_i0 | PRJNA745553 | 8852 | 405 | 3.963855 | 16.05361275 | Gemmatimonas | 173479 | Bacteria | Bacteria | 699 | 0 | NTclustered | gi|470475286|ref|NR_076270.1| | 173480 | g8657 | i0 | 97.778 | 163.074074074074 | 405 | 9 | 100 | 0 | 1 | 405 | 1427 | 1023 | Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence | blastn | 66045 | 699 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas aurantiaca | |
| 16026822 | 16026822 | PRJNA745553_S_NODE_22773_length_259_cov_3.043011_g22578_i0 | PRJNA745553 | 22773 | 259 | 3.043011 | 7.88139849 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 339 | 1.62e-88 | NTclustered | gi|2874253938|emb|OY970263.1| | 412054 | g22578 | i0 | 90.347 | 622.057915057915 | 259 | 24 | 100 | 1 | 1 | 259 | 803120 | 802863 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 | blastn | 161113 | 339 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 16501564 | 16501564 | PRJNA745553_S_NODE_11633_length_359_cov_3.251748_g11438_i0 | PRJNA745553 | 11633 | 359 | 3.251748 | 11.67377532 | Gemmatimonas | 173479 | Bacteria | Bacteria | 459 | 1.7199999999999999e-124 | NTclustered | gi|1015602748|gb|CP011454.1| | 1379270 | g11438 | i0 | 89.722 | 33.2896935933148 | 360 | 35 | 100 | 2 | 1 | 359 | 2076039 | 2076397 | Gemmatimonas phototrophica strain AP64, complete genome | blastn | 11951 | 459 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas phototrophica | |
| 19050429 | 19050429 | PRJNA745553_S_NODE_24995_length_248_cov_2.297143_g24800_i0 | PRJNA745553 | 24995 | 248 | 2.297143 | 5.69691464 | Gemmatimonas | 173479 | Bacteria | Bacteria | 353 | 5.49e-93 | NTclustered | gi|1015602748|gb|CP011454.1| | 1379270 | g24800 | i0 | 92.4 | 638.54435483871 | 250 | 15 | 99 | 4 | 2 | 248 | 2076655 | 2076407 | Gemmatimonas phototrophica strain AP64, complete genome | blastn | 158359 | 353 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas phototrophica | |
| 22401855 | 22401855 | PRJNA745553_S_NODE_6098_length_470_cov_2.460957_g5904_i0 | PRJNA745553 | 6098 | 470 | 2.460957 | 11.5664979 | uncultured Gemmatimonadaceae bacterium | 246130 | Bacteria | Bacteria | 431 | 5.0199999999999983e-116 | NTclustered | gi|2874253995|emb|OY970320.1| | 246130 | g5904 | i0 | 83.721 | 28.2702127659574 | 473 | 60 | 99 | 16 | 1 | 467 | 231722 | 231261 | MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1 | blastn | 13287 | 431 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | uncultured Gemmatimonadaceae bacterium | ||
| 24950664 | 24950664 | PRJNA745553_S_NODE_18380_length_288_cov_2.441860_g18185_i0 | PRJNA745553 | 18380 | 288 | 2.44186 | 7.0325568 | Pseudogemmatithrix spongiicola | 3062599 | Bacteria | Bacteria | 231 | 3.19e-56 | NTclustered | gi|2557479348|gb|CP130613.1| | 3062599 | g18185 | i0 | 86.239 | 5.22569444444444 | 218 | 24 | 75 | 6 | 40 | 254 | 3194595 | 3194809 | Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome | blastn | 1505 | 231 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Pseudogemmatithrix | Pseudogemmatithrix spongiicola | |
| 26894776 | 26894776 | PRJNA745553_S_NODE_5901_length_476_cov_1.352357_g5707_i0 | PRJNA745553 | 5901 | 476 | 1.352357 | 6.43721932 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 207 | 4.34e-62 | NR | HEX2611036.1 | 2448054 | g5707 | i0 | 82.1 | 0.775210084033613 | 123 | 22 | 77.5 | 0 | 3 | 371 | 320 | 442 | HEX2611036.1 IS4 family transposase [Gemmatimonadales bacterium] | diamond | 369 | 207 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29326329 | 29326329 | PRJNA745553_S_NODE_13709_length_332_cov_4.119691_g13514_i0 | PRJNA745553 | 13709 | 332 | 4.119691 | 13.67737412 | Gemmatimonas sp. | 1962908 | Bacteria | Bacteria | 91.3 | 9.78e-19 | NR | HYW30166.1 | 1962908 | g13514 | i0 | 59.2 | 0.885542168674699 | 98 | 34 | 83.1 | 1 | 14 | 289 | 1 | 98 | HYW30166.1 group II intron reverse transcriptase/maturase [Gemmatimonas sp.] | diamond | 294 | 91.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas sp. | |
| 29863162 | 29863162 | PRJNA745553_S_NODE_7331_length_438_cov_1.265753_g7137_i0 | PRJNA745553 | 7331 | 438 | 1.265753 | 5.54399814 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 172 | 9.44e-49 | NR | HEU4748609.1 | 2026741 | g7137 | i0 | 67.5 | 0.842465753424658 | 123 | 40 | 84.2 | 0 | 69 | 437 | 1 | 123 | HEU4748609.1 phage portal protein [Gemmatimonadaceae bacterium] | diamond | 369 | 172 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31168315 | 31168315 | PRJNA745553_S_NODE_19095_length_283_cov_1.466667_g18900_i0 | PRJNA745553 | 19095 | 283 | 1.466667 | 4.15066761 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 123 | 3.829999999999999e-31 | NR | MBL8983312.1 | 2026742 | g18900 | i0 | 62.5 | 10.2614840989399 | 88 | 33 | 93.3 | 0 | 2 | 265 | 335 | 422 | MBL8983312.1 amidohydrolase [Gemmatimonadota bacterium] | diamond | 2904 | 123 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31885957 | 31885957 | PRJNA745553_S_NODE_15537_length_313_cov_0.962500_g15342_i0 | PRJNA745553 | 15537 | 313 | 0.9625 | 3.012625 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 72 | 5.44e-13 | NR | MDP1861746.1 | 2026741 | g15342 | i0 | 61.8 | 1.03514376996805 | 55 | 21 | 52.7 | 0 | 148 | 312 | 23 | 77 | MDP1861746.1 GNAT family N-acetyltransferase [Gemmatimonadaceae bacterium] | diamond | 324 | 72 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae 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);;