contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA556992" and tax_phylum = "Cossaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19654700 | 19654700 | PRJNA556992_P_NODE_40976_length_554_cov_2.871102_g38831_i0 | PRJNA556992 | 40976 | 554 | 2.871102 | 15.90590508 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 304 | 5.090000000000001e-100 | NR | XNT21172.1 | 1940570 | g38831 | i0 | 76.6 | 3.985559566787 | 184 | 43 | 99.6 | 0 | 553 | 2 | 70 | 253 | XNT21172.1 MAG: replication protein [Parvoviridae sp.] | diamond | 2208 | 304 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 22204461 | 22204461 | PRJNA556992_P_NODE_33478_length_601_cov_4.880682_g31362_i0 | PRJNA556992 | 33478 | 601 | 4.880682 | 29.33289882 | Psittaciform aveparvovirus | 3042447 | Viruses | Viruses | 300 | 1.69e-98 | NR | XNT21000.1 | 3042447 | g31362 | i0 | 70.5 | 1.99667221297837 | 200 | 57 | 99.8 | 1 | 2 | 601 | 52 | 249 | XNT21000.1 MAG: replication protein [Parvoviridae sp.] | diamond | 1200 | 300 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Psittaciform aveparvovirus | |||
| 27204628 | 27204628 | PRJNA556992_P_NODE_277422_length_294_cov_1.393665_g275233_i0 | PRJNA556992 | 277422 | 294 | 1.393665 | 4.0973751 | parvo-like hybrid virus | 3367306 | Viruses | Viruses | 108 | 3.18e-25 | NR | XHS97069.1 | 3367306 | g275233 | i0 | 60.7 | 0.857142857142857 | 84 | 33 | 85.7 | 0 | 1 | 252 | 9 | 92 | XHS97069.1 capsid protein [parvo-like hybrid virus] | diamond | 252 | 108 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | parvo-like hybrid virus | |||
| 27710922 | 27710922 | PRJNA556992_P_NODE_72584_length_448_cov_4.661333_g70408_i0 | PRJNA556992 | 72584 | 448 | 4.661333 | 20.88277184 | Phoenicopteridae parvo-like hybrid virus | 2794528 | Viruses | Viruses | 63.2 | 2.29e-8 | NR | QTE03745.1 | 2794528 | g70408 | i0 | 32.9 | 0.9375 | 140 | 70 | 90.4 | 3 | 413 | 9 | 144 | 264 | QTE03745.1 MAG: hypothetical protein [Phoenicopteridae parvo-like hybrid virus] | diamond | 420 | 63.2 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Phoenicopteridae parvo-like hybrid virus | |||
| 28878309 | 28878309 | PRJNA556992_P_NODE_171788_length_343_cov_4.340741_g169600_i0 | PRJNA556992 | 171788 | 343 | 4.340741 | 14.88874163 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 107 | 9.499999999999999e-25 | NR | QKE54869.1 | 1940570 | g169600 | i0 | 53.9 | 0.778425655976676 | 89 | 40 | 77 | 1 | 315 | 52 | 262 | 350 | QKE54869.1 MAG: capsid protein [Parvoviridae sp.] | diamond | 267 | 107 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 29162869 | 29162869 | PRJNA556992_P_NODE_173069_length_343_cov_0.855556_g170881_i0 | PRJNA556992 | 173069 | 343 | 0.855556 | 2.93455708 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 190 | 9.13e-57 | NR | QKE54887.1 | 1940570 | g170881 | i0 | 80.7 | 5.98250728862974 | 114 | 22 | 99.7 | 0 | 342 | 1 | 281 | 394 | QKE54887.1 MAG: replication protein [Parvoviridae sp.] | diamond | 2052 | 190 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 30805018 | 30805018 | PRJNA556992_P_NODE_1062934_length_221_cov_7.635135_g1060744_i0 | PRJNA556992 | 1062934 | 221 | 7.635135 | 16.87364835 | Ambidensovirus sp. | 2050976 | Viruses | Viruses | 55.5 | 8.99e-7 | NR | AWV66974.1 | 2050976 | g1060744 | i0 | 58.7 | 1.289592760181 | 46 | 17 | 62.4 | 1 | 216 | 79 | 116 | 159 | AWV66974.1 Structural ORF, partial [Ambidensovirus sp.] | diamond | 285 | 55.5 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Protoambidensovirus | Protoambidensovirus incertum3 |
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);;