contig_metadata
7 rows where bioproject = "PRJNA827593" and tax_phylum = "Rhodothermota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9749364 | 9749364 | PRJNA827593_P_NODE_45448_length_299_cov_1.362832_g45149_i0 | PRJNA827593 | 45448 | 299 | 1.362832 | 4.07486768 | Rhodothermus marinus | 29549 | Bacteria | Bacteria | 65.8 | 3.57e-6 | NTclustered | gi|262333112|gb|CP001807.1| | 518766 | g45149 | i0 | 85.714 | 0.210702341137124 | 63 | 7 | 21 | 2 | 154 | 215 | 2565729 | 2565668 | Rhodothermus marinus DSM 4252, complete genome | blastn | 63 | 65.8 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermaceae | Rhodothermus | Rhodothermus marinus | |
| 12300719 | 12300719 | PRJNA827593_P_NODE_57090_length_262_cov_1.222222_g56791_i0 | PRJNA827593 | 57090 | 262 | 1.222222 | 3.20222164 | Rhodothermus marinus | 29549 | Bacteria | Bacteria | 219 | 2.2299999999999994e-52 | NTclustered | gi|2844596544|gb|CP172416.1| | 29549 | g56791 | i0 | 84.685 | 40.2022900763359 | 222 | 30 | 84 | 4 | 14 | 233 | 853576 | 853795 | Rhodothermus marinus strain ISCAR-493 chromosome | blastn | 10533 | 219 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermaceae | Rhodothermus | Rhodothermus marinus | |
| 16530977 | 16530977 | PRJNA827593_P_NODE_26013_length_410_cov_1.845697_g25714_i0 | PRJNA827593 | 26013 | 410 | 1.845697 | 7.5673577 | Rubrivirga sp. S365 | 3076080 | Bacteria | Bacteria | 168 | 4.39e-49 | NR | WP_314007323.1 | 3076080 | g25714 | i0 | 65.9 | 1.88780487804878 | 129 | 44 | 94.4 | 0 | 409 | 23 | 41 | 169 | WP_314007323.1 SDR family oxidoreductase [Rubrivirga sp. S365] | diamond | 774 | 168 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubrivirga | Rubrivirga sp. S365 | |
| 26642835 | 26642835 | PRJNA827593_P_NODE_28721_length_388_cov_0.882540_g28422_i0 | PRJNA827593 | 28721 | 388 | 0.88254 | 3.4242552 | Rhodothermales bacterium | 2306054 | Bacteria | Bacteria | 74.7 | 1.2e-12 | NR | MEX0747217.1 | 2306054 | g28422 | i0 | 48.6 | 1.08247422680412 | 70 | 36 | 54.1 | 0 | 376 | 167 | 498 | 567 | MEX0747217.1 family 78 glycoside hydrolase catalytic domain [Rhodothermales bacterium] | diamond | 420 | 74.7 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermales bacterium | |||
| 28633803 | 28633803 | PRJNA827593_P_NODE_50347_length_282_cov_1.382775_g50048_i0 | PRJNA827593 | 50347 | 282 | 1.382775 | 3.8994255 | Rubrivirga sp. IMCC43871 | 3391575 | Bacteria | Bacteria | 119 | 1.01e-29 | NR | WP_412070417.1 | 3391575 | g50048 | i0 | 67.8 | 2.8936170212766 | 90 | 29 | 95.7 | 0 | 276 | 7 | 64 | 153 | WP_412070417.1 glycosyltransferase [Rubrivirga sp. IMCC43871] | diamond | 816 | 119 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubrivirga | Rubrivirga sp. IMCC43871 | |
| 30623048 | 30623048 | PRJNA827593_P_NODE_26873_length_403_cov_0.842424_g26574_i0 | PRJNA827593 | 26873 | 403 | 0.842424 | 3.39496872 | Rhodothermales bacterium | 2306054 | Bacteria | Bacteria | 151 | 2.13e-40 | NR | NNE47913.1 | 2306054 | g26574 | i0 | 54.7 | 1.89826302729529 | 128 | 58 | 95.3 | 0 | 18 | 401 | 228 | 355 | NNE47913.1 phytoene desaturase [Rhodothermales bacterium] | diamond | 765 | 151 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermales bacterium | |||
| 31065805 | 31065805 | PRJNA827593_P_NODE_48135_length_289_cov_1.763889_g47836_i0 | PRJNA827593 | 48135 | 289 | 1.763889 | 5.09763921 | Rhodothermus sp. AH-315-K08 | 2814541 | Bacteria | Bacteria | 113 | 9.629999999999999e-30 | NR | MBN4056434.1 | 2814541 | g47836 | i0 | 54.5 | 3.82006920415225 | 88 | 40 | 91.3 | 0 | 25 | 288 | 1 | 88 | MBN4056434.1 transposase [Rhodothermus sp. AH-315-K08] | diamond | 1104 | 113 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermaceae | Rhodothermus | Rhodothermus sp. AH-315-K08 |
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);;