contig_metadata
13 rows where bioproject = "PRJNA608660", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 26953386 | 26953386 | PRJNA608660_P_NODE_14122_length_391_cov_2.114035_g13770_i0 | PRJNA608660 | 14122 | 391 | 2.114035 | 8.26587685 | Wuhu tick virus 1 | 2973975 | Viruses | Viruses | 90.9 | 3.02e-18 | NR | UYL95422.1 | 2973975 | g13770 | i0 | 46.1 | 0.882352941176471 | 115 | 60 | 86.7 | 1 | 345 | 7 | 1704 | 1818 | UYL95422.1 MAG: replicase polyprotein [Wuhu tick virus 1] | diamond | 345 | 90.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Wuhu tick virus 1 | ||||
| 29637557 | 29637557 | PRJNA608660_P_NODE_17310_length_346_cov_5.696970_g16955_i0 | PRJNA608660 | 17310 | 346 | 5.69697 | 19.7115162 | Wuhu tick virus 1 | 2973975 | Viruses | Viruses | 100 | 9.94e-22 | NR | UYL95422.1 | 2973975 | g16955 | i0 | 43.8 | 0.910404624277457 | 105 | 59 | 91 | 0 | 14 | 328 | 464 | 568 | UYL95422.1 MAG: replicase polyprotein [Wuhu tick virus 1] | diamond | 315 | 100 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Wuhu tick virus 1 | ||||
| 31185683 | 31185683 | PRJNA608660_P_NODE_9035_length_497_cov_2.484375_g8696_i0 | PRJNA608660 | 9035 | 497 | 2.484375 | 12.34734375 | Wuhu tick virus 1 | 2973975 | Viruses | Viruses | 94.4 | 6.33e-19 | NR | UYL95422.1 | 2973975 | g8696 | i0 | 41.8 | 0.736418511066398 | 122 | 69 | 72.4 | 1 | 6 | 365 | 2086 | 2207 | UYL95422.1 MAG: replicase polyprotein [Wuhu tick virus 1] | diamond | 366 | 94.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Wuhu tick virus 1 | ||||
| 31881636 | 31881636 | PRJNA608660_P_NODE_41957_length_181_cov_1.181818_g41600_i0 | PRJNA608660 | 41957 | 181 | 1.181818 | 2.13909058 | Wuhu tick virus 1 | 2973975 | Viruses | Viruses | 63.5 | 7.26e-10 | NR | UYL95422.1 | 2973975 | g41600 | i0 | 72.5 | 0.662983425414365 | 40 | 11 | 66.3 | 0 | 60 | 179 | 1863 | 1902 | UYL95422.1 MAG: replicase polyprotein [Wuhu tick virus 1] | diamond | 120 | 63.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Wuhu tick virus 1 | ||||
| 32797986 | 32797986 | PRJNA608660_P_NODE_680_length_1258_cov_14.989247_g572_i0 | PRJNA608660 | 680 | 1258 | 14.989247 | 188.56472726 | Leafy-liverwort associated tymo-like virus | 2933176 | Viruses | Viruses | 149 | 8.459999999999998e-35 | NR | CAI5383877.1 | 2933176 | g572 | i0 | 37.3 | 0.536565977742448 | 225 | 133 | 53.4 | 2 | 563 | 1234 | 28 | 245 | CAI5383877.1 replication polyprotein, partial [Leafy-liverwort associated tymo-like virus] | diamond | 675 | 149 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Leafy-liverwort associated tymo-like virus |
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);;