contig_metadata
8 rows where bioproject = "PRJNA1237347", tax_kingdom = "Thermotogati" and tax_phylum = "Synergistota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16918331 | 16918331 | PRJNA1237347_P_NODE_336654_length_311_cov_0.966387_g330081_i0 | PRJNA1237347 | 336654 | 311 | 0.966387 | 3.00546357 | Bacteria | 2 | Bacteria | Bacteria | 120 | 1.4499999999999998e-31 | NR | WP_085543844.1 | 561720 | g330081 | i0 | 55.6 | 6.04823151125402 | 90 | 39 | 86.8 | 1 | 11 | 280 | 113 | 201 | WP_085543844.1 imidazole glycerol phosphate synthase subunit HisH [Dethiosulfovibrio salsuginis] | diamond | 1881 | 121 | 0.991735537190083 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Dethiosulfovibrionaceae | Dethiosulfovibrio | Dethiosulfovibrio salsuginis | ||
| 28715445 | 28715445 | PRJNA1237347_P_NODE_406727_length_277_cov_1.132353_g400154_i0 | PRJNA1237347 | 406727 | 277 | 1.132353 | 3.13661781 | Pyramidobacter sp. | 1943581 | Bacteria | Bacteria | 69.7 | 2.31e-12 | NR | MBP5212555.1 | 1943581 | g400154 | i0 | 43.8 | 2.92418772563177 | 89 | 35 | 96.4 | 2 | 1 | 267 | 50 | 123 | MBP5212555.1 GNAT family N-acetyltransferase [Pyramidobacter sp.] | diamond | 810 | 69.7 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Dethiosulfovibrionaceae | Pyramidobacter | Pyramidobacter sp. | ||
| 29207574 | 29207574 | PRJNA1237347_P_NODE_503189_length_247_cov_1.287356_g496616_i0 | PRJNA1237347 | 503189 | 247 | 1.287356 | 3.17976932 | Bacteria candidate phyla | 1783234 | Bacteria | Bacteria | 50.4 | 7.44e-5 | NR | HOM98092.1 | 1872099 | g496616 | i0 | 50 | 2.67206477732794 | 44 | 20 | 53.4 | 1 | 3 | 134 | 735 | 776 | HOM98092.1 hypothetical protein [Acetomicrobium sp.] | diamond | 660 | 50.4 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Acetomicrobiaceae | Acetomicrobium | Acetomicrobium sp. | ||
| 29630405 | 29630405 | PRJNA1237347_P_NODE_225930_length_400_cov_1.642202_g219358_i0 | PRJNA1237347 | 225930 | 400 | 1.642202 | 6.568808 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 56.6 | 3.14e-6 | NR | MBQ7168563.1 | 2053624 | g219358 | i0 | 36.1 | 1.4325 | 108 | 67 | 79.5 | 1 | 364 | 47 | 841 | 948 | MBQ7168563.1 putative Ig domain-containing protein [Synergistaceae bacterium] | diamond | 573 | 56.6 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 30609937 | 30609937 | PRJNA1237347_P_NODE_254993_length_370_cov_1.471380_g248420_i0 | PRJNA1237347 | 254993 | 370 | 1.47138 | 5.444106 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 58.2 | 3.81e-7 | NR | MBQ9419517.1 | 2053624 | g248420 | i0 | 33 | 1.77567567567568 | 109 | 61 | 88.4 | 2 | 26 | 352 | 20 | 116 | MBQ9419517.1 tRNA pseudouridine(38-40) synthase TruA [Synergistaceae bacterium] | diamond | 657 | 58.2 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 30831645 | 30831645 | PRJNA1237347_P_NODE_81754_length_775_cov_6.111111_g75634_i0 | PRJNA1237347 | 81754 | 775 | 6.111111 | 47.36111025 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 54.7 | 1.63e-4 | NR | MDR1377386.1 | 2053624 | g75634 | i0 | 50 | 0.209032258064516 | 54 | 27 | 20.9 | 0 | 592 | 753 | 219 | 272 | MDR1377386.1 histidine ammonia-lyase [Synergistaceae bacterium] | diamond | 162 | 54.7 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 32033250 | 32033250 | PRJNA1237347_P_NODE_563018_length_232_cov_2.792453_g556444_i0 | PRJNA1237347 | 563018 | 232 | 2.792453 | 6.47849096 | Acetomicrobium mobile | 97477 | Bacteria | Bacteria | 112 | 7.62e-29 | NR | WP_303881963.1 | 97477 | g556444 | i0 | 70.1 | 0.995689655172414 | 77 | 23 | 99.6 | 0 | 2 | 232 | 80 | 156 | WP_303881963.1 ABC transporter ATP-binding protein [Acetomicrobium mobile] | diamond | 231 | 112 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Acetomicrobiaceae | Acetomicrobium | Acetomicrobium mobile | ||
| 32885731 | 32885731 | PRJNA1237347_P_NODE_492000_length_249_cov_0.875000_g485427_i0 | PRJNA1237347 | 492000 | 249 | 0.875 | 2.17875 | Cloacibacillus sp. | 2049023 | Bacteria | Bacteria | 43.5 | 0.0218 | NR | MEG1824031.1 | 2049023 | g485427 | i0 | 33.3 | 0.975903614457831 | 81 | 44 | 86.7 | 3 | 219 | 4 | 413 | 492 | MEG1824031.1 dihydroxy-acid dehydratase [Cloacibacillus sp.] | diamond | 243 | 43.5 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Cloacibacillus | Cloacibacillus sp. |
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);;