contig_metadata
15 rows where bioproject = "PRJNA572587", tax_kingdom = "Orthornavirae" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3109552 | 3109552 | PRJNA572587_P_NODE_13123_length_320_cov_45.782288_g12795_i0 | PRJNA572587 | 13123 | 320 | 45.782288 | 146.5033216 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 58.4 | 6.45e-4 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g12795 | i0 | 94.595 | 0.115625 | 37 | 2 | 12 | 0 | 284 | 320 | 51 | 15 | Carnation latent virus isolate KL, complete genome | blastn | 37 | 58.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 6937107 | 6937107 | PRJNA572587_P_NODE_34026_length_189_cov_30.321429_g33698_i0 | PRJNA572587 | 34026 | 189 | 30.321429 | 57.30750081 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 52.8 | 0.016 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g33698 | i0 | 100 | 0.148148148148148 | 28 | 0 | 15 | 0 | 162 | 189 | 42 | 15 | Carnation latent virus isolate KL, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 8211680 | 8211680 | PRJNA572587_P_NODE_13107_length_320_cov_198.726937_g12779_i0 | PRJNA572587 | 13107 | 320 | 198.726937 | 635.9261984 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g12779 | i0 | 100 | 0.440625 | 29 | 0 | 9 | 0 | 292 | 320 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 8211980 | 8211980 | PRJNA572587_P_NODE_29947_length_203_cov_8.058442_g29619_i0 | PRJNA572587 | 29947 | 203 | 8.058442 | 16.35863726 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g29619 | i0 | 100 | 0.142857142857143 | 29 | 0 | 14 | 0 | 1 | 29 | 15 | 43 | Carnation latent virus isolate KL, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 8212026 | 8212026 | PRJNA572587_P_NODE_32187_length_195_cov_19.212329_g31859_i0 | PRJNA572587 | 32187 | 195 | 19.212329 | 37.46404155 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 58.4 | 3.62e-4 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g31859 | i0 | 90.909 | 0.82051282051282 | 44 | 3 | 22 | 1 | 153 | 195 | 56 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 160 | 58.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 13312750 | 13312750 | PRJNA572587_P_NODE_20831_length_247_cov_99.893939_g20503_i0 | PRJNA572587 | 20831 | 247 | 99.893939 | 246.73802933 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 62.1 | 3.71e-5 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g20503 | i0 | 88.679 | 0.781376518218624 | 53 | 2 | 21 | 4 | 197 | 247 | 63 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 193 | 62.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 13312841 | 13312841 | PRJNA572587_P_NODE_25851_length_220_cov_13.093567_g25523_i0 | PRJNA572587 | 25851 | 220 | 13.093567 | 28.8058474 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 52.8 | 0.019 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g25523 | i0 | 100 | 0.127272727272727 | 28 | 0 | 13 | 0 | 1 | 28 | 8 | 35 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 15861502 | 15861502 | PRJNA572587_P_NODE_23713_length_231_cov_16.296703_g23385_i0 | PRJNA572587 | 23713 | 231 | 16.296703 | 37.64538393 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 52.8 | 0.021 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g23385 | i0 | 100 | 0.121212121212121 | 28 | 0 | 12 | 0 | 1 | 28 | 8 | 35 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 19685247 | 19685247 | PRJNA572587_P_NODE_18796_length_262_cov_17.492958_g18468_i0 | PRJNA572587 | 18796 | 262 | 17.492958 | 45.83154996 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g18468 | i0 | 89.13 | 0.709923664122137 | 46 | 2 | 18 | 3 | 217 | 262 | 55 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 186 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 19685285 | 19685285 | PRJNA572587_P_NODE_20556_length_249_cov_22.505000_g20228_i0 | PRJNA572587 | 20556 | 249 | 22.505 | 56.03745 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g20228 | i0 | 100 | 0.228915662650602 | 29 | 0 | 12 | 0 | 221 | 249 | 34 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 20960798 | 20960798 | PRJNA572587_P_NODE_12337_length_332_cov_24.890459_g12009_i0 | PRJNA572587 | 12337 | 332 | 24.890459 | 82.63632388 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.009 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g12009 | i0 | 96.875 | 0.518072289156627 | 32 | 1 | 10 | 0 | 1 | 32 | 13 | 44 | Carnation latent virus isolate KL, complete genome | blastn | 172 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 20961207 | 20961207 | PRJNA572587_P_NODE_37577_length_179_cov_6.938462_g37249_i0 | PRJNA572587 | 37577 | 179 | 6.938462 | 12.41984698 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 52.8 | 0.015 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g37249 | i0 | 100 | 0.156424581005587 | 28 | 0 | 16 | 0 | 152 | 179 | 42 | 15 | Carnation latent virus isolate KL, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 22235709 | 22235709 | PRJNA572587_P_NODE_12738_length_326_cov_17.534296_g12410_i0 | PRJNA572587 | 12738 | 326 | 17.534296 | 57.16180496 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.009 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g12410 | i0 | 100 | 0.174846625766871 | 29 | 0 | 9 | 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 | |||
| 22236043 | 22236043 | PRJNA572587_P_NODE_33038_length_192_cov_20.818182_g32710_i0 | PRJNA572587 | 33038 | 192 | 20.818182 | 39.97090944 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 58.4 | 3.55e-4 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g32710 | i0 | 94.595 | 0.817708333333333 | 37 | 2 | 19 | 0 | 156 | 192 | 49 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 157 | 58.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 22236107 | 22236107 | PRJNA572587_P_NODE_38218_length_177_cov_13.804688_g37890_i0 | PRJNA572587 | 38218 | 177 | 13.804688 | 24.43429776 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g37890 | i0 | 96.875 | 1.07909604519774 | 32 | 1 | 18 | 0 | 146 | 177 | 44 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 191 | 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);;