contig_metadata
23 rows where bioproject = "PRJNA404067" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10618459 | 10618459 | PRJNA404067_P_NODE_22269_length_230_cov_1.360947_g21882_i0 | PRJNA404067 | 22269 | 230 | 1.360947 | 3.1301781 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 159 | 1.18e-34 | NTclustered | gi|1675877000|gb|MK032720.1| | 2748378 | g21882 | i0 | 80.976 | 0.891304347826087 | 205 | 35 | 88 | 4 | 6 | 208 | 2164 | 2366 | MAG: Cressdnaviricota sp. isolate ctcb355, complete genome | blastn | 205 | 159 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 11893269 | 11893269 | PRJNA404067_P_NODE_1870_length_1838_cov_6.615082_g1691_i0 | PRJNA404067 | 1870 | 1838 | 6.615082 | 121.58520716 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 322 | 3.45e-102 | NR | WAE42443.1 | 2748378 | g1691 | i0 | 53 | 1.46735582154516 | 302 | 131 | 49.1 | 5 | 1542 | 640 | 14 | 305 | WAE42443.1 MAG: replication associated protein [Cressdnaviricota sp.] | diamond | 2697 | 322 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 15717478 | 15717478 | PRJNA404067_P_NODE_3673_length_909_cov_10.586085_g3357_i0 | PRJNA404067 | 3673 | 909 | 10.586085 | 96.22751265 | Meliavirus jackflis | 3430793 | Viruses | Viruses | 1639 | 0 | NTclustered | gi|1774767425|gb|MN582096.1| | 2656686 | g3357 | i0 | 99.23 | 1 | 909 | 6 | 100 | 1 | 1 | 909 | 4536 | 3629 | MAG: CRESS virus sp. ctin15, complete genome | blastn | 909 | 1639 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Gredzevirales | Gandrviridae | Meliavirus | Meliavirus jackflis | ||
| 16992392 | 16992392 | PRJNA404067_P_NODE_42814_length_183_cov_5.024590_g42427_i0 | PRJNA404067 | 42814 | 183 | 5.02459 | 9.1949997 | Meliavirus jackflis | 3430793 | Viruses | Viruses | 226 | 8.679999999999998e-55 | NTclustered | gi|1774767425|gb|MN582096.1| | 2656686 | g42427 | i0 | 100 | 1 | 122 | 0 | 100 | 0 | 1 | 122 | 4614 | 4493 | MAG: CRESS virus sp. ctin15, complete genome | blastn | 183 | 226 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Gredzevirales | Gandrviridae | Meliavirus | Meliavirus jackflis | ||
| 19540400 | 19540400 | PRJNA404067_P_NODE_2756_length_1242_cov_17.993226_g2504_i0 | PRJNA404067 | 2756 | 1242 | 17.993226 | 223.47586692 | Meliavirus jackflis | 3430793 | Viruses | Viruses | 2289 | 0 | NTclustered | gi|1774767425|gb|MN582096.1| | 2656686 | g2504 | i0 | 99.919 | 1 | 1242 | 1 | 100 | 0 | 1 | 1242 | 1378 | 137 | MAG: CRESS virus sp. ctin15, complete genome | blastn | 1242 | 2289 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Gredzevirales | Gandrviridae | Meliavirus | Meliavirus jackflis | ||
| 19540574 | 19540574 | PRJNA404067_P_NODE_3656_length_914_cov_8.643611_g3341_i0 | PRJNA404067 | 3656 | 914 | 8.643611 | 79.00260454 | Meliavirus jackflis | 3430793 | Viruses | Viruses | 1666 | 0 | NTclustered | gi|1774767425|gb|MN582096.1| | 2656686 | g3341 | i0 | 99.562 | 1 | 914 | 4 | 100 | 0 | 1 | 914 | 2824 | 3737 | MAG: CRESS virus sp. ctin15, complete genome | blastn | 914 | 1666 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Gredzevirales | Gandrviridae | Meliavirus | Meliavirus jackflis | ||
| 22090987 | 22090987 | PRJNA404067_P_NODE_22178_length_230_cov_2.355030_g21791_i0 | PRJNA404067 | 22178 | 230 | 2.35503 | 5.416569 | Meliavirus jackflis | 3430793 | Viruses | Viruses | 268 | 1.87e-67 | NTclustered | gi|1774767425|gb|MN582096.1| | 2656686 | g21791 | i0 | 95.266 | 0.991304347826087 | 169 | 8 | 96 | 0 | 1 | 169 | 4307 | 4139 | MAG: CRESS virus sp. ctin15, complete genome | blastn | 228 | 268 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Gredzevirales | Gandrviridae | Meliavirus | Meliavirus jackflis | ||
| 23366586 | 23366586 | PRJNA404067_P_NODE_2319_length_1504_cov_17.146916_g2100_i0 | PRJNA404067 | 2319 | 1504 | 17.146916 | 257.88961664 | Meliavirus jackflis | 3430793 | Viruses | Viruses | 2732 | 0 | NTclustered | gi|1774767425|gb|MN582096.1| | 2656686 | g2100 | i0 | 99.533 | 0.997340425531915 | 1500 | 7 | 99 | 0 | 3 | 1502 | 1393 | 2892 | MAG: CRESS virus sp. ctin15, complete genome | blastn | 1500 | 2732 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Gredzevirales | Gandrviridae | Meliavirus | Meliavirus jackflis | ||
| 23366962 | 23366962 | PRJNA404067_P_NODE_4539_length_714_cov_7.563553_g4194_i0 | PRJNA404067 | 4539 | 714 | 7.563553 | 54.00376842 | Meliavirus jackflis | 3430793 | Viruses | Viruses | 1206 | 0 | NTclustered | gi|1774767425|gb|MN582096.1| | 2656686 | g4194 | i0 | 99.398 | 0.995798319327731 | 665 | 4 | 99 | 0 | 1 | 665 | 4554 | 5218 | MAG: CRESS virus sp. ctin15, complete genome | blastn | 711 | 1206 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Gredzevirales | Gandrviridae | Meliavirus | Meliavirus jackflis | ||
| 24640791 | 24640791 | PRJNA404067_P_NODE_11260_length_318_cov_0.953307_g10875_i0 | PRJNA404067 | 11260 | 318 | 0.953307 | 3.03151626 | Galvornvirus isengard | 2955925 | Viruses | Viruses | 416 | 9.169999999999998e-112 | NTclustered | gi|2302005281|gb|MT200828.1| | 1954248 | g10875 | i0 | 90.252 | 1.91509433962264 | 318 | 31 | 100 | 0 | 1 | 318 | 1263 | 1580 | MAG: Circoviridae sp. isolate CN13_L12_1, complete genome | blastn | 609 | 416 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 26822423 | 26822423 | PRJNA404067_P_NODE_3281_length_1031_cov_5.179381_g2997_i0 | PRJNA404067 | 3281 | 1031 | 5.179381 | 53.39941811 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 80.1 | 1.82e-13 | NR | WAE43190.1 | 2748378 | g2997 | i0 | 30 | 0.590688651794374 | 203 | 131 | 56.2 | 4 | 363 | 941 | 21 | 222 | WAE43190.1 MAG: capsid protein [Cressdnaviricota sp.] | diamond | 609 | 80.1 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 27154943 | 27154943 | PRJNA404067_P_NODE_1362_length_2421_cov_62.047458_g1226_i0 | PRJNA404067 | 1362 | 2421 | 62.047458 | 1502.16895818 | Arfiviricetes | 2732423 | Viruses | Viruses | 242 | 4.8300000000000006e-70 | NR | YP_009116894.1 | 1592083 | g1226 | i0 | 64 | 3.71995043370508 | 172 | 62 | 21.3 | 0 | 212 | 727 | 90 | 261 | YP_009116894.1 replication-associated protein [Sewage-associated circular DNA virus-16] | diamond | 9006 | 243 | 0.995884773662551 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Saturnivirales | Kanorauviridae | Kaiwanvirus | Kaiwanvirus sewoxi | ||
| 27833453 | 27833453 | PRJNA404067_P_NODE_12304_length_300_cov_2.209205_g11918_i0 | PRJNA404067 | 12304 | 300 | 2.209205 | 6.627615 | Turdus naumanni CRESS-DNA-virus sp. | 2815063 | Viruses | Viruses | 112 | 2.44e-28 | NR | QTE03580.1 | 2815063 | g11918 | i0 | 57.6 | 0.99 | 99 | 42 | 99 | 0 | 299 | 3 | 95 | 193 | QTE03580.1 MAG: capsid protein [Turdus naumanni CRESS-DNA-virus sp.] | diamond | 297 | 112 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Turdus naumanni CRESS-DNA-virus sp. | ||||||
| 28717729 | 28717729 | PRJNA404067_P_NODE_6187_length_509_cov_3.049107_g5814_i0 | PRJNA404067 | 6187 | 509 | 3.049107 | 15.51995463 | CRESS virus sp. ctin15 | 2656686 | Viruses | Viruses | 237 | 4.02e-75 | NR | QGH73226.1 | 2656686 | g5814 | i0 | 67.3 | 0.990176817288802 | 168 | 55 | 99 | 0 | 1 | 504 | 137 | 304 | QGH73226.1 MAG: Rep protein [CRESS virus sp. ctin15] | diamond | 504 | 237 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Gredzevirales | Gandrviridae | Meliavirus | Meliavirus jackflis | ||
| 29018785 | 29018785 | PRJNA404067_P_NODE_27168_length_217_cov_5.448718_g26781_i0 | PRJNA404067 | 27168 | 217 | 5.448718 | 11.82371806 | Bacilladnavirus | 674979 | Viruses | Viruses | 90.5 | 2.5e-19 | NR | AXH77453.1 | 2267680 | g26781 | i0 | 58.2 | 1.89400921658986 | 67 | 28 | 92.6 | 0 | 14 | 214 | 117 | 183 | AXH77453.1 MAG: putative viral replication protein [Bacilladnavirus sp.] | diamond | 411 | 91.3 | 0.991237677984666 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Baphyvirales | Bacilladnaviridae | Bacilladnavirus | Bacilladnavirus sp. | ||
| 29222985 | 29222985 | PRJNA404067_P_NODE_45109_length_167_cov_4.226415_g44722_i0 | PRJNA404067 | 45109 | 167 | 4.226415 | 7.05811305 | Crogonang virus 31 | 3063426 | Viruses | Viruses | 47.8 | 2.27e-4 | NR | WPR18629.1 | 3063426 | g44722 | i0 | 65.4 | 0.934131736526946 | 26 | 9 | 46.7 | 0 | 86 | 163 | 1 | 26 | WPR18629.1 MAG: hypothetical protein [Crogonang virus 31] | diamond | 156 | 47.8 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Crogonang virus 31 | ||||||
| 29886049 | 29886049 | PRJNA404067_P_NODE_29411_length_212_cov_4.344371_g29024_i0 | PRJNA404067 | 29411 | 212 | 4.344371 | 9.21006652 | Smacoviridae sp. | 2715094 | Viruses | Viruses | 52.8 | 5.3e-6 | NR | WQA30387.1 | 2715094 | g29024 | i0 | 43.5 | 1.78301886792453 | 69 | 34 | 96.2 | 3 | 8 | 211 | 134 | 198 | WQA30387.1 MAG: rep protein, partial [Smacoviridae sp.] | diamond | 378 | 52.8 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cremevirales | Smacoviridae | Smacoviridae sp. | |||
| 30075304 | 30075304 | PRJNA404067_P_NODE_20312_length_236_cov_1.154286_g19925_i0 | PRJNA404067 | 20312 | 236 | 1.154286 | 2.72411496 | Wigfec virus K19_668 | 2986018 | Viruses | Viruses | 62.4 | 3.27e-9 | NR | UYD39137.1 | 2986018 | g19925 | i0 | 41.7 | 1.90677966101695 | 72 | 37 | 91.5 | 1 | 1 | 216 | 165 | 231 | UYD39137.1 MAG: replication associated protein [Wigfec virus K19_668] | diamond | 450 | 62.4 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Wigfec virus K19_668 | ||||||
| 32130409 | 32130409 | PRJNA404067_P_NODE_13998_length_278_cov_3.239631_g13611_i0 | PRJNA404067 | 13998 | 278 | 3.239631 | 9.00617418 | Circoviridae sp. | 1954248 | Viruses | Viruses | 56.6 | 5.87e-7 | NR | AXQ65675.1 | 1954248 | g13611 | i0 | 31 | 0.938848920863309 | 87 | 54 | 87.4 | 1 | 272 | 30 | 174 | 260 | AXQ65675.1 MAG: putative capsid protein [Circoviridae sp.] | diamond | 261 | 56.6 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 32162039 | 32162039 | PRJNA404067_P_NODE_29698_length_212_cov_1.225166_g29311_i0 | PRJNA404067 | 29698 | 212 | 1.225166 | 2.59735192 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 46.2 | 0.00128 | NR | AYP28705.1 | 2748378 | g29311 | i0 | 40.8 | 1.07547169811321 | 76 | 38 | 99.1 | 4 | 211 | 2 | 124 | 198 | AYP28705.1 MAG: coat protein [Cressdnaviricota sp.] | diamond | 228 | 46.2 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 32541804 | 32541804 | PRJNA404067_P_NODE_37639_length_202_cov_0.907801_g37252_i0 | PRJNA404067 | 37639 | 202 | 0.907801 | 1.83375802 | Grus japonensis CRESS-DNA-virus sp. | 2815045 | Viruses | Viruses | 59.7 | 1.69e-8 | NR | QTE03495.1 | 2815045 | g37252 | i0 | 48.1 | 1.51485148514851 | 52 | 22 | 77.2 | 1 | 1 | 156 | 101 | 147 | QTE03495.1 MAG: putative capsid protein [Grus japonensis CRESS-DNA-virus sp.] | diamond | 306 | 59.7 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Grus japonensis CRESS-DNA-virus sp. | ||||||
| 32793322 | 32793322 | PRJNA404067_P_NODE_42700_length_184_cov_4.300813_g42313_i0 | PRJNA404067 | 42700 | 184 | 4.300813 | 7.91349592 | Turdus naumanni CRESS-DNA-virus sp. | 2815063 | Viruses | Viruses | 98.6 | 1.74e-23 | NR | QTE03580.1 | 2815063 | g42313 | i0 | 70 | 0.978260869565217 | 60 | 18 | 97.8 | 0 | 183 | 4 | 25 | 84 | QTE03580.1 MAG: capsid protein [Turdus naumanni CRESS-DNA-virus sp.] | diamond | 180 | 98.6 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Turdus naumanni CRESS-DNA-virus sp. | ||||||
| 32825078 | 32825078 | PRJNA404067_P_NODE_23700_length_226_cov_1.709091_g23313_i0 | PRJNA404067 | 23700 | 226 | 1.709091 | 3.86254566 | Crogonang virus 31 | 3063426 | Viruses | Viruses | 53.9 | 2.94e-7 | NR | XII43503.1 | 3063426 | g23313 | i0 | 62.5 | 0.530973451327434 | 40 | 15 | 53.1 | 0 | 2 | 121 | 56 | 95 | XII43503.1 MAG: hypothetical protein [Crogonang virus 31] | diamond | 120 | 53.9 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Crogonang virus 31 |
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);;