contig_metadata
7 rows where bioproject = "PRJNA550047" and tax_kingdom = "Loebvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 514609 | 514609 | PRJNA550047_P_NODE_299201_length_297_cov_9.696429_g297232_i0 | PRJNA550047 | 299201 | 297 | 9.696429 | 28.79839413 | Inoviridae sp. | 2219103 | Viruses | Viruses | 224 | 5.53e-54 | NTclustered | gi|2054441676|tpg|BK036156.1| | 2219103 | g297232 | i0 | 95.07 | 1.44107744107744 | 142 | 7 | 48 | 0 | 150 | 291 | 5090 | 5231 | MAG TPA_asm: Inoviridae sp. isolate ctILX2, partial genome | blastn | 428 | 224 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 6895589 | 6895589 | PRJNA550047_P_NODE_546026_length_215_cov_6.169014_g544053_i0 | PRJNA550047 | 546026 | 215 | 6.169014 | 13.2633801 | Inoviridae sp. | 2219103 | Viruses | Viruses | 344 | 2.7899999999999998e-90 | NTclustered | gi|2059577653|tpg|BK036636.1| | 2219103 | g544053 | i0 | 95.775 | 200.786046511628 | 213 | 9 | 99 | 0 | 3 | 215 | 6681 | 6893 | MAG TPA_asm: Inoviridae sp. isolate ctCVc5, partial genome | blastn | 43169 | 344 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 9443301 | 9443301 | PRJNA550047_P_NODE_314548_length_295_cov_8.797297_g312579_i0 | PRJNA550047 | 314548 | 295 | 8.797297 | 25.95202615 | Inoviridae sp. | 2219103 | Viruses | Viruses | 278 | 4.15e-70 | NTclustered | gi|2057891989|tpg|BK051014.1| | 2219103 | g312579 | i0 | 99.346 | 1.01694915254237 | 153 | 1 | 100 | 0 | 1 | 153 | 3120 | 2968 | MAG TPA_asm: Inoviridae sp. isolate ctfkp1, partial genome | blastn | 300 | 278 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 14545210 | 14545210 | PRJNA550047_P_NODE_42512_length_365_cov_10.013699_g40557_i0 | PRJNA550047 | 42512 | 365 | 10.013699 | 36.55000135 | Inoviridae sp. | 2219103 | Viruses | Viruses | 405 | 2.31e-108 | NTclustered | gi|1436210078|gb|MH617262.1| | 2219103 | g40557 | i0 | 99.111 | 0.841095890410959 | 225 | 2 | 81 | 0 | 141 | 365 | 5502 | 5726 | MAG: Inoviridae sp. isolate ctcg5, complete genome | blastn | 307 | 405 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 14546811 | 14546811 | PRJNA550047_P_NODE_55272_length_345_cov_17.176471_g53312_i0 | PRJNA550047 | 55272 | 345 | 17.176471 | 59.25882495 | Inoviridae sp. | 2219103 | Viruses | Viruses | 278 | 4.9500000000000006e-70 | NTclustered | gi|2056839431|tpg|BK044096.1| | 2219103 | g53312 | i0 | 100 | 1.70434782608696 | 150 | 0 | 87 | 0 | 1 | 150 | 1689 | 1540 | MAG TPA_asm: Inoviridae sp. isolate ctx2K3, partial genome | blastn | 588 | 278 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 15815561 | 15815561 | PRJNA550047_P_NODE_134353_length_345_cov_5.746324_g132393_i0 | PRJNA550047 | 134353 | 345 | 5.746324 | 19.8248178 | Inoviridae sp. | 2219103 | Viruses | Viruses | 279 | 1.38e-70 | NTclustered | gi|2059604206|tpg|BK037164.1| | 2219103 | g132393 | i0 | 100 | 11.6579710144928 | 151 | 0 | 87 | 0 | 1 | 151 | 12205 | 12355 | MAG TPA_asm: Inoviridae sp. isolate ctPvE6, partial genome | blastn | 4022 | 279 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 17091263 | 17091263 | PRJNA550047_P_NODE_213374_length_301_cov_31.355263_g211405_i0 | PRJNA550047 | 213374 | 301 | 31.355263 | 94.37934163 | Inoviridae sp. | 2219103 | Viruses | Viruses | 145 | 4.49e-30 | NTclustered | gi|1436210078|gb|MH617262.1| | 2219103 | g211405 | i0 | 98.765 | 0.269102990033223 | 81 | 1 | 27 | 0 | 1 | 81 | 5727 | 5807 | MAG: Inoviridae sp. isolate ctcg5, complete genome | blastn | 81 | 145 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae 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);;