contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJEB64798" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 993529 | 993529 | PRJEB64798_P_NODE_3761_length_974_cov_30.497297_g2916_i0 | PRJEB64798 | 3761 | 974 | 30.497297 | 297.04367278 | Viruses | 10239 | Viruses | Viruses | 1720 | 0 | NTclustered | gi|1848664582|gb|MN891788.1| | 2740165 | g2916 | i0 | 99.681 | 3.11806981519507 | 940 | 3 | 97 | 0 | 35 | 974 | 2537 | 1598 | Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome | blastn | 3037 | 1725 | 0.997101449275362 | Viruses | CRESS viruses | Shotokuvirae | Cressdnaviricota | Brassica caulorapa CRESS virus | |||||
| 2677149 | 2677149 | PRJEB64798_P_NODE_14343_length_527_cov_6.746862_g12677_i0 | PRJEB64798 | 14343 | 527 | 6.746862 | 35.55596274 | Tick-associated circular virus-2 | 2951484 | Viruses | Viruses | 745 | 0 | NTclustered | gi|2263979286|gb|ON456885.1| | 2951484 | g12677 | i0 | 99.754 | 0.988614800759013 | 406 | 1 | 99 | 0 | 1 | 406 | 406 | 1 | Tick-associated circular virus-2 isolate Tick114CressC5, complete genome | blastn | 521 | 745 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Tick-associated circular virus-2 | |||
| 2678762 | 2678762 | PRJEB64798_P_NODE_27183_length_377_cov_13.743902_g25429_i0 | PRJEB64798 | 27183 | 377 | 13.743902 | 51.81451054 | Reagent-associated CRESS-like virus 4 | 2875812 | Viruses | Viruses | 673 | 0 | NTclustered | gi|2094552985|gb|MZ824234.1| | 2875812 | g25429 | i0 | 99.459 | 0.981432360742706 | 370 | 2 | 98 | 0 | 5 | 374 | 1512 | 1881 | Reagent-associated CRESS-like virus 4 isolate 10 replicase-like gene, partial sequence | blastn | 370 | 673 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 4 | ||||||
| 3953511 | 3953511 | PRJEB64798_P_NODE_170504_length_178_cov_8.131783_g168738_i0 | PRJEB64798 | 170504 | 178 | 8.131783 | 14.47457374 | Cirlivirales sp. | 2809008 | Viruses | Viruses | 135 | 1.4500000000000002e-27 | NTclustered | gi|2906154851|gb|PQ646830.1| | 2809008 | g168738 | i0 | 100 | 1.07303370786517 | 73 | 0 | 41 | 0 | 102 | 174 | 2509 | 2581 | MAG: Cirlivirales sp. isolate k127_3981985 genomic sequence | blastn | 191 | 135 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Cirlivirales sp. | ||||
| 5229083 | 5229083 | PRJEB64798_P_NODE_112865_length_209_cov_15.906250_g111099_i0 | PRJEB64798 | 112865 | 209 | 15.90625 | 33.2440625 | Reagent-associated CRESS-like virus 6 | 2875814 | Viruses | Viruses | 351 | 1.61e-92 | NTclustered | gi|2094552983|gb|MZ824232.1| | 2875814 | g111099 | i0 | 97.561 | 1.96172248803828 | 205 | 5 | 98 | 0 | 1 | 205 | 3504 | 3300 | Reagent-associated CRESS-like virus 6 isolate 12 replicase-like gene, partial sequence | blastn | 410 | 351 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 6 | ||||||
| 5230619 | 5230619 | PRJEB64798_P_NODE_211305_length_164_cov_5.017391_g209539_i0 | PRJEB64798 | 211305 | 164 | 5.017391 | 8.22852124 | Tick-associated circular virus-2 | 2951484 | Viruses | Viruses | 291 | 2.67e-74 | NTclustered | gi|2263979286|gb|ON456885.1| | 2951484 | g209539 | i0 | 99.375 | 0.975609756097561 | 160 | 1 | 98 | 0 | 1 | 160 | 1437 | 1278 | Tick-associated circular virus-2 isolate Tick114CressC5, complete genome | blastn | 160 | 291 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Tick-associated circular virus-2 | |||
| 5231165 | 5231165 | PRJEB64798_P_NODE_25585_length_389_cov_5.491176_g23836_i0 | PRJEB64798 | 25585 | 389 | 5.491176 | 21.36067464 | Reagent-associated CRESS-like virus 4 | 2875812 | Viruses | Viruses | 662 | 0 | NTclustered | gi|2094552985|gb|MZ824234.1| | 2875812 | g23836 | i0 | 99.723 | 0.928020565552699 | 361 | 1 | 93 | 0 | 1 | 361 | 2133 | 2493 | Reagent-associated CRESS-like virus 4 isolate 10 replicase-like gene, partial sequence | blastn | 361 | 662 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 4 | ||||||
| 5231216 | 5231216 | PRJEB64798_P_NODE_28465_length_369_cov_7.503125_g26709_i0 | PRJEB64798 | 28465 | 369 | 7.503125 | 27.68653125 | Reagent-associated CRESS-like virus 4 | 2875812 | Viruses | Viruses | 673 | 0 | NTclustered | gi|2094552985|gb|MZ824234.1| | 2875812 | g26709 | i0 | 100 | 0.986449864498645 | 364 | 0 | 99 | 0 | 1 | 364 | 593 | 956 | Reagent-associated CRESS-like virus 4 isolate 10 replicase-like gene, partial sequence | blastn | 364 | 673 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 4 | ||||||
| 6505912 | 6505912 | PRJEB64798_P_NODE_18806_length_460_cov_6.783455_g17083_i0 | PRJEB64798 | 18806 | 460 | 6.783455 | 31.203893 | Tick-associated circular virus-2 | 2951484 | Viruses | Viruses | 848 | 0 | NTclustered | gi|2263979286|gb|ON456885.1| | 2951484 | g17083 | i0 | 100 | 0.997826086956522 | 459 | 0 | 99 | 0 | 1 | 459 | 1300 | 842 | Tick-associated circular virus-2 isolate Tick114CressC5, complete genome | blastn | 459 | 848 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Tick-associated circular virus-2 | |||
| 7779673 | 7779673 | PRJEB64798_P_NODE_15747_length_502_cov_6.878587_g14055_i0 | PRJEB64798 | 15747 | 502 | 6.878587 | 34.53050674 | Reagent-associated CRESS-like virus 6 | 2875814 | Viruses | Viruses | 909 | 0 | NTclustered | gi|2094552983|gb|MZ824232.1| | 2875814 | g14055 | i0 | 99.598 | 0.99203187250996006 | 498 | 2 | 99 | 0 | 5 | 502 | 1769 | 1272 | Reagent-associated CRESS-like virus 6 isolate 12 replicase-like gene, partial sequence | blastn | 498 | 909 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 6 | ||||||
| 11604931 | 11604931 | PRJEB64798_P_NODE_109810_length_210_cov_6.360248_g108044_i0 | PRJEB64798 | 109810 | 210 | 6.360248 | 13.3565208 | Galvornvirus isengard | 2955925 | Viruses | Viruses | 65.8 | 2.37e-6 | NTclustered | gi|2302020526|gb|MT207658.1| | 1954248 | g108044 | i0 | 97.368 | 0.180952380952381 | 38 | 1 | 18 | 0 | 13 | 50 | 868 | 905 | MAG: Circoviridae sp. isolate CN3_L18_650, complete genome | blastn | 38 | 65.8 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 11605187 | 11605187 | PRJEB64798_P_NODE_1250_length_1571_cov_30.412615_g911_i0 | PRJEB64798 | 1250 | 1571 | 30.412615 | 477.78218165 | Reagent-associated CRESS-like virus 6 | 2875814 | Viruses | Viruses | 2889 | 0 | NTclustered | gi|2094552983|gb|MZ824232.1| | 2875814 | g911 | i0 | 100 | 0.995544239338001 | 1564 | 0 | 99 | 0 | 8 | 1571 | 3289 | 1726 | Reagent-associated CRESS-like virus 6 isolate 12 replicase-like gene, partial sequence | blastn | 1564 | 2889 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 6 | ||||||
| 14157102 | 14157102 | PRJEB64798_P_NODE_30332_length_357_cov_9.668831_g28575_i0 | PRJEB64798 | 30332 | 357 | 9.668831 | 34.51772667 | Reagent-associated CRESS-like virus 4 | 2875812 | Viruses | Viruses | 274 | 6.63e-69 | NTclustered | gi|2094552985|gb|MZ824234.1| | 2875812 | g28575 | i0 | 100 | 0.414565826330532 | 148 | 0 | 41 | 0 | 206 | 353 | 2663 | 2516 | Reagent-associated CRESS-like virus 4 isolate 10 replicase-like gene, partial sequence | blastn | 148 | 274 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 4 | ||||||
| 15431531 | 15431531 | PRJEB64798_P_NODE_52033_length_271_cov_6.090090_g50268_i0 | PRJEB64798 | 52033 | 271 | 6.09009 | 16.5041439 | Reagent-associated CRESS-like virus 6 | 2875814 | Viruses | Viruses | 483 | 7.44e-132 | NTclustered | gi|2094552983|gb|MZ824232.1| | 2875814 | g50268 | i0 | 99.251 | 1.08856088560886 | 267 | 2 | 99 | 0 | 5 | 271 | 556 | 290 | Reagent-associated CRESS-like virus 6 isolate 12 replicase-like gene, partial sequence | blastn | 295 | 483 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 6 | ||||||
| 15431606 | 15431606 | PRJEB64798_P_NODE_553_length_2117_cov_55.359284_g387_i0 | PRJEB64798 | 553 | 2117 | 55.359284 | 1171.95604228 | Reagent-associated CRESS-like virus 5 | 2875813 | Viruses | Viruses | 3205 | 0 | NTclustered | gi|2094552984|gb|MZ824233.1| | 2875813 | g387 | i0 | 99.942 | 3.01653282947567 | 1739 | 0 | 99 | 1 | 380 | 2117 | 1 | 1739 | Reagent-associated CRESS-like virus 5 isolate 11 replicase-like gene, partial sequence | blastn | 6386 | 3205 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 5 | ||||||
| 16705618 | 16705618 | PRJEB64798_P_NODE_40954_length_308_cov_9.637066_g39189_i0 | PRJEB64798 | 40954 | 308 | 9.637066 | 29.68216328 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 150 | 9.91e-32 | NTclustered | gi|2198202730|dbj|LC671634.1| | 2748378 | g39189 | i0 | 94.792 | 0.311688311688312 | 96 | 5 | 31 | 0 | 208 | 303 | 304 | 209 | Cressdnaviricota sp. 2020-AMS-MCO DNA, complete genome | blastn | 96 | 150 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 19252937 | 19252937 | PRJEB64798_P_NODE_16736_length_487_cov_7.607306_g15033_i0 | PRJEB64798 | 16736 | 487 | 7.607306 | 37.04758022 | Tick-associated circular virus-2 | 2951484 | Viruses | Viruses | 859 | 0 | NTclustered | gi|2263979286|gb|ON456885.1| | 2951484 | g15033 | i0 | 99.576 | 0.969199178644764 | 472 | 1 | 97 | 1 | 9 | 480 | 1927 | 1457 | Tick-associated circular virus-2 isolate Tick114CressC5, complete genome | blastn | 472 | 859 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Tick-associated circular virus-2 | |||
| 19254063 | 19254063 | PRJEB64798_P_NODE_244376_length_153_cov_14.326923_g242610_i0 | PRJEB64798 | 244376 | 153 | 14.326923 | 21.92019219 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 187 | 3.2899999999999992e-43 | NTclustered | gi|2198202730|dbj|LC671634.1| | 2748378 | g242610 | i0 | 89.262 | 0.973856209150327 | 149 | 16 | 97 | 0 | 1 | 149 | 848 | 700 | Cressdnaviricota sp. 2020-AMS-MCO DNA, complete genome | blastn | 149 | 187 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 19254464 | 19254464 | PRJEB64798_P_NODE_39976_length_312_cov_10.596958_g38212_i0 | PRJEB64798 | 39976 | 312 | 10.596958 | 33.06250896 | Duck associated circular virus VC9 | 2781378 | Viruses | Viruses | 220 | 7.56e-53 | NTclustered | gi|1918609741|gb|MT318129.1| | 2781378 | g38212 | i0 | 82.54 | 0.807692307692308 | 252 | 29 | 79 | 10 | 61 | 307 | 452 | 211 | Duck associated circular virus VC9 capsid protein gene, complete cds | blastn | 252 | 220 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Duck associated circular virus VC9 | |||
| 21803695 | 21803695 | PRJEB64798_P_NODE_14198_length_530_cov_7.282744_g12536_i0 | PRJEB64798 | 14198 | 530 | 7.282744 | 38.5985432 | Reagent-associated CRESS-like virus 6 | 2875814 | Viruses | Viruses | 950 | 0 | NTclustered | gi|2094552983|gb|MZ824232.1| | 2875814 | g12536 | i0 | 99.427 | 0.988679245283019 | 524 | 2 | 99 | 1 | 8 | 530 | 707 | 1230 | Reagent-associated CRESS-like virus 6 isolate 12 replicase-like gene, partial sequence | blastn | 524 | 950 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 6 | ||||||
| 21806079 | 21806079 | PRJEB64798_P_NODE_62758_length_245_cov_8.897959_g60993_i0 | PRJEB64798 | 62758 | 245 | 8.897959 | 21.79999955 | Tick-associated circular virus-2 | 2951484 | Viruses | Viruses | 453 | 5.1900000000000006e-123 | NTclustered | gi|2263979286|gb|ON456885.1| | 2951484 | g60993 | i0 | 100 | 1 | 245 | 0 | 100 | 0 | 1 | 245 | 825 | 581 | Tick-associated circular virus-2 isolate Tick114CressC5, complete genome | blastn | 245 | 453 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Tick-associated circular virus-2 | |||
| 21806309 | 21806309 | PRJEB64798_P_NODE_76378_length_220_cov_9.280702_g74612_i0 | PRJEB64798 | 76378 | 220 | 9.280702 | 20.4175444 | Tick-associated circular virus-2 | 2951484 | Viruses | Viruses | 405 | 1.2999999999999997e-108 | NTclustered | gi|2263979286|gb|ON456885.1| | 2951484 | g74612 | i0 | 100 | 0.995454545454545 | 219 | 0 | 99 | 0 | 1 | 219 | 381 | 599 | Tick-associated circular virus-2 isolate Tick114CressC5, complete genome | blastn | 219 | 405 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Tick-associated circular virus-2 | |||
| 23080802 | 23080802 | PRJEB64798_P_NODE_38099_length_320_cov_5.675277_g36339_i0 | PRJEB64798 | 38099 | 320 | 5.675277 | 18.1608864 | Reagent-associated CRESS-like virus 4 | 2875812 | Viruses | Viruses | 580 | 3.099999999999999e-161 | NTclustered | gi|2094552985|gb|MZ824234.1| | 2875812 | g36339 | i0 | 99.685 | 0.990625 | 317 | 1 | 99 | 0 | 4 | 320 | 1439 | 1123 | Reagent-associated CRESS-like virus 4 isolate 10 replicase-like gene, partial sequence | blastn | 317 | 580 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 4 | ||||||
| 24352374 | 24352374 | PRJEB64798_P_NODE_114440_length_209_cov_3.900000_g112674_i0 | PRJEB64798 | 114440 | 209 | 3.9 | 8.151 | Reagent-associated CRESS-like virus 4 | 2875812 | Viruses | Viruses | 377 | 2.66e-100 | NTclustered | gi|2094552985|gb|MZ824234.1| | 2875812 | g112674 | i0 | 100 | 0.976076555023923 | 204 | 0 | 98 | 0 | 1 | 204 | 404 | 607 | Reagent-associated CRESS-like virus 4 isolate 10 replicase-like gene, partial sequence | blastn | 204 | 377 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 4 | ||||||
| 24355380 | 24355380 | PRJEB64798_P_NODE_75920_length_221_cov_4.529070_g74154_i0 | PRJEB64798 | 75920 | 221 | 4.52907 | 10.0092447 | Cirlivirales sp. | 2809008 | Viruses | Viruses | 63.9 | 9.05e-6 | NTclustered | gi|2906154851|gb|PQ646830.1| | 2809008 | g74154 | i0 | 100 | 0.46606334841629 | 34 | 0 | 15 | 0 | 62 | 95 | 2537 | 2570 | MAG: Cirlivirales sp. isolate k127_3981985 genomic sequence | blastn | 103 | 63.9 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Cirlivirales 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);;