contig_metadata
9 rows where bioproject = "PRJNA611476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3140206 | 3140206 | PRJNA611476_P_NODE_28583_length_383_cov_1.490323_g27792_i0 | PRJNA611476 | 28583 | 383 | 1.490323 | 5.70793709 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 157 | 2.55e-44 | NR | WP_007279063.1 | 256847 | g27792 | i0 | 57.8 | 16.0417754569191 | 128 | 53 | 99.5 | 1 | 383 | 3 | 61 | 188 | WP_007279063.1 NADPH-dependent aldehyde reductase Ahr [Lentisphaera araneosa] | diamond | 6144 | 157 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaerales | Lentisphaeraceae | Lentisphaera | Lentisphaera araneosa | |
| 13343589 | 13343589 | PRJNA611476_P_NODE_4111_length_961_cov_1.925676_g3423_i0 | PRJNA611476 | 4111 | 961 | 1.925676 | 18.50574636 | Bacteria | 2 | Bacteria | Bacteria | 231 | 6.05e-72 | NR | MBM4165188.1 | 1932692 | g3423 | i0 | 61.6 | 9.33402705515088 | 198 | 72 | 61.5 | 3 | 15 | 605 | 3 | 197 | MBM4165188.1 UDP-glucose 4-epimerase GalE [Lentisphaerota bacterium] | diamond | 8970 | 232 | 0.995689655172414 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 26700181 | 26700181 | PRJNA611476_P_NODE_66661_length_273_cov_1.155000_g65870_i0 | PRJNA611476 | 66661 | 273 | 1.155 | 3.15315 | Victivallis lenta | 2606640 | Bacteria | Bacteria | 70.1 | 1.25e-11 | NR | WP_154418082.1 | 2606640 | g65870 | i0 | 36.3 | 1.74725274725275 | 80 | 51 | 87.9 | 0 | 241 | 2 | 202 | 281 | WP_154418082.1 polysaccharide lyase family 8 super-sandwich domain-containing protein [Victivallis lenta] | diamond | 477 | 70.1 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Victivallales | Victivallaceae | Victivallis | Victivallis lenta | |
| 26859006 | 26859006 | PRJNA611476_P_NODE_111901_length_242_cov_0.911243_g111110_i0 | PRJNA611476 | 111901 | 242 | 0.911243 | 2.20520806 | Lentisphaerae bacterium GWF2_57_35 | 1798576 | Bacteria | Bacteria | 97.4 | 2.1e-21 | NR | OGV42698.1 | 1798576 | g111110 | i0 | 56.3 | 5.9504132231405 | 80 | 35 | 99.2 | 0 | 3 | 242 | 625 | 704 | OGV42698.1 MAG: glycosyl transferase family 1 [Lentisphaerae bacterium GWF2_57_35] | diamond | 1440 | 97.4 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerae bacterium GWF2_57_35 | |||||
| 27807007 | 27807007 | PRJNA611476_P_NODE_89684_length_248_cov_0.880000_g88893_i0 | PRJNA611476 | 89684 | 248 | 0.88 | 2.1824 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 120 | 7.61e-33 | NR | MBR4956580.1 | 2053569 | g88893 | i0 | 83.3 | 2.39516129032258 | 66 | 11 | 79.8 | 0 | 198 | 1 | 1 | 66 | MBR4956580.1 (deoxy)nucleoside triphosphate pyrophosphohydrolase [Lentisphaeria bacterium] | diamond | 594 | 120 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 29732553 | 29732553 | PRJNA611476_P_NODE_82250_length_250_cov_0.870056_g81459_i0 | PRJNA611476 | 82250 | 250 | 0.870056 | 2.17514 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 45.8 | 0.00282 | NR | NLF22400.1 | 1932692 | g81459 | i0 | 39.7 | 0.936 | 78 | 41 | 93.6 | 2 | 1 | 234 | 171 | 242 | NLF22400.1 sulfatase-like hydrolase/transferase [Lentisphaerota bacterium] | diamond | 234 | 45.8 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 30270049 | 30270049 | PRJNA611476_P_NODE_66132_length_274_cov_1.149254_g65341_i0 | PRJNA611476 | 66132 | 274 | 1.149254 | 3.14895596 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 57 | 2.74e-8 | NR | MCJ8330523.1 | 2053569 | g65341 | i0 | 51 | 1.37956204379562 | 49 | 24 | 53.6 | 0 | 192 | 46 | 4 | 52 | MCJ8330523.1 hypothetical protein [Lentisphaeria bacterium] | diamond | 378 | 57 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 31944941 | 31944941 | PRJNA611476_P_NODE_110597_length_243_cov_0.905882_g109806_i0 | PRJNA611476 | 110597 | 243 | 0.905882 | 2.20129326 | Oligosphaeraceae bacterium | 2699751 | Bacteria | Bacteria | 96.7 | 1.76e-21 | NR | NMA43828.1 | 2699751 | g109806 | i0 | 54.5 | 2.87654320987654 | 77 | 35 | 95.1 | 0 | 235 | 5 | 63 | 139 | NMA43828.1 acetate kinase [Oligosphaeraceae bacterium] | diamond | 699 | 96.7 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Oligosphaeria | Oligosphaerales | Oligosphaeraceae | Oligosphaeraceae bacterium | ||
| 32388060 | 32388060 | PRJNA611476_P_NODE_11699_length_571_cov_2.371486_g10912_i0 | PRJNA611476 | 11699 | 571 | 2.371486 | 13.54118506 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 81.6 | 1.01e-14 | NR | MBM4165165.1 | 1932692 | g10912 | i0 | 38.7 | 1.57092819614711 | 150 | 70 | 78.8 | 4 | 5 | 454 | 176 | 303 | MBM4165165.1 SDR family oxidoreductase [Lentisphaerota bacterium] | diamond | 897 | 81.6 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota 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);;