contig_metadata
18 rows where bioproject = "PRJNA602115" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 575720 | 575720 | PRJNA602115_P_NODE_5621_length_268_cov_1.342995_g5596_i0 | PRJNA602115 | 5621 | 268 | 1.342995 | 3.5992266 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 381 | 2.759999999999999e-101 | NTclustered | gi|2896100955|gb|PQ792342.1| | 2748378 | g5596 | i0 | 92.509 | 0.996268656716418 | 267 | 18 | 99 | 2 | 1 | 266 | 3168 | 2903 | MAG: Cressdnaviricota sp. isolate SbovineF090_cress11 genomic sequence | blastn | 267 | 381 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 1851414 | 1851414 | PRJNA602115_P_NODE_182_length_1372_cov_6.029748_g171_i0 | PRJNA602115 | 182 | 1372 | 6.029748 | 82.72814256 | Pavo cristatus CRESS-DNA-virus sp. | 2815049 | Viruses | Viruses | 171 | 2.06e-46 | NR | QTE03529.1 | 2815049 | g171 | i0 | 38.9 | 0.533527696793003 | 244 | 146 | 52.7 | 2 | 913 | 191 | 10 | 253 | QTE03529.1 MAG: capsid protein [Pavo cristatus CRESS-DNA-virus sp.] | diamond | 732 | 171 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Pavo cristatus CRESS-DNA-virus sp. | ||||||
| 5679416 | 5679416 | PRJNA602115_P_NODE_3185_length_340_cov_1.379928_g3160_i0 | PRJNA602115 | 3185 | 340 | 1.379928 | 4.6917552 | Wigfec virus K19_555 | 2986010 | Viruses | Viruses | 573 | 5.54e-159 | NTclustered | gi|2316504316|gb|OP549837.1| | 2986010 | g3160 | i0 | 97.059 | 1 | 340 | 10 | 100 | 0 | 1 | 340 | 479 | 818 | MAG: Wigfec virus K19_555, complete genome | blastn | 340 | 573 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Wigfec virus K19_555 | ||||||
| 10779952 | 10779952 | PRJNA602115_P_NODE_1549_length_478_cov_1.688249_g1524_i0 | PRJNA602115 | 1549 | 478 | 1.6882490000000001 | 8.06983022 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 258 | 4.999999999999999e-84 | NR | QJB18631.1 | 2202565 | g1524 | i0 | 82.6 | 1.01046025104603 | 161 | 26 | 99.8 | 1 | 478 | 2 | 41 | 201 | QJB18631.1 MAG: capsid protein [Genomoviridae sp.] | diamond | 483 | 258 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 10780046 | 10780046 | PRJNA602115_P_NODE_5369_length_274_cov_1.201878_g5344_i0 | PRJNA602115 | 5369 | 274 | 1.201878 | 3.29314572 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 460 | 3.53e-125 | NTclustered | gi|2896100955|gb|PQ792342.1| | 2748378 | g5344 | i0 | 99.603 | 0.91970802919708 | 252 | 1 | 92 | 0 | 1 | 252 | 1130 | 879 | MAG: Cressdnaviricota sp. isolate SbovineF090_cress11 genomic sequence | blastn | 252 | 460 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 12054949 | 12054949 | PRJNA602115_P_NODE_3410_length_330_cov_0.951673_g3385_i0 | PRJNA602115 | 3410 | 330 | 0.951673 | 3.1405209 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 516 | 9.17e-142 | NTclustered | gi|2896100955|gb|PQ792342.1| | 2748378 | g3385 | i0 | 94.848 | 1.19090909090909 | 330 | 17 | 100 | 0 | 1 | 330 | 3220 | 3549 | MAG: Cressdnaviricota sp. isolate SbovineF090_cress11 genomic sequence | blastn | 393 | 516 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 17153483 | 17153483 | PRJNA602115_P_NODE_6734_length_245_cov_1.043478_g6709_i0 | PRJNA602115 | 6734 | 245 | 1.043478 | 2.5565211 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 381 | 2.4799999999999995e-101 | NTclustered | gi|1832329329|gb|MT309858.1| | 2202565 | g6709 | i0 | 94.694 | 14.4 | 245 | 13 | 100 | 0 | 1 | 245 | 1355 | 1111 | MAG: Genomoviridae sp. isolate 6434_413, complete genome | blastn | 3528 | 381 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 18427699 | 18427699 | PRJNA602115_P_NODE_4455_length_296_cov_0.872340_g4430_i0 | PRJNA602115 | 4455 | 296 | 0.87234 | 2.5821264 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 403 | 6.59e-108 | NTclustered | gi|2896100955|gb|PQ792342.1| | 2748378 | g4430 | i0 | 91.275 | 1.00675675675676 | 298 | 22 | 100 | 2 | 1 | 296 | 2583 | 2878 | MAG: Cressdnaviricota sp. isolate SbovineF090_cress11 genomic sequence | blastn | 298 | 403 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 20978078 | 20978078 | PRJNA602115_P_NODE_637_length_726_cov_1.493233_g613_i0 | PRJNA602115 | 637 | 726 | 1.493233 | 10.84087158 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 1184 | 0 | NTclustered | gi|1832329329|gb|MT309858.1| | 2202565 | g613 | i0 | 96.639 | 41.961432506887 | 714 | 22 | 98 | 2 | 10 | 722 | 1444 | 2156 | MAG: Genomoviridae sp. isolate 6434_413, complete genome | blastn | 30464 | 1184 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 22252962 | 22252962 | PRJNA602115_P_NODE_9938_length_206_cov_0.882759_g9913_i0 | PRJNA602115 | 9938 | 206 | 0.882759 | 1.81848354 | Wigfec virus K19_555 | 2986010 | Viruses | Viruses | 215 | 2.17e-51 | NTclustered | gi|2316504316|gb|OP549837.1| | 2986010 | g9913 | i0 | 86.911 | 0.927184466019418 | 191 | 25 | 93 | 0 | 13 | 203 | 1335 | 1525 | MAG: Wigfec virus K19_555, complete genome | blastn | 191 | 215 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Wigfec virus K19_555 | ||||||
| 26921772 | 26921772 | PRJNA602115_P_NODE_8582_length_212_cov_1.125828_g8557_i0 | PRJNA602115 | 8582 | 212 | 1.125828 | 2.38675536 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 50.8 | 3.01e-5 | NR | UOF80144.1 | 2748378 | g8557 | i0 | 44.9 | 0.976415094339623 | 69 | 37 | 96.2 | 1 | 3 | 206 | 53 | 121 | UOF80144.1 capsid protein [Cressdnaviricota sp.] | diamond | 207 | 50.8 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 27680495 | 27680495 | PRJNA602115_P_NODE_7804_length_225_cov_1.560976_g7779_i0 | PRJNA602115 | 7804 | 225 | 1.560976 | 3.512196 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 53.5 | 3.57e-6 | NR | WAE42348.1 | 2748378 | g7779 | i0 | 48.8 | 2.33333333333333 | 43 | 22 | 57.3 | 0 | 5 | 133 | 217 | 259 | WAE42348.1 MAG: capsid protein [Cressdnaviricota sp.] | diamond | 525 | 53.5 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 28248318 | 28248318 | PRJNA602115_P_NODE_3866_length_313_cov_1.519841_g3841_i0 | PRJNA602115 | 3866 | 313 | 1.519841 | 4.75710233 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 60.1 | 3.37e-8 | NR | UOF81913.1 | 2748378 | g3841 | i0 | 38.1 | 1.08306709265176 | 113 | 57 | 99.7 | 5 | 312 | 1 | 34 | 142 | UOF81913.1 hypothetical protein [Cressdnaviricota sp.] | diamond | 339 | 60.1 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 29353745 | 29353745 | PRJNA602115_P_NODE_11669_length_201_cov_0.914286_g11644_i0 | PRJNA602115 | 11669 | 201 | 0.914286 | 1.83771486 | Smacoviridae sp. | 2715094 | Viruses | Viruses | 42.4 | 0.0285 | NR | XNT20915.1 | 2715094 | g11644 | i0 | 44.8 | 1 | 67 | 27 | 88.1 | 2 | 2 | 178 | 299 | 363 | XNT20915.1 MAG: capsid protein [Smacoviridae sp.] | diamond | 201 | 42.4 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cremevirales | Smacoviridae | Smacoviridae sp. | |||
| 30079770 | 30079770 | PRJNA602115_P_NODE_5972_length_260_cov_1.567839_g5947_i0 | PRJNA602115 | 5972 | 260 | 1.567839 | 4.0763814 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 47 | 0.00126 | NR | AXH73954.1 | 2748378 | g5947 | i0 | 40.7 | 0.680769230769231 | 59 | 33 | 65.8 | 2 | 10 | 180 | 200 | 258 | AXH73954.1 MAG: hypothetical protein [Cressdnaviricota sp.] | diamond | 177 | 47 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 32053078 | 32053078 | PRJNA602115_P_NODE_1538_length_480_cov_1.589499_g1513_i0 | PRJNA602115 | 1538 | 480 | 1.589499 | 7.6295952 | Galvornvirus | 2948715 | Viruses | Viruses | 55.5 | 6.15e-6 | NR | AXQ66182.1 | 1954248 | g1513 | i0 | 42.3 | 0.71875 | 78 | 43 | 47.5 | 2 | 244 | 17 | 23 | 100 | AXQ66182.1 MAG: helicase [Circoviridae sp.] | diamond | 345 | 55.5 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 32514733 | 32514733 | PRJNA602115_P_NODE_10219_length_205_cov_0.888889_g10194_i0 | PRJNA602115 | 10219 | 205 | 0.888889 | 1.82222245 | Bovine faeces associated smacovirus 5 | 1843753 | Viruses | Viruses | 56.2 | 3.58e-7 | NR | YP_009252317.1 | 1843753 | g10194 | i0 | 58.3 | 0.702439024390244 | 48 | 19 | 70.2 | 1 | 60 | 203 | 212 | 258 | YP_009252317.1 putative capsid protein [Bovine faeces associated smacovirus 5] | diamond | 144 | 56.2 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cremevirales | Smacoviridae | Drosmacovirus | Drosmacovirus bovas1 | ||
| 32703486 | 32703486 | PRJNA602115_P_NODE_4840_length_286_cov_1.133333_g4815_i0 | PRJNA602115 | 4840 | 286 | 1.133333 | 3.24133238 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 56.2 | 7.56e-7 | NR | AXQ65663.1 | 2748378 | g4815 | i0 | 34.1 | 0.923076923076923 | 88 | 57 | 91.3 | 1 | 263 | 3 | 58 | 145 | AXQ65663.1 MAG: capsid protein [Cressdnaviricota sp.] | diamond | 264 | 56.2 | 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);;