contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA642647" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26891666 | 26891666 | PRJNA642647_P_NODE_4081_length_178_cov_2.687943_g4031_i0 | PRJNA642647 | 4081 | 178 | 2.687943 | 4.78453854 | Sewage-associated circular DNA virus-8 | 1519397 | Viruses | Viruses | 52.4 | 5.95e-6 | NR | AIF34821.1 | 1519397 | g4031 | i0 | 71.4 | 0.99438202247191 | 28 | 8 | 47.2 | 0 | 90 | 173 | 363 | 390 | AIF34821.1 hypothetical protein [Sewage-associated circular DNA virus-8] | diamond | 177 | 52.4 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Saturnivirales | Kanorauviridae | Doseivirus | Doseivirus sewoxi | ||
| 27112719 | 27112719 | PRJNA642647_P_NODE_3862_length_182_cov_3.641379_g3812_i0 | PRJNA642647 | 3862 | 182 | 3.641379 | 6.62730978 | Cynopterus sphinx circular DNA virus 9 | 3064092 | Viruses | Viruses | 92 | 3.04e-20 | NR | WOE49738.1 | 3064092 | g3812 | i0 | 84 | 0.824175824175824 | 50 | 8 | 82.4 | 0 | 152 | 3 | 253 | 302 | WOE49738.1 MAG: putative capsid protein [Cynopterus sphinx circular DNA virus 9] | diamond | 150 | 92 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cynopterus sphinx circular DNA virus 9 | ||||||
| 29260004 | 29260004 | PRJNA642647_P_NODE_5329_length_165_cov_1.171875_g5279_i0 | PRJNA642647 | 5329 | 165 | 1.171875 | 1.93359375 | Parvo-like hybrid virus UC4 | 1395615 | Viruses | Viruses | 41.6 | 0.0326 | NR | QJI53850.1 | 1395615 | g5279 | i0 | 44.7 | 0.690909090909091 | 38 | 21 | 69.1 | 0 | 3 | 116 | 157 | 194 | QJI53850.1 MAG: capsid protein [Parvo-like hybrid virus UC4] | diamond | 114 | 41.6 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Lineavirales | Oomyviridae | Nicoomyvirus | Nicoomyvirus moldensis | ||
| 29923407 | 29923407 | PRJNA642647_P_NODE_1631_length_272_cov_2.714894_g1581_i0 | PRJNA642647 | 1631 | 272 | 2.714894 | 7.38451168 | Cynopterus sphinx circular DNA virus 9 | 3064092 | Viruses | Viruses | 100 | 5.1799999999999987e-23 | NR | WOE49738.1 | 3064092 | g1581 | i0 | 64.6 | 0.871323529411765 | 79 | 21 | 79.4 | 1 | 52 | 267 | 103 | 181 | WOE49738.1 MAG: putative capsid protein [Cynopterus sphinx circular DNA virus 9] | diamond | 237 | 100 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cynopterus sphinx circular DNA virus 9 | ||||||
| 30049487 | 30049487 | PRJNA642647_P_NODE_2751_length_209_cov_4.017442_g2701_i0 | PRJNA642647 | 2751 | 209 | 4.017442 | 8.39645378 | Wigfec virus K19_645 | 2986016 | Viruses | Viruses | 72 | 3.32e-13 | NR | UYD39132.1 | 2986016 | g2701 | i0 | 50.9 | 0.818181818181818 | 57 | 28 | 81.8 | 0 | 4 | 174 | 83 | 139 | UYD39132.1 MAG: capsid protein [Wigfec virus K19_645] | diamond | 171 | 72 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Wigfec virus K19_645 | ||||||
| 30112740 | 30112740 | PRJNA642647_P_NODE_1972_length_247_cov_1.742857_g1922_i0 | PRJNA642647 | 1972 | 247 | 1.742857 | 4.30485679 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 142 | 5.97e-40 | NR | AYP28917.1 | 2748378 | g1922 | i0 | 76.5 | 1.96761133603239 | 81 | 19 | 98.4 | 0 | 4 | 246 | 144 | 224 | AYP28917.1 MAG: helicase [Cressdnaviricota sp.] | diamond | 486 | 142 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 30429201 | 30429201 | PRJNA642647_P_NODE_3833_length_183_cov_1.479452_g3783_i0 | PRJNA642647 | 3833 | 183 | 1.479452 | 2.70739716 | Cirlivirales sp. | 2809008 | Viruses | Viruses | 51.6 | 1.13e-5 | NR | XOF02623.1 | 2809008 | g3783 | i0 | 41 | 1 | 61 | 35 | 98.4 | 1 | 183 | 4 | 25 | 85 | XOF02623.1 MAG: hypothetical protein [Cirlivirales sp.] | diamond | 183 | 51.6 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Cirlivirales sp. | ||||
| 30649740 | 30649740 | PRJNA642647_P_NODE_1713_length_265_cov_2.403509_g1663_i0 | PRJNA642647 | 1713 | 265 | 2.403509 | 6.36929885 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 46.6 | 0.00201 | NR | QJI53463.1 | 2748378 | g1663 | i0 | 36.8 | 1.07547169811321 | 95 | 48 | 96.2 | 3 | 260 | 6 | 315 | 407 | QJI53463.1 MAG: capsid protein [Cressdnaviricota sp.] | diamond | 285 | 46.6 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 30997623 | 30997623 | PRJNA642647_P_NODE_1774_length_260_cov_3.085202_g1724_i0 | PRJNA642647 | 1774 | 260 | 3.0852020000000002 | 8.0215252 | Cirlivirales sp. | 2809008 | Viruses | Viruses | 51.2 | 4e-5 | NR | XOF04850.1 | 2809008 | g1724 | i0 | 66.7 | 0.380769230769231 | 33 | 11 | 38.1 | 0 | 99 | 1 | 100 | 132 | XOF04850.1 MAG: hypothetical protein [Cirlivirales sp.] | diamond | 99 | 51.2 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Cirlivirales sp. | ||||
| 31250292 | 31250292 | PRJNA642647_P_NODE_6055_length_155_cov_1.915254_g6005_i0 | PRJNA642647 | 6055 | 155 | 1.915254 | 2.9686437 | Circoviridae sp. | 1954248 | Viruses | Viruses | 43.5 | 0.00604 | NR | UOF78493.1 | 1954248 | g6005 | i0 | 47.7 | 0.851612903225806 | 44 | 15 | 85.2 | 1 | 24 | 155 | 372 | 407 | UOF78493.1 coat protein [Circoviridae sp.] | diamond | 132 | 43.5 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 31408568 | 31408568 | PRJNA642647_P_NODE_2676_length_212_cov_1.680000_g2626_i0 | PRJNA642647 | 2676 | 212 | 1.68 | 3.5616 | Circoviridae sp. | 1954248 | Viruses | Viruses | 91.7 | 1.62e-20 | NR | UOF78023.1 | 1954248 | g2626 | i0 | 60.9 | 0.976415094339623 | 69 | 27 | 97.6 | 0 | 2 | 208 | 101 | 169 | UOF78023.1 capsid protein [Circoviridae sp.] | diamond | 207 | 91.7 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 31503536 | 31503536 | PRJNA642647_P_NODE_5676_length_160_cov_1.243902_g5626_i0 | PRJNA642647 | 5676 | 160 | 1.243902 | 1.9902432 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 59.3 | 1.38e-8 | NR | WAE43026.1 | 2748378 | g5626 | i0 | 56.9 | 0.95625 | 51 | 22 | 95.6 | 0 | 155 | 3 | 73 | 123 | WAE43026.1 MAG: replication associated protein [Cressdnaviricota sp.] | diamond | 153 | 59.3 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 31535181 | 31535181 | PRJNA642647_P_NODE_3256_length_195_cov_2.253165_g3206_i0 | PRJNA642647 | 3256 | 195 | 2.253165 | 4.39367175 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 55.8 | 4.3e-7 | NR | UOF82684.1 | 2748378 | g3206 | i0 | 59.1 | 0.676923076923077 | 44 | 17 | 67.7 | 1 | 138 | 7 | 161 | 203 | UOF82684.1 capsid protein [Cressdnaviricota sp.] | diamond | 132 | 55.8 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 31693102 | 31693102 | PRJNA642647_P_NODE_4977_length_166_cov_2.961240_g4927_i0 | PRJNA642647 | 4977 | 166 | 2.96124 | 4.9156584 | Chicken proventriculitis-associated circular virus 18 | 2875673 | Viruses | Viruses | 54.7 | 6.82e-7 | NR | UAU47010.1 | 2875673 | g4927 | i0 | 32.8 | 2.15060240963855 | 119 | 15 | 97.6 | 1 | 166 | 5 | 89 | 207 | UAU47010.1 Cap [Chicken proventriculitis-associated circular virus 18] | diamond | 357 | 54.7 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Chicken proventriculitis-associated circular virus 18 | ||||||
| 31705454 | 31705454 | PRJNA642647_P_NODE_4397_length_173_cov_1.132353_g4347_i0 | PRJNA642647 | 4397 | 173 | 1.132353 | 1.95897069 | Viruses | 10239 | Viruses | Viruses | 56.6 | 1.72e-7 | NR | AIY31241.1 | 1574422 | g4347 | i0 | 46.7 | 1.64739884393064 | 45 | 24 | 78 | 0 | 19 | 153 | 243 | 287 | AIY31241.1 putative replicase protein [Dromedary stool-associated circular ssDNA virus] | diamond | 285 | 56.6 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cremevirales | Smacoviridae | Dromedary stool-associated circular ssDNA virus | |||
| 31819574 | 31819574 | PRJNA642647_P_NODE_3877_length_182_cov_2.262069_g3827_i0 | PRJNA642647 | 3877 | 182 | 2.262069 | 4.11696558 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 107 | 1.27e-26 | NR | QZW33718.1 | 2748378 | g3827 | i0 | 76.3 | 0.972527472527473 | 59 | 14 | 97.3 | 0 | 5 | 181 | 10 | 68 | QZW33718.1 putative viral replication protein [Cressdnaviricota sp.] | diamond | 177 | 107 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 31946029 | 31946029 | PRJNA642647_P_NODE_1057_length_344_cov_1.182410_g1007_i0 | PRJNA642647 | 1057 | 344 | 1.18241 | 4.0674904 | Circoviridae sp. | 1954248 | Viruses | Viruses | 55.8 | 2.87e-6 | NR | XOE93991.1 | 1954248 | g1007 | i0 | 53.7 | 0.47093023255814 | 54 | 19 | 42.7 | 2 | 200 | 54 | 12 | 64 | XOE93991.1 MAG: hypothetical protein [Circoviridae sp.] | diamond | 162 | 55.8 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 32041203 | 32041203 | PRJNA642647_P_NODE_4138_length_177_cov_2.714286_g4088_i0 | PRJNA642647 | 4138 | 177 | 2.714286 | 4.80428622 | Grus japonensis CRESS-DNA-virus sp. | 2815045 | Viruses | Viruses | 102 | 1.5299999999999999e-24 | NR | QTE03372.1 | 2815045 | g4088 | i0 | 75 | 0.949152542372881 | 56 | 14 | 94.9 | 0 | 174 | 7 | 214 | 269 | QTE03372.1 MAG: replication-associated protein [Grus japonensis CRESS-DNA-virus sp.] | diamond | 168 | 102 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Grus japonensis CRESS-DNA-virus sp. | ||||||
| 32294638 | 32294638 | PRJNA642647_P_NODE_1319_length_304_cov_3.415730_g1269_i0 | PRJNA642647 | 1319 | 304 | 3.41573 | 10.3838192 | Circoviridae sp. | 1954248 | Viruses | Viruses | 71.6 | 4.38e-14 | NR | UOF78025.1 | 1954248 | g1269 | i0 | 55.8 | 0.513157894736842 | 52 | 23 | 51.3 | 0 | 157 | 2 | 1 | 52 | UOF78025.1 hypothetical protein [Circoviridae sp.] | diamond | 156 | 71.6 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 32906003 | 32906003 | PRJNA642647_P_NODE_700_length_427_cov_4.902564_g651_i0 | PRJNA642647 | 700 | 427 | 4.902564 | 20.93394828 | Viruses | 10239 | Viruses | Viruses | 114 | 6.83e-28 | NR | WAE42659.1 | 2748378 | g651 | i0 | 63 | 2.85948477751756 | 81 | 30 | 56.9 | 0 | 245 | 3 | 21 | 101 | WAE42659.1 MAG: replication associated protein [Cressdnaviricota sp.] | diamond | 1221 | 115 | 0.991304347826087 | 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);;