contig_metadata
21 rows where analysis = "blastn", 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 |
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);;