contig_metadata
30 rows where bioproject = "PRJNA558770" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1817153 | 1817153 | PRJNA558770_P_NODE_381242_length_212_cov_8.457627_g379237_i0 | PRJNA558770 | 381242 | 212 | 8.457627 | 17.93016924 | Reagent-associated CRESS-like virus 4 | 2875812 | Viruses | Viruses | 388 | 1.25e-103 | NTclustered | gi|2094552985|gb|MZ824234.1| | 2875812 | g379237 | i0 | 100 | 0.990566037735849 | 210 | 0 | 99 | 0 | 1 | 210 | 745 | 954 | Reagent-associated CRESS-like virus 4 isolate 10 replicase-like gene, partial sequence | blastn | 210 | 388 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 4 | ||||||
| 2404460 | 2404460 | PRJNA558770_P_NODE_20002_length_444_cov_14.503667_g18132_i0 | PRJNA558770 | 20002 | 444 | 14.503667 | 64.39628148 | Arfiviricetes | 2732423 | Viruses | Viruses | 388 | 2.88e-103 | NTclustered | gi|2626080284|gb|OR270688.1| | 1954248 | g18132 | i0 | 99.531 | 6.45045045045045 | 213 | 1 | 99 | 0 | 232 | 444 | 698 | 486 | MAG: Circoviridae sp. isolate GL83, complete genome | blastn | 2864 | 388 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 6918471 | 6918471 | PRJNA558770_P_NODE_276566_length_234_cov_1.788945_g274561_i0 | PRJNA558770 | 276566 | 234 | 1.788945 | 4.1861313000000004 | Reagent-associated CRESS-like virus 6 | 2875814 | Viruses | Viruses | 139 | 1.56e-28 | NTclustered | gi|2094552983|gb|MZ824232.1| | 2875814 | g274561 | i0 | 100 | 0.636752136752137 | 75 | 0 | 64 | 0 | 1 | 75 | 2450 | 2376 | Reagent-associated CRESS-like virus 6 isolate 12 replicase-like gene, partial sequence | blastn | 149 | 139 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 6 | ||||||
| 6919526 | 6919526 | PRJNA558770_P_NODE_381686_length_210_cov_9.868571_g379681_i0 | PRJNA558770 | 381686 | 210 | 9.868571 | 20.7239991 | Reagent-associated CRESS-like virus 4 | 2875812 | Viruses | Viruses | 252 | 1.69e-62 | NTclustered | gi|2094552985|gb|MZ824234.1| | 2875812 | g379681 | i0 | 100 | 1.01904761904762 | 136 | 0 | 100 | 0 | 1 | 136 | 1600 | 1735 | Reagent-associated CRESS-like virus 4 isolate 10 replicase-like gene, partial sequence | blastn | 214 | 252 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 4 | ||||||
| 7507584 | 7507584 | PRJNA558770_P_NODE_2946_length_892_cov_31.208868_g2064_i0 | PRJNA558770 | 2946 | 892 | 31.208868 | 278.38310256 | Viruses | 10239 | Viruses | Viruses | 1648 | 0 | NTclustered | gi|1848664582|gb|MN891788.1| | 2740165 | g2064 | i0 | 100 | 3.2432735426009 | 892 | 0 | 100 | 0 | 1 | 892 | 2508 | 1617 | Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome | blastn | 2893 | 1648 | 1 | Viruses | CRESS viruses | Shotokuvirae | Cressdnaviricota | Brassica caulorapa CRESS virus | |||||
| 8194735 | 8194735 | PRJNA558770_P_NODE_395587_length_158_cov_5.991870_g393582_i0 | PRJNA558770 | 395587 | 158 | 5.99187 | 9.4671546 | Reagent-associated CRESS-like virus 4 | 2875812 | Viruses | Viruses | 285 | 1.18e-72 | NTclustered | gi|2094552985|gb|MZ824234.1| | 2875812 | g393582 | i0 | 99.363 | 0.993670886075949 | 157 | 1 | 99 | 0 | 1 | 157 | 2238 | 2394 | Reagent-associated CRESS-like virus 4 isolate 10 replicase-like gene, partial sequence | blastn | 157 | 285 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 4 | ||||||
| 8195731 | 8195731 | PRJNA558770_P_NODE_7827_length_630_cov_20.078992_g6417_i0 | PRJNA558770 | 7827 | 630 | 20.078992 | 126.4976496 | Reagent-associated CRESS-like virus 5 | 2875813 | Viruses | Viruses | 1162 | 0 | NTclustered | gi|2094552984|gb|MZ824233.1| | 2875813 | g6417 | i0 | 100 | 2.9952380952381 | 629 | 0 | 99 | 0 | 1 | 629 | 1740 | 1112 | Reagent-associated CRESS-like virus 5 isolate 11 replicase-like gene, partial sequence | blastn | 1887 | 1162 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 5 | ||||||
| 8195861 | 8195861 | PRJNA558770_P_NODE_8307_length_618_cov_7.197256_g6857_i0 | PRJNA558770 | 8307 | 618 | 7.197256 | 44.47904208 | Tick-associated circular virus-2 | 2951484 | Viruses | Viruses | 1123 | 0 | NTclustered | gi|2263979286|gb|ON456885.1| | 2951484 | g6857 | i0 | 99.515 | 1 | 618 | 1 | 99 | 1 | 1 | 616 | 1174 | 557 | Tick-associated circular virus-2 isolate Tick114CressC5, complete genome | blastn | 618 | 1123 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Tick-associated circular virus-2 | |||
| 8781885 | 8781885 | PRJNA558770_P_NODE_18187_length_461_cov_17.178404_g16354_i0 | PRJNA558770 | 18187 | 461 | 17.178404 | 79.19244244 | Viruses | 10239 | Viruses | Viruses | 848 | 0 | NTclustered | gi|1848664582|gb|MN891788.1| | 2740165 | g16354 | i0 | 100 | 3.06290672451193 | 459 | 0 | 99 | 0 | 3 | 461 | 1269 | 811 | Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome | blastn | 1412 | 848 | 1 | Viruses | CRESS viruses | Shotokuvirae | Cressdnaviricota | Brassica caulorapa CRESS virus | |||||
| 10744720 | 10744720 | PRJNA558770_P_NODE_277249_length_234_cov_1.778894_g275244_i0 | PRJNA558770 | 277249 | 234 | 1.778894 | 4.1626119600000004 | Flumine genomovirus 3 | 2940812 | Viruses | Viruses | 139 | 1.56e-28 | NTclustered | gi|2235497158|gb|OM953881.1| | 2940812 | g275244 | i0 | 100 | 3.65811965811966 | 75 | 0 | 63 | 0 | 160 | 234 | 2129 | 2055 | Flumine genomovirus 3 replication associated protein gene, complete cds | blastn | 856 | 139 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Flumine genomovirus 3 | |||
| 10746134 | 10746134 | PRJNA558770_P_NODE_396689_length_154_cov_2.453782_g394684_i0 | PRJNA558770 | 396689 | 154 | 2.453782 | 3.77882428 | Reagent-associated CRESS-like virus 6 | 2875814 | Viruses | Viruses | 281 | 1.48e-71 | NTclustered | gi|2094552983|gb|MZ824232.1| | 2875814 | g394684 | i0 | 100 | 0.987012987012987 | 152 | 0 | 99 | 0 | 3 | 154 | 2995 | 3146 | Reagent-associated CRESS-like virus 6 isolate 12 replicase-like gene, partial sequence | blastn | 152 | 281 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 6 | ||||||
| 11333124 | 11333124 | PRJNA558770_P_NODE_42029_length_328_cov_2.965870_g40031_i0 | PRJNA558770 | 42029 | 328 | 2.96587 | 9.7280536 | Arfiviricetes | 2732423 | Viruses | Viruses | 313 | 1.28e-80 | NTclustered | gi|2216801483|gb|MW202791.1| | 1954248 | g40031 | i0 | 100 | 4.82926829268293 | 169 | 0 | 72 | 0 | 1 | 169 | 1912 | 2080 | Circoviridae sp. isolate cthqR948, complete genome | blastn | 1584 | 313 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 11333399 | 11333399 | PRJNA558770_P_NODE_8289_length_618_cov_13.795883_g6841_i0 | PRJNA558770 | 8289 | 618 | 13.795883 | 85.25855694 | Viruses | 10239 | Viruses | Viruses | 1129 | 0 | NTclustered | gi|1848664582|gb|MN891788.1| | 2740165 | g6841 | i0 | 99.676 | 2.99514563106796 | 617 | 2 | 99 | 0 | 1 | 617 | 146 | 762 | Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome | blastn | 1851 | 1129 | 1 | Viruses | CRESS viruses | Shotokuvirae | Cressdnaviricota | Brassica caulorapa CRESS virus | |||||
| 12021770 | 12021770 | PRJNA558770_P_NODE_72930_length_243_cov_5.692308_g70925_i0 | PRJNA558770 | 72930 | 243 | 5.692308 | 13.83230844 | Tick-associated circular virus-2 | 2951484 | Viruses | Viruses | 444 | 3.09e-120 | NTclustered | gi|2263979286|gb|ON456885.1| | 2951484 | g70925 | i0 | 99.588 | 1 | 243 | 1 | 100 | 0 | 1 | 243 | 1395 | 1153 | Tick-associated circular virus-2 isolate Tick114CressC5, complete genome | blastn | 243 | 444 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Tick-associated circular virus-2 | |||
| 13295589 | 13295589 | PRJNA558770_P_NODE_382591_length_206_cov_9.380117_g380586_i0 | PRJNA558770 | 382591 | 206 | 9.380117 | 19.32304102 | Tick-associated circular virus-2 | 2951484 | Viruses | Viruses | 370 | 4.38e-98 | NTclustered | gi|2263979286|gb|ON456885.1| | 2951484 | g380586 | i0 | 99.029 | 1 | 206 | 2 | 100 | 0 | 1 | 206 | 1854 | 1649 | Tick-associated circular virus-2 isolate Tick114CressC5, complete genome | blastn | 206 | 370 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Tick-associated circular virus-2 | |||
| 13295737 | 13295737 | PRJNA558770_P_NODE_389071_length_180_cov_2.827586_g387066_i0 | PRJNA558770 | 389071 | 180 | 2.827586 | 5.0896548 | Reagent-associated CRESS-like virus 4 | 2875812 | Viruses | Viruses | 219 | 1.4199999999999999e-52 | NTclustered | gi|2094552985|gb|MZ824234.1| | 2875812 | g387066 | i0 | 99.18 | 0.677777777777778 | 122 | 0 | 67 | 1 | 60 | 180 | 1 | 122 | Reagent-associated CRESS-like virus 4 isolate 10 replicase-like gene, partial sequence | blastn | 122 | 219 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 4 | ||||||
| 13883844 | 13883844 | PRJNA558770_P_NODE_43711_length_321_cov_8.716783_g41713_i0 | PRJNA558770 | 43711 | 321 | 8.716783 | 27.98087343 | Viruses | 10239 | Viruses | Viruses | 573 | 5.199999999999999e-159 | NTclustered | gi|1848664582|gb|MN891788.1| | 2740165 | g41713 | i0 | 99.062 | 2.99065420560748 | 320 | 2 | 99 | 1 | 1 | 320 | 1310 | 1628 | Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome | blastn | 960 | 573 | 1 | Viruses | CRESS viruses | Shotokuvirae | Cressdnaviricota | Brassica caulorapa CRESS virus | |||||
| 14569876 | 14569876 | PRJNA558770_P_NODE_30792_length_388_cov_7.866856_g28818_i0 | PRJNA558770 | 30792 | 388 | 7.866856 | 30.52340128 | Tick-associated circular virus-2 | 2951484 | Viruses | Viruses | 451 | 3.13e-122 | NTclustered | gi|2263979286|gb|ON456885.1| | 2951484 | g28818 | i0 | 100 | 1.01288659793814 | 244 | 0 | 99 | 0 | 3 | 246 | 1880 | 2123 | Tick-associated circular virus-2 isolate Tick114CressC5, complete genome | blastn | 393 | 451 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Tick-associated circular virus-2 | |||
| 14570526 | 14570526 | PRJNA558770_P_NODE_384452_length_198_cov_4.907975_g382447_i0 | PRJNA558770 | 384452 | 198 | 4.907975 | 9.7177905 | Reagent-associated CRESS-like virus 6 | 2875814 | Viruses | Viruses | 359 | 9.03e-95 | NTclustered | gi|2094552983|gb|MZ824232.1| | 2875814 | g382447 | i0 | 99.492 | 0.994949494949495 | 197 | 1 | 99 | 0 | 1 | 197 | 979 | 783 | Reagent-associated CRESS-like virus 6 isolate 12 replicase-like gene, partial sequence | blastn | 197 | 359 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 6 | ||||||
| 24767794 | 24767794 | PRJNA558770_P_NODE_383740_length_201_cov_7.602410_g381735_i0 | PRJNA558770 | 383740 | 201 | 7.60241 | 15.2808441 | Reagent-associated CRESS-like virus 4 | 2875812 | Viruses | Viruses | 333 | 5.569999999999999e-87 | NTclustered | gi|2094552985|gb|MZ824234.1| | 2875812 | g381735 | i0 | 96.97 | 0.985074626865672 | 198 | 6 | 99 | 0 | 4 | 201 | 2660 | 2463 | Reagent-associated CRESS-like virus 4 isolate 10 replicase-like gene, partial sequence | blastn | 198 | 333 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Reagent-associated CRESS-like virus 4 | ||||||
| 25356146 | 25356146 | PRJNA558770_P_NODE_379160_length_221_cov_7.661290_g377155_i0 | PRJNA558770 | 379160 | 221 | 7.66129 | 16.9314509 | Arfiviricetes | 2732423 | Viruses | Viruses | 331 | 2.25e-86 | NTclustered | gi|2626080284|gb|OR270688.1| | 1954248 | g377155 | i0 | 93.191 | 6.16742081447964 | 235 | 1 | 99 | 2 | 2 | 221 | 1203 | 969 | MAG: Circoviridae sp. isolate GL83, complete genome | blastn | 1363 | 331 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 27647762 | 27647762 | PRJNA558770_P_NODE_395024_length_160_cov_3.736000_g393019_i0 | PRJNA558770 | 395024 | 160 | 3.736 | 5.9776 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 66.2 | 4.32e-11 | NR | AXH76405.1 | 2748378 | g393019 | i0 | 56.9 | 0.95625 | 51 | 22 | 95.6 | 0 | 6 | 158 | 172 | 222 | AXH76405.1 MAG: Rep [Cressdnaviricota sp.] | diamond | 153 | 66.2 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 27805674 | 27805674 | PRJNA558770_P_NODE_63384_length_262_cov_4.440529_g61379_i0 | PRJNA558770 | 63384 | 262 | 4.440529 | 11.63418598 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 103 | 1.05e-24 | NR | WAE42985.1 | 2748378 | g61379 | i0 | 61 | 0.938931297709924 | 82 | 29 | 90.5 | 1 | 248 | 12 | 164 | 245 | WAE42985.1 MAG: capsid protein [Cressdnaviricota sp.] | diamond | 246 | 103 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 27931783 | 27931783 | PRJNA558770_P_NODE_385165_length_195_cov_2.806250_g383160_i0 | PRJNA558770 | 385165 | 195 | 2.80625 | 5.4721875 | Arizlama virus | 2859451 | Viruses | Viruses | 43.1 | 0.0148 | NR | QXP07767.1 | 2859451 | g383160 | i0 | 35.8 | 1.55384615384615 | 53 | 34 | 81.5 | 0 | 189 | 31 | 254 | 306 | QXP07767.1 MAG: putative capsid protein [Arizlama virus] | diamond | 303 | 43.1 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arizlama virus | ||||||
| 29163403 | 29163403 | PRJNA558770_P_NODE_389109_length_180_cov_1.731034_g387104_i0 | PRJNA558770 | 389109 | 180 | 1.731034 | 3.1158612 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 58.9 | 2.35e-8 | NR | WAE43074.1 | 2748378 | g387104 | i0 | 76.7 | 0.5 | 30 | 7 | 50 | 0 | 174 | 85 | 241 | 270 | WAE43074.1 MAG: replication associated protein [Cressdnaviricota sp.] | diamond | 90 | 58.9 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 29257654 | 29257654 | PRJNA558770_P_NODE_62489_length_264_cov_4.091703_g60484_i0 | PRJNA558770 | 62489 | 264 | 4.091703 | 10.80209592 | Arizlama virus | 2859451 | Viruses | Viruses | 70.5 | 3.51e-12 | NR | QXP07768.1 | 2859451 | g60484 | i0 | 47.1 | 0.988636363636364 | 87 | 19 | 98.9 | 1 | 263 | 3 | 48 | 107 | QXP07768.1 MAG: replication associated protein [Arizlama virus] | diamond | 261 | 70.5 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arizlama virus | ||||||
| 29713554 | 29713554 | PRJNA558770_P_NODE_336650_length_233_cov_4.575758_g334645_i0 | PRJNA558770 | 336650 | 233 | 4.575758 | 10.66151614 | Viruses | 10239 | Viruses | Viruses | 50.4 | 5.87e-5 | NR | AXH73775.1 | 2748378 | g334645 | i0 | 83.3 | 1.59656652360515 | 24 | 4 | 30.9 | 0 | 162 | 233 | 49 | 72 | AXH73775.1 MAG: putative viral replication protein [Cressdnaviricota sp.] | diamond | 372 | 50.4 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 31311165 | 31311165 | PRJNA558770_P_NODE_394675_length_161_cov_4.388889_g392670_i0 | PRJNA558770 | 394675 | 161 | 4.388889 | 7.06611129 | Arizlama virus | 2859451 | Viruses | Viruses | 66.6 | 2.46e-11 | NR | QXP07768.1 | 2859451 | g392670 | i0 | 73 | 0.68944099378882 | 37 | 10 | 68.9 | 0 | 113 | 3 | 1 | 37 | QXP07768.1 MAG: replication associated protein [Arizlama virus] | diamond | 111 | 66.6 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arizlama virus | ||||||
| 31690753 | 31690753 | PRJNA558770_P_NODE_381977_length_209_cov_4.821839_g379972_i0 | PRJNA558770 | 381977 | 209 | 4.821839 | 10.07764351 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 58.9 | 3.61e-8 | NR | AXH76040.1 | 2748378 | g379972 | i0 | 49 | 0.703349282296651 | 49 | 25 | 70.3 | 0 | 204 | 58 | 235 | 283 | AXH76040.1 MAG: putative viral replication protein [Cressdnaviricota sp.] | diamond | 147 | 58.9 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 32007196 | 32007196 | PRJNA558770_P_NODE_58738_length_273_cov_2.802521_g56734_i0 | PRJNA558770 | 58738 | 273 | 2.802521 | 7.65088233 | Circoviridae sp. | 1954248 | Viruses | Viruses | 48.9 | 2.13e-4 | NR | QRI44238.1 | 1954248 | g56734 | i0 | 75 | 0.307692307692308 | 28 | 7 | 30.8 | 0 | 240 | 157 | 1 | 28 | QRI44238.1 MAG: replication-associated protein, partial [Circoviridae sp.] | diamond | 84 | 48.9 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard |
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);;