contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA853194" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2115131 | 2115131 | PRJNA853194_S_NODE_10142_length_591_cov_40.588803_g9103_i0 | PRJNA853194 | 10142 | 591 | 40.588803 | 239.87982573 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.005 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g9103 | i0 | 100 | 0.050761421319797 | 30 | 0 | 5 | 0 | 1 | 30 | 13 | 42 | Carnation latent virus isolate KL, complete genome | blastn | 30 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 3390453 | 3390453 | PRJNA853194_S_NODE_11423_length_563_cov_29.220408_g10364_i0 | PRJNA853194 | 11423 | 563 | 29.220408 | 164.51089704 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.004 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g10364 | i0 | 94.595 | 0.220248667850799 | 37 | 1 | 7 | 1 | 1 | 37 | 13 | 48 | Carnation latent virus isolate KL, complete genome | blastn | 124 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 3390779 | 3390779 | PRJNA853194_S_NODE_25223_length_408_cov_8.498507_g24132_i0 | PRJNA853194 | 25223 | 408 | 8.498507 | 34.67390856 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.011 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g24132 | i0 | 100 | 0.139705882352941 | 29 | 0 | 7 | 0 | 1 | 29 | 6 | 34 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 3390894 | 3390894 | PRJNA853194_S_NODE_30223_length_380_cov_2.469055_g29132_i0 | PRJNA853194 | 30223 | 380 | 2.469055 | 9.3824090000000009 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g29132 | i0 | 100 | 0.373684210526316 | 30 | 0 | 8 | 0 | 1 | 30 | 13 | 42 | Carnation latent virus isolate KL, complete genome | blastn | 142 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 3390918 | 3390918 | PRJNA853194_S_NODE_31443_length_374_cov_2.106312_g30352_i0 | PRJNA853194 | 31443 | 374 | 2.106312 | 7.87760688 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 60.2 | 2.13e-4 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g30352 | i0 | 100 | 0.385026737967914 | 32 | 0 | 9 | 0 | 1 | 32 | 13 | 44 | Carnation latent virus isolate KL, complete genome | blastn | 144 | 60.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 3391505 | 3391505 | PRJNA853194_S_NODE_62003_length_278_cov_2.112195_g60912_i0 | PRJNA853194 | 62003 | 278 | 2.112195 | 5.8719021 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g60912 | i0 | 94.286 | 0.633093525179856 | 35 | 2 | 13 | 0 | 244 | 278 | 47 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 176 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 5944271 | 5944271 | PRJNA853194_S_NODE_7845_length_663_cov_404.852542_g6860_i0 | PRJNA853194 | 7845 | 663 | 404.852542 | 2684.17235346 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 58.4 | 0.001 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g6860 | i0 | 100 | 0.0467571644042232 | 31 | 0 | 5 | 0 | 633 | 663 | 43 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 31 | 58.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 8493879 | 8493879 | PRJNA853194_S_NODE_71287_length_260_cov_1.401070_g70196_i0 | PRJNA853194 | 71287 | 260 | 1.40107 | 3.642782 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g70196 | i0 | 100 | 0.219230769230769 | 29 | 0 | 11 | 0 | 232 | 260 | 34 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 9768211 | 9768211 | PRJNA853194_S_NODE_30668_length_378_cov_1.767213_g29577_i0 | PRJNA853194 | 30668 | 378 | 1.767213 | 6.68006514 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.01 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g29577 | i0 | 94.444 | 0.391534391534392 | 36 | 1 | 9 | 1 | 344 | 378 | 48 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 148 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 11043897 | 11043897 | PRJNA853194_S_NODE_33469_length_365_cov_1.181507_g32378_i0 | PRJNA853194 | 33469 | 365 | 1.181507 | 4.31250055 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 558 | 1.67e-154 | NTclustered | gi|564614830|gb|KF421939.1| | 12188 | g32378 | i0 | 94.247 | 17.5917808219178 | 365 | 21 | 100 | 0 | 1 | 365 | 1911 | 1547 | White clover mosaic virus isolate 05TGP00172 putative RNA replicase, putative triple gene block protein 1, putative triple gene block protein 2, putative triple gene block protein 3, and putative coat protein genes, complete cds | blastn | 6421 | 558 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 11044189 | 11044189 | PRJNA853194_S_NODE_4889_length_810_cov_227.226594_g4066_i0 | PRJNA853194 | 4889 | 810 | 227.226594 | 1840.5354114 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.023 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g4066 | i0 | 96.875 | 0.0395061728395062 | 32 | 1 | 4 | 0 | 779 | 810 | 44 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 32 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 12319795 | 12319795 | PRJNA853194_S_NODE_4950_length_806_cov_44.492497_g4123_i0 | PRJNA853194 | 4950 | 806 | 44.492497 | 358.60952582 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 58.4 | 0.002 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g4123 | i0 | 100 | 0.0384615384615385 | 31 | 0 | 4 | 0 | 776 | 806 | 43 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 31 | 58.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 12320506 | 12320506 | PRJNA853194_S_NODE_9010_length_623_cov_43.167273_g7992_i0 | PRJNA853194 | 9010 | 623 | 43.167273 | 268.93211079 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.005 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g7992 | i0 | 100 | 0.0481540930979133 | 30 | 0 | 5 | 0 | 1 | 30 | 13 | 42 | Carnation latent virus isolate KL, complete genome | blastn | 30 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 14867721 | 14867721 | PRJNA853194_S_NODE_11832_length_555_cov_6.856846_g10768_i0 | PRJNA853194 | 11832 | 555 | 6.856846 | 38.0554953 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 60.2 | 3.27e-4 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g10768 | i0 | 100 | 0.0576576576576577 | 32 | 0 | 6 | 0 | 1 | 32 | 13 | 44 | Carnation latent virus isolate KL, complete genome | blastn | 32 | 60.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 14868084 | 14868084 | PRJNA853194_S_NODE_28612_length_388_cov_271.939683_g27521_i0 | PRJNA853194 | 28612 | 388 | 271.939683 | 1055.12597004 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g27521 | i0 | 100 | 0.365979381443299 | 30 | 0 | 8 | 0 | 359 | 388 | 42 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 142 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 16142567 | 16142567 | PRJNA853194_S_NODE_1433_length_1309_cov_91.699029_g1065_i0 | PRJNA853194 | 1433 | 1309 | 91.699029 | 1200.34028961 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 58.4 | 0.003 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g1065 | i0 | 97.059 | 0.025974025974026 | 34 | 1 | 3 | 0 | 1 | 34 | 6 | 39 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 34 | 58.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 18691132 | 18691132 | PRJNA853194_S_NODE_15535_length_495_cov_72.132701_g14447_i0 | PRJNA853194 | 15535 | 495 | 72.132701 | 357.05686995 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 56.5 | 0.004 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g14447 | i0 | 100 | 0.117171717171717 | 30 | 0 | 6 | 0 | 466 | 495 | 35 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 19966437 | 19966437 | PRJNA853194_S_NODE_20456_length_443_cov_18.778378_g19365_i0 | PRJNA853194 | 20456 | 443 | 18.778378 | 83.18821454 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.012 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g19365 | i0 | 100 | 0.318284424379232 | 29 | 0 | 7 | 0 | 415 | 443 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 19967039 | 19967039 | PRJNA853194_S_NODE_47836_length_313_cov_4.300000_g46745_i0 | PRJNA853194 | 47836 | 313 | 4.3 | 13.459 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g46745 | i0 | 100 | 0.182108626198083 | 29 | 0 | 9 | 0 | 285 | 313 | 34 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 20360923 | 20360923 | PRJNA853194_S_NODE_88536_length_205_cov_4.924242_g87445_i0 | PRJNA853194 | 88536 | 205 | 4.924242 | 10.0946961 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.005 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g87445 | i0 | 100 | 0.741463414634146 | 29 | 0 | 14 | 0 | 177 | 205 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 152 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 21242505 | 21242505 | PRJNA853194_S_NODE_45617_length_320_cov_1.821862_g44526_i0 | PRJNA853194 | 45617 | 320 | 1.821862 | 5.8299584 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g44526 | i0 | 100 | 0.440625 | 29 | 0 | 9 | 0 | 1 | 29 | 13 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 22516556 | 22516556 | PRJNA853194_S_NODE_15398_length_498_cov_1.021176_g14310_i0 | PRJNA853194 | 15398 | 498 | 1.021176 | 5.08545648 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.014 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g14310 | i0 | 100 | 0.114457831325301 | 29 | 0 | 6 | 0 | 470 | 498 | 34 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 23792450 | 23792450 | PRJNA853194_S_NODE_32459_length_369_cov_2.692568_g31368_i0 | PRJNA853194 | 32459 | 369 | 2.692568 | 9.93557592 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.01 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g31368 | i0 | 100 | 0.382113821138211 | 29 | 0 | 8 | 0 | 341 | 369 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 24186129 | 24186129 | PRJNA853194_S_NODE_8839_length_628_cov_201.342342_g7823_i0 | PRJNA853194 | 8839 | 628 | 201.342342 | 1264.42990776 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.017 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g7823 | i0 | 100 | 0.103503184713376 | 29 | 0 | 5 | 0 | 600 | 628 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 65 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi |
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);;