contig_metadata
6 rows where bioproject = "PRJNA781453", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1212188 | 1212188 | PRJNA781453_P_NODE_28781_length_268_cov_1.497436_g28666_i0 | PRJNA781453 | 28781 | 268 | 1.497436 | 4.01312848 | Carlavirus | 12163 | Viruses | Viruses | 468 | 2.06e-127 | NTclustered | gi|1081700958|gb|KU896946.1| | 12169 | g28666 | i0 | 98.134 | 35.1865671641791 | 268 | 5 | 100 | 0 | 1 | 268 | 1871 | 1604 | Potato virus S isolate HB7, complete genome | blastn | 9430 | 468 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani | ||
| 7141040 | 7141040 | PRJNA781453_P_NODE_24946_length_291_cov_1.224771_g24831_i0 | PRJNA781453 | 24946 | 291 | 1.224771 | 3.56408361 | Carlavirus sigmasolani | 3427796 | Viruses | Viruses | 488 | 1.7299999999999995e-133 | NTclustered | gi|1825505916|gb|MT107560.1| | 12169 | g24831 | i0 | 96.907 | 99.7731958762887 | 291 | 9 | 100 | 0 | 1 | 291 | 6781 | 7071 | Potato virus S isolate X1-SD, complete genome | blastn | 29034 | 488 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani | ||
| 12691914 | 12691914 | PRJNA781453_P_NODE_38750_length_243_cov_0.905882_g38635_i0 | PRJNA781453 | 38750 | 243 | 0.905882 | 2.20129326 | Carlavirus | 12163 | Viruses | Viruses | 427 | 3.11e-115 | NTclustered | gi|1746543057|gb|MN095414.1| | 12169 | g38635 | i0 | 98.354 | 97.7942386831276 | 243 | 4 | 100 | 0 | 1 | 243 | 4992 | 5234 | Potato virus S isolate KZ.Ushkonyr, complete genome | blastn | 23764 | 427 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani | ||
| 19889153 | 19889153 | PRJNA781453_P_NODE_17076_length_354_cov_1.096085_g16961_i0 | PRJNA781453 | 17076 | 354 | 1.096085 | 3.8801409 | Carlavirus sigmasolani | 3427796 | Viruses | Viruses | 643 | 4.3399999999999985e-180 | NTclustered | gi|1825505916|gb|MT107560.1| | 12169 | g16961 | i0 | 99.435 | 99.4124293785311 | 354 | 2 | 100 | 0 | 1 | 354 | 5934 | 6287 | Potato virus S isolate X1-SD, complete genome | blastn | 35192 | 643 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani | ||
| 19889382 | 19889382 | PRJNA781453_P_NODE_24656_length_293_cov_1.227273_g24541_i0 | PRJNA781453 | 24656 | 293 | 1.227273 | 3.59590989 | Carlavirus sigmasolani | 3427796 | Viruses | Viruses | 536 | 6.149999999999998e-148 | NTclustered | gi|1825505916|gb|MT107560.1| | 12169 | g24541 | i0 | 99.659 | 99.8668941979522 | 293 | 1 | 100 | 0 | 1 | 293 | 7943 | 7651 | Potato virus S isolate X1-SD, complete genome | blastn | 29261 | 536 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani | ||
| 24988649 | 24988649 | PRJNA781453_P_NODE_12760_length_413_cov_1.358824_g12646_i0 | PRJNA781453 | 12760 | 413 | 1.358824 | 5.61194312 | Carlavirus sigmasolani | 3427796 | Viruses | Viruses | 741 | 0 | NTclustered | gi|1002341922|gb|KU058657.1| | 12169 | g12646 | i0 | 99.031 | 57.041162227602896 | 413 | 4 | 100 | 0 | 1 | 413 | 8197 | 7785 | Potato virus S isolate NZ-A ab030 Lincoln, complete genome | blastn | 23558 | 741 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani |
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);;