contig_metadata
12 rows where bioproject = "PRJNA558770" and tax_phylum = "Candidatus Moraniibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27395159 | 27395159 | PRJNA558770_P_NODE_188243_length_234_cov_4.261307_g186238_i0 | PRJNA558770 | 188243 | 234 | 4.261307 | 9.97145838 | Candidatus Moraniibacteriota bacterium | 2045217 | Bacteria | Bacteria | 46.2 | 7.82e-4 | NR | QQR78330.1 | 2045217 | g186238 | i0 | 78.3 | 0.602564102564103 | 23 | 5 | 29.5 | 0 | 3 | 71 | 97 | 119 | QQR78330.1 MAG: HIT family protein [Candidatus Moraniibacteriota bacterium] | diamond | 141 | 46.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moraniibacteriota bacterium | ||||||
| 28198184 | 28198184 | PRJNA558770_P_NODE_238326_length_234_cov_2.582915_g236321_i0 | PRJNA558770 | 238326 | 234 | 2.582915 | 6.0440211 | Bacteria | 2 | Bacteria | Bacteria | 49.3 | 1.04e-4 | NR | OGI14402.1 | 1801637 | g236321 | i0 | 100 | 1.52564102564103 | 23 | 0 | 29.5 | 0 | 75 | 7 | 7 | 29 | OGI14402.1 MAG: 50S ribosomal protein L3 [Candidatus Moranbacteria bacterium RIFCSPHIGHO2_01_FULL_54_31] | diamond | 357 | 49.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moranbacteria bacterium RIFCSPHIGHO2_01_FULL_54_31 | ||||||
| 28310720 | 28310720 | PRJNA558770_P_NODE_211866_length_234_cov_3.351759_g209861_i0 | PRJNA558770 | 211866 | 234 | 3.351759 | 7.84311606 | Candidatus Moraniibacteriota bacterium | 2045217 | Bacteria | Bacteria | 45.1 | 0.0049 | NR | HOW60158.1 | 2045217 | g209861 | i0 | 79.2 | 0.871794871794872 | 24 | 5 | 30.8 | 0 | 5 | 76 | 151 | 174 | HOW60158.1 site-2 protease family protein [Candidatus Moraniibacteriota bacterium] | diamond | 204 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moraniibacteriota bacterium | ||||||
| 28594955 | 28594955 | PRJNA558770_P_NODE_319867_length_233_cov_8.939394_g317862_i0 | PRJNA558770 | 319867 | 233 | 8.939394 | 20.82878802 | Candidatus Moranbacteria bacterium GW2 | 1618703 | Bacteria | Bacteria | 74.7 | 1.54e-13 | NR | KKP97362.1 | 1618703 | g317862 | i0 | 50.6 | 2.18884120171674 | 85 | 34 | 99.1 | 1 | 232 | 2 | 245 | 329 | KKP97362.1 MAG: Tyrosine-tRNA ligase [Candidatus Moranbacteria bacterium GW2011_GWD2_36_12] | diamond | 510 | 74.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moranbacteria bacterium GW2011_GWD2_36_12 | ||||||
| 29082539 | 29082539 | PRJNA558770_P_NODE_224488_length_234_cov_2.959799_g222483_i0 | PRJNA558770 | 224488 | 234 | 2.959799 | 6.92592966 | Bacteria | 2 | Bacteria | Bacteria | 50.8 | 4.74e-5 | NR | OGI14098.1 | 1801637 | g222483 | i0 | 35.7 | 2.15384615384615 | 84 | 46 | 97.4 | 2 | 231 | 4 | 31 | 114 | OGI14098.1 MAG: penicillin-binding protein 2 [Candidatus Moranbacteria bacterium RIFCSPHIGHO2_01_FULL_54_31] | diamond | 504 | 51.2 | 0.9921875 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moranbacteria bacterium RIFCSPHIGHO2_01_FULL_54_31 | ||||||
| 30141649 | 30141649 | PRJNA558770_P_NODE_134952_length_234_cov_7.643216_g132947_i0 | PRJNA558770 | 134952 | 234 | 7.643216 | 17.88512544 | Candidatus Moraniibacteriota bacterium | 2045217 | Bacteria | Bacteria | 48.1 | 4.21e-4 | NR | NTV40662.1 | 2045217 | g132947 | i0 | 68 | 1.96153846153846 | 25 | 8 | 32.1 | 0 | 234 | 160 | 270 | 294 | NTV40662.1 hypothetical protein [Candidatus Moraniibacteriota bacterium] | diamond | 459 | 48.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moraniibacteriota bacterium | ||||||
| 30236869 | 30236869 | PRJNA558770_P_NODE_178672_length_234_cov_4.708543_g176667_i0 | PRJNA558770 | 178672 | 234 | 4.708543 | 11.01799062 | Candidatus Moraniibacteriota bacterium | 2045217 | Bacteria | Bacteria | 50.4 | 1.05e-5 | NR | HBI33800.1 | 2045217 | g176667 | i0 | 44.8 | 0.858974358974359 | 67 | 20 | 85.9 | 1 | 232 | 32 | 61 | 110 | HBI33800.1 hypothetical protein [Candidatus Moraniibacteriota bacterium] | diamond | 201 | 50.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moraniibacteriota bacterium | ||||||
| 30535249 | 30535249 | PRJNA558770_P_NODE_223093_length_234_cov_3.005025_g221088_i0 | PRJNA558770 | 223093 | 234 | 3.005025 | 7.0317585 | Bacteria | 2 | Bacteria | Bacteria | 49.7 | 7.89e-5 | NR | MEI7621729.1 | 2045217 | g221088 | i0 | 76.9 | 1 | 26 | 6 | 33.3 | 0 | 2 | 79 | 67 | 92 | MEI7621729.1 30S ribosomal protein S6 [Candidatus Moraniibacteriota bacterium] | diamond | 234 | 49.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moraniibacteriota bacterium | ||||||
| 30584240 | 30584240 | PRJNA558770_P_NODE_201133_length_234_cov_3.738693_g199128_i0 | PRJNA558770 | 201133 | 234 | 3.738693 | 8.74854162 | Candidatus Moraniibacteriota bacterium | 2045217 | Bacteria | Bacteria | 54.7 | 1.65e-7 | NR | MEI8104060.1 | 2045217 | g199128 | i0 | 100 | 1.53846153846154 | 24 | 0 | 30.8 | 0 | 74 | 3 | 24 | 47 | MEI8104060.1 septal ring lytic transglycosylase RlpA family protein [Candidatus Moraniibacteriota bacterium] | diamond | 360 | 54.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moraniibacteriota bacterium | ||||||
| 31247949 | 31247949 | PRJNA558770_P_NODE_235495_length_234_cov_2.653266_g233490_i0 | PRJNA558770 | 235495 | 234 | 2.653266 | 6.20864244 | Candidatus Moraniibacteriota bacterium | 2045217 | Bacteria | Bacteria | 82 | 2.46e-16 | NR | NTW27732.1 | 2045217 | g233490 | i0 | 58.4 | 4.92307692307692 | 77 | 10 | 98.7 | 1 | 232 | 2 | 210 | 264 | NTW27732.1 galactose-1-phosphate uridylyltransferase [Candidatus Moraniibacteriota bacterium] | diamond | 1152 | 82 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moraniibacteriota bacterium | ||||||
| 31736289 | 31736289 | PRJNA558770_P_NODE_160977_length_234_cov_5.698492_g158972_i0 | PRJNA558770 | 160977 | 234 | 5.698492 | 13.33447128 | Bacteria | 2 | Bacteria | Bacteria | 70.9 | 4.04e-12 | NR | PIR73567.1 | 1974671 | g158972 | i0 | 50 | 7 | 78 | 27 | 100 | 1 | 1 | 234 | 164 | 229 | PIR73567.1 MAG: UDP-N-acetylmuramate--L-alanine ligase [Candidatus Moranbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_35_21] | diamond | 1638 | 71.6 | 0.990223463687151 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moranbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_35_21 | ||||||
| 32608089 | 32608089 | PRJNA558770_P_NODE_163320_length_234_cov_5.552764_g161315_i0 | PRJNA558770 | 163320 | 234 | 5.552764 | 12.99346776 | Candidatus Moraniibacteriota bacterium | 2045217 | Bacteria | Bacteria | 60.8 | 1.41e-8 | NR | MDX9913233.1 | 2045217 | g161315 | i0 | 46.7 | 0.961538461538462 | 75 | 36 | 96.2 | 1 | 225 | 1 | 658 | 728 | MDX9913233.1 phage tail sheath subtilisin-like domain-containing protein [Candidatus Moraniibacteriota bacterium] | diamond | 225 | 60.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moraniibacteriota 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);;