contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA665531" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3180459 | 3180459 | PRJNA665531_P_NODE_8103_length_371_cov_1.382550_g7867_i0 | PRJNA665531 | 8103 | 371 | 1.38255 | 5.1292605 | Pestivirus bovis | 3052619 | Viruses | Viruses | 647 | 0 | NTclustered | gi|1072900293|gb|KU756226.1| | 981676 | g7867 | i0 | 98.113 | 99.989218328841 | 371 | 7 | 100 | 0 | 1 | 371 | 4339 | 3969 | Bovine viral diarrhea virus 1b strain HJ-1 polyprotein gene, complete cds | blastn | 37096 | 647 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 3180473 | 3180473 | PRJNA665531_P_NODE_8743_length_356_cov_1.424028_g8507_i0 | PRJNA665531 | 8743 | 356 | 1.424028 | 5.06953968 | Alphaendornavirus capsici | 3426171 | Viruses | Viruses | 658 | 0 | NTclustered | gi|2558625253|gb|OQ863603.1| | 354328 | g8507 | i0 | 100 | 38.9719101123596 | 356 | 0 | 100 | 0 | 1 | 356 | 14116 | 14471 | Bell pepper alphaendornavirus isolate BHJ1/22, complete genome | blastn | 13874 | 658 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus capsici | ||
| 5732734 | 5732734 | PRJNA665531_P_NODE_14505_length_272_cov_1.331658_g14269_i0 | PRJNA665531 | 14505 | 272 | 1.331658 | 3.62210976 | Pestivirus bovis | 3052619 | Viruses | Viruses | 411 | 3.569999999999999e-110 | NTclustered | gi|34596501|gb|AY182138.1| | 11099 | g14269 | i0 | 94.382 | 92.8602941176471 | 267 | 15 | 98 | 0 | 1 | 267 | 749 | 483 | Pestivirus type 1 strain NCP8 polyprotein mRNA, partial cds | blastn | 25258 | 411 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 10833392 | 10833392 | PRJNA665531_P_NODE_14449_length_272_cov_3.748744_g14213_i0 | PRJNA665531 | 14449 | 272 | 3.748744 | 10.19658368 | Alphaendornavirus capsici | 3426171 | Viruses | Viruses | 503 | 5.729999999999998e-138 | NTclustered | gi|2558625253|gb|OQ863603.1| | 354328 | g14213 | i0 | 100 | 31.9558823529412 | 272 | 0 | 100 | 0 | 1 | 272 | 12052 | 11781 | Bell pepper alphaendornavirus isolate BHJ1/22, complete genome | blastn | 8692 | 503 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus capsici | ||
| 11365806 | 11365806 | PRJNA665531_P_NODE_19429_length_240_cov_2.455090_g19193_i0 | PRJNA665531 | 19429 | 240 | 2.45509 | 5.892216 | Pestivirus | 11095 | Viruses | Viruses | 405 | 1.44e-108 | NTclustered | gi|2731951075|gb|PP770551.1| | 11099 | g19193 | i0 | 97.083 | 99.9833333333333 | 240 | 7 | 100 | 0 | 1 | 240 | 10337 | 10576 | Bovine viral diarrhea virus 1 isolate YN2-11/2023, complete genome | blastn | 23996 | 405 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 12108690 | 12108690 | PRJNA665531_P_NODE_18210_length_246_cov_0.890173_g17974_i0 | PRJNA665531 | 18210 | 246 | 0.890173 | 2.18982558 | Pestivirus bovis | 3052619 | Viruses | Viruses | 418 | 1.9e-112 | NTclustered | gi|887497285|gb|KR029825.1| | 11099 | g17974 | i0 | 97.541 | 99.9593495934959 | 244 | 6 | 99 | 0 | 1 | 244 | 8037 | 8280 | Bovine viral diarrhea virus 1 isolate Egy/Ismailia/2014, complete genome | blastn | 24590 | 418 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 12108922 | 12108922 | PRJNA665531_P_NODE_8730_length_356_cov_2.063604_g8494_i0 | PRJNA665531 | 8730 | 356 | 2.063604 | 7.34643024 | Potexvirus pepini | 3433856 | Viruses | Viruses | 604 | 2.059999999999999e-168 | NTclustered | gi|384872966|gb|JQ314460.1| | 112229 | g8494 | i0 | 98.82 | 38.4325842696629 | 339 | 4 | 95 | 0 | 18 | 356 | 5884 | 6222 | Pepino mosaic virus strain US1_EF09_58, complete genome | blastn | 13682 | 604 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 18481715 | 18481715 | PRJNA665531_P_NODE_16415_length_255_cov_1.692308_g16179_i0 | PRJNA665531 | 16415 | 255 | 1.692308 | 4.3153854 | Pestivirus bovis | 3052619 | Viruses | Viruses | 411 | 3.3199999999999995e-110 | NTclustered | gi|1523731873|gb|MH490943.1| | 981676 | g16179 | i0 | 95.686 | 100.709803921569 | 255 | 11 | 100 | 0 | 1 | 255 | 784 | 1038 | Bovine viral diarrhea virus 1b strain BVDV BJ-2016, complete genome | blastn | 25681 | 411 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 25388768 | 25388768 | PRJNA665531_P_NODE_6980_length_404_cov_3.963746_g6744_i0 | PRJNA665531 | 6980 | 404 | 3.963746 | 16.01353384 | Tobamovirus | 12234 | Viruses | Viruses | 710 | 0 | NTclustered | gi|2837380181|gb|PP099897.1| | 1761477 | g6744 | i0 | 100 | 95.049504950495 | 384 | 0 | 95 | 0 | 1 | 384 | 3797 | 3414 | Tomato brown rugose fruit virus isolate NPPO-NL 36648757, complete genome | blastn | 38400 | 710 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum |
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);;