contig_metadata
9 rows where bioproject = "PRJNA906294", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8538265 | 8538265 | PRJNA906294_P_NODE_104607_length_402_cov_0.778116_g100492_i0 | PRJNA906294 | 104607 | 402 | 0.778116 | 3.12802632 | Pestivirus brazilense | 3052620 | Viruses | Viruses | 701 | 0 | NTclustered | gi|2813517655|gb|PQ362005.1| | 381707 | g100492 | i0 | 98.25 | 32.7910447761194 | 400 | 7 | 99 | 0 | 1 | 400 | 10922 | 11321 | Bovine viral diarrhea virus 3 isolate HN2247, partial genome | blastn | 13182 | 701 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus brazilense | ||
| 9817403 | 9817403 | PRJNA906294_P_NODE_75048_length_518_cov_1.058427_g70941_i0 | PRJNA906294 | 75048 | 518 | 1.058427 | 5.48265186 | Cucumovirus CMV | 3428131 | Viruses | Viruses | 891 | 0 | NTclustered | gi|2329659987|gb|OK558679.1| | 12305 | g70941 | i0 | 97.683 | 100.362934362934 | 518 | 12 | 100 | 0 | 1 | 518 | 1321 | 1838 | Cucumber mosaic virus isolate VRS-443 hypothetical protein gene, complete cds | blastn | 51988 | 891 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Cucumovirus | Cucumovirus CMV | ||
| 11089317 | 11089317 | PRJNA906294_P_NODE_116609_length_371_cov_1.268456_g112494_i0 | PRJNA906294 | 116609 | 371 | 1.268456 | 4.70597176 | Cucumovirus CMV | 3428131 | Viruses | Viruses | 580 | 3.639999999999999e-161 | NTclustered | gi|1483570685|gb|MH567342.1| | 12305 | g112494 | i0 | 94.879 | 100.88679245283 | 371 | 19 | 100 | 0 | 1 | 371 | 886 | 1256 | Cucumber mosaic virus isolate Kirinyaga1 1a protein gene, complete cds | blastn | 37429 | 580 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Cucumovirus | Cucumovirus CMV | ||
| 20012288 | 20012288 | PRJNA906294_P_NODE_117056_length_370_cov_1.249158_g112941_i0 | PRJNA906294 | 117056 | 370 | 1.249158 | 4.6218846 | Pestivirus brazilense | 3052620 | Viruses | Viruses | 656 | 0 | NTclustered | gi|2813517653|gb|PQ362004.1| | 381707 | g112941 | i0 | 98.649 | 43.4513513513513 | 370 | 5 | 100 | 0 | 1 | 370 | 6436 | 6067 | Bovine viral diarrhea virus 3 isolate HN2168, partial genome | blastn | 16077 | 656 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus brazilense | ||
| 20013904 | 20013904 | PRJNA906294_P_NODE_186176_length_269_cov_1.377551_g182060_i0 | PRJNA906294 | 186176 | 269 | 1.377551 | 3.70561219 | Pestivirus brazilense | 3052620 | Viruses | Viruses | 459 | 1.2399999999999996e-124 | NTclustered | gi|2813517653|gb|PQ362004.1| | 381707 | g182060 | i0 | 97.398 | 37.728624535316 | 269 | 7 | 100 | 0 | 1 | 269 | 2143 | 1875 | Bovine viral diarrhea virus 3 isolate HN2168, partial genome | blastn | 10149 | 459 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus brazilense | ||
| 21290483 | 21290483 | PRJNA906294_P_NODE_29857_length_1016_cov_3.262990_g26580_i0 | PRJNA906294 | 29857 | 1016 | 3.26299 | 33.1519784 | Cucumovirus CMV | 3428131 | Viruses | Viruses | 1659 | 0 | NTclustered | gi|2329660007|gb|OK558687.1| | 12305 | g26580 | i0 | 96.161 | 99.7716535433071 | 1016 | 37 | 100 | 2 | 1 | 1016 | 31 | 1044 | Cucumber mosaic virus isolate VRS-443 3a protein genes, complete cds | blastn | 101368 | 1659 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Cucumovirus | Cucumovirus CMV | ||
| 22562498 | 22562498 | PRJNA906294_P_NODE_109798_length_387_cov_2.751592_g105683_i0 | PRJNA906294 | 109798 | 387 | 2.751592 | 10.64866104 | Cucumovirus CMV | 3428131 | Viruses | Viruses | 649 | 0 | NTclustered | gi|1888362496|gb|MN326869.1| | 12305 | g105683 | i0 | 96.899 | 99.6227390180879 | 387 | 12 | 100 | 0 | 1 | 387 | 1701 | 2087 | Cucumber mosaic virus isolate EP-1 segment RNA3, complete sequence | blastn | 38554 | 649 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Cucumovirus | Cucumovirus CMV | ||
| 22563252 | 22563252 | PRJNA906294_P_NODE_140538_length_326_cov_1.039526_g136422_i0 | PRJNA906294 | 140538 | 326 | 1.039526 | 3.38885476 | Pestivirus brazilense | 3052620 | Viruses | Viruses | 575 | 1.4699999999999996e-159 | NTclustered | gi|2813517649|gb|PQ362002.1| | 381707 | g136422 | i0 | 98.466 | 57.8895705521472 | 326 | 5 | 100 | 0 | 1 | 326 | 6941 | 6616 | Bovine viral diarrhea virus 3 isolate HN2009, partial genome | blastn | 18872 | 575 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus brazilense | ||
| 23837645 | 23837645 | PRJNA906294_P_NODE_109039_length_389_cov_3.161392_g104924_i0 | PRJNA906294 | 109039 | 389 | 3.161392 | 12.29781488 | Cucumovirus CMV | 3428131 | Viruses | Viruses | 634 | 2.8999999999999995e-177 | NTclustered | gi|2217168049|gb|ON013887.1| | 12305 | g104924 | i0 | 96.154 | 100.601542416452 | 390 | 12 | 100 | 2 | 1 | 389 | 1440 | 1053 | Cucumber mosaic virus isolate DSMZ PV-0185 segment RNA 3, complete sequence | blastn | 39134 | 634 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Cucumovirus | Cucumovirus CMV |
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);;