contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA177642" and tax_kingdom = "Heunggongvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2916177 | 2916177 | PRJNA177642_P_NODE_17883_length_165_cov_1.058824_g16658_i0 | PRJNA177642 | 17883 | 165 | 1.058824 | 1.7470596 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 244 | 2.12e-60 | NTclustered | gi|2914758139|gb|OR221626.1| | 2832643 | g16658 | i0 | 93.333 | 1 | 165 | 11 | 100 | 0 | 1 | 165 | 43320 | 43156 | MAG: Caudoviricetes sp. isolate MSP1433 genomic sequence | blastn | 165 | 244 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2916198 | 2916198 | PRJNA177642_P_NODE_18943_length_156_cov_2.149606_g17718_i0 | PRJNA177642 | 18943 | 156 | 2.149606 | 3.35338536 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 285 | 1.16e-72 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g17718 | i0 | 100 | 0.987179487179487 | 154 | 0 | 99 | 0 | 2 | 155 | 27184 | 27031 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 154 | 285 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11258395 | 11258395 | PRJNA177642_P_NODE_8909_length_393_cov_22.258242_g7694_i0 | PRJNA177642 | 8909 | 393 | 22.258242 | 87.47489106 | root | 1 | Root_unresolved | Root_unresolved | 108 | 7.91e-19 | NTclustered | gi|671698184|gb|KM192300.1| | 10359 | g7694 | i0 | 98.361 | 31.4351145038168 | 61 | 1 | 30 | 0 | 69 | 129 | 39438 | 39498 | Human herpesvirus 5 strain Merlin isolate RCMV1528, complete genome | blastn | 12354 | 108 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus humanbeta5 | ||
| 11844051 | 11844051 | PRJNA177642_P_NODE_17250_length_168_cov_1.007194_g16025_i0 | PRJNA177642 | 17250 | 168 | 1.007194 | 1.69208592 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 309 | 7.58e-80 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g16025 | i0 | 100 | 0.994047619047619 | 167 | 0 | 99 | 0 | 2 | 168 | 16215 | 16049 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 167 | 309 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16942732 | 16942732 | PRJNA177642_P_NODE_15814_length_180_cov_1.874172_g14589_i0 | PRJNA177642 | 15814 | 180 | 1.874172 | 3.3735096 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 331 | 1.75e-86 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g14589 | i0 | 100 | 0.994444444444444 | 179 | 0 | 99 | 0 | 1 | 179 | 22229 | 22407 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 179 | 331 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22042021 | 22042021 | PRJNA177642_P_NODE_13338_length_258_cov_1.803493_g12113_i0 | PRJNA177642 | 13338 | 258 | 1.803493 | 4.65301194 | Kenyattavirus kv136 | 3060064 | Viruses | Viruses | 169 | 2.23e-37 | NTclustered | gi|2438272093|ref|NC_071049.1| | 2419619 | g12113 | i0 | 79.498 | 3.70542635658915 | 239 | 48 | 92 | 1 | 20 | 257 | 45907 | 45669 | Bacillus phage vB_BcoS-136, complete genome | blastn | 956 | 169 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kenyattavirus | Kenyattavirus kv136 | ||||
| 23317523 | 23317523 | PRJNA177642_P_NODE_13479_length_249_cov_1.263636_g12254_i0 | PRJNA177642 | 13479 | 249 | 1.263636 | 3.14645364 | Parageobacillus phage vB_PtoS_NIIg3.2 | 2985569 | Viruses | Viruses | 156 | 1.67e-33 | NTclustered | gi|2320140881|gb|OP341623.1| | 2985569 | g12254 | i0 | 79.817 | 0.875502008032129 | 218 | 40 | 87 | 4 | 31 | 246 | 29129 | 29344 | Parageobacillus phage vB_PtoS_NIIg3.2, complete genome | blastn | 218 | 156 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Parageobacillus phage vB_PtoS_NIIg3.2 |
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);;