contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA800053" and tax_phylum = "Phixviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2071983 | 2071983 | PRJNA800053_P_NODE_19282_length_248_cov_0.880000_g19118_i0 | PRJNA800053 | 19282 | 248 | 0.88 | 2.1824 | Microviridae sp. | 2202644 | Viruses | Viruses | 95.3 | 3.67e-15 | NTclustered | gi|1603902424|gb|MH616660.2| | 2202644 | g19118 | i0 | 89.333 | 0.30241935483871 | 75 | 8 | 30 | 0 | 14 | 88 | 2513 | 2439 | MAG: Microviridae sp. isolate ctbb538, complete genome | blastn | 75 | 95.3 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 3347259 | 3347259 | PRJNA800053_P_NODE_22143_length_243_cov_2.476471_g21979_i0 | PRJNA800053 | 22143 | 243 | 2.476471 | 6.01782453 | Microviridae sp. | 2202644 | Viruses | Viruses | 174 | 4.48e-39 | NTclustered | gi|1436210819|gb|MH617304.1| | 2202644 | g21979 | i0 | 83.784 | 0.761316872427984 | 185 | 29 | 76 | 1 | 38 | 222 | 300 | 117 | MAG: Microviridae sp. isolate cthh626, complete genome | blastn | 185 | 174 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 5899720 | 5899720 | PRJNA800053_P_NODE_15965_length_259_cov_1.655914_g15801_i0 | PRJNA800053 | 15965 | 259 | 1.655914 | 4.28881726 | Microviridae sp. | 2202644 | Viruses | Viruses | 124 | 4.9299999999999996e-24 | NTclustered | gi|2906156024|gb|PQ646919.1| | 2202644 | g15801 | i0 | 92.308 | 2.12355212355212 | 91 | 2 | 34 | 5 | 154 | 242 | 3584 | 3497 | MAG: Microviridae sp. isolate k127_3884585 genomic sequence | blastn | 550 | 124 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 8449344 | 8449344 | PRJNA800053_P_NODE_5987_length_377_cov_1.957237_g5824_i0 | PRJNA800053 | 5987 | 377 | 1.957237 | 7.37878349 | Microvirus sp. | 2202559 | Viruses | Viruses | 126 | 2.09e-24 | NTclustered | gi|2581532587|gb|OR350095.1| | 2202559 | g5824 | i0 | 79.474 | 3.45623342175066 | 190 | 30 | 50 | 4 | 138 | 327 | 3629 | 3449 | MAG: Microvirus sp. isolate LSWO_57 clone LS328, complete genome | blastn | 1303 | 126 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 9724379 | 9724379 | PRJNA800053_P_NODE_8768_length_324_cov_1.816733_g8604_i0 | PRJNA800053 | 8768 | 324 | 1.816733 | 5.88621492 | Arizlama microvirus | 2859450 | Viruses | Viruses | 448 | 3.3199999999999993e-121 | NTclustered | gi|2067848116|gb|MW697638.1| | 2859450 | g8604 | i0 | 91.875 | 2.5679012345679 | 320 | 26 | 99 | 0 | 2 | 321 | 404 | 85 | MAG: Arizlama microvirus isolate AZLM_332, complete genome | blastn | 832 | 448 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Arizlama microvirus | |||
| 13549733 | 13549733 | PRJNA800053_P_NODE_10791_length_298_cov_4.231111_g10627_i0 | PRJNA800053 | 10791 | 298 | 4.231111 | 12.60871078 | Microviridae sp. | 2202644 | Viruses | Viruses | 307 | 5.3500000000000007e-79 | NTclustered | gi|1603903290|gb|MH617454.2| | 2202644 | g10627 | i0 | 85.424 | 3.08724832214765 | 295 | 43 | 99 | 0 | 4 | 298 | 428 | 134 | MAG: Microviridae sp. isolate ctig683, complete genome | blastn | 920 | 307 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 18647729 | 18647729 | PRJNA800053_P_NODE_23995_length_241_cov_0.916667_g23831_i0 | PRJNA800053 | 23995 | 241 | 0.916667 | 2.20916747 | Ariapismic virus 233 | 3376474 | Viruses | Viruses | 86.1 | 2.14e-12 | NTclustered | gi|2844714133|gb|PQ492015.1| | 3376474 | g23831 | i0 | 89.552 | 2.1701244813278 | 67 | 7 | 28 | 0 | 172 | 238 | 595 | 529 | MAG: Ariapismic virus 233 isolate HBTUC_9178, complete genome | blastn | 523 | 86.1 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Ariapismic virus 233 | |||
| 18647752 | 18647752 | PRJNA800053_P_NODE_6835_length_358_cov_3.140351_g6671_i0 | PRJNA800053 | 6835 | 358 | 3.140351 | 11.24245658 | Arizlama microvirus | 2859450 | Viruses | Viruses | 300 | 1.1e-76 | NTclustered | gi|2067848321|gb|MW697678.1| | 2859450 | g6671 | i0 | 82.941 | 1.07262569832402 | 340 | 50 | 94 | 7 | 20 | 355 | 4054 | 3719 | MAG: Arizlama microvirus isolate AZLM_281, complete genome | blastn | 384 | 300 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Arizlama 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);;