contig_metadata
11 rows where bioproject = "PRJNA1240804", tax_kingdom = "Loebvirae" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 346668 | 346668 | PRJNA1240804_P_NODE_105521_length_170_cov_1.157025_g105155_i0 | PRJNA1240804 | 105521 | 170 | 1.157025 | 1.9669425 | Inoviridae sp. | 2219103 | Viruses | Viruses | 278 | 2.15e-70 | NTclustered | gi|2053040871|tpg|BK024249.1| | 2219103 | g105155 | i0 | 98.718 | 21.3529411764706 | 156 | 2 | 92 | 0 | 1 | 156 | 9191 | 9346 | MAG TPA_asm: Inoviridae sp. isolate ct4CW1, partial genome | blastn | 3630 | 278 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 1623751 | 1623751 | PRJNA1240804_P_NODE_83942_length_184_cov_1.148148_g83576_i0 | PRJNA1240804 | 83942 | 184 | 1.148148 | 2.11259232 | Inoviridae sp. | 2219103 | Viruses | Viruses | 291 | 3.05e-74 | NTclustered | gi|2057891989|tpg|BK051014.1| | 2219103 | g83576 | i0 | 100 | 2.27717391304348 | 157 | 0 | 85 | 0 | 14 | 170 | 294 | 450 | MAG TPA_asm: Inoviridae sp. isolate ctfkp1, partial genome | blastn | 419 | 291 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 9277055 | 9277055 | PRJNA1240804_P_NODE_69628_length_194_cov_1.289655_g69262_i0 | PRJNA1240804 | 69628 | 194 | 1.289655 | 2.5019307 | Inoviridae sp. | 2219103 | Viruses | Viruses | 333 | 5.339999999999999e-87 | NTclustered | gi|2057891989|tpg|BK051014.1| | 2219103 | g69262 | i0 | 100 | 0.927835051546392 | 180 | 0 | 93 | 0 | 15 | 194 | 5129 | 5308 | MAG TPA_asm: Inoviridae sp. isolate ctfkp1, partial genome | blastn | 180 | 333 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 10551334 | 10551334 | PRJNA1240804_P_NODE_134329_length_164_cov_2.460870_g133963_i0 | PRJNA1240804 | 134329 | 164 | 2.46087 | 4.0358268 | Inoviridae sp. | 2219103 | Viruses | Viruses | 174 | 2.8e-39 | NTclustered | gi|2057891989|tpg|BK051014.1| | 2219103 | g133963 | i0 | 87.919 | 0.908536585365854 | 149 | 16 | 90 | 2 | 17 | 164 | 16694 | 16547 | MAG TPA_asm: Inoviridae sp. isolate ctfkp1, partial genome | blastn | 149 | 174 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 16925744 | 16925744 | PRJNA1240804_P_NODE_55074_length_212_cov_0.871166_g54708_i0 | PRJNA1240804 | 55074 | 212 | 0.871166 | 1.84687192 | Inoviridae sp. | 2219103 | Viruses | Viruses | 198 | 2.26e-46 | NTclustered | gi|2053040871|tpg|BK024249.1| | 2219103 | g54708 | i0 | 100 | 0.504716981132076 | 107 | 0 | 50 | 0 | 40 | 146 | 1 | 107 | MAG TPA_asm: Inoviridae sp. isolate ct4CW1, partial genome | blastn | 107 | 198 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 18199643 | 18199643 | PRJNA1240804_P_NODE_29975_length_266_cov_1.764977_g29609_i0 | PRJNA1240804 | 29975 | 266 | 1.764977 | 4.69483882 | Inoviridae sp. | 2219103 | Viruses | Viruses | 460 | 3.41e-125 | NTclustered | gi|2053040871|tpg|BK024249.1| | 2219103 | g29609 | i0 | 100 | 83.8007518796992 | 249 | 0 | 94 | 0 | 3 | 251 | 1885 | 1637 | MAG TPA_asm: Inoviridae sp. isolate ct4CW1, partial genome | blastn | 22291 | 460 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 19472847 | 19472847 | PRJNA1240804_P_NODE_103216_length_171_cov_1.590164_g102850_i0 | PRJNA1240804 | 103216 | 171 | 1.590164 | 2.71918044 | Inoviridae sp. | 2219103 | Viruses | Viruses | 279 | 6.03e-71 | NTclustered | gi|2053040871|tpg|BK024249.1| | 2219103 | g102850 | i0 | 100 | 88.766081871345 | 151 | 0 | 88 | 0 | 15 | 165 | 1237 | 1087 | MAG TPA_asm: Inoviridae sp. isolate ct4CW1, partial genome | blastn | 15179 | 279 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 22026150 | 22026150 | PRJNA1240804_P_NODE_99298_length_174_cov_1.136000_g98932_i0 | PRJNA1240804 | 99298 | 174 | 1.136 | 1.97664 | Inoviridae sp. | 2219103 | Viruses | Viruses | 268 | 1.34e-67 | NTclustered | gi|2057891989|tpg|BK051014.1| | 2219103 | g98932 | i0 | 98.065 | 0.890804597701149 | 155 | 2 | 89 | 1 | 9 | 162 | 2669 | 2515 | MAG TPA_asm: Inoviridae sp. isolate ctfkp1, partial genome | blastn | 155 | 268 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 23300634 | 23300634 | PRJNA1240804_P_NODE_39799_length_238_cov_1.544974_g39433_i0 | PRJNA1240804 | 39799 | 238 | 1.544974 | 3.67703812 | Inoviridae sp. | 2219103 | Viruses | Viruses | 377 | 3.11e-100 | NTclustered | gi|2057891989|tpg|BK051014.1| | 2219103 | g39433 | i0 | 99.048 | 0.882352941176471 | 210 | 2 | 88 | 0 | 15 | 224 | 280 | 71 | MAG TPA_asm: Inoviridae sp. isolate ctfkp1, partial genome | blastn | 210 | 377 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 24575344 | 24575344 | PRJNA1240804_P_NODE_81540_length_185_cov_2.007353_g81174_i0 | PRJNA1240804 | 81540 | 185 | 2.007353 | 3.71360305 | Inoviridae sp. | 2219103 | Viruses | Viruses | 274 | 3.1e-69 | NTclustered | gi|2057891989|tpg|BK051014.1| | 2219103 | g81174 | i0 | 96.429 | 0.908108108108108 | 168 | 3 | 90 | 3 | 15 | 180 | 18910 | 18744 | MAG TPA_asm: Inoviridae sp. isolate ctfkp1, partial genome | blastn | 168 | 274 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 24575626 | 24575626 | PRJNA1240804_P_NODE_94360_length_177_cov_1.250000_g93994_i0 | PRJNA1240804 | 94360 | 177 | 1.25 | 2.2125 | Inoviridae sp. | 2219103 | Viruses | Viruses | 259 | 8.21e-65 | NTclustered | gi|2057891989|tpg|BK051014.1| | 2219103 | g93994 | i0 | 99.301 | 0.807909604519774 | 143 | 1 | 81 | 0 | 19 | 161 | 6436 | 6578 | MAG TPA_asm: Inoviridae sp. isolate ctfkp1, partial genome | blastn | 143 | 259 | 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);;