contig_metadata
10 rows where bioproject = "PRJNA1240805", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 349313 | 349313 | PRJNA1240805_P_NODE_4121_length_226_cov_14.994350_g4072_i0 | PRJNA1240805 | 4121 | 226 | 14.99435 | 33.887231 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g4072 | i0 | 100 | 0.256637168141593 | 30 | 0 | 13 | 0 | 1 | 30 | 6 | 35 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 4176569 | 4176569 | PRJNA1240805_P_NODE_1844_length_357_cov_13.775974_g1795_i0 | PRJNA1240805 | 1844 | 357 | 13.775974 | 49.18022718 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 52.8 | 0.034 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g1795 | i0 | 100 | 0.0784313725490196 | 28 | 0 | 8 | 0 | 1 | 28 | 15 | 42 | Carnation latent virus isolate KL, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 9277672 | 9277672 | PRJNA1240805_P_NODE_2568_length_296_cov_2.060729_g2519_i0 | PRJNA1240805 | 2568 | 296 | 2.060729 | 6.09975784 | Pestivirus bovis | 3052619 | Viruses | Viruses | 508 | 1.36e-139 | NTclustered | gi|1129880483|gb|KX170609.1| | 11099 | g2519 | i0 | 97.635 | 98.7364864864865 | 296 | 7 | 100 | 0 | 1 | 296 | 616 | 321 | Bovine viral diarrhea virus 1 isolate V087 NS5A gene, partial cds | blastn | 29226 | 508 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 18201172 | 18201172 | PRJNA1240805_P_NODE_3855_length_235_cov_8.059140_g3806_i0 | PRJNA1240805 | 3855 | 235 | 8.05914 | 18.938979 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g3806 | i0 | 100 | 0.123404255319149 | 29 | 0 | 12 | 0 | 207 | 235 | 36 | 8 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 20176686 | 20176686 | PRJNA1240805_P_NODE_3916_length_233_cov_15.913043_g3867_i0 | PRJNA1240805 | 3916 | 233 | 15.913043 | 37.07739019 | Tobamovirus | 12234 | Viruses | Viruses | 388 | 1.4e-103 | NTclustered | gi|1496534726|gb|MH271428.1| | 12235 | g3867 | i0 | 100 | 40.3948497854077 | 210 | 0 | 90 | 0 | 24 | 233 | 834 | 1043 | Cucumber green mottle mosaic virus isolate CG023, complete genome | blastn | 9412 | 388 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus viridimaculae | ||
| 20750980 | 20750980 | PRJNA1240805_P_NODE_5437_length_196_cov_1.557823_g5388_i0 | PRJNA1240805 | 5437 | 196 | 1.557823 | 3.05333308 | Pestivirus bovis | 3052619 | Viruses | Viruses | 346 | 6.94e-91 | NTclustered | gi|575471150|gb|KF772785.1| | 11099 | g5388 | i0 | 98.469 | 99.780612244898 | 196 | 3 | 100 | 0 | 1 | 196 | 7710 | 7515 | Bovine viral diarrhea virus 1 isolate CC13B, complete genome | blastn | 19557 | 346 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 23301842 | 23301842 | PRJNA1240805_P_NODE_2819_length_281_cov_6.793103_g2770_i0 | PRJNA1240805 | 2819 | 281 | 6.793103 | 19.08861943 | Tuatara cloaca-associated tombusvirus-1 | 2970558 | Viruses | Viruses | 89.8 | 1.97e-13 | NTclustered | gi|2284660261|gb|OP080581.1| | 2970558 | g2770 | i0 | 85.556 | 3.2135231316726 | 90 | 8 | 31 | 4 | 49 | 134 | 3177 | 3265 | MAG: Tuatara cloaca-associated tombusvirus-1 isolate T65 RNA-dependent RNA polymerase and coat protein genes, complete cds | blastn | 903 | 89.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Tombusvirus | Tuatara cloaca-associated tombusvirus-1 | ||
| 23301891 | 23301891 | PRJNA1240805_P_NODE_6439_length_180_cov_7.030534_g6390_i0 | PRJNA1240805 | 6439 | 180 | 7.030534 | 12.6549612 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g6390 | i0 | 100 | 0.161111111111111 | 29 | 0 | 16 | 0 | 152 | 180 | 43 | 15 | Carnation latent virus isolate KL, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 24575783 | 24575783 | PRJNA1240805_P_NODE_5660_length_192_cov_1.818182_g5611_i0 | PRJNA1240805 | 5660 | 192 | 1.818182 | 3.49090944 | Pestivirus bovis | 3052619 | Viruses | Viruses | 294 | 2.49e-75 | NTclustered | gi|77799881|dbj|AB111964.2| | 233886 | g5611 | i0 | 94.271 | 96.8020833333333 | 192 | 11 | 100 | 0 | 1 | 192 | 1774 | 1965 | Bovine viral diarrhea virus 839cp gene for poryprotein, partai cds, strain: 839cp | blastn | 18586 | 294 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 27122973 | 27122973 | PRJNA1240805_P_NODE_1682_length_377_cov_8.240854_g1633_i0 | PRJNA1240805 | 1682 | 377 | 8.240854 | 31.06801958 | Viruses | 10239 | Viruses | Viruses | 185 | 3.959999999999999e-52 | NR | WRQ65486.1 | 2809914 | g1633 | i0 | 70.7 | 2.72148541114058 | 116 | 34 | 92.3 | 0 | 367 | 20 | 529 | 644 | WRQ65486.1 polyprotein [Tolivirales sp.] | diamond | 1026 | 185 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. |
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);;