contig_metadata
22 rows where bioproject = "PRJNA784979" and tax_phylum = "Cressdnaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3316819 | 3316819 | PRJNA784979_S_NODE_343_length_2132_cov_56.326932_g339_i0 | PRJNA784979 | 343 | 2132 | 56.326932 | 1200.89019024 | Reagent-associated CRESS-like virus 2 | 2875810 | Viruses | Viruses | 3408 | 0 | NTclustered | gi|2094552987|gb|MZ824236.1| | 2875810 | g339 | i0 | 100 | 6.38696060037523 | 1845 | 0 | 100 | 0 | 288 | 2132 | 2377 | 533 | Reagent-associated CRESS-like virus 2 isolate 8 replicase-like gene, partial sequence | blastn | 13617 | 3408 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 2 | ||||||
| 3316852 | 3316852 | PRJNA784979_S_NODE_883_length_600_cov_1.500907_g843_i0 | PRJNA784979 | 883 | 600 | 1.500907 | 9.005442 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 347 | 9.939999999999996e-119 | NR | WAE43074.1 | 2748378 | g843 | i0 | 78.8 | 0.99 | 198 | 42 | 99 | 0 | 598 | 5 | 73 | 270 | WAE43074.1 MAG: replication associated protein [Cressdnaviricota sp.] | diamond | 594 | 347 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 7144043 | 7144043 | PRJNA784979_S_NODE_6566_length_195_cov_1.363014_g6524_i0 | PRJNA784979 | 6566 | 195 | 1.363014 | 2.6578773 | Cynopterus sphinx circular DNA virus 10 | 3064083 | Viruses | Viruses | 246 | 7.2e-61 | NTclustered | gi|2593361801|gb|OQ351951.1| | 3064083 | g6524 | i0 | 90.761 | 0.943589743589744 | 184 | 17 | 94 | 0 | 5 | 188 | 1489 | 1672 | MAG: Cynopterus sphinx circular DNA virus 10 isolate B468G10 genomic sequence | blastn | 184 | 246 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cynopterus sphinx circular DNA virus 10 | ||||||
| 8418678 | 8418678 | PRJNA784979_S_NODE_4627_length_221_cov_2.412791_g4585_i0 | PRJNA784979 | 4627 | 221 | 2.412791 | 5.33226811 | Galvornvirus isengard | 2955925 | Viruses | Viruses | 86.1 | 1.93e-12 | NTclustered | gi|2302011143|gb|MT202679.1| | 1954248 | g4585 | i0 | 87.838 | 0.334841628959276 | 74 | 8 | 33 | 1 | 143 | 216 | 1885 | 1957 | MAG: Circoviridae sp. isolate CN23_L15_3196, complete genome | blastn | 74 | 86.1 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 12245111 | 12245111 | PRJNA784979_S_NODE_12770_length_162_cov_0.938053_g12728_i0 | PRJNA784979 | 12770 | 162 | 0.938053 | 1.51964586 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 296 | 5.64e-76 | NTclustered | gi|1436211682|gb|MH617353.1| | 2748378 | g12728 | i0 | 100 | 1.61728395061728 | 160 | 0 | 99 | 0 | 3 | 162 | 5541 | 5700 | MAG: Cressdnaviricota sp. isolate ctce741, complete genome | blastn | 262 | 296 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 13519337 | 13519337 | PRJNA784979_S_NODE_2171_length_315_cov_2.172932_g2129_i0 | PRJNA784979 | 2171 | 315 | 2.172932 | 6.8447358 | Cynopterus sphinx circular DNA virus 10 | 3064083 | Viruses | Viruses | 259 | 1.6200000000000003e-64 | NTclustered | gi|2593361801|gb|OQ351951.1| | 3064083 | g2129 | i0 | 82.075 | 1.00952380952381 | 318 | 44 | 97 | 6 | 9 | 315 | 828 | 1143 | MAG: Cynopterus sphinx circular DNA virus 10 isolate B468G10 genomic sequence | blastn | 318 | 259 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cynopterus sphinx circular DNA virus 10 | ||||||
| 13519353 | 13519353 | PRJNA784979_S_NODE_6251_length_199_cov_0.866667_g6209_i0 | PRJNA784979 | 6251 | 199 | 0.866667 | 1.72466733 | Cirlivirales sp. | 2809008 | Viruses | Viruses | 63.9 | 7.98e-6 | NTclustered | gi|2906154851|gb|PQ646830.1| | 2809008 | g6209 | i0 | 100 | 0.517587939698492 | 34 | 0 | 17 | 0 | 12 | 45 | 2537 | 2570 | MAG: Cirlivirales sp. isolate k127_3981985 genomic sequence | blastn | 103 | 63.9 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Cirlivirales sp. | ||||
| 18617143 | 18617143 | PRJNA784979_S_NODE_9795_length_169_cov_1.808333_g9753_i0 | PRJNA784979 | 9795 | 169 | 1.808333 | 3.05608277 | Cirlivirales sp. | 2809008 | Viruses | Viruses | 69.4 | 1.4e-7 | NTclustered | gi|2906154851|gb|PQ646830.1| | 2809008 | g9753 | i0 | 86.154 | 1.02366863905325 | 65 | 8 | 38 | 1 | 79 | 142 | 2542 | 2606 | MAG: Cirlivirales sp. isolate k127_3981985 genomic sequence | blastn | 173 | 69.4 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Cirlivirales sp. | ||||
| 26705232 | 26705232 | PRJNA784979_S_NODE_2441_length_294_cov_1.469388_g2399_i0 | PRJNA784979 | 2441 | 294 | 1.469388 | 4.32000072 | Cynopterus sphinx circular DNA virus 1 | 3064082 | Viruses | Viruses | 133 | 4.02e-36 | NR | WOE49740.1 | 3064083 | g2399 | i0 | 66 | 0.959183673469388 | 94 | 32 | 95.9 | 0 | 283 | 2 | 1 | 94 | WOE49740.1 MAG: putative replicase protein [Cynopterus sphinx circular DNA virus 10] | diamond | 282 | 133 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cynopterus sphinx circular DNA virus 10 | ||||||
| 26832178 | 26832178 | PRJNA784979_S_NODE_9541_length_171_cov_1.040984_g9499_i0 | PRJNA784979 | 9541 | 171 | 1.040984 | 1.78008264 | Parvo-like hybrid virus UC4 | 1395615 | Viruses | Viruses | 74.3 | 8.67e-14 | NR | QJI53854.1 | 1395615 | g9499 | i0 | 62.3 | 0.929824561403509 | 53 | 20 | 93 | 0 | 170 | 12 | 300 | 352 | QJI53854.1 MAG: replication protein [Parvo-like hybrid virus UC4] | diamond | 159 | 74.3 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Lineavirales | Oomyviridae | Nicoomyvirus | Nicoomyvirus moldensis | ||
| 27116640 | 27116640 | PRJNA784979_S_NODE_3122_length_262_cov_1.150235_g3080_i0 | PRJNA784979 | 3122 | 262 | 1.150235 | 3.0136157 | Parvo-like hybrid virus UC4 | 1395615 | Viruses | Viruses | 114 | 7.68e-28 | NR | QJI53849.1 | 1395615 | g3080 | i0 | 86 | 0.652671755725191 | 57 | 8 | 65.3 | 0 | 256 | 86 | 335 | 391 | QJI53849.1 MAG: replication protein [Parvo-like hybrid virus UC4] | diamond | 171 | 114 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Lineavirales | Oomyviridae | Nicoomyvirus | Nicoomyvirus moldensis | ||
| 27211482 | 27211482 | PRJNA784979_S_NODE_7802_length_183_cov_2.029851_g7760_i0 | PRJNA784979 | 7802 | 183 | 2.029851 | 3.71462733 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 45.4 | 0.00156 | NR | AXH77215.1 | 2748378 | g7760 | i0 | 42.3 | 3.27868852459016 | 52 | 29 | 83.6 | 1 | 30 | 182 | 110 | 161 | AXH77215.1 MAG: putative replication initiation protein [Cressdnaviricota sp.] | diamond | 600 | 45.4 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 27274949 | 27274949 | PRJNA784979_S_NODE_2923_length_270_cov_1.520362_g2881_i0 | PRJNA784979 | 2923 | 270 | 1.520362 | 4.1049774 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 44.3 | 0.013 | NR | WAE43074.1 | 2748378 | g2881 | i0 | 59.3 | 0.3 | 27 | 11 | 30 | 0 | 186 | 266 | 1 | 27 | WAE43074.1 MAG: replication associated protein [Cressdnaviricota sp.] | diamond | 81 | 44.3 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 27622485 | 27622485 | PRJNA784979_S_NODE_2244_length_309_cov_1.965385_g2202_i0 | PRJNA784979 | 2244 | 309 | 1.965385 | 6.07303965 | Cynopterus sphinx circular DNA virus 1 | 3064082 | Viruses | Viruses | 87 | 1.67e-17 | NR | WOE49739.1 | 3064083 | g2202 | i0 | 45.1 | 0.990291262135922 | 102 | 55 | 98.1 | 1 | 7 | 309 | 66 | 167 | WOE49739.1 MAG: putative capsid protein, partial [Cynopterus sphinx circular DNA virus 10] | diamond | 306 | 87 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cynopterus sphinx circular DNA virus 10 | ||||||
| 28032956 | 28032956 | PRJNA784979_S_NODE_1585_length_382_cov_1.576577_g1543_i0 | PRJNA784979 | 1585 | 382 | 1.576577 | 6.02252414 | Cynopterus sphinx circular DNA virus 1 | 3064082 | Viruses | Viruses | 223 | 7.32e-69 | NR | WOE49739.1 | 3064083 | g1543 | i0 | 86.3 | 0.973821989528796 | 124 | 17 | 97.4 | 0 | 11 | 382 | 253 | 376 | WOE49739.1 MAG: putative capsid protein, partial [Cynopterus sphinx circular DNA virus 10] | diamond | 372 | 223 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cynopterus sphinx circular DNA virus 10 | ||||||
| 28159324 | 28159324 | PRJNA784979_S_NODE_4025_length_233_cov_1.418478_g3983_i0 | PRJNA784979 | 4025 | 233 | 1.418478 | 3.30505374 | Cremevirales sp. | 2809069 | Viruses | Viruses | 89 | 4.16e-19 | NR | XOF00289.1 | 2809069 | g3983 | i0 | 48.1 | 2.94849785407725 | 77 | 40 | 99.1 | 0 | 3 | 233 | 147 | 223 | XOF00289.1 MAG: hypothetical protein [Cremevirales sp.] | diamond | 687 | 89 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cremevirales | Cremevirales sp. | ||||
| 29421863 | 29421863 | PRJNA784979_S_NODE_12709_length_162_cov_1.283186_g12667_i0 | PRJNA784979 | 12709 | 162 | 1.283186 | 2.07876132 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 72.4 | 2.95e-13 | NR | QTZ83196.1 | 3003968 | g12667 | i0 | 72.1 | 0.796296296296296 | 43 | 12 | 79.6 | 0 | 24 | 152 | 22 | 64 | QTZ83196.1 MAG: capsid protein [Grus japonensis parvo-like hybrid virus] | diamond | 129 | 72.4 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Lineavirales | Oomyviridae | Nicoomyvirus | Fish-associated parvo-like hybrid virus | ||
| 31001606 | 31001606 | PRJNA784979_S_NODE_12514_length_163_cov_0.877193_g12472_i0 | PRJNA784979 | 12514 | 163 | 0.877193 | 1.42982459 | Parvo-like hybrid virus UC4 | 1395615 | Viruses | Viruses | 42.4 | 0.0174 | NR | QJI53850.1 | 1395615 | g12472 | i0 | 38.9 | 0.993865030674847 | 54 | 29 | 92 | 1 | 4 | 153 | 157 | 210 | QJI53850.1 MAG: capsid protein [Parvo-like hybrid virus UC4] | diamond | 162 | 42.4 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Lineavirales | Oomyviridae | Nicoomyvirus | Nicoomyvirus moldensis | ||
| 31760372 | 31760372 | PRJNA784979_S_NODE_8237_length_180_cov_1.633588_g8195_i0 | PRJNA784979 | 8237 | 180 | 1.633588 | 2.9404584 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 47.8 | 2.7e-4 | NR | AXH74985.1 | 2748378 | g8195 | i0 | 33.9 | 0.933333333333333 | 56 | 36 | 93.3 | 1 | 174 | 7 | 100 | 154 | AXH74985.1 MAG: Rep [Cressdnaviricota sp.] | diamond | 168 | 47.8 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 31896163 | 31896163 | PRJNA784979_S_NODE_1137_length_487_cov_1.835616_g1095_i0 | PRJNA784979 | 1137 | 487 | 1.835616 | 8.93944992 | Viruses | 10239 | Viruses | Viruses | 107 | 9.36e-25 | NR | QGH73619.1 | 2656678 | g1095 | i0 | 37.2 | 2.87679671457906 | 164 | 92 | 94.9 | 3 | 18 | 479 | 4 | 166 | QGH73619.1 MAG: Rep protein [CRESS virus sp. ctWOo3] | diamond | 1401 | 107 | 1 | Viruses | CRESS viruses | Shotokuvirae | Cressdnaviricota | CRESS virus sp. ctWOo3 | |||||
| 32298640 | 32298640 | PRJNA784979_S_NODE_8339_length_179_cov_1.815385_g8297_i0 | PRJNA784979 | 8339 | 179 | 1.815385 | 3.24953915 | Cynopterus sphinx circular DNA virus 1 | 3064082 | Viruses | Viruses | 74.3 | 4.07e-14 | NR | WOE49740.1 | 3064083 | g8297 | i0 | 82.9 | 0.687150837988827 | 41 | 7 | 68.7 | 0 | 178 | 56 | 223 | 263 | WOE49740.1 MAG: putative replicase protein [Cynopterus sphinx circular DNA virus 10] | diamond | 123 | 74.3 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cynopterus sphinx circular DNA virus 10 | ||||||
| 32520017 | 32520017 | PRJNA784979_S_NODE_7039_length_190_cov_2.503546_g6997_i0 | PRJNA784979 | 7039 | 190 | 2.503546 | 4.7567374 | Cynopterus sphinx circular DNA virus 1 | 3064082 | Viruses | Viruses | 80.9 | 5.69e-16 | NR | WOE49739.1 | 3064083 | g6997 | i0 | 64.4 | 0.931578947368421 | 59 | 21 | 93.2 | 0 | 183 | 7 | 248 | 306 | WOE49739.1 MAG: putative capsid protein, partial [Cynopterus sphinx circular DNA virus 10] | diamond | 177 | 80.9 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cynopterus sphinx circular DNA virus 10 |
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);;