contig_metadata
9 rows where bioproject = "PRJNA533623", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3058073 | 3058073 | PRJNA533623_P_NODE_70823_length_217_cov_4.916667_g69042_i0 | PRJNA533623 | 70823 | 217 | 4.916667 | 10.66916739 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 52.8 | 0.019 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g69042 | i0 | 100 | 0.129032258064516 | 28 | 0 | 13 | 0 | 190 | 217 | 43 | 16 | Carnation latent virus isolate KL, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 4333354 | 4333354 | PRJNA533623_P_NODE_35944_length_369_cov_15.126623_g34172_i0 | PRJNA533623 | 35944 | 369 | 15.126623 | 55.81723887 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 71.3 | 9.68e-8 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g34172 | i0 | 89.474 | 0.479674796747967 | 57 | 4 | 15 | 2 | 1 | 56 | 13 | 68 | Carnation latent virus isolate KL, complete genome | blastn | 177 | 71.3 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 4333585 | 4333585 | PRJNA533623_P_NODE_46184_length_312_cov_4.872510_g44408_i0 | PRJNA533623 | 46184 | 312 | 4.87251 | 15.2022312 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g44408 | i0 | 100 | 0.455128205128205 | 30 | 0 | 10 | 0 | 283 | 312 | 42 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 142 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 5610774 | 5610774 | PRJNA533623_P_NODE_62425_length_245_cov_3.385870_g60644_i0 | PRJNA533623 | 62425 | 245 | 3.38587 | 8.2953815 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g60644 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 218 | 245 | 35 | 8 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 9434753 | 9434753 | PRJNA533623_P_NODE_3708_length_1146_cov_45.283871_g2184_i2 | PRJNA533623 | 3708 | 1146 | 45.283871 | 518.95316166 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 60.2 | 6.98e-4 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g2184 | i2 | 97.143 | 0.0305410122164049 | 35 | 1 | 3 | 0 | 1095 | 1129 | 40 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 35 | 60.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 13260756 | 13260756 | PRJNA533623_P_NODE_60611_length_251_cov_26.005263_g58831_i0 | PRJNA533623 | 60611 | 251 | 26.005263 | 65.27321013 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g58831 | i0 | 100 | 0.561752988047809 | 29 | 0 | 12 | 0 | 223 | 251 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 20908179 | 20908179 | PRJNA533623_P_NODE_25637_length_454_cov_49.908397_g23869_i0 | PRJNA533623 | 25637 | 454 | 49.908397 | 226.58412238 | Allexivirus deltallii | 3433711 | Viruses | Viruses | 769 | 0 | NTclustered | gi|940785373|gb|KR819505.1| | 12430 | g23869 | i0 | 98.845 | 83.7334801762115 | 433 | 2 | 95 | 2 | 1 | 430 | 8414 | 7982 | Garlic virus D isolate Mesi 13, complete genome | blastn | 38015 | 769 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Allexivirus | Allexivirus deltallii | ||
| 20909179 | 20909179 | PRJNA533623_P_NODE_71077_length_216_cov_13.806452_g69296_i0 | PRJNA533623 | 71077 | 216 | 13.806452 | 29.82193632 | Bromovirus BMV | 3427622 | Viruses | Viruses | 342 | 1.0099999999999999e-89 | NTclustered | gi|2329659869|gb|OK558648.1| | 12302 | g69296 | i0 | 98.454 | 29.6388888888889 | 194 | 3 | 90 | 0 | 1 | 194 | 1194 | 1001 | Brome mosaic virus isolate VRS-315 ORF1 and ORF2 genes, complete cds | blastn | 6402 | 342 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Bromovirus | Bromovirus BMV | ||
| 20909417 | 20909417 | PRJNA533623_P_NODE_9477_length_761_cov_6.132857_g7945_i0 | PRJNA533623 | 9477 | 761 | 6.132857 | 46.67104177 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.021 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g7945 | i0 | 100 | 0.038107752956636 | 29 | 0 | 4 | 0 | 733 | 761 | 34 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 |
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);;