contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1092581" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 195551 | 195551 | PRJNA1092581_P_NODE_101161_length_251_cov_2.634831_g100628_i0 | PRJNA1092581 | 101161 | 251 | 2.634831 | 6.61342581 | Cucumovirus PSV | 3428133 | Viruses | Viruses | 353 | 5.569999999999998e-93 | NTclustered | gi|4099093|gb|U83332.1|PSU83332 | 12313 | g100628 | i0 | 94.397 | 48.7490039840637 | 232 | 10 | 92 | 3 | 1 | 231 | 231 | 2 | Peanut stunt virus putative RNA dependent RNA polymerase (2a) and putative movement protein (2b) genes, complete cds | blastn | 12236 | 353 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Cucumovirus | Cucumovirus PSV | ||
| 196680 | 196680 | PRJNA1092581_P_NODE_32661_length_483_cov_8.148780_g32129_i0 | PRJNA1092581 | 32661 | 483 | 8.14878 | 39.3586074 | Allexivirus deltallii | 3433711 | Viruses | Viruses | 856 | 0 | NTclustered | gi|1722561170|gb|MN059346.1| | 12430 | g32129 | i0 | 100 | 85.0828157349897 | 463 | 0 | 96 | 0 | 21 | 483 | 7952 | 8414 | Garlic virus D isolate G120-3, complete genome | blastn | 41095 | 856 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Allexivirus | Allexivirus deltallii | ||
| 197089 | 197089 | PRJNA1092581_P_NODE_47741_length_390_cov_11.151420_g47208_i0 | PRJNA1092581 | 47741 | 390 | 11.15142 | 43.490538 | Betaflexiviridae sp. | 1955154 | Viruses | Viruses | 359 | 1.96e-94 | NTclustered | gi|2463200070|gb|OP021693.1| | 1955154 | g47208 | i0 | 91.288 | 1.74358974358974 | 264 | 21 | 67 | 2 | 3 | 265 | 8166 | 7904 | Betaflexiviridae sp. isolate GYCV replicase, triple gene block protein1, triple gene block protein 2, triple gene block protein 3, and coat protein genes, complete cds | blastn | 680 | 359 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Betaflexiviridae sp. | |||
| 1472526 | 1472526 | PRJNA1092581_P_NODE_81942_length_285_cov_2.594340_g81409_i0 | PRJNA1092581 | 81942 | 285 | 2.59434 | 7.393869 | Trichovirus chloropersicae | 3432984 | Viruses | Viruses | 412 | 1.0499999999999999e-110 | NTclustered | gi|2504505089|gb|OP923917.1| | 2358294 | g81409 | i0 | 92.982 | 63.3824561403509 | 285 | 16 | 100 | 2 | 1 | 285 | 7151 | 7431 | Peach chlorotic leaf spot virus isolate Apricot XJ, complete genome | blastn | 18064 | 412 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Trichovirus | Trichovirus chloropersicae | ||
| 2747909 | 2747909 | PRJNA1092581_P_NODE_51963_length_372_cov_3.464883_g51430_i0 | PRJNA1092581 | 51963 | 372 | 3.464883 | 12.88936476 | Allexivirus ecsallii | 3433712 | Viruses | Viruses | 455 | 2.31e-123 | NTclustered | gi|410131120|gb|JQ807994.1| | 150284 | g51430 | i0 | 95.172 | 70.8091397849462 | 290 | 11 | 77 | 2 | 2 | 288 | 8345 | 8056 | Garlic virus X isolate SW3, complete genome | blastn | 26341 | 455 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Allexivirus | Allexivirus ecsallii | ||
| 5300478 | 5300478 | PRJNA1092581_P_NODE_7025_length_985_cov_5.628289_g6665_i0 | PRJNA1092581 | 7025 | 985 | 5.628289 | 55.43864665 | Potexvirus ecscacti | 3433821 | Viruses | Viruses | 1748 | 0 | NTclustered | gi|1110865423|gb|KX883791.1| | 112227 | g6665 | i0 | 99.378 | 2.93604060913706 | 964 | 6 | 98 | 0 | 1 | 964 | 2901 | 1938 | Cactus virus X strain SCM51431 ORF1, ORF2, ORF3, and ORF4 genes, complete cds | blastn | 2892 | 1748 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus ecscacti | ||
| 9125008 | 9125008 | PRJNA1092581_P_NODE_59888_length_342_cov_10.602230_g59355_i0 | PRJNA1092581 | 59888 | 342 | 10.60223 | 36.2596266 | Allexivirus ecsascalonicum | 3433713 | Viruses | Viruses | 65.8 | 4.15e-6 | NTclustered | gi|1678654015|gb|MH389250.1| | 31770 | g59355 | i0 | 80.899 | 2.80701754385965 | 89 | 11 | 25 | 6 | 21 | 105 | 1 | 87 | Shallot virus X isolate 13-04-2, complete genome | blastn | 960 | 65.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Allexivirus | Allexivirus ecsascalonicum | ||
| 11675689 | 11675689 | PRJNA1092581_P_NODE_46730_length_395_cov_4.937888_g46197_i0 | PRJNA1092581 | 46730 | 395 | 4.937888 | 19.5046576 | Cucumovirus PSV | 3428133 | Viruses | Viruses | 656 | 0 | NTclustered | gi|2575892182|gb|OR233183.1| | 12313 | g46197 | i0 | 97.65 | 92.093670886076 | 383 | 7 | 97 | 2 | 1 | 382 | 12 | 393 | Peanut stunt virus isolate DSMZ PV-0203 segment RNA 1, complete sequence | blastn | 36377 | 656 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Cucumovirus | Cucumovirus PSV | ||
| 11676277 | 11676277 | PRJNA1092581_P_NODE_70730_length_311_cov_2.588235_g70197_i0 | PRJNA1092581 | 70730 | 311 | 2.588235 | 8.04941085 | Tobamovirus tomatotessellati | 3432892 | Viruses | Viruses | 575 | 1.3899999999999995e-159 | NTclustered | gi|2201440261|gb|OL652662.1| | 12253 | g70197 | i0 | 100 | 99.9228295819936 | 311 | 0 | 100 | 0 | 1 | 311 | 4608 | 4918 | Tomato mosaic virus isolate NVWA36783860, complete genome | blastn | 31076 | 575 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 21872957 | 21872957 | PRJNA1092581_P_NODE_14078_length_734_cov_10.284418_g13589_i0 | PRJNA1092581 | 14078 | 734 | 10.284418 | 75.48762812 | Tobamovirus capsici | 3432865 | Viruses | Viruses | 1339 | 0 | NTclustered | gi|1791312535|gb|MN616927.1| | 12239 | g13589 | i0 | 99.591 | 94.4291553133515 | 734 | 3 | 100 | 0 | 1 | 734 | 4843 | 5576 | Pepper mild mottle virus isolate ZJ2, complete genome | blastn | 69311 | 1339 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 21873041 | 21873041 | PRJNA1092581_P_NODE_16938_length_674_cov_3.231281_g16429_i0 | PRJNA1092581 | 16938 | 674 | 3.231281 | 21.77883394 | Allexivirus alphallii | 3433708 | Viruses | Viruses | 1194 | 0 | NTclustered | gi|1722560631|gb|MN059269.1| | 12433 | g16429 | i0 | 99.542 | 94.5548961424332 | 655 | 3 | 97 | 0 | 1 | 655 | 8664 | 8010 | Garlic virus A isolate G26-3, complete genome | blastn | 63730 | 1194 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Allexivirus | Allexivirus alphallii | ||
| 23147842 | 23147842 | PRJNA1092581_P_NODE_106519_length_244_cov_5.912281_g105986_i0 | PRJNA1092581 | 106519 | 244 | 5.912281 | 14.42596564 | Cucumovirus CMV | 3428131 | Viruses | Viruses | 412 | 8.759999999999998e-111 | NTclustered | gi|2017768906|gb|MW556589.1| | 12305 | g105986 | i0 | 100 | 91.4426229508197 | 223 | 0 | 91 | 0 | 21 | 243 | 670 | 892 | Cucumber mosaic virus isolate WSJ segment RNA3, complete sequence | blastn | 22312 | 412 | 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);;