contig_metadata
12 rows where bioproject = "PRJNA340009", tax_kingdom = "Shotokuvirae" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6769607 | 6769607 | PRJNA340009_P_NODE_24646_length_247_cov_2.161616_g24339_i0 | PRJNA340009 | 24646 | 247 | 2.161616 | 5.33919152 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 134 | 1.06e-35 | NR | XNT21000.1 | 1940570 | g24339 | i0 | 74.4 | 3.98380566801619 | 82 | 20 | 99.6 | 1 | 2 | 247 | 229 | 309 | XNT21000.1 MAG: replication protein [Parvoviridae sp.] | diamond | 984 | 134 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 8045682 | 8045682 | PRJNA340009_P_NODE_62047_length_167_cov_0.864407_g61740_i0 | PRJNA340009 | 62047 | 167 | 0.864407 | 1.44355969 | Protoambidensovirus incertum3 | 3431910 | Viruses | Viruses | 167 | 4.79e-37 | NTclustered | gi|2742831367|gb|PP793395.1| | 2050976 | g61740 | i0 | 88.489 | 3.65868263473054 | 139 | 15 | 83 | 1 | 9 | 146 | 497 | 359 | MAG: Ambidensovirus sp. isolate 136_3958, partial genome | blastn | 611 | 167 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Protoambidensovirus | Protoambidensovirus incertum3 | ||
| 9319852 | 9319852 | PRJNA340009_P_NODE_12328_length_332_cov_1.862191_g12021_i0 | PRJNA340009 | 12328 | 332 | 1.862191 | 6.18247412 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 603 | 6.889999999999997e-168 | NTclustered | gi|2413975755|gb|OP933681.1| | 1940570 | g12021 | i0 | 99.398 | 1.54518072289157 | 332 | 2 | 100 | 0 | 1 | 332 | 1462 | 1131 | MAG: Parvoviridae sp. isolate fi099par3 replication protein and capsid protein genes, complete cds | blastn | 513 | 603 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 9320299 | 9320299 | PRJNA340009_P_NODE_48328_length_186_cov_1.489051_g48021_i0 | PRJNA340009 | 48328 | 186 | 1.489051 | 2.76963486 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 339 | 1.0899999999999998e-88 | NTclustered | gi|2413975755|gb|OP933681.1| | 1940570 | g48021 | i0 | 99.462 | 1 | 186 | 1 | 100 | 0 | 1 | 186 | 3309 | 3124 | MAG: Parvoviridae sp. isolate fi099par3 replication protein and capsid protein genes, complete cds | blastn | 186 | 339 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 9320417 | 9320417 | PRJNA340009_P_NODE_58888_length_171_cov_0.909836_g58581_i0 | PRJNA340009 | 58888 | 171 | 0.909836 | 1.55581956 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 159 | 8.199999999999998e-35 | NTclustered | gi|156598992|gb|EF579658.1| | 1891767 | g58581 | i0 | 86.755 | 0.883040935672515 | 151 | 11 | 88 | 4 | 11 | 161 | 2675 | 2534 | Simian virus 40 isolate SV40(Ad)191, complete genome | blastn | 151 | 159 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 9998110 | 9998110 | PRJNA340009_P_NODE_23448_length_252_cov_2.093596_g23141_i0 | PRJNA340009 | 23448 | 252 | 2.093596 | 5.27586192 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 65.9 | 2.9e-10 | NR | AAK29054.1 | 1891767 | g23141 | i0 | 72.7 | 0.523809523809524 | 44 | 12 | 52.4 | 0 | 188 | 57 | 494 | 537 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 132 | 65.9 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 10596000 | 10596000 | PRJNA340009_P_NODE_50009_length_183_cov_3.455224_g49702_i0 | PRJNA340009 | 50009 | 183 | 3.455224 | 6.32305992 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 333 | 4.97e-87 | NTclustered | gi|2413975755|gb|OP933681.1| | 1940570 | g49702 | i0 | 99.454 | 1 | 183 | 1 | 100 | 0 | 1 | 183 | 2116 | 1934 | MAG: Parvoviridae sp. isolate fi099par3 replication protein and capsid protein genes, complete cds | blastn | 183 | 333 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 15694619 | 15694619 | PRJNA340009_P_NODE_23073_length_254_cov_1.292683_g22766_i0 | PRJNA340009 | 23073 | 254 | 1.292683 | 3.28341482 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 355 | 1.57e-93 | NTclustered | gi|2413975755|gb|OP933681.1| | 1940570 | g22766 | i0 | 95.111 | 0.885826771653543 | 225 | 11 | 89 | 0 | 30 | 254 | 2538 | 2314 | MAG: Parvoviridae sp. isolate fi099par3 replication protein and capsid protein genes, complete cds | blastn | 225 | 355 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 22068310 | 22068310 | PRJNA340009_P_NODE_13378_length_321_cov_1.547794_g13071_i0 | PRJNA340009 | 13378 | 321 | 1.547794 | 4.96841874 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 390 | 5.62e-104 | NTclustered | gi|2413975755|gb|OP933681.1| | 1940570 | g13071 | i0 | 99.078 | 1.03738317757009 | 217 | 2 | 100 | 0 | 1 | 217 | 654 | 870 | MAG: Parvoviridae sp. isolate fi099par3 replication protein and capsid protein genes, complete cds | blastn | 333 | 390 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 23344544 | 23344544 | PRJNA340009_P_NODE_7999_length_396_cov_2.512968_g7692_i0 | PRJNA340009 | 7999 | 396 | 2.512968 | 9.95135328 | Parvoviridae sp. | 1940570 | Viruses | Viruses | 676 | 0 | NTclustered | gi|2413975755|gb|OP933681.1| | 1940570 | g7692 | i0 | 97.475 | 1 | 396 | 10 | 100 | 0 | 1 | 396 | 3110 | 2715 | MAG: Parvoviridae sp. isolate fi099par3 replication protein and capsid protein genes, complete cds | blastn | 396 | 676 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 28401162 | 28401162 | PRJNA340009_P_NODE_63946_length_166_cov_1.470085_g63639_i0 | PRJNA340009 | 63946 | 166 | 1.470085 | 2.4403411 | Luscinia sibilans parvo-like hybrid virus | 2794515 | Viruses | Viruses | 95.9 | 1.14e-21 | NR | QTE03982.1 | 2794515 | g63639 | i0 | 94.4 | 0.975903614457831 | 54 | 3 | 97.6 | 0 | 3 | 164 | 141 | 194 | QTE03982.1 MAG: replication protein [Luscinia sibilans parvo-like hybrid virus] | diamond | 162 | 95.9 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Luscinia sibilans parvo-like hybrid virus | |||
| 31844618 | 31844618 | PRJNA340009_P_NODE_33457_length_217_cov_1.285714_g33150_i0 | PRJNA340009 | 33457 | 217 | 1.285714 | 2.78999938 | Luscinia sibilans parvo-like hybrid virus | 2794515 | Viruses | Viruses | 117 | 1.47e-29 | NR | QTE03982.1 | 2794515 | g33150 | i0 | 88.3 | 0.829493087557604 | 60 | 7 | 82.9 | 0 | 212 | 33 | 335 | 394 | QTE03982.1 MAG: replication protein [Luscinia sibilans parvo-like hybrid virus] | diamond | 180 | 117 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Luscinia sibilans parvo-like hybrid virus |
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);;