contig_metadata
12 rows where bioproject = "PRJNA556992", tax_kingdom = "Sangervirae" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5628494 | 5628494 | PRJNA556992_P_NODE_153205_length_356_cov_1.710247_g151017_i0 | PRJNA556992 | 153205 | 356 | 1.710247 | 6.08847932 | Microviridae sp. | 2202644 | Viruses | Viruses | 505 | 2.15e-138 | NTclustered | gi|2057883726|tpg|BK050880.1| | 2202644 | g151017 | i0 | 92.179 | 4.00561797752809 | 358 | 26 | 100 | 1 | 1 | 356 | 1216 | 859 | MAG TPA_asm: Microviridae sp. isolate ct5wH15, partial genome | blastn | 1426 | 505 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 5631242 | 5631242 | PRJNA556992_P_NODE_334625_length_284_cov_1.459716_g332436_i0 | PRJNA556992 | 334625 | 284 | 1.459716 | 4.14559344 | Microvirus D_HF6_100 | 3071187 | Viruses | Viruses | 381 | 2.9399999999999995e-101 | NTclustered | gi|2566892290|gb|OR149007.1| | 3071187 | g332436 | i0 | 90.845 | 3 | 284 | 26 | 100 | 0 | 1 | 284 | 1727 | 1444 | Microvirus D_HF6_100, complete genome | blastn | 852 | 381 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus D_HF6_100 | |||
| 14550895 | 14550895 | PRJNA556992_P_NODE_100552_length_404_cov_5.069486_g98368_i0 | PRJNA556992 | 100552 | 404 | 5.069486 | 20.48072344 | Wigfec virus K19_94 | 2985971 | Viruses | Viruses | 172 | 4.31e-49 | NR | UYD39188.1 | 2985971 | g98368 | i0 | 60.5 | 0.920792079207921 | 124 | 49 | 92.1 | 0 | 1 | 372 | 235 | 358 | UYD39188.1 MAG: replication initiator protein [Wigfec virus K19_94] | diamond | 372 | 172 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Wigfec virus K19_94 | |||
| 18379248 | 18379248 | PRJNA556992_P_NODE_341875_length_283_cov_1.738095_g339686_i0 | PRJNA556992 | 341875 | 283 | 1.738095 | 4.91880885 | Microvirus sp. | 2202559 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1832329955|gb|MT309986.1| | 2202559 | g339686 | i0 | 100 | 0.106007067137809 | 30 | 0 | 11 | 0 | 191 | 220 | 4280 | 4309 | MAG: Microvirus sp. isolate BS1_350, complete genome | blastn | 30 | 56.5 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 26666707 | 26666707 | PRJNA556992_P_NODE_362561_length_280_cov_20.173913_g360372_i0 | PRJNA556992 | 362561 | 280 | 20.173913 | 56.4869564 | Sedum sarmentosum microvirus | 2740151 | Viruses | Viruses | 110 | 3.9e-26 | NR | QKI28954.1 | 2740151 | g360372 | i0 | 66.3 | 0.921428571428571 | 86 | 29 | 92.1 | 0 | 258 | 1 | 5 | 90 | QKI28954.1 VP2 [Sedum sarmentosum microvirus] | diamond | 258 | 110 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Sedum sarmentosum microvirus | |||
| 27267990 | 27267990 | PRJNA556992_P_NODE_164503_length_348_cov_2.585455_g162315_i0 | PRJNA556992 | 164503 | 348 | 2.585455 | 8.9973834 | Sedum sarmentosum microvirus | 2740151 | Viruses | Viruses | 189 | 5.939999999999999e-55 | NR | QKI28952.1 | 2740151 | g162315 | i0 | 72.2 | 0.991379310344828 | 115 | 32 | 99.1 | 0 | 347 | 3 | 396 | 510 | QKI28952.1 VP1 [Sedum sarmentosum microvirus] | diamond | 345 | 189 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Sedum sarmentosum microvirus | |||
| 28215032 | 28215032 | PRJNA556992_P_NODE_106786_length_397_cov_2.537037_g104602_i0 | PRJNA556992 | 106786 | 397 | 2.537037 | 10.07203689 | Sedum sarmentosum microvirus | 2740151 | Viruses | Viruses | 129 | 7.38e-33 | NR | QKI28954.1 | 2740151 | g104602 | i0 | 57.7 | 0.982367758186398 | 130 | 55 | 98.2 | 0 | 392 | 3 | 96 | 225 | QKI28954.1 VP2 [Sedum sarmentosum microvirus] | diamond | 390 | 129 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Sedum sarmentosum microvirus | |||
| 28720896 | 28720896 | PRJNA556992_P_NODE_625107_length_257_cov_1.440217_g622918_i0 | PRJNA556992 | 625107 | 257 | 1.440217 | 3.70135769 | Microviridae sp. | 2202644 | Viruses | Viruses | 102 | 3.21e-23 | NR | AXH75328.1 | 2202644 | g622918 | i0 | 54.2 | 0.968871595330739 | 83 | 38 | 96.9 | 0 | 253 | 5 | 129 | 211 | AXH75328.1 MAG: major capsid protein [Microviridae sp.] | diamond | 249 | 102 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 30015271 | 30015271 | PRJNA556992_P_NODE_12511_length_946_cov_4.678121_g10873_i0 | PRJNA556992 | 12511 | 946 | 4.678121 | 44.25502466 | Sedum sarmentosum microvirus | 2740151 | Viruses | Viruses | 354 | 2.2300000000000003e-117 | NR | QKI28950.1 | 2740151 | g10873 | i0 | 57.1 | 1.00528541226216 | 317 | 126 | 99.9 | 3 | 946 | 2 | 44 | 352 | QKI28950.1 VP4 [Sedum sarmentosum microvirus] | diamond | 951 | 354 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Sedum sarmentosum microvirus | |||
| 30015287 | 30015287 | PRJNA556992_P_NODE_159371_length_351_cov_6.068345_g157183_i0 | PRJNA556992 | 159371 | 351 | 6.068345 | 21.29989095 | Sedum sarmentosum microvirus | 2740151 | Viruses | Viruses | 63.2 | 8.48e-9 | NR | QKI28952.1 | 2740151 | g157183 | i0 | 58.8 | 0.435897435897436 | 51 | 20 | 42.7 | 1 | 152 | 3 | 1 | 51 | QKI28952.1 VP1 [Sedum sarmentosum microvirus] | diamond | 153 | 63.2 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Sedum sarmentosum microvirus | |||
| 31183983 | 31183983 | PRJNA556992_P_NODE_23715_length_699_cov_5.396166_g21708_i0 | PRJNA556992 | 23715 | 699 | 5.396166 | 37.71920034 | Sedum sarmentosum microvirus | 2740151 | Viruses | Viruses | 249 | 2e-76 | NR | QKI28952.1 | 2740151 | g21708 | i0 | 67.8 | 0.759656652360515 | 177 | 52 | 75.5 | 3 | 43 | 570 | 60 | 232 | QKI28952.1 VP1 [Sedum sarmentosum microvirus] | diamond | 531 | 249 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Sedum sarmentosum microvirus | |||
| 31658575 | 31658575 | PRJNA556992_P_NODE_472997_length_269_cov_4.622449_g470808_i0 | PRJNA556992 | 472997 | 269 | 4.622449 | 12.43438781 | Sedum sarmentosum microvirus | 2740151 | Viruses | Viruses | 65.1 | 2.13e-11 | NR | QKI28953.1 | 2740151 | g470808 | i0 | 43.6 | 0.869888475836431 | 78 | 44 | 87 | 0 | 3 | 236 | 8 | 85 | QKI28953.1 hypothetical protein 1 [Sedum sarmentosum microvirus] | diamond | 234 | 65.1 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Sedum sarmentosum microvirus |
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);;