contig_metadata
24 rows where bioproject = "PRJNA560932", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14573382 | 14573382 | PRJNA560932_P_NODE_12412_length_496_cov_0.820331_g12058_i0 | PRJNA560932 | 12412 | 496 | 0.820331 | 4.06884176 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 125 | 1.39e-30 | NR | HMA40046.1 | 2448054 | g12058 | i0 | 52.3 | 3.82862903225806 | 111 | 53 | 67.1 | 0 | 335 | 3 | 3 | 113 | HMA40046.1 aspartate aminotransferase family protein [Gemmatimonadales bacterium] | diamond | 1899 | 125 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 20946935 | 20946935 | PRJNA560932_P_NODE_48877_length_260_cov_1.647059_g48521_i0 | PRJNA560932 | 48877 | 260 | 1.647059 | 4.2823534 | Gemmatimonas phototrophica | 1379270 | Bacteria | Bacteria | 414 | 2.62e-111 | NTclustered | gi|1015602748|gb|CP011454.1| | 1379270 | g48521 | i0 | 95.385 | 197.096153846154 | 260 | 12 | 100 | 0 | 1 | 260 | 2074984 | 2074725 | Gemmatimonas phototrophica strain AP64, complete genome | blastn | 51245 | 414 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas phototrophica | |
| 27047402 | 27047402 | PRJNA560932_P_NODE_1582_length_1233_cov_2.306034_g1413_i0 | PRJNA560932 | 1582 | 1233 | 2.306034 | 28.43339922 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 75.5 | 1.95e-12 | NR | MDQ3556889.1 | 2026742 | g1413 | i0 | 37.8 | 0.781021897810219 | 98 | 61 | 23.8 | 0 | 831 | 1124 | 4 | 101 | MDQ3556889.1 30S ribosomal protein S9 [Gemmatimonadota bacterium] | diamond | 963 | 75.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27426896 | 27426896 | PRJNA560932_P_NODE_54543_length_250_cov_0.870056_g54187_i0 | PRJNA560932 | 54543 | 250 | 0.870056 | 2.17514 | uncultured Gemmatimonadaceae bacterium | 246130 | Bacteria | Bacteria | 48.1 | 3.05e-4 | NR | CAA9297862.1 | 246130 | g54187 | i0 | 39.2 | 2.724 | 74 | 43 | 86.4 | 1 | 220 | 5 | 46 | 119 | CAA9297862.1 MAG: Methanol dehydrogenase large subunit protein [uncultured Gemmatimonadaceae bacterium] | diamond | 681 | 48.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | uncultured Gemmatimonadaceae bacterium | ||
| 27647809 | 27647809 | PRJNA560932_P_NODE_15904_length_440_cov_1.621253_g15549_i0 | PRJNA560932 | 15904 | 440 | 1.621253 | 7.1335132 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 85.1 | 4.46e-17 | NR | HEX3276166.1 | 2448054 | g15549 | i0 | 37 | 0.940909090909091 | 138 | 79 | 92 | 3 | 11 | 415 | 6 | 138 | HEX3276166.1 aquaporin [Gemmatimonadales bacterium] | diamond | 414 | 85.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 27900119 | 27900119 | PRJNA560932_P_NODE_54865_length_249_cov_1.136364_g54509_i0 | PRJNA560932 | 54865 | 249 | 1.136364 | 2.82954636 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 60.1 | 3.09e-8 | NR | HET9985637.1 | 2910168 | g54509 | i0 | 37.8 | 4.8433734939759 | 82 | 46 | 96.4 | 2 | 244 | 5 | 424 | 502 | HET9985637.1 glutamine--tRNA ligase/YqeY domain fusion protein [Longimicrobiales bacterium] | diamond | 1206 | 60.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 28026688 | 28026688 | PRJNA560932_P_NODE_27005_length_345_cov_0.849265_g26649_i0 | PRJNA560932 | 27005 | 345 | 0.849265 | 2.92996425 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 57.4 | 7.62e-7 | NR | HEY0970368.1 | 2448054 | g26649 | i0 | 39.5 | 1.75652173913043 | 86 | 46 | 74.8 | 1 | 303 | 46 | 42 | 121 | HEY0970368.1 heme ABC transporter ATP-binding protein [Gemmatimonadales bacterium] | diamond | 606 | 57.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 28531950 | 28531950 | PRJNA560932_P_NODE_61547_length_245_cov_0.895349_g61191_i0 | PRJNA560932 | 61547 | 245 | 0.895349 | 2.19360505 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 42.4 | 0.0481 | NR | HEU0053638.1 | 2029185 | g61191 | i0 | 43.3 | 0.73469387755102 | 60 | 31 | 73.5 | 2 | 57 | 236 | 114 | 170 | HEU0053638.1 LytTR family DNA-binding domain-containing protein [Longimicrobium sp.] | diamond | 180 | 42.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 28595023 | 28595023 | PRJNA560932_P_NODE_15507_length_445_cov_1.602151_g15152_i0 | PRJNA560932 | 15507 | 445 | 1.602151 | 7.12957195 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 45.8 | 0.0189 | NR | NNK49592.1 | 2026742 | g15152 | i0 | 37.3 | 0.559550561797753 | 83 | 44 | 56 | 1 | 96 | 344 | 184 | 258 | NNK49592.1 FkbM family methyltransferase [Gemmatimonadota bacterium] | diamond | 249 | 45.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28910346 | 28910346 | PRJNA560932_P_NODE_34188_length_310_cov_2.367089_g33832_i0 | PRJNA560932 | 34188 | 310 | 2.367089 | 7.3379759 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 61.2 | 2.68e-8 | NR | HZI99252.1 | 2026741 | g33832 | i0 | 45.5 | 0.745161290322581 | 77 | 37 | 73.5 | 3 | 83 | 310 | 724 | 796 | HZI99252.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 231 | 61.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 29005827 | 29005827 | PRJNA560932_P_NODE_6828_length_662_cov_1.740238_g6477_i0 | PRJNA560932 | 6828 | 662 | 1.740238 | 11.52037556 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 53.9 | 1.13e-4 | NR | HEX2078858.1 | 2029185 | g6477 | i0 | 66.7 | 0.176737160120846 | 39 | 13 | 17.7 | 0 | 119 | 3 | 137 | 175 | HEX2078858.1 DUF2382 domain-containing protein [Longimicrobium sp.] | diamond | 117 | 53.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 29352793 | 29352793 | PRJNA560932_P_NODE_3049_length_955_cov_1.980726_g2783_i0 | PRJNA560932 | 3049 | 955 | 1.980726 | 18.9159333 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 97.4 | 1.68e-19 | NR | HEX2210215.1 | 2029185 | g2783 | i0 | 47.4 | 0.76020942408377 | 114 | 59 | 35.5 | 1 | 775 | 437 | 135 | 248 | HEX2210215.1 DUF2382 domain-containing protein [Longimicrobium sp.] | diamond | 726 | 97.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 29447234 | 29447234 | PRJNA560932_P_NODE_60610_length_245_cov_0.895349_g60254_i0 | PRJNA560932 | 60610 | 245 | 0.895349 | 2.19360505 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 44.7 | 0.00668 | NR | MCA9738193.1 | 2026742 | g60254 | i0 | 39.1 | 0.783673469387755 | 64 | 36 | 78.4 | 1 | 194 | 3 | 3 | 63 | MCA9738193.1 tetratricopeptide repeat protein [Gemmatimonadota bacterium] | diamond | 192 | 44.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29857812 | 29857812 | PRJNA560932_P_NODE_24971_length_356_cov_1.356890_g24615_i0 | PRJNA560932 | 24971 | 356 | 1.35689 | 4.8305284 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 68.6 | 9.58e-11 | NR | HXV15547.1 | 2026741 | g24615 | i0 | 37.1 | 4.3314606741573 | 105 | 53 | 86.8 | 2 | 351 | 43 | 102 | 195 | HXV15547.1 alpha/beta fold hydrolase [Gemmatimonadaceae bacterium] | diamond | 1542 | 68.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 29889585 | 29889585 | PRJNA560932_P_NODE_17611_length_419_cov_1.653179_g17255_i0 | PRJNA560932 | 17611 | 419 | 1.653179 | 6.92682001 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 137 | 1.18e-34 | NR | NNE08319.1 | 2026742 | g17255 | i0 | 46.4 | 1.00238663484487 | 140 | 67 | 99.5 | 3 | 419 | 3 | 205 | 337 | NNE08319.1 T9SS type A sorting domain-containing protein [Gemmatimonadota bacterium] | diamond | 420 | 137 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30141792 | 30141792 | PRJNA560932_P_NODE_32272_length_319_cov_0.939024_g31916_i0 | PRJNA560932 | 32272 | 319 | 0.939024 | 2.99548656 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 42.7 | 0.0344 | NR | MBY0492105.1 | 2026741 | g31916 | i0 | 39 | 0.554858934169279 | 59 | 34 | 53.6 | 2 | 187 | 17 | 2 | 60 | MBY0492105.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 177 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30647462 | 30647462 | PRJNA560932_P_NODE_22233_length_375_cov_1.887417_g21877_i0 | PRJNA560932 | 22233 | 375 | 1.887417 | 7.07781375 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 45.4 | 0.0172 | NR | MBA3556131.1 | 2448054 | g21877 | i0 | 35.8 | 0.96 | 120 | 52 | 76 | 5 | 76 | 360 | 106 | 225 | MBA3556131.1 sugar ABC transporter ATP-binding protein [Gemmatimonadales bacterium] | diamond | 360 | 45.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 30679183 | 30679183 | PRJNA560932_P_NODE_67053_length_241_cov_0.916667_g66697_i0 | PRJNA560932 | 67053 | 241 | 0.916667 | 2.20916747 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 91.3 | 2.23e-19 | NR | MEK7667633.1 | 2026742 | g66697 | i0 | 56.4 | 0.970954356846473 | 78 | 34 | 97.1 | 0 | 8 | 241 | 116 | 193 | MEK7667633.1 MFS transporter [Gemmatimonadota bacterium] | diamond | 234 | 91.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30742485 | 30742485 | PRJNA560932_P_NODE_23254_length_368_cov_1.006780_g22898_i0 | PRJNA560932 | 23254 | 368 | 1.00678 | 3.7049504 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 45.4 | 0.016 | NR | MBT7549682.1 | 2026742 | g22898 | i0 | 29.5 | 0.855978260869565 | 105 | 64 | 82.3 | 3 | 50 | 352 | 10 | 108 | MBT7549682.1 sigma 54-interacting transcriptional regulator [Gemmatimonadota bacterium] | diamond | 315 | 45.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31483708 | 31483708 | PRJNA560932_P_NODE_42036_length_282_cov_0.851675_g41680_i0 | PRJNA560932 | 42036 | 282 | 0.851675 | 2.4017235 | Gemmatimonas | 173479 | Bacteria | Bacteria | 77.4 | 3.74e-14 | NR | WP_291155774.1 | 1946568 | g41680 | i0 | 43 | 6.97872340425532 | 93 | 51 | 98.9 | 2 | 281 | 3 | 346 | 436 | WP_291155774.1 leishmanolysin-related zinc metalloendopeptidase [Gemmatimonas sp. UBA7669] | diamond | 1968 | 77.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas sp. UBA7669 | |
| 31880545 | 31880545 | PRJNA560932_P_NODE_65177_length_242_cov_0.911243_g64821_i0 | PRJNA560932 | 65177 | 242 | 0.911243 | 2.20520806 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 54.3 | 2.79e-6 | NR | HET9465852.1 | 2448054 | g64821 | i0 | 69.7 | 0.409090909090909 | 33 | 10 | 40.9 | 0 | 9 | 107 | 108 | 140 | HET9465852.1 ferrochelatase [Gemmatimonadales bacterium] | diamond | 99 | 54.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32324028 | 32324028 | PRJNA560932_P_NODE_46499_length_268_cov_1.184615_g46143_i0 | PRJNA560932 | 46499 | 268 | 1.184615 | 3.1747682 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 43.9 | 0.0191 | NR | HEY3280245.1 | 2448054 | g46143 | i0 | 31.4 | 2.59701492537313 | 86 | 57 | 96.3 | 1 | 7 | 264 | 115 | 198 | HEY3280245.1 putative glycoside hydrolase [Gemmatimonadales bacterium] | diamond | 696 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32369516 | 32369516 | PRJNA560932_P_NODE_53319_length_250_cov_1.305085_g52963_i0 | PRJNA560932 | 53319 | 250 | 1.305085 | 3.2627125 | Bacteria | 2 | Bacteria | Bacteria | 119 | 7.249999999999998e-30 | NR | MFQ5746996.1 | 2026742 | g52963 | i0 | 68.3 | 3.9 | 82 | 26 | 98.4 | 0 | 246 | 1 | 286 | 367 | MFQ5746996.1 inorganic phosphate transporter [Gemmatimonadota bacterium] | diamond | 975 | 120 | 0.991666666666667 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32765561 | 32765561 | PRJNA560932_P_NODE_3180_length_939_cov_1.740185_g2911_i0 | PRJNA560932 | 3180 | 939 | 1.740185 | 16.34033715 | Gemmatirosa sp. | 2510638 | Bacteria | Bacteria | 85.1 | 7.34e-15 | NR | HZF66933.1 | 2510638 | g2911 | i0 | 39.8 | 1.12460063897764 | 123 | 73 | 39.3 | 1 | 550 | 918 | 162 | 283 | HZF66933.1 DUF2382 domain-containing protein [Gemmatirosa sp.] | diamond | 1056 | 85.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa sp. |
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);;