contig_metadata
8 rows where bioproject = "PRJNA681861" and tax_phylum = "Uroviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3208381 | 3208381 | PRJNA681861_P_NODE_16523_length_379_cov_5.168571_g14428_i0 | PRJNA681861 | 16523 | 379 | 5.168571 | 19.58888409 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 651 | 0 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g14428 | i0 | 97.625 | 456.807387862797 | 379 | 9 | 100 | 0 | 1 | 379 | 18353 | 17975 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 173130 | 651 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13925424 | 13925424 | PRJNA681861_P_NODE_18051_length_349_cov_14.053125_g15953_i0 | PRJNA681861 | 18051 | 349 | 14.053125 | 49.04540625 | root | 1 | Root_unresolved | Root_unresolved | 645 | 1.1899999999999993e-180 | NTclustered | gi|2915034053|gb|OR222678.1| | 2832643 | g15953 | i0 | 100 | 72.9169054441261 | 349 | 0 | 100 | 0 | 1 | 349 | 30197 | 30545 | MAG: Caudoviricetes sp. isolate MSP0255 genomic sequence | blastn | 25448 | 645 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14686624 | 14686624 | PRJNA681861_P_NODE_45272_length_160_cov_1.847328_g43172_i0 | PRJNA681861 | 45272 | 160 | 1.847328 | 2.9557248 | Mycobacterium phage Maddy2 | 3240400 | Viruses | Viruses | 147 | 5.919999999999999e-31 | NTclustered | gi|2784346100|gb|PQ115172.1| | 3240400 | g43172 | i0 | 87.597 | 1.33125 | 129 | 12 | 79 | 3 | 1 | 127 | 2902 | 2776 | Mycobacterium phage Maddy2, complete genome | blastn | 213 | 147 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Mycobacterium phage Maddy2 | |||||
| 15960305 | 15960305 | PRJNA681861_P_NODE_37253_length_183_cov_1.857143_g35153_i0 | PRJNA681861 | 37253 | 183 | 1.857143 | 3.39857169 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 196 | 6.8e-46 | NTclustered | gi|2056971494|tpg|BK023137.1| | 2832643 | g35153 | i0 | 86.857 | 2.87978142076503 | 175 | 23 | 96 | 0 | 1 | 175 | 8024 | 8198 | MAG TPA_asm: Caudoviricetes sp. isolate cttej9, partial genome | blastn | 527 | 196 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17235561 | 17235561 | PRJNA681861_P_NODE_44554_length_164_cov_1.466667_g42454_i0 | PRJNA681861 | 44554 | 164 | 1.466667 | 2.40533388 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 292 | 7.41e-75 | NTclustered | gi|2058010581|tpg|BK041739.1| | 2832643 | g42454 | i0 | 98.78 | 106.981707317073 | 164 | 2 | 100 | 0 | 1 | 164 | 19705 | 19542 | MAG TPA_asm: Caudoviricetes sp. isolate ctdVG2, partial genome | blastn | 17545 | 292 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17235562 | 17235562 | PRJNA681861_P_NODE_44894_length_162_cov_1.954887_g42794_i0 | PRJNA681861 | 44894 | 162 | 1.954887 | 3.16691694 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 265 | 1.5899999999999998e-66 | NTclustered | gi|2058086609|tpg|BK033291.1| | 2832643 | g42794 | i0 | 97.419 | 4.91975308641975 | 155 | 4 | 96 | 0 | 6 | 160 | 29212 | 29058 | MAG TPA_asm: Caudoviricetes sp. isolate ctm0613, partial genome | blastn | 797 | 265 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21060106 | 21060106 | PRJNA681861_P_NODE_43117_length_172_cov_2.146853_g41017_i0 | PRJNA681861 | 43117 | 172 | 2.146853 | 3.69258716 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 257 | 2.85e-64 | NTclustered | gi|2059864702|tpg|BK040737.1| | 2832643 | g41017 | i0 | 93.605 | 7.99418604651163 | 172 | 11 | 100 | 0 | 1 | 172 | 24393 | 24222 | MAG TPA_asm: Caudoviricetes sp. isolate ct6TI17, partial genome | blastn | 1375 | 257 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28661148 | 28661148 | PRJNA681861_P_NODE_43467_length_170_cov_1.985816_g41367_i0 | PRJNA681861 | 43467 | 170 | 1.985816 | 3.3758872 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 44.7 | 9.02e-4 | NR | DAT38148.1 | 2832643 | g41367 | i0 | 62.1 | 0.511764705882353 | 29 | 11 | 51.2 | 0 | 83 | 169 | 1 | 29 | DAT38148.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 87 | 44.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes 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);;