contig_metadata
7 rows where bioproject = "PRJNA1196438" and tax_phylum = "Lentisphaerota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14352523 | 14352523 | PRJNA1196438_P_NODE_70432_length_247_cov_0.896552_g70005_i0 | PRJNA1196438 | 70432 | 247 | 0.896552 | 2.21448344 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 100 | 9.66e-23 | NR | MBE6382667.1 | 1932692 | g70005 | i0 | 58.8 | 1.94331983805668 | 80 | 33 | 97.2 | 0 | 241 | 2 | 209 | 288 | MBE6382667.1 alkaline phosphatase [Lentisphaerota bacterium] | diamond | 480 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 27357119 | 27357119 | PRJNA1196438_P_NODE_61623_length_256_cov_1.344262_g61196_i0 | PRJNA1196438 | 61623 | 256 | 1.344262 | 3.44131072 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 55.1 | 5.7e-7 | NR | MDT8391404.1 | 2053569 | g61196 | i0 | 41.1 | 1.0546875 | 90 | 45 | 98.4 | 3 | 2 | 253 | 42 | 129 | MDT8391404.1 biotin/lipoyl-containing protein [Lentisphaeria bacterium] | diamond | 270 | 55.1 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 28304186 | 28304186 | PRJNA1196438_P_NODE_56406_length_263_cov_3.068421_g55979_i0 | PRJNA1196438 | 56406 | 263 | 3.068421 | 8.06994723 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 69.7 | 1.54e-11 | NR | MBR7145007.1 | 2053569 | g55979 | i0 | 40.5 | 0.958174904942966 | 84 | 49 | 94.7 | 1 | 258 | 10 | 190 | 273 | MBR7145007.1 beta-galactosidase [Lentisphaeria bacterium] | diamond | 252 | 69.7 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 29125412 | 29125412 | PRJNA1196438_P_NODE_46309_length_279_cov_1.509709_g45882_i0 | PRJNA1196438 | 46309 | 279 | 1.509709 | 4.21208811 | Victivallis vadensis | 172901 | Bacteria | Bacteria | 44.7 | 0.00794 | NR | WP_168961273.1 | 172901 | g45882 | i0 | 41.5 | 0.881720430107527 | 82 | 38 | 88.2 | 5 | 29 | 274 | 16 | 87 | WP_168961273.1 hypothetical protein [Victivallis vadensis] | diamond | 246 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Victivallales | Victivallaceae | Victivallis | Victivallis vadensis | |
| 29883104 | 29883104 | PRJNA1196438_P_NODE_20711_length_312_cov_2.933054_g20285_i0 | PRJNA1196438 | 20711 | 312 | 2.933054 | 9.15112848 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 56.2 | 1.41e-6 | NR | NLN02221.1 | 1932692 | g20285 | i0 | 57.4 | 1.39423076923077 | 47 | 20 | 45.2 | 0 | 170 | 310 | 117 | 163 | NLN02221.1 ATP-binding protein [Lentisphaerota bacterium] | diamond | 435 | 56.2 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 30325822 | 30325822 | PRJNA1196438_P_NODE_80012_length_234_cov_2.378882_g79585_i0 | PRJNA1196438 | 80012 | 234 | 2.378882 | 5.56658388 | Victivallales bacterium | 2212475 | Bacteria | Bacteria | 119 | 6.68e-30 | NR | MBQ9368782.1 | 2212475 | g79585 | i0 | 74 | 0.987179487179487 | 77 | 20 | 98.7 | 0 | 4 | 234 | 305 | 381 | MBQ9368782.1 protease modulator HflK [Victivallales bacterium] | diamond | 231 | 119 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Victivallales | Victivallales bacterium | |||
| 31558084 | 31558084 | PRJNA1196438_P_NODE_71776_length_246_cov_0.884393_g71349_i0 | PRJNA1196438 | 71776 | 246 | 0.884393 | 2.17560678 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 107 | 1.58e-25 | NR | MCI6288833.1 | 2053569 | g71349 | i0 | 56.8 | 1.97560975609756 | 81 | 35 | 98.8 | 0 | 2 | 244 | 104 | 184 | MCI6288833.1 YibE/F family protein [Lentisphaeria bacterium] | diamond | 486 | 107 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria 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);;