contig_metadata
9 rows where bioproject = "PRJNA610520" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1864513 | 1864513 | PRJNA610520_S_NODE_71142_length_231_cov_2.063291_g71052_i0 | PRJNA610520 | 71142 | 231 | 2.063291 | 4.76620221 | Flavobacterium sp. Sr18 | 935222 | Bacteria | Bacteria | 427 | 2.9399999999999998e-115 | NTclustered | gi|1818223938|gb|CP049329.1| | 935222 | g71052 | i0 | 100 | 100.220779220779 | 231 | 0 | 100 | 0 | 1 | 231 | 2672238 | 2672468 | Flavobacterium sp. Sr18 chromosome, complete genome | blastn | 23151 | 427 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. Sr18 | |
| 6966884 | 6966884 | PRJNA610520_S_NODE_71826_length_226_cov_3.143791_g71736_i0 | PRJNA610520 | 71826 | 226 | 3.143791 | 7.10496766 | Flavobacterium sp. Sr18 | 935222 | Bacteria | Bacteria | 407 | 3.73e-109 | NTclustered | gi|1818223938|gb|CP049329.1| | 935222 | g71736 | i0 | 99.115 | 1 | 226 | 2 | 100 | 0 | 1 | 226 | 1679428 | 1679203 | Flavobacterium sp. Sr18 chromosome, complete genome | blastn | 226 | 407 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. Sr18 | |
| 8241427 | 8241427 | PRJNA610520_S_NODE_29147_length_326_cov_1.545455_g29057_i0 | PRJNA610520 | 29147 | 326 | 1.545455 | 5.0381833 | Flavobacterium sp. Sr18 | 935222 | Bacteria | Bacteria | 575 | 1.4699999999999996e-159 | NTclustered | gi|1818223938|gb|CP049329.1| | 935222 | g29057 | i0 | 98.466 | 99.6840490797546 | 326 | 5 | 100 | 0 | 1 | 326 | 2665418 | 2665093 | Flavobacterium sp. Sr18 chromosome, complete genome | blastn | 32497 | 575 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. Sr18 | |
| 22824756 | 22824756 | PRJNA610520_S_NODE_26678_length_334_cov_1.475096_g26588_i0 | PRJNA610520 | 26678 | 334 | 1.475096 | 4.92682064 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 68.2 | 1.27e-11 | NR | MCE3279722.1 | 1898104 | g26588 | i0 | 39.8 | 0.745508982035928 | 83 | 42 | 67.4 | 1 | 330 | 106 | 75 | 157 | MCE3279722.1 ribosomal protein [Bacteroidota bacterium] | diamond | 249 | 68.2 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 27819969 | 27819969 | PRJNA610520_S_NODE_52504_length_267_cov_1.865979_g52414_i0 | PRJNA610520 | 52504 | 267 | 1.865979 | 4.98216393 | Bacteroidota | 976 | Bacteria | Bacteria | 44.3 | 0.0132 | NR | HYF29897.1 | 1869212 | g52414 | i0 | 60.7 | 1.25842696629213 | 28 | 11 | 31.5 | 0 | 263 | 180 | 299 | 326 | HYF29897.1 ADP-glyceromanno-heptose 6-epimerase [Chitinophagaceae bacterium] | diamond | 336 | 44.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 27996221 | 27996221 | PRJNA610520_S_NODE_42865_length_288_cov_1.702326_g42775_i0 | PRJNA610520 | 42865 | 288 | 1.702326 | 4.90269888 | Flavobacterium sp. | 239 | Bacteria | Bacteria | 175 | 5.309999999999999e-54 | NR | HEY4628803.1 | 239 | g42775 | i0 | 93.8 | 1 | 96 | 6 | 100 | 0 | 288 | 1 | 60 | 155 | HEY4628803.1 RNA polymerase sigma factor [Flavobacterium sp.] | diamond | 288 | 175 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. | |
| 28546267 | 28546267 | PRJNA610520_S_NODE_55927_length_260_cov_2.679144_g55837_i0 | PRJNA610520 | 55927 | 260 | 2.679144 | 6.9657744 | root | 1 | Root_unresolved | Root_unresolved | 50.4 | 1.65e-5 | NR | WP_337580933.1 | 454154 | g55837 | i0 | 52.8 | 4.21153846153846 | 53 | 20 | 61.2 | 1 | 258 | 100 | 67 | 114 | WP_337580933.1 ubiquitin-like protein [Paraprevotella clara] | diamond | 1095 | 50.8 | 0.992125984251969 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Paraprevotella | Paraprevotella clara | |
| 29795679 | 29795679 | PRJNA610520_S_NODE_43511_length_286_cov_3.530516_g43421_i0 | PRJNA610520 | 43511 | 286 | 3.530516 | 10.09727576 | Flavimarina sp. Hel_I_48 | 1392488 | Bacteria | Bacteria | 65.1 | 4.85e-10 | NR | WP_031426029.1 | 1392488 | g43421 | i0 | 50.8 | 2.13986013986014 | 65 | 31 | 68.2 | 1 | 35 | 229 | 187 | 250 | WP_031426029.1 DNA/RNA non-specific endonuclease [Flavimarina sp. Hel_I_48] | diamond | 612 | 65.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavimarina | Flavimarina sp. Hel_I_48 | |
| 30933295 | 30933295 | PRJNA610520_S_NODE_20654_length_356_cov_7.526502_g20564_i0 | PRJNA610520 | 20654 | 356 | 7.526502 | 26.79434712 | Crocinitomix catalasitica | 184607 | Bacteria | Bacteria | 48.5 | 0.00113 | NR | WP_035844478.1 | 184607 | g20564 | i0 | 35.2 | 0.76685393258427 | 91 | 55 | 74.2 | 2 | 345 | 82 | 91 | 180 | WP_035844478.1 trypsin-like peptidase domain-containing protein [Crocinitomix catalasitica] | diamond | 273 | 48.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Crocinitomicaceae | Crocinitomix | Crocinitomix catalasitica |
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);;