contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA608660" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3135347 | 3135347 | PRJNA608660_P_NODE_11423_length_440_cov_11.920716_g11076_i0 | PRJNA608660 | 11423 | 440 | 11.920716 | 52.4511504 | Alphaendornavirus fuphaseoli | 3426176 | Viruses | Viruses | 403 | 1.0199999999999994e-107 | NTclustered | gi|1243012349|gb|MF281671.1| | 1188793 | g11076 | i0 | 100 | 12.6863636363636 | 218 | 0 | 100 | 0 | 1 | 218 | 2495 | 2278 | Phaseolus vulgaris alphaendornavirus 2 isolate SRF2 polyprotein gene, complete cds | blastn | 5582 | 403 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus fuphaseoli | ||
| 4412407 | 4412407 | PRJNA608660_P_NODE_40864_length_185_cov_1.500000_g40507_i0 | PRJNA608660 | 40864 | 185 | 1.5 | 2.775 | Tobamovirus fortpiercense | 3432870 | Viruses | Viruses | 228 | 2.4499999999999995e-55 | NTclustered | gi|1341138404|gb|KY769775.1| | 233051 | g40507 | i0 | 94 | 19.4594594594595 | 150 | 9 | 81 | 0 | 1 | 150 | 6209 | 6060 | Hibiscus latent Fort Pierce virus isolate Hib2, complete genome | blastn | 3600 | 228 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fortpiercense | ||
| 6962950 | 6962950 | PRJNA608660_P_NODE_27526_length_251_cov_1.544554_g27170_i0 | PRJNA608660 | 27526 | 251 | 1.544554 | 3.87683054 | Alphaendornavirus capsici | 3426171 | Viruses | Viruses | 348 | 2.5900000000000005e-91 | NTclustered | gi|2558625253|gb|OQ863603.1| | 354328 | g27170 | i0 | 99.476 | 31.1434262948207 | 191 | 1 | 100 | 0 | 1 | 191 | 1995 | 2185 | Bell pepper alphaendornavirus isolate BHJ1/22, complete genome | blastn | 7817 | 348 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus capsici | ||
| 17162574 | 17162574 | PRJNA608660_P_NODE_4814_length_658_cov_16.986864_g4520_i0 | PRJNA608660 | 4814 | 658 | 16.986864 | 111.77356512 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 664 | 0 | NTclustered | gi|2217162015|gb|OL584366.1| | 12242 | g4520 | i0 | 99.452 | 98.7765957446808 | 365 | 2 | 97 | 0 | 12 | 376 | 4908 | 4544 | Tobacco mosaic virus isolate DSMZ PV-1199 genomic sequence | blastn | 64995 | 664 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 20986978 | 20986978 | PRJNA608660_P_NODE_24517_length_273_cov_2.705357_g24161_i0 | PRJNA608660 | 24517 | 273 | 2.705357 | 7.38562461 | Alphaendornavirus fuphaseoli | 3426176 | Viruses | Viruses | 409 | 1.29e-109 | NTclustered | gi|1243012349|gb|MF281671.1| | 1188793 | g24161 | i0 | 98.696 | 12.2014652014652 | 230 | 3 | 84 | 0 | 39 | 268 | 5479 | 5250 | Phaseolus vulgaris alphaendornavirus 2 isolate SRF2 polyprotein gene, complete cds | blastn | 3331 | 409 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus fuphaseoli | ||
| 20987296 | 20987296 | PRJNA608660_P_NODE_8757_length_504_cov_33.061538_g8419_i0 | PRJNA608660 | 8757 | 504 | 33.061538 | 166.63015152 | Alphaendornavirus fuphaseoli | 3426176 | Viruses | Viruses | 571 | 3.0599999999999993e-158 | NTclustered | gi|1243012349|gb|MF281671.1| | 1188793 | g8419 | i0 | 100 | 12.2539682539683 | 309 | 0 | 93 | 0 | 179 | 487 | 9795 | 10103 | Phaseolus vulgaris alphaendornavirus 2 isolate SRF2 polyprotein gene, complete cds | blastn | 6176 | 571 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus fuphaseoli | ||
| 21548813 | 21548813 | PRJNA608660_P_NODE_2757_length_815_cov_4.639687_g2530_i0 | PRJNA608660 | 2757 | 815 | 4.639687 | 37.81344905 | Tobamovirus | 12234 | Viruses | Viruses | 1474 | 0 | NTclustered | gi|2201440261|gb|OL652662.1| | 12253 | g2530 | i0 | 99.751 | 98.6539877300613 | 804 | 2 | 99 | 0 | 1 | 804 | 5190 | 5993 | Tomato mosaic virus isolate NVWA36783860, complete genome | blastn | 80403 | 1474 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 24811006 | 24811006 | PRJNA608660_P_NODE_30140_length_235_cov_1.397849_g29784_i0 | PRJNA608660 | 30140 | 235 | 1.397849 | 3.28494515 | Alphaendornavirus fuphaseoli | 3426176 | Viruses | Viruses | 414 | 2.33e-111 | NTclustered | gi|1243012349|gb|MF281671.1| | 1188793 | g29784 | i0 | 100 | 12.3914893617021 | 224 | 0 | 95 | 0 | 12 | 235 | 7719 | 7496 | Phaseolus vulgaris alphaendornavirus 2 isolate SRF2 polyprotein gene, complete cds | blastn | 2912 | 414 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus fuphaseoli |
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);;