contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA1040136" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10372972 | 10372972 | PRJNA1040136_S_NODE_2009_length_262_cov_1.587302_g2006_i0 | PRJNA1040136 | 2009 | 262 | 1.587302 | 4.15873124 | Microvirus sp. | 2202559 | Viruses | Viruses | 220 | 6.19e-53 | NTclustered | gi|1832330121|gb|MT310010.1| | 2202559 | g2006 | i0 | 86.111 | 0.824427480916031 | 216 | 16 | 79 | 8 | 47 | 252 | 3001 | 2790 | MAG: Microvirus sp. isolate BS1_250, complete genome | blastn | 216 | 220 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 12923453 | 12923453 | PRJNA1040136_S_NODE_1251_length_301_cov_1.350877_g1248_i0 | PRJNA1040136 | 1251 | 301 | 1.350877 | 4.06613977 | Microvirus sp. | 2202559 | Viruses | Viruses | 484 | 2.3299999999999996e-132 | NTclustered | gi|1832330271|gb|MT310032.1| | 2202559 | g1248 | i0 | 95.681 | 3.04318936877076 | 301 | 13 | 100 | 0 | 1 | 301 | 3420 | 3120 | MAG: Microvirus sp. isolate 6538_62, complete genome | blastn | 916 | 484 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 16746716 | 16746716 | PRJNA1040136_S_NODE_1074_length_313_cov_0.962500_g1071_i0 | PRJNA1040136 | 1074 | 313 | 0.9625 | 3.012625 | Microviridae sp. | 2202644 | Viruses | Viruses | 163 | 1.3e-35 | NTclustered | gi|2906150692|gb|PQ646526.1| | 2202644 | g1071 | i0 | 87.586 | 1.54313099041534 | 145 | 13 | 45 | 4 | 17 | 158 | 3816 | 3674 | MAG: Microviridae sp. isolate k127_1321310 genomic sequence | blastn | 483 | 163 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 23122021 | 23122021 | PRJNA1040136_S_NODE_1879_length_267_cov_1.649485_g1876_i0 | PRJNA1040136 | 1879 | 267 | 1.649485 | 4.40412495 | Microviridae sp. | 2202644 | Viruses | Viruses | 320 | 6.07e-83 | NTclustered | gi|2302017686|gb|MT205519.1| | 2202644 | g1876 | i0 | 88.636 | 3.45692883895131 | 264 | 28 | 99 | 2 | 4 | 266 | 3948 | 3686 | MAG: Microviridae sp. isolate CN7_L16_647, complete genome | blastn | 923 | 320 | 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);;