contig_metadata
15 rows where analysis = "diamond", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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);;