contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA1200128" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1601876 | 1601876 | PRJNA1200128_S_NODE_8982_length_261_cov_1175.082569_g8873_i0 | PRJNA1200128 | 8982 | 261 | 1175.082569 | 3066.96550509 | Enterococcus phage SSMH01 | 3075855 | Viruses | Viruses | 119 | 2.31e-22 | NTclustered | gi|2583824285|gb|OR360270.1| | 3075855 | g8873 | i0 | 91.86 | 46.6513409961686 | 86 | 5 | 33 | 2 | 176 | 261 | 41598 | 41681 | Enterococcus phage SSMH01, complete genome | blastn | 12176 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Efquatrovirus | Enterococcus phage SSMH01 | ||||
| 6704919 | 6704919 | PRJNA1200128_S_NODE_47786_length_152_cov_1.293578_g47677_i0 | PRJNA1200128 | 47786 | 152 | 1.293578 | 1.96623856 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 259 | 6.82e-65 | NTclustered | gi|2057961319|tpg|BK046393.1| | 2832643 | g47677 | i0 | 97.368 | 5.95394736842105 | 152 | 4 | 100 | 0 | 1 | 152 | 49471 | 49622 | MAG TPA_asm: Caudoviricetes sp. isolate ct5v45, partial genome | blastn | 905 | 259 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7980602 | 7980602 | PRJNA1200128_S_NODE_4787_length_320_cov_26830.783394_g4678_i0 | PRJNA1200128 | 4787 | 320 | 26830.783394 | 85858.5068608 | Enterococcus phage SSMH01 | 3075855 | Viruses | Viruses | 122 | 2.26e-23 | NTclustered | gi|2583824285|gb|OR360270.1| | 3075855 | g4678 | i0 | 92.941 | 38.025 | 85 | 4 | 27 | 2 | 1 | 85 | 41681 | 41599 | Enterococcus phage SSMH01, complete genome | blastn | 12168 | 122 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Efquatrovirus | Enterococcus phage SSMH01 | ||||
| 9254951 | 9254951 | PRJNA1200128_S_NODE_10908_length_245_cov_781.559406_g10799_i0 | PRJNA1200128 | 10908 | 245 | 781.559406 | 1914.8205447 | Enterococcus phage SSMH01 | 3075855 | Viruses | Viruses | 119 | 2.15e-22 | NTclustered | gi|2583824285|gb|OR360270.1| | 3075855 | g10799 | i0 | 91.86 | 33.0897959183673 | 86 | 5 | 35 | 2 | 1 | 86 | 41681 | 41598 | Enterococcus phage SSMH01, complete genome | blastn | 8107 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Efquatrovirus | Enterococcus phage SSMH01 | ||||
| 9255132 | 9255132 | PRJNA1200128_S_NODE_9848_length_253_cov_29588.614286_g9739_i0 | PRJNA1200128 | 9848 | 253 | 29588.614286 | 74859.19414358 | Enterococcus phage SSMH01 | 3075855 | Viruses | Viruses | 122 | 1.73e-23 | NTclustered | gi|2583824285|gb|OR360270.1| | 3075855 | g9739 | i0 | 92.941 | 28.5494071146245 | 85 | 4 | 34 | 2 | 1 | 85 | 41681 | 41599 | Enterococcus phage SSMH01, complete genome | blastn | 7223 | 122 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Efquatrovirus | Enterococcus phage SSMH01 | ||||
| 10530990 | 10530990 | PRJNA1200128_S_NODE_6689_length_286_cov_25572.567901_g6580_i0 | PRJNA1200128 | 6689 | 286 | 25572.567901 | 73137.54419686 | Enterococcus phage SSMH01 | 3075855 | Viruses | Viruses | 122 | 1.99e-23 | NTclustered | gi|2583824285|gb|OR360270.1| | 3075855 | g6580 | i0 | 92.941 | 25.6713286713287 | 85 | 4 | 30 | 2 | 1 | 85 | 41681 | 41599 | Enterococcus phage SSMH01, complete genome | blastn | 7342 | 122 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Efquatrovirus | Enterococcus phage SSMH01 | ||||
| 10531004 | 10531004 | PRJNA1200128_S_NODE_9969_length_252_cov_25135.645933_g9860_i0 | PRJNA1200128 | 9969 | 252 | 25135.645933 | 63341.82775116 | Enterococcus phage SSMH01 | 3075855 | Viruses | Viruses | 128 | 3.69e-25 | NTclustered | gi|2583824285|gb|OR360270.1| | 3075855 | g9860 | i0 | 94.118 | 53.1269841269841 | 85 | 3 | 34 | 1 | 168 | 252 | 41599 | 41681 | Enterococcus phage SSMH01, complete genome | blastn | 13388 | 128 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Efquatrovirus | Enterococcus phage SSMH01 | ||||
| 11805725 | 11805725 | PRJNA1200128_S_NODE_7770_length_273_cov_2998.595652_g7661_i0 | PRJNA1200128 | 7770 | 273 | 2998.595652 | 8186.16612996 | Enterococcus phage SSMH01 | 3075855 | Viruses | Viruses | 117 | 8.76e-22 | NTclustered | gi|2583824285|gb|OR360270.1| | 3075855 | g7661 | i0 | 91.765 | 44.6007326007326 | 85 | 5 | 31 | 2 | 189 | 273 | 41599 | 41681 | Enterococcus phage SSMH01, complete genome | blastn | 12176 | 117 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Efquatrovirus | Enterococcus phage SSMH01 | ||||
| 11805733 | 11805733 | PRJNA1200128_S_NODE_9850_length_253_cov_20393.028571_g9741_i0 | PRJNA1200128 | 9850 | 253 | 20393.028571 | 51594.36228463 | Enterococcus phage SSMH01 | 3075855 | Viruses | Viruses | 128 | 3.71e-25 | NTclustered | gi|2583824285|gb|OR360270.1| | 3075855 | g9741 | i0 | 94.118 | 26.2687747035573 | 85 | 3 | 34 | 2 | 169 | 253 | 41599 | 41681 | Enterococcus phage SSMH01, complete genome | blastn | 6646 | 128 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Efquatrovirus | Enterococcus phage SSMH01 | ||||
| 15629882 | 15629882 | PRJNA1200128_S_NODE_22753_length_196_cov_1.052288_g22644_i0 | PRJNA1200128 | 22753 | 196 | 1.052288 | 2.06248448 | Kayfunavirus R1 | 3430153 | Viruses | Viruses | 58.4 | 3.64e-4 | NTclustered | gi|2496482497|gb|OQ703102.1| | 3038273 | g22644 | i0 | 100 | 4.18877551020408 | 31 | 0 | 16 | 0 | 1 | 31 | 40869 | 40839 | Escherichia phage vB_EcoP-R1, complete genome | blastn | 821 | 58.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autotranscriptaviridae | Kayfunavirus | Kayfunavirus R1 | ||
| 18178758 | 18178758 | PRJNA1200128_S_NODE_4075_length_339_cov_4701.395270_g3966_i0 | PRJNA1200128 | 4075 | 339 | 4701.39527 | 15937.7299653 | Enterococcus phage SSMH01 | 3075855 | Viruses | Viruses | 122 | 2.4099999999999994e-23 | NTclustered | gi|2583824285|gb|OR360270.1| | 3075855 | g3966 | i0 | 92.941 | 19.7581120943953 | 85 | 4 | 25 | 1 | 255 | 339 | 41599 | 41681 | Enterococcus phage SSMH01, complete genome | blastn | 6698 | 122 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Efquatrovirus | Enterococcus phage SSMH01 | ||||
| 19453244 | 19453244 | PRJNA1200128_S_NODE_8136_length_269_cov_32935.030973_g8027_i0 | PRJNA1200128 | 8136 | 269 | 32935.030973 | 88595.23331737 | Enterococcus phage SSMH01 | 3075855 | Viruses | Viruses | 122 | 1.8499999999999998e-23 | NTclustered | gi|2583824285|gb|OR360270.1| | 3075855 | g8027 | i0 | 92.941 | 45.2899628252788 | 85 | 4 | 32 | 2 | 1 | 85 | 41681 | 41599 | Enterococcus phage SSMH01, complete genome | blastn | 12183 | 122 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Efquatrovirus | Enterococcus phage SSMH01 | ||||
| 20728475 | 20728475 | PRJNA1200128_S_NODE_25977_length_187_cov_3.194444_g25868_i0 | PRJNA1200128 | 25977 | 187 | 3.194444 | 5.97361028 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 65.8 | 2.06e-6 | NTclustered | gi|2914818327|gb|OR222051.1| | 2832643 | g25868 | i0 | 100 | 20.807486631016 | 35 | 0 | 19 | 0 | 153 | 187 | 51 | 17 | MAG: Caudoviricetes sp. isolate MSP0064 genomic sequence | blastn | 3891 | 65.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22721642 | 22721642 | PRJNA1200128_S_NODE_5518_length_305_cov_5257.931298_g5409_i0 | PRJNA1200128 | 5518 | 305 | 5257.931298 | 16036.6904589 | root | 1 | Root_unresolved | Root_unresolved | 121 | 7.68e-23 | NTclustered | gi|1893169343|gb|MT364888.1| | 10310 | g5409 | i0 | 94.872 | 21.9803278688525 | 78 | 2 | 26 | 2 | 9 | 86 | 5 | 80 | Human alphaherpesvirus 2, partial genome | blastn | 6704 | 122 | 0.991803278688525 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha2 | ||
| 23279282 | 23279282 | PRJNA1200128_S_NODE_8039_length_270_cov_17308.977974_g7930_i0 | PRJNA1200128 | 8039 | 270 | 17308.977974 | 46734.2405298 | Enterococcus phage SSMH01 | 3075855 | Viruses | Viruses | 128 | 4e-25 | NTclustered | gi|2583824285|gb|OR360270.1| | 3075855 | g7930 | i0 | 93.182 | 26.1111111111111 | 88 | 4 | 33 | 2 | 1 | 88 | 41681 | 41596 | Enterococcus phage SSMH01, complete genome | blastn | 7050 | 128 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Efquatrovirus | Enterococcus phage SSMH01 | ||||
| 24553255 | 24553255 | PRJNA1200128_S_NODE_8040_length_270_cov_13319.854626_g7931_i0 | PRJNA1200128 | 8040 | 270 | 13319.854626 | 35963.6074902 | Enterococcus phage SSMH01 | 3075855 | Viruses | Viruses | 134 | 8.590000000000001e-27 | NTclustered | gi|2583824285|gb|OR360270.1| | 3075855 | g7931 | i0 | 95.349 | 26.3185185185185 | 86 | 0 | 31 | 2 | 1 | 85 | 41681 | 41599 | Enterococcus phage SSMH01, complete genome | blastn | 7106 | 134 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Efquatrovirus | Enterococcus phage SSMH01 |
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);;