contig_metadata
29 rows where analysis = "diamond", bioproject = "PRJNA352610" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26631625 | 26631625 | PRJNA352610_P_NODE_10181_length_366_cov_1.348123_g10120_i0 | PRJNA352610 | 10181 | 366 | 1.348123 | 4.93413018 | Bacteroidetes bacterium CG2_3 | 1898104 | Bacteria | Bacteria | 45.4 | 0.0126 | NR | OIP01831.1 | 1805033 | g10120 | i0 | 35.2 | 0.581967213114754 | 71 | 37 | 58.2 | 2 | 2 | 214 | 159 | 220 | OIP01831.1 MAG: hypothetical protein AUJ98_02960 [Bacteroidetes bacterium CG2_30_33_31] | diamond | 213 | 45.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidetes bacterium CG2_30_33_31 | |||||
| 26790058 | 26790058 | PRJNA352610_P_NODE_23181_length_261_cov_1.515957_g23120_i0 | PRJNA352610 | 23181 | 261 | 1.515957 | 3.95664777 | Niastella vici | 1703345 | Bacteria | Bacteria | 74.7 | 1.56e-13 | NR | WP_081146969.1 | 1703345 | g23120 | i0 | 46.3 | 2.89655172413793 | 80 | 34 | 92 | 1 | 21 | 260 | 229 | 299 | WP_081146969.1 pectinesterase family protein [Niastella vici] | diamond | 756 | 74.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Niastella | Niastella vici | |
| 26902297 | 26902297 | PRJNA352610_P_NODE_23041_length_262_cov_1.275132_g22980_i0 | PRJNA352610 | 23041 | 262 | 1.275132 | 3.34084584 | FCB group | 1783270 | Bacteria | Bacteria | 90.9 | 1.86e-20 | NR | MFT5138642.1 | 2306054 | g22980 | i0 | 63.1 | 2.23282442748092 | 65 | 24 | 74.4 | 0 | 246 | 52 | 133 | 197 | MFT5138642.1 ribonuclease HII [Rhodothermales bacterium] | diamond | 585 | 91.3 | 0.995618838992333 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermales bacterium | |||
| 26916597 | 26916597 | PRJNA352610_P_NODE_28022_length_247_cov_0.885057_g27961_i0 | PRJNA352610 | 28022 | 247 | 0.885057 | 2.18609079 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 88.6 | 7.58e-19 | NR | MBM3417397.1 | 1898104 | g27961 | i0 | 75.4 | 0.692307692307692 | 57 | 14 | 69.2 | 0 | 171 | 1 | 21 | 77 | MBM3417397.1 hypothetical protein [Bacteroidota bacterium] | diamond | 171 | 88.6 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 26933750 | 26933750 | PRJNA352610_P_NODE_882_length_897_cov_1.367718_g843_i0 | PRJNA352610 | 882 | 897 | 1.367718 | 12.26843046 | Chryseobacterium | 59732 | Bacteria | Bacteria | 150 | 5.95e-39 | NR | WP_027386695.1 | 456299 | g843 | i0 | 34.8 | 2.67224080267559 | 273 | 167 | 90.3 | 7 | 5 | 814 | 46 | 310 | WP_027386695.1 RNA ligase, Rnl2 family [Chryseobacterium gregarium] | diamond | 2397 | 150 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium gregarium | |
| 27517182 | 27517182 | PRJNA352610_P_NODE_30343_length_243_cov_0.905882_g30282_i0 | PRJNA352610 | 30343 | 243 | 0.905882 | 2.20129326 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 107 | 3.5e-26 | NR | MBL52157.1 | 2026760 | g30282 | i0 | 62 | 1.95061728395062 | 79 | 30 | 97.5 | 0 | 238 | 2 | 157 | 235 | MBL52157.1 amidohydrolase [Fidelibacterota bacterium] | diamond | 474 | 107 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 28464529 | 28464529 | PRJNA352610_P_NODE_31986_length_241_cov_0.916667_g31925_i0 | PRJNA352610 | 31986 | 241 | 0.916667 | 2.20916747 | Chitinophagales bacterium | 2448779 | Bacteria | Bacteria | 56.6 | 4.9e-7 | NR | MDX2003532.1 | 2448779 | g31925 | i0 | 44 | 0.933609958506224 | 75 | 41 | 92.1 | 1 | 223 | 2 | 12 | 86 | MDX2003532.1 gliding motility-associated C-terminal domain-containing protein [Chitinophagales bacterium] | diamond | 225 | 56.6 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagales bacterium | |||
| 28653865 | 28653865 | PRJNA352610_P_NODE_6187_length_442_cov_1.065041_g6126_i0 | PRJNA352610 | 6187 | 442 | 1.065041 | 4.70748122 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 58.9 | 7.3e-7 | NR | MFO7827238.1 | 2030927 | g6126 | i0 | 37 | 0.495475113122172 | 73 | 46 | 49.5 | 0 | 1 | 219 | 854 | 926 | MFO7827238.1 reverse transcriptase domain-containing protein [Bacteroidales bacterium] | diamond | 219 | 58.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 28717059 | 28717059 | PRJNA352610_P_NODE_27987_length_247_cov_0.885057_g27926_i0 | PRJNA352610 | 27987 | 247 | 0.885057 | 2.18609079 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 169 | 1.69e-46 | NR | MFO7827122.1 | 2030927 | g27926 | i0 | 97.5 | 0.983805668016194 | 81 | 2 | 98.4 | 0 | 245 | 3 | 279 | 359 | MFO7827122.1 reverse transcriptase family protein [Bacteroidales bacterium] | diamond | 243 | 169 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 28843106 | 28843106 | PRJNA352610_P_NODE_31648_length_241_cov_0.916667_g31587_i0 | PRJNA352610 | 31648 | 241 | 0.916667 | 2.20916747 | Bacteroidia bacterium | 2044936 | Bacteria | Bacteria | 115 | 1.13e-28 | NR | NCB97227.1 | 2044936 | g31587 | i0 | 63.8 | 0.995850622406639 | 80 | 29 | 99.6 | 0 | 241 | 2 | 298 | 377 | NCB97227.1 phosphoribosylformylglycinamidine cyclo-ligase [Bacteroidia bacterium] | diamond | 240 | 115 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidia bacterium | ||||
| 28923451 | 28923451 | PRJNA352610_P_NODE_16048_length_308_cov_1.025532_g15987_i0 | PRJNA352610 | 16048 | 308 | 1.025532 | 3.15863856 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 125 | 6.149999999999999e-31 | NR | MES2728259.1 | 1898104 | g15987 | i0 | 57.9 | 7.28571428571429 | 95 | 40 | 92.5 | 0 | 286 | 2 | 465 | 559 | MES2728259.1 M13 family metallopeptidase [Bacteroidota bacterium] | diamond | 2244 | 126 | 0.992063492063492 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 29569397 | 29569397 | PRJNA352610_P_NODE_32010_length_241_cov_0.916667_g31949_i0 | PRJNA352610 | 32010 | 241 | 0.916667 | 2.20916747 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 49.3 | 1.67e-4 | NR | MEY4861303.1 | 1898104 | g31949 | i0 | 29.4 | 1.65560165975104 | 68 | 48 | 84.6 | 0 | 236 | 33 | 13 | 80 | MEY4861303.1 hypothetical protein [Bacteroidota bacterium] | diamond | 399 | 49.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 30043109 | 30043109 | PRJNA352610_P_NODE_15751_length_310_cov_2.139241_g15690_i0 | PRJNA352610 | 15751 | 310 | 2.139241 | 6.6316471 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 43.5 | 0.0432 | NR | MEI7626964.1 | 1898104 | g15690 | i0 | 40.7 | 0.570967741935484 | 59 | 35 | 57.1 | 0 | 210 | 34 | 106 | 164 | MEI7626964.1 S8 family peptidase [Bacteroidota bacterium] | diamond | 177 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 30454195 | 30454195 | PRJNA352610_P_NODE_27293_length_248_cov_0.880000_g27232_i0 | PRJNA352610 | 27293 | 248 | 0.88 | 2.1824 | Psychroflexus sp. | 1921580 | Bacteria | Bacteria | 168 | 3.01e-46 | NR | MFO7744505.1 | 1921580 | g27232 | i0 | 98.8 | 0.991935483870968 | 82 | 1 | 99.2 | 0 | 1 | 246 | 251 | 332 | MFO7744505.1 reverse transcriptase family protein [Psychroflexus sp.] | diamond | 246 | 168 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Psychroflexus | Psychroflexus sp. | |
| 30738181 | 30738181 | PRJNA352610_P_NODE_25734_length_250_cov_0.870056_g25673_i0 | PRJNA352610 | 25734 | 250 | 0.870056 | 2.17514 | Sphingobacteriales bacterium | 2044944 | Bacteria | Bacteria | 41.6 | 0.0422 | NR | RYE56219.1 | 2044944 | g25673 | i0 | 41.3 | 0.552 | 46 | 27 | 55.2 | 0 | 1 | 138 | 73 | 118 | RYE56219.1 MAG: hypothetical protein EOP48_08505 [Sphingobacteriales bacterium] | diamond | 138 | 41.6 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriales bacterium | |||
| 30738187 | 30738187 | PRJNA352610_P_NODE_29874_length_244_cov_0.900585_g29813_i0 | PRJNA352610 | 29874 | 244 | 0.900585 | 2.1974274 | Bacteroidia bacterium | 2044936 | Bacteria | Bacteria | 42.7 | 0.0324 | NR | MEZ4685224.1 | 2044936 | g29813 | i0 | 36.3 | 0.983606557377049 | 80 | 47 | 98.4 | 2 | 244 | 5 | 143 | 218 | MEZ4685224.1 hypothetical protein [Bacteroidia bacterium] | diamond | 240 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidia bacterium | ||||
| 30896421 | 30896421 | PRJNA352610_P_NODE_21054_length_274_cov_1.348259_g20993_i0 | PRJNA352610 | 21054 | 274 | 1.348259 | 3.69422966 | Alistipes sp. | 1872444 | Bacteria | Bacteria | 72.4 | 1.93e-12 | NR | MBQ5738490.1 | 1872444 | g20993 | i0 | 46.3 | 0.897810218978102 | 82 | 40 | 89.8 | 1 | 260 | 15 | 343 | 420 | MBQ5738490.1 family 20 glycosylhydrolase [Alistipes sp.] | diamond | 246 | 72.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Rikenellaceae | Alistipes | Alistipes sp. | |
| 31180280 | 31180280 | PRJNA352610_P_NODE_14695_length_319_cov_0.983740_g14634_i0 | PRJNA352610 | 14695 | 319 | 0.98374 | 3.1381306 | Mucilaginibacter sp. FT3.2 | 2723090 | Bacteria | Bacteria | 63.2 | 5.59e-9 | NR | WP_184547870.1 | 2723090 | g14634 | i0 | 42.3 | 0.978056426332288 | 104 | 48 | 90.3 | 6 | 290 | 3 | 36 | 135 | WP_184547870.1 glycoside hydrolase family 28 protein [Mucilaginibacter sp. FT3.2] | diamond | 312 | 63.2 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Mucilaginibacter | Mucilaginibacter sp. FT3.2 | |
| 31243778 | 31243778 | PRJNA352610_P_NODE_12415_length_340_cov_0.865169_g12354_i0 | PRJNA352610 | 12415 | 340 | 0.865169 | 2.9415746 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 64.7 | 7.44e-10 | NR | MBE2255103.1 | 2053306 | g12354 | i0 | 35.1 | 1.87058823529412 | 111 | 67 | 97.9 | 3 | 339 | 7 | 85 | 190 | MBE2255103.1 class I SAM-dependent methyltransferase [Ignavibacteria bacterium] | diamond | 636 | 64.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 31654882 | 31654882 | PRJNA352610_P_NODE_3417_length_553_cov_1.037500_g3356_i0 | PRJNA352610 | 3417 | 553 | 1.0375 | 5.737375 | Chloroherpetonaceae bacterium | 2969135 | Bacteria | Bacteria | 292 | 3.17e-98 | NR | MDX2130223.1 | 2969135 | g3356 | i0 | 76.6 | 0.927667269439421 | 171 | 40 | 92.8 | 0 | 3 | 515 | 34 | 204 | MDX2130223.1 Fe-Mn family superoxide dismutase [Chloroherpetonaceae bacterium] | diamond | 513 | 292 | 1 | Bacteria | FCB group | Pseudomonadati | Chlorobiota | Chlorobiia | Chlorobiales | Chloroherpetonaceae | Chloroherpetonaceae bacterium | ||
| 31781393 | 31781393 | PRJNA352610_P_NODE_26897_length_248_cov_1.548571_g26836_i0 | PRJNA352610 | 26897 | 248 | 1.548571 | 3.84045608 | Fibrobacter sp. | 35828 | Bacteria | Bacteria | 44.3 | 0.0113 | NR | MBP5246380.1 | 35828 | g26836 | i0 | 48.8 | 1.41532258064516 | 43 | 21 | 50.8 | 1 | 155 | 30 | 440 | 482 | MBP5246380.1 endo-1,4-beta-xylanase [Fibrobacter sp.] | diamond | 351 | 44.3 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 31844722 | 31844722 | PRJNA352610_P_NODE_29157_length_245_cov_0.895349_g29096_i0 | PRJNA352610 | 29157 | 245 | 0.895349 | 2.19360505 | Dyadobacter sp. | 1914288 | Bacteria | Bacteria | 45.4 | 0.00274 | NR | WP_348073938.1 | 1914288 | g29096 | i0 | 34.2 | 0.96734693877551 | 79 | 50 | 94.3 | 1 | 4 | 234 | 46 | 124 | WP_348073938.1 cupin domain-containing protein [Dyadobacter sp.] | diamond | 237 | 45.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Spirosomataceae | Dyadobacter | Dyadobacter sp. | |
| 31908071 | 31908071 | PRJNA352610_P_NODE_23037_length_262_cov_1.317460_g22976_i0 | PRJNA352610 | 23037 | 262 | 1.31746 | 3.4517452 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 42.7 | 0.0444 | NR | HKJ03699.1 | 2910168 | g22976 | i0 | 45.9 | 0.698473282442748 | 61 | 32 | 68.7 | 1 | 6 | 185 | 215 | 275 | HKJ03699.1 3-phosphoshikimate 1-carboxyvinyltransferase [Longimicrobiales bacterium] | diamond | 183 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 32097898 | 32097898 | PRJNA352610_P_NODE_9638_length_374_cov_1.112957_g9577_i0 | PRJNA352610 | 9638 | 374 | 1.112957 | 4.16245918 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 45.1 | 0.0246 | NR | MBN2173308.1 | 2030927 | g9577 | i0 | 40.4 | 0.417112299465241 | 52 | 26 | 37.7 | 2 | 354 | 214 | 158 | 209 | MBN2173308.1 PAN domain-containing protein [Bacteroidales bacterium] | diamond | 156 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 32146815 | 32146815 | PRJNA352610_P_NODE_18878_length_288_cov_1.018605_g18817_i0 | PRJNA352610 | 18878 | 288 | 1.018605 | 2.9335824 | Cyclobacteriaceae | 563798 | Bacteria | Bacteria | 43.5 | 0.0237 | NR | WP_009035554.1 | 579922 | g18817 | i0 | 41 | 1.27083333333333 | 61 | 35 | 62.5 | 1 | 79 | 258 | 7 | 67 | WP_009035554.1 hypothetical protein [Indibacter alkaliphilus] | diamond | 366 | 43.9 | 0.990888382687927 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cyclobacteriaceae | Indibacter | Indibacter alkaliphilus | |
| 32351261 | 32351261 | PRJNA352610_P_NODE_28799_length_246_cov_0.890173_g28738_i0 | PRJNA352610 | 28799 | 246 | 0.890173 | 2.18982558 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 40.8 | 0.0421 | NR | MBO4537181.1 | 2030927 | g28738 | i0 | 34 | 0.646341463414634 | 53 | 34 | 64.6 | 1 | 12 | 170 | 31 | 82 | MBO4537181.1 hypothetical protein [Bacteroidales bacterium] | diamond | 159 | 40.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 32414462 | 32414462 | PRJNA352610_P_NODE_18959_length_287_cov_1.420561_g18898_i0 | PRJNA352610 | 18959 | 287 | 1.420561 | 4.07701007 | Mesoflavibacter sp. | 1930902 | Bacteria | Bacteria | 67.4 | 1.3099999999999999e-10 | NR | MCP4053575.1 | 1930902 | g18898 | i0 | 40.4 | 2.90592334494774 | 94 | 41 | 98.3 | 1 | 284 | 3 | 417 | 495 | MCP4053575.1 reverse transcriptase family protein [Mesoflavibacter sp.] | diamond | 834 | 67.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Mesoflavibacter | Mesoflavibacter sp. | |
| 32446219 | 32446219 | PRJNA352610_P_NODE_21179_length_273_cov_1.880000_g21118_i0 | PRJNA352610 | 21179 | 273 | 1.88 | 5.1324 | Candidatus Symbiothrix dinenymphae | 467085 | Bacteria | Bacteria | 43.5 | 0.0263 | NR | WP_082592097.1 | 467085 | g21118 | i0 | 32.2 | 0.956043956043956 | 87 | 54 | 91.2 | 3 | 21 | 269 | 177 | 262 | WP_082592097.1 sugar phosphate isomerase/epimerase family protein [Candidatus Symbiothrix dinenymphae] | diamond | 261 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Candidatus Symbiothrix | Candidatus Symbiothrix dinenymphae | ||
| 32761425 | 32761425 | PRJNA352610_P_NODE_26780_length_249_cov_0.875000_g26719_i0 | PRJNA352610 | 26780 | 249 | 0.875 | 2.17875 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 53.1 | 8.21e-6 | NR | HOZ47120.1 | 2030809 | g26719 | i0 | 34.9 | 1.03614457831325 | 86 | 51 | 97.6 | 1 | 245 | 3 | 241 | 326 | HOZ47120.1 NHL repeat-containing protein [Candidatus Hydrogenedentota bacterium] | diamond | 258 | 53.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota 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);;