contig_metadata
24 rows where bioproject = "PRJNA703759" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3235679 | 3235679 | PRJNA703759_P_NODE_42643_length_247_cov_1.488506_g42167_i0 | PRJNA703759 | 42643 | 247 | 1.488506 | 3.67660982 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 124 | 9.68e-31 | NR | MBY0491525.1 | 2026741 | g42167 | i0 | 92.8 | 0.838056680161943 | 69 | 5 | 83.8 | 0 | 207 | 1 | 531 | 599 | MBY0491525.1 NAD-dependent DNA ligase LigA [Gemmatimonadaceae bacterium] | diamond | 207 | 124 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 7062511 | 7062511 | PRJNA703759_P_NODE_12166_length_384_cov_1.649518_g11690_i0 | PRJNA703759 | 12166 | 384 | 1.649518 | 6.33414912 | Pseudogemmatithrix spongiicola | 3062599 | Bacteria | Bacteria | 135 | 3.5400000000000005e-27 | NTclustered | gi|2557479348|gb|CP130613.1| | 3062599 | g11690 | i0 | 73.935 | 2.51822916666667 | 399 | 77 | 98 | 22 | 1 | 378 | 233603 | 233995 | Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome | blastn | 967 | 135 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Pseudogemmatithrix | Pseudogemmatithrix spongiicola | |
| 8337920 | 8337920 | PRJNA703759_P_NODE_45907_length_245_cov_0.906977_g45431_i0 | PRJNA703759 | 45907 | 245 | 0.906977 | 2.22209365 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 160 | 6.979999999999999e-46 | NR | MBY0489567.1 | 2026741 | g45431 | i0 | 98.8 | 0.991836734693878 | 81 | 1 | 99.2 | 0 | 2 | 244 | 58 | 138 | MBY0489567.1 chemotaxis response regulator protein-glutamate methylesterase [Gemmatimonadaceae bacterium] | diamond | 243 | 160 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 9612370 | 9612370 | PRJNA703759_P_NODE_10328_length_420_cov_2.469741_g9852_i0 | PRJNA703759 | 10328 | 420 | 2.469741 | 10.3729122 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 111 | 8.58e-26 | NR | HEX6615028.1 | 2448054 | g9852 | i0 | 71.2 | 3.62857142857143 | 73 | 21 | 52.1 | 0 | 419 | 201 | 248 | 320 | HEX6615028.1 ATP-binding protein [Gemmatimonadales bacterium] | diamond | 1524 | 111 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 15986514 | 15986514 | PRJNA703759_P_NODE_12113_length_385_cov_1.823718_g11637_i0 | PRJNA703759 | 12113 | 385 | 1.823718 | 7.0213143 | Bacteria | 2 | Bacteria | Bacteria | 120 | 2.5899999999999997e-31 | NR | MFQ5680324.1 | 2026742 | g11637 | i0 | 64.4 | 14.9532467532468 | 90 | 32 | 70.1 | 0 | 115 | 384 | 23 | 112 | MFQ5680324.1 sigma-70 family RNA polymerase sigma factor [Gemmatimonadota bacterium] | diamond | 5757 | 120 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 24911164 | 24911164 | PRJNA703759_P_NODE_50940_length_242_cov_0.923077_g50464_i0 | PRJNA703759 | 50940 | 242 | 0.923077 | 2.23384634 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 146 | 3.1899999999999993e-40 | NR | MBY0492540.1 | 2026741 | g50464 | i0 | 97.5 | 0.991735537190083 | 80 | 2 | 99.2 | 0 | 240 | 1 | 310 | 389 | MBY0492540.1 chorismate synthase [Gemmatimonadaceae bacterium] | diamond | 240 | 146 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 27398996 | 27398996 | PRJNA703759_P_NODE_32783_length_257_cov_2.396739_g32307_i0 | PRJNA703759 | 32783 | 257 | 2.396739 | 6.15961923 | Gemmatimonas sp. | 1962908 | Bacteria | Bacteria | 44.3 | 0.0116 | NR | WP_396223237.1 | 1962908 | g32307 | i0 | 33.9 | 1.52918287937743 | 56 | 37 | 65.4 | 0 | 3 | 170 | 216 | 271 | WP_396223237.1 PLP-dependent aminotransferase family protein [Gemmatimonas sp.] | diamond | 393 | 44.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas sp. | |
| 28420571 | 28420571 | PRJNA703759_P_NODE_51566_length_241_cov_3.226190_g51090_i0 | PRJNA703759 | 51566 | 241 | 3.22619 | 7.7751179 | Bacteria | 2 | Bacteria | Bacteria | 62 | 4.81e-9 | NR | PKL93066.1 | 2013806 | g51090 | i0 | 71.4 | 4.38174273858921 | 35 | 10 | 43.6 | 0 | 130 | 234 | 17 | 51 | PKL93066.1 MAG: MFS transporter, partial [Gemmatimonadetes bacterium HGW-Gemmatimonadetes-1] | diamond | 1056 | 62 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadetes bacterium HGW-Gemmatimonadetes-1 | |||||
| 28503977 | 28503977 | PRJNA703759_P_NODE_34887_length_253_cov_0.866667_g34411_i0 | PRJNA703759 | 34887 | 253 | 0.866667 | 2.19266751 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 54.3 | 3.38e-6 | NR | MBY0488958.1 | 2026741 | g34411 | i0 | 92 | 1.28063241106719 | 25 | 2 | 29.6 | 0 | 178 | 252 | 2 | 26 | MBY0488958.1 peptide chain release factor 2 [Gemmatimonadaceae bacterium] | diamond | 324 | 54.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28819380 | 28819380 | PRJNA703759_P_NODE_36268_length_252_cov_0.871508_g35792_i0 | PRJNA703759 | 36268 | 252 | 0.871508 | 2.19620016 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 115 | 2.02e-28 | NR | HEX5576518.1 | 2448054 | g35792 | i0 | 69.8 | 2.03571428571429 | 86 | 23 | 100 | 2 | 1 | 252 | 144 | 228 | HEX5576518.1 DbpA RNA binding domain-containing protein [Gemmatimonadales bacterium] | diamond | 513 | 115 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29072487 | 29072487 | PRJNA703759_P_NODE_46228_length_245_cov_0.906977_g45752_i0 | PRJNA703759 | 46228 | 245 | 0.906977 | 2.22209365 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 145 | 4.17e-40 | NR | MBY0490015.1 | 2026741 | g45752 | i0 | 100 | 0.991836734693878 | 81 | 0 | 99.2 | 0 | 1 | 243 | 5 | 85 | MBY0490015.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 243 | 145 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 29388217 | 29388217 | PRJNA703759_P_NODE_51449_length_242_cov_0.923077_g50973_i0 | PRJNA703759 | 51449 | 242 | 0.923077 | 2.23384634 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 151 | 1.84e-40 | NR | MBY0488372.1 | 2026741 | g50973 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 3 | 242 | 18 | 97 | MBY0488372.1 DEAD/DEAH box helicase [Gemmatimonadaceae bacterium] | diamond | 240 | 151 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 29703377 | 29703377 | PRJNA703759_P_NODE_46570_length_245_cov_0.906977_g46094_i0 | PRJNA703759 | 46570 | 245 | 0.906977 | 2.22209365 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 114 | 3.68e-28 | NR | MBU6367826.1 | 2026742 | g46094 | i0 | 93 | 0.697959183673469 | 57 | 4 | 69.8 | 0 | 245 | 75 | 294 | 350 | MBU6367826.1 IS5 family transposase [Gemmatimonadota bacterium] | diamond | 171 | 114 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29735076 | 29735076 | PRJNA703759_P_NODE_49710_length_243_cov_0.917647_g49234_i0 | PRJNA703759 | 49710 | 243 | 0.917647 | 2.22988221 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 128 | 1.63e-33 | NR | MCI0434341.1 | 2026742 | g49234 | i0 | 72 | 2 | 82 | 21 | 98.8 | 1 | 242 | 3 | 133 | 214 | MCI0434341.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 486 | 128 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30177499 | 30177499 | PRJNA703759_P_NODE_17072_length_330_cov_2.190661_g16596_i0 | PRJNA703759 | 17072 | 330 | 2.190661 | 7.2291813 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 108 | 1.22e-25 | NR | HEY0243888.1 | 2026741 | g16596 | i0 | 52.9 | 0.945454545454545 | 104 | 46 | 94.5 | 1 | 317 | 6 | 42 | 142 | HEY0243888.1 MBL fold metallo-hydrolase [Gemmatimonadaceae bacterium] | diamond | 312 | 108 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30662654 | 30662654 | PRJNA703759_P_NODE_41633_length_248_cov_0.891429_g41157_i0 | PRJNA703759 | 41633 | 248 | 0.891429 | 2.21074392 | Bacteria | 2 | Bacteria | Bacteria | 113 | 1.1e-27 | NR | MEX0892144.1 | 2026742 | g41157 | i0 | 70.9 | 5.84274193548387 | 79 | 23 | 95.6 | 0 | 6 | 242 | 128 | 206 | MEX0892144.1 AAA family ATPase [Gemmatimonadota bacterium] | diamond | 1449 | 114 | 0.991228070175439 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30777959 | 30777959 | PRJNA703759_P_NODE_36574_length_252_cov_0.871508_g36098_i0 | PRJNA703759 | 36574 | 252 | 0.871508 | 2.19620016 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 76.3 | 4.96e-15 | NR | HET7470090.1 | 2448054 | g36098 | i0 | 53.6 | 1.64285714285714 | 69 | 32 | 82.1 | 0 | 2 | 208 | 108 | 176 | HET7470090.1 DUF3341 domain-containing protein [Gemmatimonadales bacterium] | diamond | 414 | 76.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31283383 | 31283383 | PRJNA703759_P_NODE_12555_length_379_cov_1.212418_g12079_i0 | PRJNA703759 | 12555 | 379 | 1.212418 | 4.59506422 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 113 | 1.57e-29 | NR | HXY19345.1 | 2448054 | g12079 | i0 | 67.1 | 1.34564643799472 | 85 | 26 | 66.5 | 2 | 253 | 2 | 1 | 84 | HXY19345.1 VOC family protein [Gemmatimonadales bacterium] | diamond | 510 | 113 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31315141 | 31315141 | PRJNA703759_P_NODE_20655_length_306_cov_1.158798_g20179_i0 | PRJNA703759 | 20655 | 306 | 1.158798 | 3.54592188 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 75.5 | 2.3e-14 | NR | MBY0488634.1 | 2026741 | g20179 | i0 | 76.1 | 0.450980392156863 | 46 | 11 | 45.1 | 0 | 138 | 1 | 1 | 46 | MBY0488634.1 DUF1697 domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 138 | 75.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31662913 | 31662913 | PRJNA703759_P_NODE_9117_length_450_cov_2.639257_g8641_i0 | PRJNA703759 | 9117 | 450 | 2.639257 | 11.8766565 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 48.9 | 0.00104 | NR | MCE2941074.1 | 2026742 | g8641 | i0 | 29.5 | 0.586666666666667 | 88 | 59 | 57.3 | 2 | 92 | 349 | 67 | 153 | MCE2941074.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 264 | 48.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32042721 | 32042721 | PRJNA703759_P_NODE_40958_length_249_cov_0.886364_g40482_i0 | PRJNA703759 | 40958 | 249 | 0.886364 | 2.20704636 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 136 | 3.75e-36 | NR | MBY0488640.1 | 2026741 | g40482 | i0 | 90.2 | 0.987951807228916 | 82 | 8 | 98.8 | 0 | 2 | 247 | 157 | 238 | MBY0488640.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 246 | 136 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32327875 | 32327875 | PRJNA703759_P_NODE_43539_length_247_cov_0.896552_g43063_i0 | PRJNA703759 | 43539 | 247 | 0.896552 | 2.21448344 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 131 | 3.47e-35 | NR | WP_329687970.1 | 2029185 | g43063 | i0 | 86.4 | 0.983805668016194 | 81 | 11 | 98.4 | 0 | 4 | 246 | 67 | 147 | WP_329687970.1 hypothetical protein [Longimicrobium sp.] | diamond | 243 | 131 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 32485845 | 32485845 | PRJNA703759_P_NODE_35199_length_253_cov_0.866667_g34723_i0 | PRJNA703759 | 35199 | 253 | 0.866667 | 2.19266751 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 147 | 6.17e-40 | NR | MBY0488480.1 | 2026741 | g34723 | i0 | 91.7 | 0.99604743083004 | 84 | 7 | 99.6 | 0 | 253 | 2 | 216 | 299 | MBY0488480.1 ABC transporter ATP-binding protein [Gemmatimonadaceae bacterium] | diamond | 252 | 147 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32812006 | 32812006 | PRJNA703759_P_NODE_13360_length_368_cov_1.057627_g12884_i0 | PRJNA703759 | 13360 | 368 | 1.057627 | 3.89206736 | Bacteria | 2 | Bacteria | Bacteria | 141 | 1.9699999999999998e-38 | NR | OPX31674.1 | 1956166 | g12884 | i0 | 58.8 | 3.77445652173913 | 114 | 47 | 92.9 | 0 | 368 | 27 | 154 | 267 | OPX31674.1 MAG: hypothetical protein B1H09_02310 [Gemmatimonadaceae bacterium 4484_173] | diamond | 1389 | 141 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium 4484_173 |
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);;