contig_metadata
23 rows where bioproject = "PRJNA688736" and tax_clade = "FCB 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 668345 | 668345 | PRJNA688736_P_NODE_9121_length_493_cov_1.114286_g8837_i0 | PRJNA688736 | 9121 | 493 | 1.114286 | 5.49342998 | Candidatus Fluviicola riflensis | 1798018 | Bacteria | Bacteria | 695 | 0 | NTclustered | gi|1229046090|gb|CP022585.1| | 1798018 | g8837 | i0 | 92.089 | 340.584178498986 | 493 | 39 | 100 | 0 | 1 | 493 | 786332 | 786824 | Candidatus Fluviicola riflensis chromosome, complete genome | blastn | 167908 | 695 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Crocinitomicaceae | Fluviicola | Candidatus Fluviicola riflensis | |
| 5771836 | 5771836 | PRJNA688736_P_NODE_50465_length_242_cov_0.923077_g50180_i0 | PRJNA688736 | 50465 | 242 | 0.923077 | 2.23384634 | Candidatus Nephrothrix sp. EaCA | 2044729 | Bacteria | Bacteria | 147 | 1.07e-42 | NR | PGH37897.1 | 2044729 | g50180 | i0 | 98.6 | 0.867768595041322 | 70 | 1 | 86.8 | 0 | 240 | 31 | 136 | 205 | PGH37897.1 MAG: hypothetical protein CRN43_18450, partial [Candidatus Nephrothrix sp. EaCA] | diamond | 210 | 147 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cytophagaceae | Candidatus Nephrothrix | Candidatus Nephrothrix sp. EaCA | |
| 7555141 | 7555141 | PRJNA688736_P_NODE_20166_length_347_cov_3.043796_g19881_i0 | PRJNA688736 | 20166 | 347 | 3.043796 | 10.56197212 | Flavobacterium | 237 | Bacteria | Bacteria | 636 | 7.13e-178 | NTclustered | gi|2892685955|gb|CP174374.1| | 3379707 | g19881 | i0 | 99.712 | 534.527377521614 | 347 | 1 | 100 | 0 | 1 | 347 | 1248674 | 1248328 | Flavobacterium sp. TBRC 19031 chromosome, complete genome | blastn | 185481 | 641 | 0.992199687987519 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium mekongense | |
| 11381333 | 11381333 | PRJNA688736_P_NODE_48529_length_244_cov_0.912281_g48244_i0 | PRJNA688736 | 48529 | 244 | 0.912281 | 2.22596564 | Solitalea | 929509 | Bacteria | Bacteria | 285 | 1.99e-72 | NTclustered | gi|470489978|ref|NR_076960.1| | 995 | g48244 | i0 | 90.411 | 323.25 | 219 | 18 | 90 | 3 | 26 | 244 | 1422 | 1207 | Solitalea canadensis strain UASM 9D 23S ribosomal RNA gene, complete sequence | blastn | 78873 | 285 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Solitalea | Solitalea canadensis | |
| 18519456 | 18519456 | PRJNA688736_P_NODE_15715_length_387_cov_1.420382_g15430_i0 | PRJNA688736 | 15715 | 387 | 1.420382 | 5.49687834 | Cyclobacteriaceae bacterium | 2099675 | Bacteria | Bacteria | 449 | 1.12e-121 | NTclustered | gi|1869340971|gb|CP058703.1| | 2099675 | g15430 | i0 | 87.755 | 290.679586563308 | 392 | 39 | 99 | 7 | 3 | 387 | 1696441 | 1696830 | MAG: Cyclobacteriaceae bacterium isolate SSA6 chromosome | blastn | 112493 | 449 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cyclobacteriaceae | Cyclobacteriaceae bacterium | ||
| 19794538 | 19794538 | PRJNA688736_P_NODE_24876_length_318_cov_1.000000_g24591_i0 | PRJNA688736 | 24876 | 318 | 1 | 3.18 | Aurantibacillus circumpalustris | 3036359 | Bacteria | Bacteria | 483 | 8.919999999999998e-132 | NTclustered | gi|2482055248|gb|CP121197.1| | 3036359 | g24591 | i0 | 94.025 | 370.883647798742 | 318 | 19 | 100 | 0 | 1 | 318 | 2012890 | 2012573 | Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome | blastn | 117941 | 483 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Aurantibacillaceae | Aurantibacillus | Aurantibacillus circumpalustris | |
| 19794968 | 19794968 | PRJNA688736_P_NODE_43116_length_250_cov_0.881356_g42831_i0 | PRJNA688736 | 43116 | 250 | 0.881356 | 2.20339 | Flavobacterium sp. TBRC 19032 | 3379707 | Bacteria | Bacteria | 462 | 8.83e-126 | NTclustered | gi|2892685960|gb|CP174373.1| | 3379708 | g42831 | i0 | 100 | 2 | 250 | 0 | 100 | 0 | 1 | 250 | 3022523 | 3022274 | Flavobacterium sp. TBRC 19032 chromosome, complete genome | blastn | 500 | 462 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. TBRC 19032 | |
| 20303587 | 20303587 | PRJNA688736_P_NODE_19616_length_351_cov_2.097122_g19331_i0 | PRJNA688736 | 19616 | 351 | 2.097122 | 7.36089822 | Flavobacterium | 237 | Bacteria | Bacteria | 643 | 4.3e-180 | NTclustered | gi|2892685955|gb|CP174374.1| | 3379707 | g19331 | i0 | 99.715 | 549.507122507123 | 351 | 1 | 100 | 0 | 1 | 351 | 1249947 | 1249597 | Flavobacterium sp. TBRC 19031 chromosome, complete genome | blastn | 192877 | 649 | 0.99075500770416 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium mekongense | |
| 23621066 | 23621066 | PRJNA688736_P_NODE_49079_length_244_cov_0.912281_g48794_i0 | PRJNA688736 | 49079 | 244 | 0.912281 | 2.22596564 | Sphingobacterium spiritivorum | 258 | Bacteria | Bacteria | 451 | 1.86e-122 | NTclustered | gi|2636475595|gb|CP139978.1| | 258 | g48794 | i0 | 100 | 3.99180327868852 | 244 | 0 | 100 | 0 | 1 | 244 | 1895275 | 1895032 | Sphingobacterium spiritivorum strain HAMBI_1896 chromosome, complete genome | blastn | 974 | 451 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Sphingobacterium | Sphingobacterium spiritivorum | |
| 27145059 | 27145059 | PRJNA688736_P_NODE_40382_length_253_cov_0.866667_g40097_i0 | PRJNA688736 | 40382 | 253 | 0.866667 | 2.19266751 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 84.3 | 9.81e-17 | NR | MBS1651351.1 | 1898104 | g40097 | i0 | 48.8 | 0.99604743083004 | 84 | 43 | 99.6 | 0 | 253 | 2 | 609 | 692 | MBS1651351.1 T9SS type A sorting domain-containing protein [Bacteroidota bacterium] | diamond | 252 | 84.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 27493111 | 27493111 | PRJNA688736_P_NODE_37663_length_260_cov_2.299465_g37378_i0 | PRJNA688736 | 37663 | 260 | 2.299465 | 5.978609 | Candidatus Nephrothrix sp. EaCA | 2044729 | Bacteria | Bacteria | 51.2 | 6.12e-6 | NR | PGH37164.1 | 2044729 | g37378 | i0 | 95.8 | 0.276923076923077 | 24 | 1 | 27.7 | 0 | 189 | 260 | 56 | 79 | PGH37164.1 MAG: hypothetical protein CRN43_22790 [Candidatus Nephrothrix sp. EaCA] | diamond | 72 | 51.2 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cytophagaceae | Candidatus Nephrothrix | Candidatus Nephrothrix sp. EaCA | |
| 27682836 | 27682836 | PRJNA688736_P_NODE_3704_length_738_cov_1.201504_g3450_i0 | PRJNA688736 | 3704 | 738 | 1.201504 | 8.86709952 | Candidatus Nephrothrix sp. EaCA | 2044729 | Bacteria | Bacteria | 240 | 6.58e-75 | NR | PGH37471.1 | 2044729 | g3450 | i0 | 75.3 | 0.609756097560976 | 150 | 37 | 61 | 0 | 736 | 287 | 182 | 331 | PGH37471.1 MAG: hypothetical protein CRN43_21000, partial [Candidatus Nephrothrix sp. EaCA] | diamond | 450 | 240 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cytophagaceae | Candidatus Nephrothrix | Candidatus Nephrothrix sp. EaCA | |
| 27840163 | 27840163 | PRJNA688736_P_NODE_40444_length_253_cov_0.866667_g40159_i0 | PRJNA688736 | 40444 | 253 | 0.866667 | 2.19266751 | Sphingobacterium alimentarium | 797292 | Bacteria | Bacteria | 161 | 8.88e-45 | NR | WP_132779283.1 | 797292 | g40159 | i0 | 100 | 0.984189723320158 | 83 | 0 | 98.4 | 0 | 251 | 3 | 155 | 237 | WP_132779283.1 RagB/SusD family nutrient uptake outer membrane protein [Sphingobacterium alimentarium] | diamond | 249 | 161 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Sphingobacterium | Sphingobacterium alimentarium | |
| 28219020 | 28219020 | PRJNA688736_P_NODE_42346_length_251_cov_0.876404_g42061_i0 | PRJNA688736 | 42346 | 251 | 0.876404 | 2.19977404 | Candidatus Nephrothrix sp. EaCA | 2044729 | Bacteria | Bacteria | 111 | 3.25e-26 | NR | PGH38545.1 | 2044729 | g42061 | i0 | 67.1 | 1.97211155378486 | 82 | 27 | 98 | 0 | 249 | 4 | 715 | 796 | PGH38545.1 MAG: hypothetical protein CRN43_14440 [Candidatus Nephrothrix sp. EaCA] | diamond | 495 | 111 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cytophagaceae | Candidatus Nephrothrix | Candidatus Nephrothrix sp. EaCA | |
| 29071933 | 29071933 | PRJNA688736_P_NODE_43148_length_250_cov_0.881356_g42863_i0 | PRJNA688736 | 43148 | 250 | 0.881356 | 2.20339 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 144 | 4.43e-39 | NR | HEX3273601.1 | 2448054 | g42863 | i0 | 80.7 | 0.996 | 83 | 16 | 99.6 | 0 | 1 | 249 | 135 | 217 | HEX3273601.1 transposase [Gemmatimonadales bacterium] | diamond | 249 | 144 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29639797 | 29639797 | PRJNA688736_P_NODE_19490_length_352_cov_3.272401_g19205_i0 | PRJNA688736 | 19490 | 352 | 3.272401 | 11.51885152 | Candidatus Nephrothrix sp. EaCA | 2044729 | Bacteria | Bacteria | 62.8 | 9.94e-9 | NR | PGH37471.1 | 2044729 | g19205 | i0 | 46.7 | 0.639204545454545 | 75 | 37 | 63.9 | 1 | 330 | 106 | 2 | 73 | PGH37471.1 MAG: hypothetical protein CRN43_21000, partial [Candidatus Nephrothrix sp. EaCA] | diamond | 225 | 62.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cytophagaceae | Candidatus Nephrothrix | Candidatus Nephrothrix sp. EaCA | |
| 29935981 | 29935981 | PRJNA688736_P_NODE_40071_length_253_cov_0.866667_g39786_i0 | PRJNA688736 | 40071 | 253 | 0.866667 | 2.19266751 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 58.2 | 3.77e-8 | NR | PGH37340.1 | 2044729 | g39786 | i0 | 76.5 | 0.889328063241107 | 34 | 8 | 40.3 | 0 | 252 | 151 | 123 | 156 | PGH37340.1 MAG: hypothetical protein CRN43_21760 [Candidatus Nephrothrix sp. EaCA] | diamond | 225 | 58.2 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cytophagaceae | Candidatus Nephrothrix | Candidatus Nephrothrix sp. EaCA | |
| 30082105 | 30082105 | PRJNA688736_P_NODE_40872_length_252_cov_0.871508_g40587_i0 | PRJNA688736 | 40872 | 252 | 0.871508 | 2.19620016 | Fibrisoma montanum | 2305895 | Bacteria | Bacteria | 108 | 2.12e-25 | NR | WP_119669855.1 | 2305895 | g40587 | i0 | 65.1 | 0.988095238095238 | 83 | 29 | 98.8 | 0 | 250 | 2 | 77 | 159 | WP_119669855.1 SusC/RagA family TonB-linked outer membrane protein [Fibrisoma montanum] | diamond | 249 | 108 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Spirosomataceae | Fibrisoma | Fibrisoma montanum | |
| 30208366 | 30208366 | PRJNA688736_P_NODE_24412_length_321_cov_0.943548_g24127_i0 | PRJNA688736 | 24412 | 321 | 0.943548 | 3.02878908 | Candidatus Nephrothrix sp. EaCA | 2044729 | Bacteria | Bacteria | 105 | 1.72e-27 | NR | PGH37166.1 | 2044729 | g24127 | i0 | 92.7 | 0.514018691588785 | 55 | 4 | 51.4 | 0 | 45 | 209 | 1 | 55 | PGH37166.1 MAG: hypothetical protein CRN43_22775 [Candidatus Nephrothrix sp. EaCA] | diamond | 165 | 105 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cytophagaceae | Candidatus Nephrothrix | Candidatus Nephrothrix sp. EaCA | |
| 30536121 | 30536121 | PRJNA688736_P_NODE_39673_length_253_cov_1.411111_g39388_i0 | PRJNA688736 | 39673 | 253 | 1.411111 | 3.57011083 | Chryseobacterium | 59732 | Bacteria | Bacteria | 140 | 5.63e-38 | NR | WP_147756530.1 | 1871047 | g39388 | i0 | 85.7 | 8.89328063241107 | 84 | 12 | 99.6 | 0 | 253 | 2 | 85 | 168 | WP_147756530.1 FtsW/RodA/SpoVE family cell cycle protein [Chryseobacterium sp.] | diamond | 2250 | 140 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium sp. | |
| 30978661 | 30978661 | PRJNA688736_P_NODE_46574_length_246_cov_0.901734_g46289_i0 | PRJNA688736 | 46574 | 246 | 0.901734 | 2.21826564 | Seramator | 2919400 | Bacteria | Bacteria | 161 | 3.2499999999999996e-48 | NR | MDK2838396.1 | 1898104 | g46289 | i0 | 98.8 | 3.95121951219512 | 81 | 1 | 98.8 | 0 | 2 | 244 | 112 | 192 | MDK2838396.1 outer membrane protein [Bacteroidota bacterium] | diamond | 972 | 162 | 0.993827160493827 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 31199205 | 31199205 | PRJNA688736_P_NODE_39835_length_253_cov_0.866667_g39550_i0 | PRJNA688736 | 39835 | 253 | 0.866667 | 2.19266751 | Bacteria | 2 | Bacteria | Bacteria | 148 | 2.76e-39 | NR | MCW5914747.1 | 1869212 | g39550 | i0 | 89.3 | 3.98418972332016 | 84 | 4 | 99.6 | 1 | 252 | 1 | 378 | 456 | MCW5914747.1 type I restriction endonuclease subunit R [Chitinophagaceae bacterium] | diamond | 1008 | 149 | 0.993288590604027 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 32022109 | 32022109 | PRJNA688736_P_NODE_41898_length_251_cov_0.876404_g41613_i0 | PRJNA688736 | 41898 | 251 | 0.876404 | 2.19977404 | root | 1 | Root_unresolved | Root_unresolved | 60.8 | 1.72e-8 | NR | MFM2291787.1 | 1898104 | g41613 | i0 | 44.9 | 1.64940239043825 | 69 | 35 | 78.9 | 2 | 41 | 238 | 759 | 827 | MFM2291787.1 hypothetical protein [Bacteroidota bacterium] | diamond | 414 | 60.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota 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);;