contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA814235" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 817029 | 817029 | PRJNA814235_P_NODE_194521_length_151_cov_2.464912_g193126_i0 | PRJNA814235 | 194521 | 151 | 2.464912 | 3.72201712 | Rubrivirga sp. IMCC43871 | 3391575 | Bacteria | Bacteria | 100 | 4.34e-17 | NTclustered | gi|2890853429|gb|CP177355.1| | 3391575 | g193126 | i0 | 92.754 | 7.04635761589404 | 69 | 5 | 46 | 0 | 81 | 149 | 2008696 | 2008764 | Rubrivirga sp. IMCC43871 chromosome, complete genome | blastn | 1064 | 100 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubrivirga | Rubrivirga sp. IMCC43871 | |
| 7195064 | 7195064 | PRJNA814235_P_NODE_183466_length_151_cov_4.640351_g182071_i0 | PRJNA814235 | 183466 | 151 | 4.640351 | 7.00693001 | Rubrivirga sp. IMCC45206 | 3391614 | Bacteria | Bacteria | 89.8 | 9.39e-14 | NTclustered | gi|2890849321|gb|CP177357.1| | 3391614 | g182071 | i0 | 86.585 | 0.543046357615894 | 82 | 10 | 54 | 1 | 69 | 149 | 1084148 | 1084067 | Rubrivirga sp. IMCC45206 chromosome, complete genome | blastn | 82 | 89.8 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubrivirga | Rubrivirga sp. IMCC45206 | |
| 9745006 | 9745006 | PRJNA814235_P_NODE_192008_length_151_cov_2.842105_g190613_i0 | PRJNA814235 | 192008 | 151 | 2.842105 | 4.29157855 | Rubrivirga sp. IMCC45206 | 3391614 | Bacteria | Bacteria | 95.3 | 2.02e-15 | NTclustered | gi|2890849321|gb|CP177357.1| | 3391614 | g190613 | i0 | 91.429 | 0.463576158940397 | 70 | 4 | 46 | 2 | 1 | 69 | 1389350 | 1389418 | Rubrivirga sp. IMCC45206 chromosome, complete genome | blastn | 70 | 95.3 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubrivirga | Rubrivirga sp. IMCC45206 | |
| 17393601 | 17393601 | PRJNA814235_P_NODE_109634_length_203_cov_2.078313_g108239_i0 | PRJNA814235 | 109634 | 203 | 2.078313 | 4.21897539 | Rhodocaloribacter litoris | 2558931 | Bacteria | Bacteria | 86.1 | 1.74e-12 | NTclustered | gi|2076465437|gb|CP076718.1| | 2558931 | g108239 | i0 | 87.671 | 5.9064039408867 | 73 | 9 | 36 | 0 | 128 | 200 | 1494724 | 1494652 | Rhodocaloribacter litoris strain ISCAR-4553 chromosome | blastn | 1199 | 86.1 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermaceae | Rhodocaloribacter | Rhodocaloribacter litoris | |
| 21217495 | 21217495 | PRJNA814235_P_NODE_121837_length_202_cov_3.284848_g120442_i0 | PRJNA814235 | 121837 | 202 | 3.284848 | 6.63539296 | Rhodocaloribacter litoris | 2558931 | Bacteria | Bacteria | 86.1 | 1.73e-12 | NTclustered | gi|2076465437|gb|CP076718.1| | 2558931 | g120442 | i0 | 87.013 | 9.52970297029703 | 77 | 8 | 38 | 2 | 127 | 202 | 3221684 | 3221609 | Rhodocaloribacter litoris strain ISCAR-4553 chromosome | blastn | 1925 | 86.1 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermaceae | Rhodocaloribacter | Rhodocaloribacter litoris | |
| 21627459 | 21627459 | PRJNA814235_P_NODE_104877_length_203_cov_2.234940_g103482_i0 | PRJNA814235 | 104877 | 203 | 2.23494 | 4.5369282 | Rhodothermales | 1853224 | Bacteria | Bacteria | 102 | 1.73e-17 | NTclustered | gi|1167574847|gb|CP020382.1| | 1779382 | g103482 | i0 | 94.03 | 1.02955665024631 | 67 | 4 | 33 | 0 | 131 | 197 | 59897 | 59963 | Rhodothermaceae bacterium RA chromosome, complete genome | blastn | 209 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermaceae | Rhodothermaceae bacterium RA | ||
| 22903034 | 22903034 | PRJNA814235_P_NODE_101878_length_203_cov_2.361446_g100483_i0 | PRJNA814235 | 101878 | 203 | 2.361446 | 4.79373538 | Rubrivirga | 1434037 | Bacteria | Bacteria | 93.5 | 1.04e-14 | NTclustered | gi|2890853429|gb|CP177355.1| | 3391575 | g100483 | i0 | 88.312 | 1.76847290640394 | 77 | 9 | 38 | 0 | 127 | 203 | 3532640 | 3532564 | Rubrivirga sp. IMCC43871 chromosome, complete genome | blastn | 359 | 93.5 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubrivirga | Rubrivirga sp. IMCC43871 | |
| 25041535 | 25041535 | PRJNA814235_P_NODE_106760_length_203_cov_2.168675_g105365_i0 | PRJNA814235 | 106760 | 203 | 2.168675 | 4.40241025 | Rubrivirga sp. IMCC45206 | 3391614 | Bacteria | Bacteria | 78.7 | 2.92e-10 | NTclustered | gi|2890849321|gb|CP177357.1| | 3391614 | g105365 | i0 | 94.231 | 1.54679802955665 | 52 | 2 | 26 | 1 | 18 | 69 | 779823 | 779873 | Rubrivirga sp. IMCC45206 chromosome, complete genome | blastn | 314 | 78.7 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubrivirga | Rubrivirga sp. IMCC45206 |
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);;