contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1215774" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2881614 | 2881614 | PRJNA1215774_P_NODE_12843_length_610_cov_3.096834_g12527_i0 | PRJNA1215774 | 12843 | 610 | 3.096834 | 18.8906874 | Microviridae sp. | 2202644 | Viruses | Viruses | 481 | 6.499999999999998e-131 | NTclustered | gi|2057777496|tpg|BK054653.1| | 2202644 | g12527 | i0 | 81.23 | 12.0360655737705 | 618 | 96 | 99 | 18 | 1 | 608 | 3654 | 4261 | MAG TPA_asm: Microviridae sp. isolate ct9KH21, partial genome | blastn | 7342 | 481 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 5434008 | 5434008 | PRJNA1215774_P_NODE_25585_length_421_cov_2.054598_g25265_i0 | PRJNA1215774 | 25585 | 421 | 2.054598 | 8.64985758 | Microviridae sp. | 2202644 | Viruses | Viruses | 529 | 1.5399999999999996e-145 | NTclustered | gi|2059744875|tpg|BK026898.1| | 2202644 | g25265 | i0 | 89.499 | 22.7980997624703 | 419 | 42 | 99 | 2 | 4 | 421 | 5220 | 4803 | MAG TPA_asm: Microviridae sp. isolate ctbSo7, partial genome | blastn | 9598 | 529 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 6709333 | 6709333 | PRJNA1215774_P_NODE_73366_length_248_cov_0.880000_g73046_i0 | PRJNA1215774 | 73366 | 248 | 0.88 | 2.1824 | Microviridae sp. | 2202644 | Viruses | Viruses | 287 | 5.649999999999999e-73 | NTclustered | gi|2057973413|tpg|BK046613.1| | 2202644 | g73046 | i0 | 87.5 | 8.87903225806452 | 248 | 31 | 100 | 0 | 1 | 248 | 3429 | 3182 | MAG TPA_asm: Microviridae sp. isolate ctBCA5, partial genome | blastn | 2202 | 287 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 10534769 | 10534769 | PRJNA1215774_P_NODE_31809_length_375_cov_1.311258_g31489_i0 | PRJNA1215774 | 31809 | 375 | 1.311258 | 4.9172175 | Microviridae sp. ct6ut1 | 2824986 | Viruses | Viruses | 516 | 1.05e-141 | NTclustered | gi|2053171804|tpg|BK016118.1| | 2824986 | g31489 | i0 | 91.467 | 20.888 | 375 | 32 | 100 | 0 | 1 | 375 | 5460 | 5834 | MAG TPA_asm: Microviridae sp. ct6ut1, partial genome | blastn | 7833 | 516 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. ct6ut1 | |||
| 11809978 | 11809978 | PRJNA1215774_P_NODE_60450_length_270_cov_1.167513_g60130_i0 | PRJNA1215774 | 60450 | 270 | 1.167513 | 3.1522851 | Microviridae sp. | 2202644 | Viruses | Viruses | 466 | 7.46e-127 | NTclustered | gi|2054639204|tpg|BK051779.1| | 2202644 | g60130 | i0 | 97.778 | 13.8555555555556 | 270 | 6 | 100 | 0 | 1 | 270 | 2517 | 2248 | MAG TPA_asm: Microviridae sp. isolate ctav95, partial genome | blastn | 3741 | 466 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 19457021 | 19457021 | PRJNA1215774_P_NODE_37416_length_345_cov_1.382353_g37096_i0 | PRJNA1215774 | 37416 | 345 | 1.382353 | 4.76911785 | Microviridae sp. | 2202644 | Viruses | Viruses | 481 | 3.51e-131 | NTclustered | gi|2054639204|tpg|BK051779.1| | 2202644 | g37096 | i0 | 91.884 | 15.8028985507246 | 345 | 27 | 100 | 1 | 1 | 345 | 4485 | 4142 | MAG TPA_asm: Microviridae sp. isolate ctav95, partial genome | blastn | 5452 | 481 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 19457699 | 19457699 | PRJNA1215774_P_NODE_85896_length_231_cov_2.436709_g85576_i0 | PRJNA1215774 | 85896 | 231 | 2.436709 | 5.62879779 | Microviridae sp. | 2202644 | Viruses | Viruses | 337 | 5.09e-88 | NTclustered | gi|2058002168|tpg|BK047145.1| | 2202644 | g85576 | i0 | 93.043 | 31.9220779220779 | 230 | 16 | 99 | 0 | 1 | 230 | 2431 | 2202 | MAG TPA_asm: Microviridae sp. isolate ct0I81, partial genome | blastn | 7374 | 337 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 23282886 | 23282886 | PRJNA1215774_P_NODE_16439_length_536_cov_1.492441_g16120_i0 | PRJNA1215774 | 16439 | 536 | 1.492441 | 7.99948376 | Microviridae sp. | 2202644 | Viruses | Viruses | 771 | 0 | NTclustered | gi|2059752544|tpg|BK027604.1| | 2202644 | g16120 | i0 | 92.844 | 41.9944029850746 | 531 | 38 | 99 | 0 | 1 | 531 | 6378 | 5848 | MAG TPA_asm: Microviridae sp. isolate ctRB44, partial genome | blastn | 22509 | 771 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 23283665 | 23283665 | PRJNA1215774_P_NODE_73779_length_248_cov_0.880000_g73459_i0 | PRJNA1215774 | 73779 | 248 | 0.88 | 2.1824 | Microviridae sp. | 2202644 | Viruses | Viruses | 296 | 9.39e-76 | NTclustered | gi|2483596168|gb|OQ633105.1| | 2202644 | g73459 | i0 | 99.387 | 2.33467741935484 | 163 | 1 | 100 | 0 | 1 | 163 | 207 | 45 | MAG: Microviridae sp. isolate 34-01 major capsid protein gene, complete cds | blastn | 579 | 296 | 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);;