contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA596870" and tax_phylum = "Bacteroidota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3119339 | 3119339 | PRJNA596870_P_NODE_23723_length_278_cov_1.229268_g23590_i0 | PRJNA596870 | 23723 | 278 | 1.229268 | 3.41736504 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 94.7 | 7.200000000000001e-22 | NR | MBO7546915.1 | 2030927 | g23590 | i0 | 86.5 | 1.12230215827338 | 52 | 7 | 56.1 | 0 | 2 | 157 | 149 | 200 | MBO7546915.1 30S ribosomal protein S4 [Bacteroidales bacterium] | diamond | 312 | 94.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 8221324 | 8221324 | PRJNA596870_P_NODE_13007_length_358_cov_1.077193_g12874_i0 | PRJNA596870 | 13007 | 358 | 1.077193 | 3.85635094 | Spongiivirga citrea | 1481457 | Bacteria | Bacteria | 79 | 2.84e-14 | NR | WP_164029204.1 | 1481457 | g12874 | i0 | 43.4 | 0.946927374301676 | 113 | 51 | 94.7 | 3 | 15 | 353 | 841 | 940 | WP_164029204.1 fasciclin domain-containing protein [Spongiivirga citrea] | diamond | 339 | 79 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Spongiivirga | Spongiivirga citrea | |
| 26604763 | 26604763 | PRJNA596870_P_NODE_35701_length_245_cov_0.895349_g35568_i0 | PRJNA596870 | 35701 | 245 | 0.895349 | 2.19360505 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 162 | 2.46e-44 | NR | MFO7827238.1 | 2030927 | g35568 | i0 | 97.6 | 1.00408163265306 | 82 | 1 | 99.2 | 1 | 243 | 1 | 930 | 1011 | MFO7827238.1 reverse transcriptase domain-containing protein [Bacteroidales bacterium] | diamond | 246 | 162 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 27332857 | 27332857 | PRJNA596870_P_NODE_21183_length_291_cov_0.922018_g21050_i0 | PRJNA596870 | 21183 | 291 | 0.922018 | 2.68307238 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 188 | 2.45e-53 | NR | MFO7829217.1 | 2030927 | g21050 | i0 | 95.8 | 0.989690721649485 | 96 | 4 | 99 | 0 | 2 | 289 | 528 | 623 | MFO7829217.1 reverse transcriptase family protein [Bacteroidales bacterium] | diamond | 288 | 188 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 28659008 | 28659008 | PRJNA596870_P_NODE_22087_length_286_cov_1.446009_g21954_i0 | PRJNA596870 | 22087 | 286 | 1.446009 | 4.13558574 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 48.5 | 5.98e-4 | NR | MDD2529612.1 | 2030927 | g21954 | i0 | 48.1 | 1.09090909090909 | 52 | 25 | 54.5 | 2 | 98 | 253 | 236 | 285 | MDD2529612.1 DNA polymerase III subunit alpha [Bacteroidales bacterium] | diamond | 312 | 48.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 28911138 | 28911138 | PRJNA596870_P_NODE_33288_length_247_cov_1.563218_g33155_i0 | PRJNA596870 | 33288 | 247 | 1.563218 | 3.86114846 | Myroides sp. | 1874736 | Bacteria | Bacteria | 164 | 1.68e-45 | NR | MEG1377069.1 | 1874736 | g33155 | i0 | 95.1 | 0.995951417004049 | 82 | 4 | 99.6 | 0 | 2 | 247 | 180 | 261 | MEG1377069.1 TonB-dependent receptor [Myroides sp.] | diamond | 246 | 164 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Myroides | Myroides sp. | |
| 29511208 | 29511208 | PRJNA596870_P_NODE_29350_length_251_cov_0.865169_g29217_i0 | PRJNA596870 | 29350 | 251 | 0.865169 | 2.17157419 | Paraprevotella clara | 454154 | Bacteria | Bacteria | 152 | 4.75e-44 | NR | WP_302979927.1 | 454154 | g29217 | i0 | 97.1 | 0.836653386454183 | 70 | 2 | 83.7 | 0 | 251 | 42 | 182 | 251 | WP_302979927.1 hypothetical protein [Paraprevotella clara] | diamond | 210 | 152 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Paraprevotella | Paraprevotella clara | |
| 29574277 | 29574277 | PRJNA596870_P_NODE_8250_length_434_cov_1.066482_g8117_i0 | PRJNA596870 | 8250 | 434 | 1.066482 | 4.62853188 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 150 | 9.61e-42 | NR | MFO7844438.1 | 2030927 | g8117 | i0 | 46.9 | 1.00230414746544 | 145 | 76 | 99.5 | 1 | 434 | 3 | 132 | 276 | MFO7844438.1 endonuclease/exonuclease/phosphatase family protein [Bacteroidales bacterium] | diamond | 435 | 150 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 29795366 | 29795366 | PRJNA596870_P_NODE_39691_length_241_cov_0.916667_g39558_i0 | PRJNA596870 | 39691 | 241 | 0.916667 | 2.20916747 | Chryseobacterium piscicola | 551459 | Bacteria | Bacteria | 167 | 3.0099999999999998e-52 | NR | WP_076452933.1 | 551459 | g39558 | i0 | 96.2 | 0.970954356846473 | 78 | 3 | 97.1 | 0 | 236 | 3 | 1 | 78 | WP_076452933.1 virulence factor [Chryseobacterium piscicola] | diamond | 234 | 167 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium piscicola | |
| 30016745 | 30016745 | PRJNA596870_P_NODE_31311_length_249_cov_0.875000_g31178_i0 | PRJNA596870 | 31311 | 249 | 0.875 | 2.17875 | Bacteroidetes bacterium ADurb.Bin4 | 1898104 | Bacteria | Bacteria | 72 | 1.35e-12 | NR | OPZ97063.1 | 1852813 | g31178 | i0 | 44.9 | 0.939759036144578 | 78 | 43 | 94 | 0 | 242 | 9 | 124 | 201 | OPZ97063.1 MAG: GIY-YIG catalytic domain protein [Bacteroidetes bacterium ADurb.Bin408] | diamond | 234 | 72 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidetes bacterium ADurb.Bin408 | |||||
| 30079648 | 30079648 | PRJNA596870_P_NODE_26752_length_262_cov_1.629630_g26619_i0 | PRJNA596870 | 26752 | 262 | 1.62963 | 4.2696306 | Segetibacter sp. | 2231182 | Bacteria | Bacteria | 120 | 6.39e-33 | NR | MEJ7681046.1 | 2231182 | g26619 | i0 | 69 | 1.99236641221374 | 87 | 27 | 99.6 | 0 | 1 | 261 | 1 | 87 | MEJ7681046.1 hypothetical protein [Segetibacter sp.] | diamond | 522 | 120 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Segetibacter | Segetibacter sp. | |
| 30585196 | 30585196 | PRJNA596870_P_NODE_8573_length_426_cov_1.682720_g8440_i0 | PRJNA596870 | 8573 | 426 | 1.68272 | 7.1683872 | Gramella sp. MT6 | 2705471 | Bacteria | Bacteria | 45.8 | 0.0202 | NR | WP_219550722.1 | 2705471 | g8440 | i0 | 40.3 | 1.01408450704225 | 62 | 33 | 40.8 | 1 | 187 | 360 | 439 | 500 | WP_219550722.1 class I adenylate-forming enzyme family protein [Gramella sp. MT6] | diamond | 432 | 45.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Christiangramia | Gramella sp. MT6 | |
| 30679914 | 30679914 | PRJNA596870_P_NODE_28473_length_253_cov_1.711111_g28340_i0 | PRJNA596870 | 28473 | 253 | 1.711111 | 4.32911083 | Proteiniphilum acetatigenes | 294710 | Bacteria | Bacteria | 180 | 5.39e-52 | NR | WP_019541377.1 | 294710 | g28340 | i0 | 100 | 1.96837944664032 | 83 | 0 | 98.4 | 0 | 251 | 3 | 21 | 103 | WP_019541377.1 RagB/SusD family nutrient uptake outer membrane protein [Proteiniphilum acetatigenes] | diamond | 498 | 180 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Dysgonomonadaceae | Proteiniphilum | Proteiniphilum acetatigenes | |
| 30788302 | 30788302 | PRJNA596870_P_NODE_16894_length_321_cov_1.241935_g16761_i0 | PRJNA596870 | 16894 | 321 | 1.241935 | 3.98661135 | Prevotella | 838 | Bacteria | Bacteria | 44.3 | 0.0264 | NR | MCR5131956.1 | 59823 | g16761 | i0 | 41.5 | 2.74766355140187 | 53 | 28 | 47.7 | 2 | 152 | 304 | 226 | 277 | MCR5131956.1 glycoside hydrolase family 9 protein [Prevotella sp.] | diamond | 882 | 44.7 | 0.991051454138702 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Prevotella | Prevotella sp. | |
| 31185390 | 31185390 | PRJNA596870_P_NODE_32575_length_248_cov_0.880000_g32442_i0 | PRJNA596870 | 32575 | 248 | 0.88 | 2.1824 | Cytophagaceae bacterium | 2026729 | Bacteria | Bacteria | 45.4 | 0.00323 | NR | HSZ25010.1 | 2026729 | g32442 | i0 | 39.3 | 0.67741935483871 | 56 | 33 | 67.7 | 1 | 46 | 213 | 132 | 186 | HSZ25010.1 hypothetical protein [Cytophagaceae bacterium] | diamond | 168 | 45.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cytophagaceae | Cytophagaceae bacterium | ||
| 31438581 | 31438581 | PRJNA596870_P_NODE_33716_length_247_cov_0.885057_g33583_i0 | PRJNA596870 | 33716 | 247 | 0.885057 | 2.18609079 | Fibrella sp. GW2-5 | 3242487 | Bacteria | Bacteria | 50.1 | 1.08e-4 | NR | WP_370721328.1 | 3242487 | g33583 | i0 | 38.2 | 0.825910931174089 | 68 | 42 | 82.6 | 0 | 41 | 244 | 3514 | 3581 | WP_370721328.1 SdrD B-like domain-containing protein [Fibrella sp. GW2-5] | diamond | 204 | 50.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Spirosomataceae | Fibrella | Fibrella aquatica | |
| 31565405 | 31565405 | PRJNA596870_P_NODE_32136_length_248_cov_2.394286_g32003_i0 | PRJNA596870 | 32136 | 248 | 2.394286 | 5.93782928 | Paenimyroides marinum | 1159016 | Bacteria | Bacteria | 108 | 1.78e-25 | NR | WP_177165112.1 | 1159016 | g32003 | i0 | 62.5 | 0.967741935483871 | 80 | 29 | 96.8 | 1 | 4 | 243 | 42 | 120 | WP_177165112.1 GEVED domain-containing protein, partial [Paenimyroides marinum] | diamond | 240 | 108 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Paenimyroides | Paenimyroides marinum | |
| 31628412 | 31628412 | PRJNA596870_P_NODE_34596_length_246_cov_0.890173_g34463_i0 | PRJNA596870 | 34596 | 246 | 0.890173 | 2.18982558 | Flavobacterium sp. | 239 | Bacteria | Bacteria | 47.8 | 3.21e-4 | NR | WP_298138790.1 | 239 | g34463 | i0 | 45.1 | 1.46341463414634 | 51 | 28 | 62.2 | 0 | 157 | 5 | 29 | 79 | WP_298138790.1 ankyrin repeat domain-containing protein [Flavobacterium sp.] | diamond | 360 | 47.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. | |
| 31944600 | 31944600 | PRJNA596870_P_NODE_9537_length_407_cov_1.844311_g9404_i0 | PRJNA596870 | 9537 | 407 | 1.844311 | 7.50634577 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 132 | 9.81e-33 | NR | MFO7827122.1 | 2030927 | g9404 | i0 | 51.9 | 0.995085995085995 | 135 | 64 | 98.8 | 1 | 2 | 403 | 839 | 973 | MFO7827122.1 reverse transcriptase family protein [Bacteroidales bacterium] | diamond | 405 | 132 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 32071322 | 32071322 | PRJNA596870_P_NODE_38078_length_243_cov_0.905882_g37945_i0 | PRJNA596870 | 38078 | 243 | 0.905882 | 2.20129326 | uncultured Flavobacterium sp. | 165435 | Bacteria | Bacteria | 92.8 | 4.22e-21 | NR | WP_308130976.1 | 165435 | g37945 | i0 | 90.2 | 1.25925925925926 | 51 | 5 | 63 | 0 | 1 | 153 | 172 | 222 | WP_308130976.1 hypothetical protein [uncultured Flavobacterium sp.] | diamond | 306 | 92.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | uncultured Flavobacterium sp. | |
| 32166441 | 32166441 | PRJNA596870_P_NODE_37138_length_244_cov_0.900585_g37005_i0 | PRJNA596870 | 37138 | 244 | 0.900585 | 2.1974274 | Psychroflexus sp. | 1921580 | Bacteria | Bacteria | 53.5 | 6.05e-6 | NR | MFO7744505.1 | 1921580 | g37005 | i0 | 40.2 | 1.79508196721311 | 82 | 46 | 99.6 | 2 | 2 | 244 | 830 | 909 | MFO7744505.1 reverse transcriptase family protein [Psychroflexus sp.] | diamond | 438 | 53.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Psychroflexus | Psychroflexus sp. | |
| 32261467 | 32261467 | PRJNA596870_P_NODE_36218_length_245_cov_0.895349_g36085_i0 | PRJNA596870 | 36218 | 245 | 0.895349 | 2.19360505 | Psychroflexus sp. | 1921580 | Bacteria | Bacteria | 67.4 | 7.9e-11 | NR | MFO7744505.1 | 1921580 | g36085 | i0 | 40.8 | 0.930612244897959 | 76 | 42 | 91.8 | 2 | 2 | 226 | 816 | 889 | MFO7744505.1 reverse transcriptase family protein [Psychroflexus sp.] | diamond | 228 | 67.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Psychroflexus | Psychroflexus sp. | |
| 32293199 | 32293199 | PRJNA596870_P_NODE_23979_length_276_cov_2.201970_g23846_i0 | PRJNA596870 | 23979 | 276 | 2.20197 | 6.0774372 | Paraflavisolibacter caeni | 2982496 | Bacteria | Bacteria | 165 | 2.34e-49 | NR | WP_279295959.1 | 2982496 | g23846 | i0 | 89 | 0.989130434782609 | 91 | 10 | 98.9 | 0 | 275 | 3 | 76 | 166 | WP_279295959.1 rhomboid family intramembrane serine protease [Paraflavisolibacter caeni] | diamond | 273 | 165 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Paraflavisolibacter | Paraflavisolibacter caeni | |
| 32860898 | 32860898 | PRJNA596870_P_NODE_31420_length_249_cov_0.875000_g31287_i0 | PRJNA596870 | 31420 | 249 | 0.875 | 2.17875 | Alistipes intestinihominis | 3133172 | Bacteria | Bacteria | 164 | 3.55e-49 | NR | WP_349094085.1 | 3133172 | g31287 | i0 | 100 | 1 | 83 | 0 | 100 | 0 | 249 | 1 | 111 | 193 | WP_349094085.1 acyl carrier protein [Alistipes intestinihominis] | diamond | 249 | 164 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Rikenellaceae | Alistipes | Alistipes intestinihominis |
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);;