contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA641707" and tax_phylum = "Candidatus Altimarinota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3167263 | 3167263 | PRJNA641707_P_NODE_38403_length_351_cov_5.652318_g35763_i0 | PRJNA641707 | 38403 | 351 | 5.652318 | 19.83963618 | Gracilibacteria bacterium canine oral taxon 323 | 1151651 | Bacteria | Bacteria | 420 | 7.89e-113 | NTclustered | gi|373279794|gb|JN713493.1| | 1151651 | g35763 | i0 | 99.142 | 80.3589743589744 | 233 | 2 | 85 | 0 | 1 | 233 | 481 | 249 | GN02 bacterium canine oral taxon 323 clone 1D068 16S ribosomal RNA gene, partial sequence | blastn | 28206 | 420 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Gracilibacteria bacterium canine oral taxon 323 | ||||||
| 4441441 | 4441441 | PRJNA641707_P_NODE_23204_length_452_cov_9.553350_g20645_i0 | PRJNA641707 | 23204 | 452 | 9.55335 | 43.181142 | Gracilibacteria bacterium canine oral taxon 323 | 1151651 | Bacteria | Bacteria | 597 | 4.4899999999999986e-166 | NTclustered | gi|373279794|gb|JN713493.1| | 1151651 | g20645 | i0 | 98.806 | 90.6305309734513 | 335 | 4 | 91 | 0 | 1 | 335 | 831 | 497 | GN02 bacterium canine oral taxon 323 clone 1D068 16S ribosomal RNA gene, partial sequence | blastn | 40965 | 597 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Gracilibacteria bacterium canine oral taxon 323 | ||||||
| 8270067 | 8270067 | PRJNA641707_P_NODE_57367_length_282_cov_4.772532_g54706_i0 | PRJNA641707 | 57367 | 282 | 4.772532 | 13.45854024 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 392 | 1.35e-104 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g54706 | i0 | 92.364 | 5.73049645390071 | 275 | 21 | 98 | 0 | 4 | 278 | 891286 | 891012 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 1616 | 392 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 12091487 | 12091487 | PRJNA641707_P_NODE_156270_length_224_cov_3.280000_g153607_i0 | PRJNA641707 | 156270 | 224 | 3.28 | 7.3472 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 267 | 6.53e-67 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g153607 | i0 | 88.889 | 8.67410714285714 | 216 | 24 | 96 | 0 | 1 | 216 | 890345 | 890130 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 1943 | 267 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 14645723 | 14645723 | PRJNA641707_P_NODE_57332_length_282_cov_5.781116_g54671_i0 | PRJNA641707 | 57332 | 282 | 5.781116 | 16.30274712 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 422 | 1.72e-113 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g54671 | i0 | 94.224 | 54.8510638297872 | 277 | 14 | 98 | 2 | 3 | 278 | 891703 | 891428 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 15468 | 422 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 15918152 | 15918152 | PRJNA641707_P_NODE_296953_length_165_cov_3.715517_g294290_i0 | PRJNA641707 | 296953 | 165 | 3.715517 | 6.13060305 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 278 | 2.09e-70 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g294290 | i0 | 97.531 | 170.406060606061 | 162 | 4 | 98 | 0 | 4 | 165 | 892091 | 892252 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 28117 | 278 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 21015829 | 21015829 | PRJNA641707_P_NODE_21897_length_465_cov_8.538462_g19353_i0 | PRJNA641707 | 21897 | 465 | 8.5384620000000009 | 39.7038483 | Gracilibacteria bacterium canine oral taxon 323 | 1151651 | Bacteria | Bacteria | 420 | 1.07e-112 | NTclustered | gi|373279794|gb|JN713493.1| | 1151651 | g19353 | i0 | 99.142 | 70.1741935483871 | 233 | 2 | 94 | 0 | 1 | 233 | 481 | 249 | GN02 bacterium canine oral taxon 323 clone 1D068 16S ribosomal RNA gene, partial sequence | blastn | 32631 | 420 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Gracilibacteria bacterium canine oral taxon 323 | ||||||
| 22289134 | 22289134 | PRJNA641707_P_NODE_157018_length_222_cov_3.988439_g154355_i0 | PRJNA641707 | 157018 | 222 | 3.988439 | 8.85433458 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 263 | 8.36e-66 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g154355 | i0 | 88.636 | 3.92792792792793 | 220 | 20 | 98 | 5 | 6 | 222 | 891285 | 891502 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 872 | 263 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 24108671 | 24108671 | PRJNA641707_P_NODE_200539_length_197_cov_7.378378_g197876_i0 | PRJNA641707 | 200539 | 197 | 7.378378 | 14.53540466 | Bacteria | 2 | Bacteria | Bacteria | 348 | 1.94e-91 | NTclustered | gi|402243568|gb|JX294354.1| | 1226340 | g197876 | i0 | 99.476 | 95.8477157360406 | 191 | 1 | 97 | 0 | 5 | 195 | 1183 | 1373 | GN02 bacterium oral taxon 873 clone 4Q04 16S ribosomal RNA gene, partial sequence | blastn | 18882 | 348 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Gracilibacteria bacterium oral taxon 873 | ||||||
| 24842420 | 24842420 | PRJNA641707_P_NODE_332440_length_153_cov_5.769231_g329777_i0 | PRJNA641707 | 332440 | 153 | 5.7692310000000004 | 8.82692343 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 248 | 1.49e-61 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g329777 | i0 | 97.26 | 113.686274509804 | 146 | 4 | 95 | 0 | 2 | 147 | 892345 | 892200 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 17394 | 248 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 24842634 | 24842634 | PRJNA641707_P_NODE_36620_length_358_cov_7.061489_g33985_i0 | PRJNA641707 | 36620 | 358 | 7.061489 | 25.28013062 | Gracilibacteria bacterium canine oral taxon 323 | 1151651 | Bacteria | Bacteria | 351 | 2.99e-92 | NTclustered | gi|373279794|gb|JN713493.1| | 1151651 | g33985 | i0 | 92.946 | 85.6061452513967 | 241 | 17 | 91 | 0 | 118 | 358 | 1177 | 1417 | GN02 bacterium canine oral taxon 323 clone 1D068 16S ribosomal RNA gene, partial sequence | blastn | 30647 | 351 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Gracilibacteria bacterium canine oral taxon 323 |
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);;