contig_metadata
13 rows where bioproject = "PRJEB83711", tax_clade = "FCB group" and tax_phylum = "Fibrobacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2694671 | 2694671 | PRJEB83711_P_NODE_65583_length_249_cov_0.886364_g65317_i0 | PRJEB83711 | 65583 | 249 | 0.886364 | 2.20704636 | Fibrobacteraceae bacterium | 2652288 | Bacteria | Bacteria | 166 | 1.22e-46 | NR | MFA6624007.1 | 2652288 | g65317 | i0 | 100 | 0.987951807228916 | 82 | 0 | 98.8 | 0 | 2 | 247 | 330 | 411 | MFA6624007.1 homoserine O-acetyltransferase [Fibrobacteraceae bacterium] | diamond | 246 | 166 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacteraceae bacterium | ||
| 10346671 | 10346671 | PRJEB83711_P_NODE_27909_length_338_cov_1.177358_g27643_i0 | PRJEB83711 | 27909 | 338 | 1.177358 | 3.97947004 | Fibrobacteraceae bacterium | 2652288 | Bacteria | Bacteria | 201 | 6.21e-63 | NR | MFA6623748.1 | 2652288 | g27643 | i0 | 90.2 | 0.994082840236686 | 112 | 11 | 99.4 | 0 | 1 | 336 | 88 | 199 | MFA6623748.1 DNA translocase FtsK [Fibrobacteraceae bacterium] | diamond | 336 | 201 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacteraceae bacterium | ||
| 18850588 | 18850588 | PRJEB83711_P_NODE_74835_length_244_cov_0.912281_g74569_i0 | PRJEB83711 | 74835 | 244 | 0.912281 | 2.22596564 | Fibrobacteraceae bacterium | 2652288 | Bacteria | Bacteria | 168 | 2.58e-48 | NR | MFA6622777.1 | 2652288 | g74569 | i0 | 100 | 0.995901639344262 | 81 | 0 | 99.6 | 0 | 244 | 2 | 30 | 110 | MFA6622777.1 NADH-quinone oxidoreductase subunit NuoF [Fibrobacteraceae bacterium] | diamond | 243 | 168 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacteraceae bacterium | ||
| 26844715 | 26844715 | PRJEB83711_P_NODE_69501_length_247_cov_0.896552_g69235_i0 | PRJEB83711 | 69501 | 247 | 0.896552 | 2.21448344 | Fibrobacteraceae bacterium | 2652288 | Bacteria | Bacteria | 126 | 7.5099999999999985e-34 | NR | MFA6622827.1 | 2652288 | g69235 | i0 | 96.7 | 0.728744939271255 | 60 | 2 | 72.9 | 0 | 245 | 66 | 191 | 250 | MFA6622827.1 M23 family metallopeptidase [Fibrobacteraceae bacterium] | diamond | 180 | 126 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacteraceae bacterium | ||
| 26970928 | 26970928 | PRJEB83711_P_NODE_40802_length_287_cov_1.350467_g40536_i0 | PRJEB83711 | 40802 | 287 | 1.350467 | 3.87584029 | Fibrobacteraceae bacterium | 2652288 | Bacteria | Bacteria | 157 | 7.68e-46 | NR | MFA6623337.1 | 2652288 | g40536 | i0 | 87.2 | 0.982578397212544 | 94 | 12 | 98.3 | 0 | 1 | 282 | 140 | 233 | MFA6623337.1 hypothetical protein [Fibrobacteraceae bacterium] | diamond | 282 | 157 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacteraceae bacterium | ||
| 27413869 | 27413869 | PRJEB83711_P_NODE_77563_length_243_cov_0.870588_g77297_i0 | PRJEB83711 | 77563 | 243 | 0.870588 | 2.11552884 | Chitinispirillaceae bacterium | 2813024 | Bacteria | Bacteria | 62 | 5.89e-9 | NR | MBN1128288.1 | 2813024 | g77297 | i0 | 54.4 | 1.95061728395062 | 79 | 33 | 95.1 | 3 | 236 | 6 | 485 | 562 | MBN1128288.1 hypothetical protein [Chitinispirillaceae bacterium] | diamond | 474 | 62 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Chitinispirillia | Chitinispirillales | Chitinispirillaceae | Chitinispirillaceae bacterium | ||
| 27698153 | 27698153 | PRJEB83711_P_NODE_61084_length_251_cov_1.134831_g60818_i0 | PRJEB83711 | 61084 | 251 | 1.134831 | 2.84842581 | Fibrobacteraceae bacterium | 2652288 | Bacteria | Bacteria | 163 | 8.43e-46 | NR | MFA6623303.1 | 2652288 | g60818 | i0 | 91.6 | 0.99203187250996006 | 83 | 7 | 99.2 | 0 | 251 | 3 | 123 | 205 | MFA6623303.1 hypothetical protein [Fibrobacteraceae bacterium] | diamond | 249 | 163 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacteraceae bacterium | ||
| 28645101 | 28645101 | PRJEB83711_P_NODE_60367_length_252_cov_0.871508_g60101_i0 | PRJEB83711 | 60367 | 252 | 0.871508 | 2.19620016 | Fibrobacteraceae bacterium | 2652288 | Bacteria | Bacteria | 127 | 3.03e-33 | NR | MCK9181761.1 | 2652288 | g60101 | i0 | 72.8 | 0.964285714285714 | 81 | 22 | 96.4 | 0 | 251 | 9 | 225 | 305 | MCK9181761.1 hypothetical protein [Fibrobacteraceae bacterium] | diamond | 243 | 127 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacteraceae bacterium | ||
| 28858548 | 28858548 | PRJEB83711_P_NODE_63528_length_250_cov_0.881356_g63262_i0 | PRJEB83711 | 63528 | 250 | 0.881356 | 2.20339 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 76.6 | 4.73e-14 | NR | MBR2091580.1 | 35828 | g63262 | i0 | 55.9 | 1.356 | 59 | 26 | 70.8 | 0 | 177 | 1 | 2 | 60 | MBR2091580.1 DUF262 domain-containing protein [Fibrobacter sp.] | diamond | 339 | 77 | 0.994805194805195 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 31488294 | 31488294 | PRJEB83711_P_NODE_63796_length_250_cov_0.881356_g63530_i0 | PRJEB83711 | 63796 | 250 | 0.881356 | 2.20339 | Fibrobacter sp. | 35828 | Bacteria | Bacteria | 55.1 | 4.29e-7 | NR | MDY6285683.1 | 35828 | g63530 | i0 | 62.5 | 0.48 | 40 | 15 | 48 | 0 | 129 | 248 | 1 | 40 | MDY6285683.1 GtrA family protein [Fibrobacter sp.] | diamond | 120 | 55.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 32025861 | 32025861 | PRJEB83711_P_NODE_41598_length_285_cov_1.367925_g41332_i0 | PRJEB83711 | 41598 | 285 | 1.367925 | 3.89858625 | Fibrobacteraceae bacterium | 2652288 | Bacteria | Bacteria | 181 | 1.81e-53 | NR | MFA6623028.1 | 2652288 | g41332 | i0 | 95.7 | 0.989473684210526 | 94 | 4 | 98.9 | 0 | 3 | 284 | 79 | 172 | MFA6623028.1 penicillin-binding transpeptidase domain-containing protein [Fibrobacteraceae bacterium] | diamond | 282 | 181 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacteraceae bacterium | ||
| 32342461 | 32342461 | PRJEB83711_P_NODE_30319_length_326_cov_0.924901_g30053_i0 | PRJEB83711 | 30319 | 326 | 0.924901 | 3.01517726 | Fibrobacter succinogenes | 833 | Bacteria | Bacteria | 43.5 | 0.0492 | NR | WP_014545723.1 | 833 | g30053 | i0 | 33.8 | 0.680981595092024 | 74 | 45 | 67.2 | 2 | 221 | 3 | 352 | 422 | WP_014545723.1 O-antigen polymerase [Fibrobacter succinogenes] | diamond | 222 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter succinogenes | |
| 32563963 | 32563963 | PRJEB83711_P_NODE_59739_length_252_cov_0.871508_g59473_i0 | PRJEB83711 | 59739 | 252 | 0.871508 | 2.19620016 | Fibrobacteraceae bacterium | 2652288 | Bacteria | Bacteria | 149 | 3.909999999999999e-41 | NR | MFA6622806.1 | 2652288 | g59473 | i0 | 92.9 | 1 | 84 | 6 | 100 | 0 | 252 | 1 | 46 | 129 | MFA6622806.1 ABC transporter permease [Fibrobacteraceae bacterium] | diamond | 252 | 149 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacteraceae 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);;