contig_metadata
10 rows where bioproject = "PRJNA438687", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2986033 | 2986033 | PRJNA438687_S_NODE_6043_length_178_cov_6.741259_g5953_i0 | PRJNA438687 | 6043 | 178 | 6.741259 | 11.99944102 | Sopidub virus | 3131684 | Viruses | Viruses | 100 | 5.3e-17 | NTclustered | gi|2717323145|gb|PP173985.1| | 3131684 | g5953 | i0 | 90.789 | 1.52808988764045 | 76 | 6 | 43 | 1 | 5 | 80 | 2212 | 2138 | MAG: Sopidub virus isolate SP1B_k141_213983 genomic sequence | blastn | 272 | 100 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Sopidub virus | |||
| 2986072 | 2986072 | PRJNA438687_S_NODE_8123_length_151_cov_2.086207_g8033_i0 | PRJNA438687 | 8123 | 151 | 2.086207 | 3.15017257 | Sobemovirus sp. | 2809869 | Viruses | Viruses | 182 | 1.51e-41 | NTclustered | gi|2171144996|gb|MZ218234.1| | 2809869 | g8033 | i0 | 94.118 | 78.1523178807947 | 119 | 7 | 79 | 0 | 33 | 151 | 4524 | 4406 | MAG: Sobemovirus sp. isolate R90-k141_286143 genomic sequence | blastn | 11801 | 182 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus sp. | ||
| 5538983 | 5538983 | PRJNA438687_S_NODE_3245_length_248_cov_2.751174_g3155_i0 | PRJNA438687 | 3245 | 248 | 2.751174 | 6.82291152 | Sobemovirus CNMOV | 3432495 | Viruses | Viruses | 451 | 1.89e-122 | NTclustered | gi|2575892443|gb|OR238492.1| | 2931826 | g3155 | i0 | 99.595 | 7.96774193548387 | 247 | 1 | 99 | 0 | 2 | 248 | 608 | 362 | Cynosurus mottle virus isolate Schladen, complete genome | blastn | 1976 | 451 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus CNMOV | ||
| 6813130 | 6813130 | PRJNA438687_S_NODE_6686_length_169_cov_1.365672_g6596_i0 | PRJNA438687 | 6686 | 169 | 1.365672 | 2.30798568 | Sopidub virus | 3131684 | Viruses | Viruses | 80.5 | 6.47e-11 | NTclustered | gi|2717323145|gb|PP173985.1| | 3131684 | g6596 | i0 | 87.5 | 0.958579881656805 | 72 | 5 | 40 | 4 | 95 | 162 | 2139 | 2210 | MAG: Sopidub virus isolate SP1B_k141_213983 genomic sequence | blastn | 162 | 80.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Sopidub virus | |||
| 9363376 | 9363376 | PRJNA438687_S_NODE_6448_length_172_cov_3.620438_g6358_i0 | PRJNA438687 | 6448 | 172 | 3.620438 | 6.22715336 | Mute swan feces associated sobemovirus 1 | 2832221 | Viruses | Viruses | 313 | 5.989999999999998e-81 | NTclustered | gi|2032489095|gb|MW588173.1| | 2832221 | g6358 | i0 | 99.419 | 10.8662790697674 | 172 | 1 | 100 | 0 | 1 | 172 | 2147 | 1976 | Mute swan feces associated sobemovirus 1 strain Abbotsbury/A/2016 polyprotein P2a, polyprotein 2b, and capsid protein genes, complete cds | blastn | 1869 | 313 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Mute swan feces associated sobemovirus 1 | ||
| 10639118 | 10639118 | PRJNA438687_S_NODE_1009_length_378_cov_1.618076_g920_i0 | PRJNA438687 | 1009 | 378 | 1.618076 | 6.11632728 | Mute swan feces associated sobemovirus 1 | 2832221 | Viruses | Viruses | 671 | 0 | NTclustered | gi|2032489095|gb|MW588173.1| | 2832221 | g920 | i0 | 98.681 | 8.02116402116402 | 379 | 4 | 100 | 1 | 1 | 378 | 1505 | 1127 | Mute swan feces associated sobemovirus 1 strain Abbotsbury/A/2016 polyprotein P2a, polyprotein 2b, and capsid protein genes, complete cds | blastn | 3032 | 671 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Mute swan feces associated sobemovirus 1 | ||
| 13188994 | 13188994 | PRJNA438687_S_NODE_4131_length_218_cov_4.535519_g4041_i0 | PRJNA438687 | 4131 | 218 | 4.535519 | 9.88743142 | Sobemovirus CNMOV | 3432495 | Viruses | Viruses | 381 | 2.1599999999999994e-101 | NTclustered | gi|2575892419|gb|OR238488.1| | 2931826 | g4041 | i0 | 98.174 | 10.894495412844 | 219 | 3 | 100 | 1 | 1 | 218 | 2477 | 2695 | Cynosurus mottle virus isolate CV-104, complete genome | blastn | 2375 | 381 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus CNMOV | ||
| 18942709 | 18942709 | PRJNA438687_S_NODE_7795_length_155_cov_1.333333_g7705_i0 | PRJNA438687 | 7795 | 155 | 1.333333 | 2.06666615 | Sobemovirus | 12137 | Viruses | Viruses | 174 | 2.61e-39 | NTclustered | gi|2562620724|gb|OQ974933.1| | 40979 | g7705 | i0 | 91.339 | 11.1354838709677 | 127 | 11 | 82 | 0 | 1 | 127 | 1843 | 1969 | Cocksfoot mottle virus isolate CfMV_Est, complete genome | blastn | 1726 | 174 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus CFMV | ||
| 28244400 | 28244400 | PRJNA438687_S_NODE_7926_length_153_cov_3.186441_g7836_i0 | PRJNA438687 | 7926 | 153 | 3.186441 | 4.87525473 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 73.6 | 1.51e-13 | NR | UNY42033.1 | 3003959 | g7836 | i0 | 64 | 2.94117647058824 | 50 | 18 | 98 | 0 | 1 | 150 | 928 | 977 | UNY42033.1 MAG: polyprotein [Picornavirales sp.] | diamond | 450 | 73.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 31862163 | 31862163 | PRJNA438687_S_NODE_4677_length_205_cov_3.129412_g4587_i0 | PRJNA438687 | 4677 | 205 | 3.129412 | 6.4152946 | Viruses | 10239 | Viruses | Viruses | 103 | 6.179999999999999e-24 | NR | WPR18179.1 | 3062991 | g4587 | i0 | 63.1 | 2.89756097560976 | 65 | 24 | 95.1 | 0 | 9 | 203 | 461 | 525 | WPR18179.1 MAG: capsid protein, partial [Crogonang virus 121] | diamond | 594 | 103 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Crogonang virus 121 |
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);;