contig_metadata
5 rows where bioproject = "PRJNA1148190" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2849946 | 2849946 | PRJNA1148190_P_NODE_692703_length_245_cov_3.180233_g681530_i0 | PRJNA1148190 | 692703 | 245 | 3.180233 | 7.79157085 | Viruses | 10239 | Viruses | Viruses | 108 | 1.34e-27 | NR | QTE03962.1 | 2794463 | g681530 | i0 | 73.4 | 3.18367346938776 | 64 | 17 | 78.4 | 0 | 40 | 231 | 62 | 125 | QTE03962.1 MAG: replication protein, partial [Accipiter gentilis parvoviridae sp.] | diamond | 780 | 108 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Accipiter gentilis parvoviridae sp. | |||
| 23250727 | 23250727 | PRJNA1148190_P_NODE_646639_length_248_cov_0.880000_g635466_i0 | PRJNA1148190 | 646639 | 248 | 0.88 | 2.1824 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 198 | 2.7199999999999993e-46 | NTclustered | gi|2413975755|gb|OP933681.1| | 1940570 | g635466 | i0 | 84.286 | 0.846774193548387 | 210 | 25 | 83 | 7 | 7 | 212 | 3366 | 3571 | MAG: Parvoviridae sp. isolate fi099par3 replication protein and capsid protein genes, complete cds | blastn | 210 | 198 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 27387672 | 27387672 | PRJNA1148190_P_NODE_573563_length_252_cov_2.039106_g562390_i0 | PRJNA1148190 | 573563 | 252 | 2.039106 | 5.13854712 | Emberiza spodocephala parvoviridae sp. | 2794481 | Viruses | Viruses | 76.3 | 6.5e-14 | NR | QTE03789.1 | 2794481 | g562390 | i0 | 52.1 | 0.845238095238095 | 71 | 29 | 78.6 | 1 | 236 | 39 | 258 | 328 | QTE03789.1 MAG: structural protein [Emberiza spodocephala parvoviridae sp.] | diamond | 213 | 76.3 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Emberiza spodocephala parvoviridae sp. | |||
| 28208063 | 28208063 | PRJNA1148190_P_NODE_43846_length_941_cov_1.563364_g33267_i0 | PRJNA1148190 | 43846 | 941 | 1.563364 | 14.71125524 | Emberiza spodocephala parvoviridae sp. | 2794481 | Viruses | Viruses | 164 | 9.33e-42 | NR | QTE03789.1 | 2794481 | g33267 | i0 | 47.4 | 0.67268862911796 | 211 | 106 | 65.7 | 3 | 1 | 618 | 501 | 711 | QTE03789.1 MAG: structural protein [Emberiza spodocephala parvoviridae sp.] | diamond | 633 | 164 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Emberiza spodocephala parvoviridae sp. | |||
| 31367117 | 31367117 | PRJNA1148190_P_NODE_515496_length_263_cov_2.521053_g504323_i0 | PRJNA1148190 | 515496 | 263 | 2.521053 | 6.63036939 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 63.9 | 1.58e-9 | NR | XNT20749.1 | 1940570 | g504323 | i0 | 44.2 | 0.878326996197719 | 77 | 39 | 83.3 | 2 | 38 | 256 | 24 | 100 | XNT20749.1 MAG: replication protein [Parvoviridae sp.] | diamond | 231 | 63.9 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae 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);;