contig_metadata
6 rows where bioproject = "PRJEB73599", tax_kingdom = "Orthornavirae" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3961275 | 3961275 | PRJEB73599_P_NODE_3844_length_355_cov_1.794479_g3558_i0 | PRJEB73599 | 3844 | 355 | 1.794479 | 6.37040045 | Tolivirales sp. | 2809914 | Viruses | Viruses | 538 | 2.109999999999999e-148 | NTclustered | gi|2647549764|gb|OR843730.1| | 2809914 | g3558 | i0 | 92.703 | 1.34647887323944 | 370 | 12 | 100 | 1 | 1 | 355 | 1812 | 2181 | Tolivirales sp. strain MR233-17E/3903 polyprotein, hypothetical protein, and structural protein genes, complete cds | blastn | 478 | 538 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 9062458 | 9062458 | PRJEB73599_P_NODE_5708_length_262_cov_1.811159_g5421_i0 | PRJEB73599 | 5708 | 262 | 1.811159 | 4.74523658 | Tolivirales sp. | 2809914 | Viruses | Viruses | 438 | 1.5699999999999999e-118 | NTclustered | gi|2647549764|gb|OR843730.1| | 2809914 | g5421 | i0 | 95.802 | 1.97328244274809 | 262 | 10 | 100 | 1 | 1 | 262 | 1096 | 1356 | Tolivirales sp. strain MR233-17E/3903 polyprotein, hypothetical protein, and structural protein genes, complete cds | blastn | 517 | 438 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 11613657 | 11613657 | PRJEB73599_P_NODE_2510_length_466_cov_2.073227_g2239_i0 | PRJEB73599 | 2510 | 466 | 2.073227 | 9.66123782 | Tolivirales sp. | 2809914 | Viruses | Viruses | 861 | 0 | NTclustered | gi|2647549764|gb|OR843730.1| | 2809914 | g2239 | i0 | 100 | 2.02145922746781 | 466 | 0 | 100 | 0 | 1 | 466 | 195 | 660 | Tolivirales sp. strain MR233-17E/3903 polyprotein, hypothetical protein, and structural protein genes, complete cds | blastn | 942 | 861 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 24361039 | 24361039 | PRJEB73599_P_NODE_9460_length_163_cov_1.149254_g9173_i0 | PRJEB73599 | 9460 | 163 | 1.149254 | 1.87328402 | Qianjiang tombus-like virus 116 | 3347776 | Viruses | Viruses | 126 | 7.89e-25 | NTclustered | gi|2806501001|gb|PQ054236.1| | 3347776 | g9173 | i0 | 81.646 | 1.51533742331288 | 158 | 23 | 95 | 5 | 9 | 163 | 1062 | 1216 | MAG: Qianjiang tombus-like virus 116 isolate QJ5MS217 genomic sequence | blastn | 247 | 126 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 116 | |||
| 28195352 | 28195352 | PRJEB73599_P_NODE_7726_length_198_cov_1.816568_g7439_i0 | PRJEB73599 | 7726 | 198 | 1.816568 | 3.59680464 | Viruses | 10239 | Viruses | Viruses | 56.2 | 3.46e-7 | NR | WRQ65340.1 | 2809914 | g7439 | i0 | 58.7 | 1.74242424242424 | 46 | 18 | 69.7 | 1 | 196 | 59 | 249 | 293 | WRQ65340.1 structural protein [Tolivirales sp.] | diamond | 345 | 56.6 | 0.992932862190813 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 30571024 | 30571024 | PRJEB73599_P_NODE_6633_length_230_cov_2.248756_g6346_i0 | PRJEB73599 | 6633 | 230 | 2.248756 | 5.1721388 | Qianjiang noda-like virus 156 | 3348530 | Viruses | Viruses | 103 | 1.67e-23 | NR | XHA86180.1 | 3348530 | g6346 | i0 | 71.4 | 1.83913043478261 | 70 | 20 | 91.3 | 0 | 228 | 19 | 790 | 859 | XHA86180.1 MAG: polyprotein [Qianjiang noda-like virus 156] | diamond | 423 | 103 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Qianjiang noda-like virus 156 |
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);;