contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA642647" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1894220 | 1894220 | PRJNA642647_P_NODE_542_length_481_cov_4.254505_g493_i0 | PRJNA642647 | 542 | 481 | 4.254505 | 20.46416905 | Microviridae sp. | 2202644 | Viruses | Viruses | 259 | 2.5700000000000003e-64 | NTclustered | gi|1603903290|gb|MH617454.2| | 2202644 | g493 | i0 | 85.547 | 0.532224532224532 | 256 | 28 | 52 | 9 | 219 | 470 | 826 | 1076 | MAG: Microviridae sp. isolate ctig683, complete genome | blastn | 256 | 259 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 3168803 | 3168803 | PRJNA642647_P_NODE_223_length_737_cov_3.568571_g187_i0 | PRJNA642647 | 223 | 737 | 3.568571 | 26.30036827 | Microviridae sp. | 2202644 | Viruses | Viruses | 470 | 1.72e-127 | NTclustered | gi|1603903290|gb|MH617454.2| | 2202644 | g187 | i0 | 84.342 | 2.08005427408412 | 479 | 75 | 65 | 0 | 17 | 495 | 1316 | 838 | MAG: Microviridae sp. isolate ctig683, complete genome | blastn | 1533 | 470 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 4445662 | 4445662 | PRJNA642647_P_NODE_2144_length_235_cov_3.691919_g2094_i0 | PRJNA642647 | 2144 | 235 | 3.691919 | 8.67600965 | Microviridae sp. | 2202644 | Viruses | Viruses | 322 | 1.45e-83 | NTclustered | gi|2428721376|tpg|BK061429.1| | 2202644 | g2094 | i0 | 93.897 | 3.52765957446808 | 213 | 13 | 91 | 0 | 20 | 232 | 2499 | 2287 | TPA_asm: Microviridae sp. isolate reeWastUs1, complete genome | blastn | 829 | 322 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 5721546 | 5721546 | PRJNA642647_P_NODE_6165_length_154_cov_1.273504_g6115_i0 | PRJNA642647 | 6165 | 154 | 1.273504 | 1.96119616 | Microviridae sp. | 2202644 | Viruses | Viruses | 147 | 5.639999999999999e-31 | NTclustered | gi|2428721376|tpg|BK061429.1| | 2202644 | g6115 | i0 | 95.604 | 0.590909090909091 | 91 | 4 | 59 | 0 | 4 | 94 | 1918 | 2008 | TPA_asm: Microviridae sp. isolate reeWastUs1, complete genome | blastn | 91 | 147 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 6996531 | 6996531 | PRJNA642647_P_NODE_1966_length_247_cov_2.547619_g1916_i0 | PRJNA642647 | 1966 | 247 | 2.547619 | 6.29261893 | Microviridae sp. | 2202644 | Viruses | Viruses | 200 | 7.529999999999999e-47 | NTclustered | gi|1603903290|gb|MH617454.2| | 2202644 | g1916 | i0 | 83.568 | 0.862348178137652 | 213 | 35 | 86 | 0 | 12 | 224 | 4230 | 4018 | MAG: Microviridae sp. isolate ctig683, complete genome | blastn | 213 | 200 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 9546549 | 9546549 | PRJNA642647_P_NODE_1268_length_311_cov_3.021898_g1218_i0 | PRJNA642647 | 1268 | 311 | 3.021898 | 9.39810278 | Microviridae sp. | 2202644 | Viruses | Viruses | 311 | 4.34e-80 | NTclustered | gi|1603903290|gb|MH617454.2| | 2202644 | g1218 | i0 | 85.113 | 2.85852090032154 | 309 | 40 | 98 | 6 | 4 | 309 | 441 | 136 | MAG: Microviridae sp. isolate ctig683, complete genome | blastn | 889 | 311 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 17195957 | 17195957 | PRJNA642647_P_NODE_6294_length_152_cov_3.269565_g6244_i0 | PRJNA642647 | 6294 | 152 | 3.269565 | 4.9697388 | Arizlama microvirus | 2859450 | Viruses | Viruses | 104 | 3.38e-18 | NTclustered | gi|2067847829|gb|MW697590.1| | 2859450 | g6244 | i0 | 95.385 | 0.842105263157895 | 65 | 3 | 43 | 0 | 13 | 77 | 398 | 334 | MAG: Arizlama microvirus isolate AZLM_406, complete genome | blastn | 128 | 104 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Arizlama microvirus | |||
| 18470224 | 18470224 | PRJNA642647_P_NODE_215_length_760_cov_8.058091_g181_i0 | PRJNA642647 | 215 | 760 | 8.058091 | 61.2414916 | Microviridae sp. | 2202644 | Viruses | Viruses | 551 | 6.169999999999998e-152 | NTclustered | gi|1603903290|gb|MH617454.2| | 2202644 | g181 | i0 | 85.499 | 2.86578947368421 | 531 | 73 | 70 | 4 | 229 | 757 | 664 | 136 | MAG: Microviridae sp. isolate ctig683, complete genome | blastn | 2178 | 551 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 23570725 | 23570725 | PRJNA642647_P_NODE_4679_length_168_cov_6.022901_g4629_i0 | PRJNA642647 | 4679 | 168 | 6.022901 | 10.11847368 | Microvirus sp. | 2202559 | Viruses | Viruses | 176 | 8.03e-40 | NTclustered | gi|1832330608|gb|MT310076.1| | 2202559 | g4629 | i0 | 85.629 | 3.60714285714286 | 167 | 24 | 99 | 0 | 2 | 168 | 1374 | 1208 | MAG: Microvirus sp. isolate 6537_26, complete genome | blastn | 606 | 176 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. |
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);;