contig_metadata
9 rows where bioproject = "PRJNA902848", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 881879 | 881879 | PRJNA902848_P_NODE_11161_length_272_cov_1.175879_g11111_i0 | PRJNA902848 | 11161 | 272 | 1.175879 | 3.19839088 | Bombyx mori latent virus | 2065033 | Viruses | Viruses | 442 | 1.2699999999999995e-119 | NTclustered | gi|1464307034|ref|NC_038331.1| | 2065033 | g11111 | i0 | 95.956 | 4 | 272 | 11 | 100 | 0 | 1 | 272 | 2141 | 1870 | Bombyx mori latent virus genomic RNA, complete genome | blastn | 1088 | 442 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Bombyx mori latent virus | |||
| 3799097 | 3799097 | PRJNA902848_P_NODE_5523_length_358_cov_1.080702_g5473_i0 | PRJNA902848 | 5523 | 358 | 1.080702 | 3.86891316 | Crinivirus | 67753 | Viruses | Viruses | 660 | 0 | NTclustered | gi|2512036304|gb|OP976053.1| | 3049511 | g5473 | i0 | 100 | 5.98324022346369 | 357 | 0 | 99 | 0 | 2 | 358 | 6300 | 5944 | Chieh-qua chlorotic virus isolate pumpkin-DF segment RNA2, complete sequence | blastn | 2142 | 660 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Crinivirus | chieh-qua chlorotic virus | ||
| 10175579 | 10175579 | PRJNA902848_P_NODE_1908_length_531_cov_0.986900_g1859_i0 | PRJNA902848 | 1908 | 531 | 0.9869 | 5.240439 | Maculavirus | 249185 | Viruses | Viruses | 915 | 0 | NTclustered | gi|612507560|gb|KJ433990.1| | 288456 | g1859 | i0 | 97.917 | 3.9774011299435 | 528 | 11 | 99 | 0 | 1 | 528 | 3923 | 4450 | Bombyx mori Macula-like virus strain SZ, complete genome | blastn | 2112 | 920 | 0.994565217391304 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Maculavirus | Bombyx mori Macula-like virus | ||
| 11085829 | 11085829 | PRJNA902848_P_NODE_789_length_733_cov_1.393939_g745_i0 | PRJNA902848 | 789 | 733 | 1.393939 | 10.21757287 | Bombyx mori latent virus | 2065033 | Viruses | Viruses | 1243 | 0 | NTclustered | gi|1464307034|ref|NC_038331.1| | 2065033 | g745 | i0 | 97.271 | 4 | 733 | 20 | 100 | 0 | 1 | 733 | 3094 | 3826 | Bombyx mori latent virus genomic RNA, complete genome | blastn | 2932 | 1243 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Bombyx mori latent virus | |||
| 14001031 | 14001031 | PRJNA902848_P_NODE_4431_length_388_cov_1.641270_g4381_i0 | PRJNA902848 | 4431 | 388 | 1.64127 | 6.3681276 | Maculavirus | 249185 | Viruses | Viruses | 645 | 1.3399999999999995e-180 | NTclustered | gi|612507560|gb|KJ433990.1| | 288456 | g4381 | i0 | 96.649 | 4.79381443298969 | 388 | 13 | 100 | 0 | 1 | 388 | 4898 | 4511 | Bombyx mori Macula-like virus strain SZ, complete genome | blastn | 1860 | 651 | 0.990783410138249 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Maculavirus | Bombyx mori Macula-like virus | ||
| 16184818 | 16184818 | PRJNA902848_P_NODE_19213_length_243_cov_1.188235_g19163_i0 | PRJNA902848 | 19213 | 243 | 1.188235 | 2.88741105 | Bombyx mori latent virus | 2065033 | Viruses | Viruses | 422 | 1.45e-113 | NTclustered | gi|1464307034|ref|NC_038331.1| | 2065033 | g19163 | i0 | 97.942 | 4 | 243 | 5 | 100 | 0 | 1 | 243 | 2837 | 2595 | Bombyx mori latent virus genomic RNA, complete genome | blastn | 972 | 422 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Bombyx mori latent virus | |||
| 23834176 | 23834176 | PRJNA902848_P_NODE_199_length_1211_cov_3.463093_g173_i0 | PRJNA902848 | 199 | 1211 | 3.463093 | 41.93805623 | Bombyx mori latent virus | 2065033 | Viruses | Viruses | 1879 | 0 | NTclustered | gi|1464307034|ref|NC_038331.1| | 2065033 | g173 | i0 | 94.544 | 5.08257638315442 | 1228 | 47 | 99 | 2 | 4 | 1211 | 5154 | 6381 | Bombyx mori latent virus genomic RNA, complete genome | blastn | 6155 | 1879 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Bombyx mori latent virus | |||
| 24198563 | 24198563 | PRJNA902848_P_NODE_2239_length_499_cov_1.098592_g2189_i0 | PRJNA902848 | 2239 | 499 | 1.098592 | 5.48197408 | Crinivirus | 67753 | Viruses | Viruses | 922 | 0 | NTclustered | gi|2512036304|gb|OP976053.1| | 3049511 | g2189 | i0 | 100 | 6 | 499 | 0 | 100 | 0 | 1 | 499 | 3489 | 3987 | Chieh-qua chlorotic virus isolate pumpkin-DF segment RNA2, complete sequence | blastn | 2994 | 922 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Crinivirus | chieh-qua chlorotic virus | ||
| 25107921 | 25107921 | PRJNA902848_P_NODE_1320_length_603_cov_1.764151_g1271_i0 | PRJNA902848 | 1320 | 603 | 1.764151 | 10.63783053 | Bombyx mori Macula-like virus | 288456 | Viruses | Viruses | 880 | 0 | NTclustered | gi|612507560|gb|KJ433990.1| | 288456 | g1271 | i0 | 94.7 | 3.75456053067993 | 566 | 30 | 94 | 0 | 37 | 602 | 1207 | 1772 | Bombyx mori Macula-like virus strain SZ, complete genome | blastn | 2264 | 880 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Maculavirus | Bombyx mori Macula-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);;