contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJEB64798" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3954499 | 3954499 | PRJEB64798_P_NODE_238664_length_155_cov_11.377358_g236898_i0 | PRJEB64798 | 238664 | 155 | 11.377358 | 17.6349049 | Microviridae sp. | 2202644 | Viruses | Viruses | 207 | 2.57e-49 | NTclustered | gi|1444874594|gb|MH572428.1| | 2202644 | g236898 | i0 | 96.063 | 2.45806451612903 | 127 | 5 | 82 | 0 | 5 | 131 | 127 | 1 | Microviridae sp. isolate SD_MC_67, complete genome | blastn | 381 | 207 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 7780621 | 7780621 | PRJEB64798_P_NODE_222627_length_161_cov_8.946429_g220861_i0 | PRJEB64798 | 222627 | 161 | 8.946429 | 14.40375069 | Microviridae sp. | 2202644 | Viruses | Viruses | 100 | 4.71e-17 | NTclustered | gi|1603903290|gb|MH617454.2| | 2202644 | g220861 | i0 | 95.385 | 2.91925465838509 | 65 | 0 | 39 | 2 | 72 | 133 | 2877 | 2813 | MAG: Microviridae sp. isolate ctig683, complete genome | blastn | 470 | 100 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 11606043 | 11606043 | PRJEB64798_P_NODE_180710_length_174_cov_2.736000_g178944_i0 | PRJEB64798 | 180710 | 174 | 2.736 | 4.76064 | Arizlama microvirus | 2859450 | Viruses | Viruses | 213 | 6.35e-51 | NTclustered | gi|2067847856|gb|MW697594.1| | 2859450 | g178944 | i0 | 89.349 | 3.90804597701149 | 169 | 18 | 97 | 0 | 1 | 169 | 2409 | 2577 | MAG: Arizlama microvirus isolate AZLM_26073, complete genome | blastn | 680 | 213 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Arizlama microvirus | |||
| 14155625 | 14155625 | PRJEB64798_P_NODE_157252_length_185_cov_1.227941_g155486_i0 | PRJEB64798 | 157252 | 185 | 1.227941 | 2.27169085 | Capybara microvirus Cap3_SP_645 | 2585486 | Viruses | Viruses | 235 | 1.46e-57 | NTclustered | gi|1655475599|gb|MK496823.1| | 2585486 | g155486 | i0 | 90.11 | 0.983783783783784 | 182 | 16 | 97 | 1 | 1 | 180 | 3964 | 4145 | Capybara microvirus Cap3_SP_645, complete genome | blastn | 182 | 235 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Capybara microvirus Cap3_SP_645 | |||
| 15430284 | 15430284 | PRJEB64798_P_NODE_203193_length_166_cov_8.623932_g201427_i0 | PRJEB64798 | 203193 | 166 | 8.623932 | 14.31572712 | Microviridae sp. | 2202644 | Viruses | Viruses | 226 | 7.739999999999998e-55 | NTclustered | gi|1444874594|gb|MH572428.1| | 2202644 | g201427 | i0 | 91.925 | 1.93975903614458 | 161 | 13 | 97 | 0 | 6 | 166 | 3909 | 3749 | Microviridae sp. isolate SD_MC_67, complete genome | blastn | 322 | 226 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 16703415 | 16703415 | PRJEB64798_P_NODE_126474_length_200_cov_6.298013_g124708_i0 | PRJEB64798 | 126474 | 200 | 6.298013 | 12.596026 | Microviridae sp. | 2202644 | Viruses | Viruses | 86.1 | 1.71e-12 | NTclustered | gi|2057031176|tpg|BK049077.1| | 2202644 | g124708 | i0 | 85.366 | 1.4 | 82 | 12 | 41 | 0 | 1 | 82 | 1810 | 1891 | MAG TPA_asm: Microviridae sp. isolate ctomy2, partial genome | blastn | 280 | 86.1 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 17979232 | 17979232 | PRJEB64798_P_NODE_188855_length_171_cov_1.385246_g187089_i0 | PRJEB64798 | 188855 | 171 | 1.385246 | 2.36877066 | Microviridae sp. | 2202644 | Viruses | Viruses | 76.8 | 8.5e-10 | NTclustered | gi|2216802331|gb|MW202853.1| | 2202644 | g187089 | i0 | 90 | 10.812865497076 | 60 | 4 | 35 | 2 | 112 | 171 | 1075 | 1018 | Microviridae sp. isolate ctxHn541, complete genome | blastn | 1849 | 76.8 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 23079211 | 23079211 | PRJEB64798_P_NODE_158839_length_184_cov_2.370370_g157073_i0 | PRJEB64798 | 158839 | 184 | 2.37037 | 4.3614808 | Microviridae sp. | 2202644 | Viruses | Viruses | 243 | 8.67e-60 | NTclustered | gi|2302019702|gb|MT206132.1| | 2202644 | g157073 | i0 | 93.293 | 3.08695652173913 | 164 | 11 | 89 | 0 | 5 | 168 | 2818 | 2655 | MAG: Microviridae sp. isolate CN7_L17_105, complete genome | blastn | 568 | 243 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 23079573 | 23079573 | PRJEB64798_P_NODE_182219_length_173_cov_6.250000_g180453_i0 | PRJEB64798 | 182219 | 173 | 6.25 | 10.8125 | Microviridae sp. | 2202644 | Viruses | Viruses | 52.8 | 0.015 | NTclustered | gi|2302011513|gb|MT202826.1| | 2202644 | g180453 | i0 | 100 | 0.161849710982659 | 28 | 0 | 16 | 0 | 146 | 173 | 3433 | 3460 | MAG: Microviridae sp. isolate CN7_L15_494, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae 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);;