contig_metadata
13 rows where bioproject = "PRJNA168635" and tax_kingdom = "Shotokuvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8017764 | 8017764 | PRJNA168635_P_NODE_19127_length_185_cov_2.808824_g18711_i0 | PRJNA168635 | 19127 | 185 | 2.808824 | 5.1963244 | Tick-associated circular virus-2 | 2951484 | Viruses | Viruses | 339 | 1.08e-88 | NTclustered | gi|2263979286|gb|ON456885.1| | 2951484 | g18711 | i0 | 100 | 0.989189189189189 | 183 | 0 | 99 | 0 | 3 | 185 | 1475 | 1293 | Tick-associated circular virus-2 isolate Tick114CressC5, complete genome | blastn | 183 | 339 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Tick-associated circular virus-2 | |||
| 17631936 | 17631936 | PRJNA168635_P_NODE_30454_length_163_cov_2.728070_g30038_i0 | PRJNA168635 | 30454 | 163 | 2.72807 | 4.4467541 | Viruses | 10239 | Viruses | Viruses | 283 | 4.43e-72 | NTclustered | gi|1397590996|gb|MH425513.1| | 2217875 | g30038 | i0 | 100 | 4.68711656441718 | 153 | 0 | 94 | 0 | 11 | 163 | 319 | 167 | MAG: Humpback whale blow-associated circo-like virus 2 replication initiation protein gene, complete cds | blastn | 764 | 283 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Humpback whale blow-associated circo-like virus 2 | |||
| 18215992 | 18215992 | PRJNA168635_P_NODE_11695_length_239_cov_5.110526_g11279_i0 | PRJNA168635 | 11695 | 239 | 5.110526 | 12.21415714 | Cirlivirales sp. | 2809008 | Viruses | Viruses | 403 | 5.15e-108 | NTclustered | gi|2906144154|gb|PQ646098.1| | 2809008 | g11279 | i0 | 98.261 | 0.96234309623431 | 230 | 4 | 96 | 0 | 1 | 230 | 1375 | 1604 | MAG: Cirlivirales sp. isolate k127_3115209 genomic sequence | blastn | 230 | 403 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Cirlivirales sp. | ||||
| 19490222 | 19490222 | PRJNA168635_P_NODE_11636_length_240_cov_1.931937_g11220_i0 | PRJNA168635 | 11636 | 240 | 1.931937 | 4.6366488 | Cirlivirales sp. | 2809008 | Viruses | Viruses | 351 | 1.9e-92 | NTclustered | gi|2906144154|gb|PQ646098.1| | 2809008 | g11220 | i0 | 93.991 | 0.970833333333333 | 233 | 13 | 97 | 1 | 8 | 239 | 2107 | 1875 | MAG: Cirlivirales sp. isolate k127_3115209 genomic sequence | blastn | 233 | 351 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Cirlivirales sp. | ||||
| 20180268 | 20180268 | PRJNA168635_P_NODE_19976_length_182_cov_2.872180_g19560_i0 | PRJNA168635 | 19976 | 182 | 2.87218 | 5.2273676 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 337 | 3.82e-88 | NTclustered | gi|530787446|ref|NC_022089.1| | 3003968 | g19560 | i0 | 100 | 15.9175824175824 | 182 | 0 | 100 | 0 | 1 | 182 | 230 | 411 | Parvovirus NIH-CQV putative 15-kDa protein, putative replication associated protein (rep), and putative capsid protein (cap) genes, complete cds | blastn | 2897 | 337 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Lineavirales | Oomyviridae | Nicoomyvirus | Fish-associated parvo-like hybrid virus | ||
| 20180282 | 20180282 | PRJNA168635_P_NODE_20976_length_179_cov_1.784615_g20560_i0 | PRJNA168635 | 20976 | 179 | 1.784615 | 3.19446085 | Nicoomyvirus | 3425078 | Viruses | Viruses | 267 | 4.9699999999999996e-67 | NTclustered | gi|530787446|ref|NC_022089.1| | 1341019 | g20560 | i0 | 98.667 | 12.5698324022346 | 150 | 2 | 84 | 0 | 10 | 159 | 3067 | 2918 | Parvovirus NIH-CQV putative 15-kDa protein, putative replication associated protein (rep), and putative capsid protein (cap) genes, complete cds | blastn | 2250 | 267 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Lineavirales | Oomyviridae | Nicoomyvirus | Nicoomyvirus moldensis | ||
| 20765830 | 20765830 | PRJNA168635_P_NODE_11797_length_238_cov_2.894180_g11381_i0 | PRJNA168635 | 11797 | 238 | 2.89418 | 6.8881484 | Cirlivirales sp. | 2809008 | Viruses | Viruses | 281 | 2.5e-71 | NTclustered | gi|2906144154|gb|PQ646098.1| | 2809008 | g11381 | i0 | 90.952 | 0.882352941176471 | 210 | 17 | 87 | 2 | 1 | 208 | 882 | 673 | MAG: Cirlivirales sp. isolate k127_3115209 genomic sequence | blastn | 210 | 281 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Cirlivirales sp. | ||||
| 24591025 | 24591025 | PRJNA168635_P_NODE_7600_length_306_cov_8.023346_g7188_i0 | PRJNA168635 | 7600 | 306 | 8.023346 | 24.55143876 | Luscinia sibilans parvo-like hybrid virus | 2794515 | Viruses | Viruses | 407 | 5.29e-109 | NTclustered | gi|2015373198|gb|MW046538.1| | 2794515 | g7188 | i0 | 91.03 | 1.3202614379085 | 301 | 27 | 98 | 0 | 1 | 301 | 1069 | 1369 | MAG: Luscinia sibilans parvo-like hybrid virus isolate rtr167par08 genomic sequence, sequence | blastn | 404 | 407 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Luscinia sibilans parvo-like hybrid virus | |||
| 26662097 | 26662097 | PRJNA168635_P_NODE_34021_length_156_cov_2.607477_g33605_i0 | PRJNA168635 | 34021 | 156 | 2.607477 | 4.06766412 | Mute swan feces associated circular virus 14 | 2832264 | Viruses | Viruses | 50.1 | 2.79e-5 | NR | QUS52617.1 | 2832264 | g33605 | i0 | 41.2 | 0.980769230769231 | 51 | 30 | 98.1 | 0 | 155 | 3 | 118 | 168 | QUS52617.1 replication protein [Mute swan feces associated circular virus 14] | diamond | 153 | 50.1 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Gredzevirales | Ouroboviridae | Aretevirus | Aretevirus swances | ||
| 28021626 | 28021626 | PRJNA168635_P_NODE_24025_length_171_cov_3.057377_g23609_i0 | PRJNA168635 | 24025 | 171 | 3.057377 | 5.22811467 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 42.4 | 0.0189 | NR | QTZ83196.1 | 3003968 | g23609 | i0 | 90 | 0.350877192982456 | 20 | 2 | 35.1 | 0 | 3 | 62 | 310 | 329 | QTZ83196.1 MAG: capsid protein [Grus japonensis parvo-like hybrid virus] | diamond | 60 | 42.4 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Lineavirales | Oomyviridae | Nicoomyvirus | Fish-associated parvo-like hybrid virus | ||
| 28558367 | 28558367 | PRJNA168635_P_NODE_21627_length_177_cov_2.398438_g21211_i0 | PRJNA168635 | 21627 | 177 | 2.398438 | 4.24523526 | Luscinia sibilans parvo-like hybrid virus | 2794515 | Viruses | Viruses | 95.1 | 4.88e-21 | NR | QTE03983.1 | 2794515 | g21211 | i0 | 75.9 | 0.983050847457627 | 58 | 14 | 98.3 | 0 | 177 | 4 | 248 | 305 | QTE03983.1 MAG: capsid protein, partial [Luscinia sibilans parvo-like hybrid virus] | diamond | 174 | 95.1 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Luscinia sibilans parvo-like hybrid virus | |||
| 30705694 | 30705694 | PRJNA168635_P_NODE_10654_length_252_cov_13.955665_g10239_i0 | PRJNA168635 | 10654 | 252 | 13.955665 | 35.1682758 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 129 | 2.82e-34 | NR | WAE43063.1 | 2748378 | g10239 | i0 | 69.1 | 0.964285714285714 | 81 | 25 | 96.4 | 0 | 2 | 244 | 20 | 100 | WAE43063.1 MAG: replication associated protein [Cressdnaviricota sp.] | diamond | 243 | 129 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 31432715 | 31432715 | PRJNA168635_P_NODE_31416_length_162_cov_4.079646_g31000_i0 | PRJNA168635 | 31416 | 162 | 4.079646 | 6.60902652 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 63.5 | 4.2e-10 | NR | QKN88869.1 | 2748378 | g31000 | i0 | 54.7 | 2.90740740740741 | 53 | 24 | 98.1 | 0 | 161 | 3 | 200 | 252 | QKN88869.1 MAG: replication-associated protein [Cressdnaviricota sp.] | diamond | 471 | 63.5 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota 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);;