contig_metadata
20 rows where bioproject = "PRJNA800090", tax_phylum = "Kitrinoviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3349965 | 3349965 | PRJNA800090_P_NODE_3_length_8790_cov_40.282422_g2_i0 | PRJNA800090 | 3 | 8790 | 40.282422 | 3540.8248938 | Citrivirus citri | 3427970 | Viruses | Viruses | 16111 | 0 | NTclustered | gi|2177954234|gb|OK513325.1| | 129141 | g2 | i0 | 99.75 | 54.698976109215 | 8790 | 22 | 100 | 0 | 1 | 8790 | 38 | 8827 | MAG: Citrus leaf blotch virus isolate B2A-3-RC, complete genome | blastn | 480804 | 16111 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Citrivirus | Citrivirus citri | ||
| 3351840 | 3351840 | PRJNA800090_S_NODE_4543_length_536_cov_1.663812_g4431_i0 | PRJNA800090 | 4543 | 536 | 1.663812 | 8.91803232 | Actinidia seed-borne latent like virus | 2715797 | Viruses | Viruses | 566 | 1.5199999999999996e-156 | NTclustered | gi|1834198069|gb|MN022371.1| | 2715797 | g4431 | i0 | 86.207 | 0.973880597014925 | 522 | 72 | 97 | 0 | 12 | 533 | 4653 | 4132 | Actinidia seed-borne latent like virus isolate ASbLLV-Meixian, complete genome | blastn | 522 | 566 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Actinidia seed-borne latent like virus | |||
| 4627021 | 4627021 | PRJNA800090_P_NODE_21524_length_858_cov_4.404309_g19686_i0 | PRJNA800090 | 21524 | 858 | 4.404309 | 37.78897122 | Prunevirus actinidiae | 3241185 | Viruses | Viruses | 695 | 0 | NTclustered | gi|2177954332|gb|OK513356.1| | 2560282 | g19686 | i0 | 82.28 | 1.91142191142191 | 807 | 139 | 94 | 4 | 43 | 847 | 2544 | 3348 | MAG: Actinidia seed borne latent virus isolate ASbLV-CG-1, complete genome | blastn | 1640 | 695 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus actinidiae | ||
| 5903922 | 5903922 | PRJNA800090_S_NODE_1565_length_871_cov_1.306733_g1493_i0 | PRJNA800090 | 1565 | 871 | 1.306733 | 11.38164443 | Prunevirus actinidiae | 3241185 | Viruses | Viruses | 963 | 0 | NTclustered | gi|2177954337|gb|OK513357.1| | 2560282 | g1493 | i0 | 86.651 | 1.25717566016073 | 869 | 116 | 99 | 0 | 1 | 869 | 4759 | 5627 | MAG: Actinidia seed borne latent virus isolate ASbLV-MZH-28, complete genome | blastn | 1095 | 963 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus actinidiae | ||
| 7179307 | 7179307 | PRJNA800090_S_NODE_6_length_4363_cov_10.787378_g3_i0 | PRJNA800090 | 6 | 4363 | 10.787378 | 470.65330214 | Citrivirus citri | 3427970 | Viruses | Viruses | 8000 | 0 | NTclustered | gi|2177954234|gb|OK513325.1| | 129141 | g3 | i0 | 99.771 | 62.7973871189548 | 4363 | 9 | 100 | 1 | 1 | 4363 | 8805 | 4444 | MAG: Citrus leaf blotch virus isolate B2A-3-RC, complete genome | blastn | 273985 | 8000 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Citrivirus | Citrivirus citri | ||
| 11004830 | 11004830 | PRJNA800090_S_NODE_36229_length_191_cov_5.180328_g36117_i0 | PRJNA800090 | 36229 | 191 | 5.180328 | 9.89442648 | Citrivirus citri | 3427970 | Viruses | Viruses | 337 | 4.05e-88 | NTclustered | gi|2177954279|gb|OK513338.1| | 129141 | g36117 | i0 | 100 | 27.6230366492147 | 182 | 0 | 95 | 0 | 10 | 191 | 1816 | 1635 | MAG: Citrus leaf blotch virus isolate XL6-1, complete genome | blastn | 5276 | 337 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Citrivirus | Citrivirus citri | ||
| 12280470 | 12280470 | PRJNA800090_S_NODE_6670_length_447_cov_2.653439_g6558_i0 | PRJNA800090 | 6670 | 447 | 2.653439 | 11.86087233 | Citrivirus citri | 3427970 | Viruses | Viruses | 780 | 0 | NTclustered | gi|2177953998|gb|OK513349.1| | 129141 | g6558 | i0 | 99.533 | 30.4049217002237 | 428 | 2 | 96 | 0 | 1 | 428 | 1210 | 1637 | MAG: Citrus leaf blotch virus isolate ZZ30-26, partial genome | blastn | 13591 | 780 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Citrivirus | Citrivirus citri | ||
| 13554644 | 13554644 | PRJNA800090_S_NODE_8791_length_392_cov_2.953560_g8679_i0 | PRJNA800090 | 8791 | 392 | 2.95356 | 11.5779552 | Prunevirus actinidiae | 3241185 | Viruses | Viruses | 401 | 3.229999999999999e-107 | NTclustered | gi|2177954337|gb|OK513357.1| | 2560282 | g8679 | i0 | 85.602 | 1.94387755102041 | 382 | 55 | 97 | 0 | 11 | 392 | 6293 | 5912 | MAG: Actinidia seed borne latent virus isolate ASbLV-MZH-28, complete genome | blastn | 762 | 401 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus actinidiae | ||
| 14828860 | 14828860 | PRJNA800090_S_NODE_1452_length_901_cov_2.935096_g1383_i0 | PRJNA800090 | 1452 | 901 | 2.935096 | 26.44521496 | Citrivirus citri | 3427970 | Viruses | Viruses | 1648 | 0 | NTclustered | gi|1560019398|gb|MH427033.1| | 129141 | g1383 | i0 | 99.667 | 34.5715871254162 | 901 | 3 | 100 | 0 | 1 | 901 | 1785 | 2685 | Citrus leaf blotch virus isolate XL, complete genome | blastn | 31149 | 1648 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Citrivirus | Citrivirus citri | ||
| 17378801 | 17378801 | PRJNA800090_S_NODE_1454_length_901_cov_2.081731_g1385_i0 | PRJNA800090 | 1454 | 901 | 2.081731 | 18.75639631 | Citrivirus citri | 3427970 | Viruses | Viruses | 1640 | 0 | NTclustered | gi|2177954279|gb|OK513338.1| | 129141 | g1385 | i0 | 99.888 | 31.3951165371809 | 891 | 1 | 99 | 0 | 1 | 891 | 292 | 1182 | MAG: Citrus leaf blotch virus isolate XL6-1, complete genome | blastn | 28287 | 1640 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Citrivirus | Citrivirus citri | ||
| 17379325 | 17379325 | PRJNA800090_S_NODE_494_length_1376_cov_4.844682_g467_i0 | PRJNA800090 | 494 | 1376 | 4.844682 | 66.66282432 | Citrivirus citri | 3427970 | Viruses | Viruses | 2514 | 0 | NTclustered | gi|2177953979|gb|OK513342.1| | 129141 | g467 | i0 | 99.854 | 39.1504360465116 | 1367 | 2 | 99 | 0 | 1 | 1367 | 2888 | 4254 | MAG: Citrus leaf blotch virus isolate ZZ22-4, partial genome | blastn | 53871 | 2514 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Citrivirus | Citrivirus citri | ||
| 18652472 | 18652472 | PRJNA800090_S_NODE_7915_length_412_cov_2.489796_g7803_i0 | PRJNA800090 | 7915 | 412 | 2.489796 | 10.25795952 | Citrivirus citri | 3427970 | Viruses | Viruses | 756 | 0 | NTclustered | gi|2177953998|gb|OK513349.1| | 129141 | g7803 | i0 | 99.757 | 27.9878640776699 | 412 | 1 | 100 | 0 | 1 | 412 | 3025 | 2614 | MAG: Citrus leaf blotch virus isolate ZZ30-26, partial genome | blastn | 11531 | 756 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Citrivirus | Citrivirus citri | ||
| 21203155 | 21203155 | PRJNA800090_S_NODE_30477_length_234_cov_1.309091_g30365_i0 | PRJNA800090 | 30477 | 234 | 1.309091 | 3.06327294 | Prunevirus actinidiae | 3241185 | Viruses | Viruses | 250 | 6.92e-62 | NTclustered | gi|2177954337|gb|OK513357.1| | 2560282 | g30365 | i0 | 88.406 | 3.76923076923077 | 207 | 24 | 88 | 0 | 17 | 223 | 3518 | 3312 | MAG: Actinidia seed borne latent virus isolate ASbLV-MZH-28, complete genome | blastn | 882 | 250 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus actinidiae | ||
| 21623693 | 21623693 | PRJNA800090_S_NODE_297_length_1635_cov_5.911877_g280_i0 | PRJNA800090 | 297 | 1635 | 5.911877 | 96.65918895 | Prunevirus | 1914295 | Viruses | Viruses | 2052 | 0 | NTclustered | gi|2177954342|gb|OK513358.1| | 2560282 | g280 | i0 | 89.345 | 12.6452599388379 | 1633 | 174 | 99 | 0 | 1 | 1633 | 8139 | 6507 | MAG: Actinidia seed borne latent virus isolate ASbLV-ZZ25-8, complete genome | blastn | 20675 | 2061 | 0.995633187772926 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus actinidiae | ||
| 22476296 | 22476296 | PRJNA800090_P_NODE_51458_length_497_cov_2.000000_g49276_i0 | PRJNA800090 | 51458 | 497 | 2 | 9.94 | Prunevirus actinidiae | 3241185 | Viruses | Viruses | 555 | 3.029999999999999e-153 | NTclustered | gi|2177954337|gb|OK513357.1| | 2560282 | g49276 | i0 | 86.869 | 2.99597585513078 | 495 | 65 | 99 | 0 | 3 | 497 | 1169 | 675 | MAG: Actinidia seed borne latent virus isolate ASbLV-MZH-28, complete genome | blastn | 1489 | 555 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus actinidiae | ||
| 24171915 | 24171915 | PRJNA800090_P_NODE_145239_length_261_cov_1.125000_g143054_i0 | PRJNA800090 | 145239 | 261 | 1.125 | 2.93625 | Prunevirus | 1914295 | Viruses | Viruses | 359 | 1.25e-94 | NTclustered | gi|2177954332|gb|OK513356.1| | 2560282 | g143054 | i0 | 91.538 | 7.76245210727969 | 260 | 22 | 99 | 0 | 2 | 261 | 25 | 284 | MAG: Actinidia seed borne latent virus isolate ASbLV-CG-1, complete genome | blastn | 2026 | 359 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus actinidiae | ||
| 25022916 | 25022916 | PRJNA800090_P_NODE_100_length_4847_cov_14.135412_g79_i0 | PRJNA800090 | 100 | 4847 | 14.135412 | 685.14341964 | Prunevirus actinidiae | 3241185 | Viruses | Viruses | 5240 | 0 | NTclustered | gi|2177954337|gb|OK513357.1| | 2560282 | g79 | i0 | 86.208 | 9.58035898493914 | 4858 | 648 | 100 | 21 | 1 | 4847 | 3268 | 8114 | MAG: Actinidia seed borne latent virus isolate ASbLV-MZH-28, complete genome | blastn | 46436 | 5240 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus actinidiae | ||
| 25026461 | 25026461 | PRJNA800090_P_NODE_81940_length_368_cov_3.712375_g79755_i0 | PRJNA800090 | 81940 | 368 | 3.712375 | 13.66154 | Actinidia seed-borne latent like virus | 2715797 | Viruses | Viruses | 492 | 1.7399999999999996e-134 | NTclustered | gi|1834198069|gb|MN022371.1| | 2715797 | g79755 | i0 | 90.761 | 3 | 368 | 34 | 100 | 0 | 1 | 368 | 728 | 361 | Actinidia seed-borne latent like virus isolate ASbLLV-Meixian, complete genome | blastn | 1104 | 492 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Actinidia seed-borne latent like virus | |||
| 29896271 | 29896271 | PRJNA800090_P_NODE_33031_length_659_cov_3.103390_g30910_i0 | PRJNA800090 | 33031 | 659 | 3.10339 | 20.4513401 | Actinidia seed-borne latent like virus | 2715797 | Viruses | Viruses | 210 | 1.22e-58 | NR | QJD14857.1 | 2715797 | g30910 | i0 | 56.7 | 2.02124430955994 | 224 | 81 | 97.9 | 4 | 657 | 13 | 459 | 675 | QJD14857.1 replicase [Actinidia seed-borne latent like virus] | diamond | 1332 | 210 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Actinidia seed-borne latent like virus | |||
| 32866754 | 32866754 | PRJNA800090_S_NODE_27340_length_245_cov_1.051136_g27228_i0 | PRJNA800090 | 27340 | 245 | 1.051136 | 2.5752832 | Actinidia seed-borne latent like virus | 2715797 | Viruses | Viruses | 90.5 | 6.06e-19 | NR | QJD14857.1 | 2715797 | g27228 | i0 | 61.4 | 0.857142857142857 | 70 | 27 | 85.7 | 0 | 1 | 210 | 524 | 593 | QJD14857.1 replicase [Actinidia seed-borne latent like virus] | diamond | 210 | 90.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Actinidia seed-borne latent like virus |
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);;