contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA1145276" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6666199 | 6666199 | PRJNA1145276_P_NODE_14506_length_264_cov_2.780105_g14449_i0 | PRJNA1145276 | 14506 | 264 | 2.780105 | 7.3394772 | Jasmine virus C | 1853762 | Viruses | Viruses | 177 | 1.79e-49 | NR | ULO04618.1 | 1853762 | g14449 | i0 | 98.9 | 2.96590909090909 | 87 | 1 | 98.9 | 0 | 262 | 2 | 1754 | 1840 | ULO04618.1 polyprotein [Jasmine virus C] | diamond | 783 | 177 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 6666218 | 6666218 | PRJNA1145276_P_NODE_15226_length_256_cov_1.262295_g15169_i0 | PRJNA1145276 | 15226 | 256 | 1.262295 | 3.2314752 | Jasmine virus C | 1853762 | Viruses | Viruses | 180 | 2.55e-50 | NR | ULO04618.1 | 1853762 | g15169 | i0 | 97.6 | 2.98828125 | 85 | 2 | 99.6 | 0 | 2 | 256 | 1822 | 1906 | ULO04618.1 polyprotein [Jasmine virus C] | diamond | 765 | 180 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 10491943 | 10491943 | PRJNA1145276_P_NODE_15349_length_254_cov_2.093923_g15292_i0 | PRJNA1145276 | 15349 | 254 | 2.093923 | 5.31856442 | Jasmine virus C | 1853762 | Viruses | Viruses | 167 | 5.03e-46 | NR | ULO04618.1 | 1853762 | g15292 | i0 | 96.4 | 2.94094488188976 | 83 | 3 | 98 | 0 | 252 | 4 | 1881 | 1963 | ULO04618.1 polyprotein [Jasmine virus C] | diamond | 747 | 167 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 14317410 | 14317410 | PRJNA1145276_P_NODE_5612_length_420_cov_1.325648_g5555_i0 | PRJNA1145276 | 5612 | 420 | 1.325648 | 5.5677216 | Jasmine virus C | 1853762 | Viruses | Viruses | 275 | 1.89e-82 | NR | ULO04618.1 | 1853762 | g5555 | i0 | 96.4 | 3 | 140 | 5 | 100 | 0 | 1 | 420 | 1588 | 1727 | ULO04618.1 polyprotein [Jasmine virus C] | diamond | 1260 | 275 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 26627372 | 26627372 | PRJNA1145276_P_NODE_1001_length_929_cov_1.369159_g959_i0 | PRJNA1145276 | 1001 | 929 | 1.369159 | 12.71948711 | Jasmine virus C | 1853762 | Viruses | Viruses | 506 | 9.69e-162 | NR | ULO04618.1 | 1853762 | g959 | i0 | 79.9 | 0.96232508073197 | 298 | 60 | 96.2 | 0 | 927 | 34 | 533 | 830 | ULO04618.1 polyprotein [Jasmine virus C] | diamond | 894 | 506 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 26721923 | 26721923 | PRJNA1145276_P_NODE_3141_length_548_cov_2.484211_g3084_i0 | PRJNA1145276 | 3141 | 548 | 2.484211 | 13.61347628 | Jasmine virus C | 1853762 | Viruses | Viruses | 187 | 3.0799999999999997e-56 | NR | ULO04619.1 | 1853762 | g3084 | i0 | 89.1 | 0.552919708029197 | 101 | 11 | 55.3 | 0 | 544 | 242 | 130 | 230 | ULO04619.1 triple gene block 1 [Jasmine virus C] | diamond | 303 | 187 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 27481350 | 27481350 | PRJNA1145276_P_NODE_3963_length_491_cov_2.258373_g3906_i0 | PRJNA1145276 | 3963 | 491 | 2.258373 | 11.08861143 | Jasmine virus C | 1853762 | Viruses | Viruses | 184 | 5.18e-57 | NR | ULO04620.1 | 1853762 | g3906 | i0 | 84.6 | 0.635437881873727 | 104 | 16 | 63.5 | 0 | 314 | 3 | 1 | 104 | ULO04620.1 triple gene block protein 2 [Jasmine virus C] | diamond | 312 | 184 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 27734258 | 27734258 | PRJNA1145276_P_NODE_13284_length_278_cov_1.663415_g13227_i0 | PRJNA1145276 | 13284 | 278 | 1.663415 | 4.6242937 | Jasmine virus C | 1853762 | Viruses | Viruses | 188 | 5.07e-53 | NR | ULO04618.1 | 1853762 | g13227 | i0 | 97.8 | 2.97841726618705 | 92 | 2 | 99.3 | 0 | 2 | 277 | 226 | 317 | ULO04618.1 polyprotein [Jasmine virus C] | diamond | 828 | 188 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 27828705 | 27828705 | PRJNA1145276_P_NODE_6444_length_394_cov_1.482866_g6387_i0 | PRJNA1145276 | 6444 | 394 | 1.482866 | 5.84249204 | Jasmine virus C | 1853762 | Viruses | Viruses | 202 | 2.66e-57 | NR | ULO04618.1 | 1853762 | g6387 | i0 | 71 | 0.99746192893401 | 131 | 38 | 99.7 | 0 | 393 | 1 | 569 | 699 | ULO04618.1 polyprotein [Jasmine virus C] | diamond | 393 | 202 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 27986556 | 27986556 | PRJNA1145276_P_NODE_19185_length_242_cov_0.911243_g19128_i0 | PRJNA1145276 | 19185 | 242 | 0.911243 | 2.20520806 | Jasmine virus C | 1853762 | Viruses | Viruses | 137 | 2.62e-35 | NR | ULO04618.1 | 1853762 | g19128 | i0 | 84.4 | 0.954545454545455 | 77 | 12 | 95.5 | 0 | 5 | 235 | 477 | 553 | ULO04618.1 polyprotein [Jasmine virus C] | diamond | 231 | 137 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 29028774 | 29028774 | PRJNA1145276_P_NODE_2368_length_627_cov_2.120939_g2312_i0 | PRJNA1145276 | 2368 | 627 | 2.120939 | 13.29828753 | Jasmine virus C | 1853762 | Viruses | Viruses | 352 | 2.59e-108 | NR | ULO04618.1 | 1853762 | g2312 | i0 | 91.7 | 0.861244019138756 | 180 | 15 | 86.1 | 0 | 3 | 542 | 1283 | 1462 | ULO04618.1 polyprotein [Jasmine virus C] | diamond | 540 | 352 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 29470205 | 29470205 | PRJNA1145276_P_NODE_11730_length_297_cov_1.075893_g11673_i0 | PRJNA1145276 | 11730 | 297 | 1.075893 | 3.19540221 | Jasmine virus C | 1853762 | Viruses | Viruses | 204 | 1.09e-58 | NR | YP_009275350.1 | 1853762 | g11673 | i0 | 98 | 3 | 99 | 2 | 100 | 0 | 1 | 297 | 1718 | 1816 | YP_009275350.1 replicase [Jasmine virus C] | diamond | 891 | 204 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 30007538 | 30007538 | PRJNA1145276_P_NODE_1611_length_752_cov_1.397644_g1559_i0 | PRJNA1145276 | 1611 | 752 | 1.397644 | 10.51028288 | Jasmine virus C | 1853762 | Viruses | Viruses | 491 | 2.989999999999999e-157 | NR | ULO04618.1 | 1853762 | g1559 | i0 | 92.8 | 0.993351063829787 | 249 | 18 | 99.3 | 0 | 3 | 749 | 1141 | 1389 | ULO04618.1 polyprotein [Jasmine virus C] | diamond | 747 | 491 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 30196764 | 30196764 | PRJNA1145276_P_NODE_15432_length_254_cov_1.005525_g15375_i0 | PRJNA1145276 | 15432 | 254 | 1.005525 | 2.5540335 | Jasmine virus C | 1853762 | Viruses | Viruses | 149 | 1.1e-39 | NR | ULO04618.1 | 1853762 | g15375 | i0 | 81 | 0.992125984251969 | 84 | 16 | 99.2 | 0 | 1 | 252 | 787 | 870 | ULO04618.1 polyprotein [Jasmine virus C] | diamond | 252 | 149 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 30670771 | 30670771 | PRJNA1145276_P_NODE_6713_length_387_cov_1.796178_g6656_i0 | PRJNA1145276 | 6713 | 387 | 1.796178 | 6.95120886 | Jasmine virus C | 1853762 | Viruses | Viruses | 208 | 2.24e-59 | NR | ULO04618.1 | 1853762 | g6656 | i0 | 75.8 | 0.992248062015504 | 128 | 31 | 99.2 | 0 | 386 | 3 | 825 | 952 | ULO04618.1 polyprotein [Jasmine virus C] | diamond | 384 | 208 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 31050322 | 31050322 | PRJNA1145276_P_NODE_10315_length_317_cov_1.795082_g10258_i0 | PRJNA1145276 | 10315 | 317 | 1.795082 | 5.69040994 | Jasmine virus C | 1853762 | Viruses | Viruses | 185 | 1.05e-51 | NR | ULO04618.1 | 1853762 | g10258 | i0 | 82.9 | 0.993690851735016 | 105 | 18 | 99.4 | 0 | 3 | 317 | 392 | 496 | ULO04618.1 polyprotein [Jasmine virus C] | diamond | 315 | 185 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 31366324 | 31366324 | PRJNA1145276_P_NODE_3096_length_552_cov_2.294363_g3039_i0 | PRJNA1145276 | 3096 | 552 | 2.294363 | 12.66488376 | Jasmine virus C | 1853762 | Viruses | Viruses | 332 | 1.3199999999999995e-101 | NR | ULO04618.1 | 1853762 | g3039 | i0 | 89.1 | 0.994565217391304 | 183 | 20 | 99.5 | 0 | 550 | 2 | 1029 | 1211 | ULO04618.1 polyprotein [Jasmine virus C] | diamond | 549 | 332 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 31619130 | 31619130 | PRJNA1145276_P_NODE_10536_length_314_cov_1.278008_g10479_i0 | PRJNA1145276 | 10536 | 314 | 1.278008 | 4.01294512 | Jasmine virus C | 1853762 | Viruses | Viruses | 195 | 2.3099999999999997e-55 | NR | UXX34115.1 | 1853762 | g10479 | i0 | 94.2 | 2.98089171974522 | 104 | 6 | 99.4 | 0 | 313 | 2 | 315 | 418 | UXX34115.1 replicase [Jasmine virus C] | diamond | 936 | 195 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 31745585 | 31745585 | PRJNA1145276_P_NODE_15997_length_250_cov_1.344633_g15940_i0 | PRJNA1145276 | 15997 | 250 | 1.344633 | 3.3615825 | Jasmine virus C | 1853762 | Viruses | Viruses | 160 | 1.7599999999999999e-43 | NR | ULO04618.1 | 1853762 | g15940 | i0 | 95.2 | 2.988 | 83 | 4 | 99.6 | 0 | 1 | 249 | 1565 | 1647 | ULO04618.1 polyprotein [Jasmine virus C] | diamond | 747 | 160 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 31777276 | 31777276 | PRJNA1145276_P_NODE_18037_length_245_cov_0.895349_g17980_i0 | PRJNA1145276 | 18037 | 245 | 0.895349 | 2.19360505 | Jasmine virus C | 1853762 | Viruses | Viruses | 147 | 6.23e-39 | NR | UXX34115.1 | 1853762 | g17980 | i0 | 91.3 | 2.93877551020408 | 80 | 7 | 98 | 0 | 245 | 6 | 351 | 430 | UXX34115.1 replicase [Jasmine virus C] | diamond | 720 | 147 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini | ||
| 31998782 | 31998782 | PRJNA1145276_P_NODE_398_length_1396_cov_1.554800_g375_i0 | PRJNA1145276 | 398 | 1396 | 1.5548 | 21.705008 | Jasmine virus C | 1853762 | Viruses | Viruses | 778 | 7.779999999999999e-262 | NR | ULO04618.1 | 1853762 | g375 | i0 | 80 | 0.999283667621776 | 465 | 93 | 99.9 | 0 | 1 | 1395 | 548 | 1012 | ULO04618.1 polyprotein [Jasmine virus C] | diamond | 1395 | 778 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus jasmini |
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);;