contig_metadata
13 rows where bioproject = "PRJNA885753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3793277 | 3793277 | PRJNA885753_S_NODE_2783_length_279_cov_2.242718_g2765_i0 | PRJNA885753 | 2783 | 279 | 2.242718 | 6.25718322 | root | 1 | Root_unresolved | Root_unresolved | 335 | 2.2799999999999993e-87 | NTclustered | gi|1377596870|gb|MF044052.1| | 10515 | g2765 | i0 | 100 | 92.6917562724014 | 181 | 0 | 92 | 0 | 18 | 198 | 33920 | 34100 | human adenovirus 2 isolate HK91, complete genome | blastn | 25861 | 335 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 8894218 | 8894218 | PRJNA885753_S_NODE_4227_length_246_cov_0.901734_g4209_i0 | PRJNA885753 | 4227 | 246 | 0.901734 | 2.21826564 | root | 1 | Root_unresolved | Root_unresolved | 455 | 1.4500000000000002e-123 | NTclustered | gi|2452971982|gb|OQ518311.1| | 10533 | g4209 | i0 | 100 | 100.073170731707 | 246 | 0 | 100 | 0 | 1 | 246 | 34296 | 34541 | Human adenovirus 1 isolate HAdV-C1/USA/2C6/2009, complete genome | blastn | 24618 | 455 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 11065286 | 11065286 | PRJNA885753_S_NODE_3929_length_249_cov_1.255682_g3911_i0 | PRJNA885753 | 3929 | 249 | 1.255682 | 3.12664818 | Eriocheir sinensis kita-like virus | 3022112 | Viruses | Viruses | 448 | 2.46e-121 | NTclustered | gi|2430285606|gb|OP019101.1| | 3022112 | g3911 | i0 | 99.197 | 1 | 249 | 1 | 100 | 1 | 1 | 249 | 12874 | 12627 | MAG: Eriocheir sinensis kita-like virus isolate Suqian, Jiangsu genomic sequence | blastn | 249 | 448 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Kitaviridae | Eriocheir sinensis kita-like virus | |||
| 19988366 | 19988366 | PRJNA885753_S_NODE_3556_length_254_cov_7.430939_g3538_i0 | PRJNA885753 | 3556 | 254 | 7.430939 | 18.87458506 | Orthoavulavirus javaense | 3051375 | Viruses | Viruses | 62.1 | 3.83e-5 | NTclustered | gi|1810954291|gb|MN727300.2| | 2560319 | g3538 | i0 | 100 | 0.12992125984252 | 33 | 0 | 13 | 0 | 1 | 33 | 15285 | 15253 | Avian paramyxovirus 1 isolate chicken/Indonesia/ITA/012WJ, complete genome | blastn | 33 | 62.1 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthoavulavirus | Orthoavulavirus javaense | ||
| 22918946 | 22918946 | PRJNA885753_S_NODE_2338_length_300_cov_1.030837_g2320_i0 | PRJNA885753 | 2338 | 300 | 1.030837 | 3.092511 | root | 1 | Root_unresolved | Root_unresolved | 555 | 1.7399999999999995e-153 | NTclustered | gi|1377596870|gb|MF044052.1| | 10515 | g2320 | i0 | 100 | 100 | 300 | 0 | 100 | 0 | 1 | 300 | 33184 | 32885 | human adenovirus 2 isolate HK91, complete genome | blastn | 30000 | 555 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 27340066 | 27340066 | PRJNA885753_S_NODE_3543_length_255_cov_1.170330_g3525_i0 | PRJNA885753 | 3543 | 255 | 1.17033 | 2.9843415 | Synechococcus phage S-CREM1 | 2982919 | Viruses | Viruses | 90.9 | 1.77e-20 | NR | UYA57495.1 | 2982919 | g3525 | i0 | 58.7 | 0.882352941176471 | 75 | 31 | 88.2 | 0 | 18 | 242 | 1 | 75 | UYA57495.1 loader of DNA helicase [Synechococcus phage S-CREM1] | diamond | 225 | 90.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Kyanoviridae | Synechococcus phage S-CREM1 | |||
| 27908007 | 27908007 | PRJNA885753_S_NODE_2545_length_290_cov_1.078341_g2527_i0 | PRJNA885753 | 2545 | 290 | 1.078341 | 3.1271889 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 85.9 | 8.45e-20 | NR | CAB4184887.1 | 2100421 | g2527 | i0 | 72.6 | 1.24137931034483 | 62 | 17 | 64.1 | 0 | 280 | 95 | 1 | 62 | CAB4184887.1 hypothetical protein UFOVP1116_44 [uncultured Caudovirales phage] | diamond | 360 | 85.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28223856 | 28223856 | PRJNA885753_S_NODE_1146_length_399_cov_1.128834_g1128_i0 | PRJNA885753 | 1146 | 399 | 1.128834 | 4.50404766 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 152 | 2.1e-40 | NR | CAB4148890.1 | 2100421 | g1128 | i0 | 61.9 | 4.09774436090226 | 139 | 46 | 99.2 | 2 | 397 | 2 | 4 | 142 | CAB4148890.1 COG4695 Phage-related protein [uncultured Caudovirales phage] | diamond | 1635 | 152 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28476652 | 28476652 | PRJNA885753_S_NODE_3966_length_249_cov_0.886364_g3948_i0 | PRJNA885753 | 3966 | 249 | 0.886364 | 2.20704636 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 119 | 1.76e-29 | NR | CAB4184372.1 | 2100421 | g3948 | i0 | 75.3 | 0.975903614457831 | 81 | 20 | 97.6 | 0 | 3 | 245 | 291 | 371 | CAB4184372.1 COG4653 Predicted phage phi-C31 gp36 major capsid-like protein [uncultured Caudovirales phage] | diamond | 243 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28926509 | 28926509 | PRJNA885753_S_NODE_4608_length_242_cov_0.911243_g4590_i0 | PRJNA885753 | 4608 | 242 | 0.911243 | 2.20520806 | root | 1 | Root_unresolved | Root_unresolved | 95.1 | 4.85e-22 | NR | WDS61225.1 | 753087 | g4590 | i0 | 55.7 | 9.76859504132231 | 79 | 35 | 97.9 | 0 | 238 | 2 | 1 | 79 | WDS61225.1 sliding clamp DNA polymerase accessory protein [Synechococcus phage S-BM3] | diamond | 2364 | 95.9 | 0.991657977059437 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Kyanoviridae | Synechococcus phage S-BM3 | |||
| 29518487 | 29518487 | PRJNA885753_S_NODE_4370_length_244_cov_0.912281_g4352_i0 | PRJNA885753 | 4370 | 244 | 0.912281 | 2.22596564 | Tombusviridae sp. | 2583950 | Viruses | Viruses | 84 | 6.91e-18 | NR | WWV89951.1 | 2583950 | g4352 | i0 | 52.7 | 0.909836065573771 | 74 | 33 | 91 | 1 | 244 | 23 | 73 | 144 | WWV89951.1 MAG: RNA polymerase, partial [Tombusviridae sp.] | diamond | 222 | 84 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Tombusviridae sp. | |||
| 30118526 | 30118526 | PRJNA885753_S_NODE_3092_length_268_cov_1.200000_g3074_i0 | PRJNA885753 | 3092 | 268 | 1.2 | 3.216 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 77 | 1.65e-14 | NR | CAB4148604.1 | 2100421 | g3074 | i0 | 44.2 | 0.962686567164179 | 86 | 48 | 96.3 | 0 | 258 | 1 | 145 | 230 | CAB4148604.1 hypothetical protein UFOVP524_20 [uncultured Caudovirales phage] | diamond | 258 | 77 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32276552 | 32276552 | PRJNA885753_S_NODE_3538_length_255_cov_1.241758_g3520_i0 | PRJNA885753 | 3538 | 255 | 1.241758 | 3.1664829 | root | 1 | Root_unresolved | Root_unresolved | 88.2 | 4.29e-18 | NR | BAR24318.1 | 1407671 | g3520 | i0 | 67.2 | 2.31764705882353 | 64 | 21 | 75.3 | 0 | 253 | 62 | 537 | 600 | BAR24318.1 terminase large subunit [uncultured Mediterranean phage uvMED] | diamond | 591 | 88.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | uncultured Mediterranean phage uvMED |
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);;