contig_metadata
7 rows where bioproject = "PRJNA1102048" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21888491 | 21888491 | PRJNA1102048_P_NODE_11118_length_266_cov_1.352332_g11014_i0 | PRJNA1102048 | 11118 | 266 | 1.352332 | 3.59720312 | Marine virus AFVG_25M84 | 2694782 | Viruses | Viruses | 259 | 1.34e-64 | NTclustered | gi|1789809213|gb|MN693569.1| | 2694782 | g11014 | i0 | 84.586 | 2.45112781954887 | 266 | 36 | 99 | 5 | 1 | 264 | 26023 | 25761 | MAG: Marine virus AFVG_25M84, complete genome | blastn | 652 | 259 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marine virus AFVG_25M84 | |||||
| 27257303 | 27257303 | PRJNA1102048_P_NODE_15123_length_246_cov_0.890173_g15019_i0 | PRJNA1102048 | 15123 | 246 | 0.890173 | 2.18982558 | uncultured Mediterranean phage uvMED | 1407671 | Viruses | Viruses | 169 | 1.25e-46 | NR | BAR35078.1 | 1407671 | g15019 | i0 | 97.6 | 1 | 82 | 2 | 100 | 0 | 1 | 246 | 493 | 574 | BAR35078.1 DNA polymerase elongation subunit (family B) (PolB) [uncultured Mediterranean phage uvMED] | diamond | 246 | 169 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | uncultured Mediterranean phage uvMED | |||||
| 27478459 | 27478459 | PRJNA1102048_P_NODE_12883_length_251_cov_0.865169_g12779_i0 | PRJNA1102048 | 12883 | 251 | 0.865169 | 2.17157419 | Synechococcus phage S-SRM | 3060697 | Viruses | Viruses | 83.2 | 2.44e-16 | NR | YP_010670308.1 | 2781608 | g12779 | i0 | 57.8 | 1.99601593625498 | 83 | 34 | 99.2 | 1 | 3 | 251 | 1374 | 1455 | YP_010670308.1 baseplate wedge subunit [Synechococcus phage S-SRM01] | diamond | 501 | 83.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Kyanoviridae | Serangoonvirus | Serangoonvirus essarone | ||
| 28488895 | 28488895 | PRJNA1102048_P_NODE_13887_length_249_cov_0.875000_g13783_i0 | PRJNA1102048 | 13887 | 249 | 0.875 | 2.17875 | Crassvirales sp. | 2960088 | Viruses | Viruses | 59.7 | 3.94e-8 | NR | DAU59201.1 | 2960088 | g13783 | i0 | 50 | 1.87951807228916 | 52 | 26 | 62.7 | 0 | 14 | 169 | 322 | 373 | DAU59201.1 MAG TPA: intron associated endonuclease [Crassvirales sp.] | diamond | 468 | 59.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Crassvirales | Crassvirales sp. | ||||
| 29878248 | 29878248 | PRJNA1102048_P_NODE_12491_length_252_cov_1.424581_g12387_i0 | PRJNA1102048 | 12491 | 252 | 1.424581 | 3.58994412 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 122 | 3.34e-30 | NR | CAB5238816.1 | 2100421 | g12387 | i0 | 71.4 | 4 | 84 | 24 | 100 | 0 | 252 | 1 | 552 | 635 | CAB5238816.1 bifunctional 3'-5' exonuclease/DNA polymerase [uncultured Caudovirales phage] | diamond | 1008 | 122 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31363408 | 31363408 | PRJNA1102048_P_NODE_12836_length_251_cov_0.865169_g12732_i0 | PRJNA1102048 | 12836 | 251 | 0.865169 | 2.17157419 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 56.6 | 4.23e-7 | NR | CAB4143366.1 | 2100421 | g12732 | i0 | 71.4 | 0.657370517928287 | 28 | 8 | 33.5 | 0 | 3 | 86 | 256 | 283 | CAB4143366.1 hypothetical protein UFOVP449_170 [uncultured Caudovirales phage] | diamond | 165 | 56.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31521534 | 31521534 | PRJNA1102048_P_NODE_17256_length_242_cov_0.911243_g17152_i0 | PRJNA1102048 | 17256 | 242 | 0.911243 | 2.20520806 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 91.3 | 8.360000000000001e-21 | NR | CAB4133252.1 | 2100421 | g17152 | i0 | 54.4 | 1.99586776859504 | 79 | 33 | 94.2 | 1 | 229 | 2 | 63 | 141 | CAB4133252.1 hypothetical protein UFOVP250_89 [uncultured Caudovirales phage] | diamond | 483 | 91.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch |
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);;