contig_metadata
12 rows where analysis = "diamond" and tax_clade = "RNA satellites"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22680293 | 22680293 | PRJNA1020854_S_NODE_7038_length_591_cov_549.135231_g4457_i0 | PRJNA1020854 | 7038 | 591 | 549.135231 | 3245.38921521 | Blackcurrant reversion virus satellite RNA | 99930 | Viruses | Viruses | 159 | 1.98e-43 | NR | NP_624321.1 | 99930 | g4457 | i0 | 68.1 | 0.573604060913706 | 113 | 34 | 57.4 | 1 | 68 | 406 | 292 | 402 | NP_624321.1 hypothetical protein [Blackcurrant reversion virus satellite RNA] | diamond | 339 | 159 | 1 | Viruses | RNA satellites | Blackcurrant reversion virus satellite RNA | |||||||
| 27434161 | 27434161 | PRJNA841653_P_NODE_13343_length_452_cov_0.970976_g12672_i0 | PRJNA841653 | 13343 | 452 | 0.970976 | 4.38881152 | Rhodosporidiobolus odoratus dsRNA Virus 1 satellite | 2787046 | Viruses | Viruses | 67.4 | 3e-11 | NR | QPH36702.1 | 2787046 | g12672 | i0 | 50.7 | 0.484513274336283 | 73 | 31 | 48.5 | 2 | 364 | 146 | 49 | 116 | QPH36702.1 Satellite-like RNA [Rhodosporidiobolus odoratus dsRNA Virus 1 satellite] | diamond | 219 | 67.4 | 1 | Viruses | RNA satellites | Rhodosporidiobolus odoratus dsRNA Virus 1 satellite | |||||||
| 28315329 | 28315329 | PRJNA715462_P_NODE_4346_length_1210_cov_15.648197_g3819_i0 | PRJNA715462 | 4346 | 1210 | 15.648197 | 189.3431837 | Green Sichuan pepper nepovirus satellite | 2851655 | Viruses | Viruses | 132 | 5.73e-31 | NR | QWY93777.1 | 2851655 | g3819 | i0 | 34.7 | 1.70578512396694 | 331 | 176 | 77.1 | 16 | 1073 | 141 | 55 | 365 | QWY93777.1 hypothetical protein [Green Sichuan pepper nepovirus satellite] | diamond | 2064 | 132 | 1 | Viruses | RNA satellites | Green Sichuan pepper nepovirus satellite | |||||||
| 28320804 | 28320804 | PRJNA971593_P_NODE_12146_length_347_cov_0.923358_g11997_i0 | PRJNA971593 | 12146 | 347 | 0.923358 | 3.20405226 | Cnidiuim virus associated satellite | 3133206 | Viruses | Viruses | 147 | 3.15e-41 | NR | WXB65927.1 | 3133206 | g11997 | i0 | 77.2 | 0.873198847262248 | 101 | 22 | 87.3 | 1 | 45 | 347 | 8 | 107 | WXB65927.1 31 kDa protein [Cnidiuim virus associated satellite] | diamond | 303 | 147 | 1 | Viruses | RNA satellites | Cnidiuim virus associated satellite | |||||||
| 28352384 | 28352384 | PRJNA971593_P_NODE_19626_length_268_cov_1.543590_g19477_i0 | PRJNA971593 | 19626 | 268 | 1.54359 | 4.1368212 | Cnidiuim virus associated satellite | 3133206 | Viruses | Viruses | 125 | 2.68e-33 | NR | WXB65927.1 | 3133206 | g19477 | i0 | 70 | 1.00746268656716 | 90 | 24 | 98.5 | 2 | 3 | 266 | 121 | 209 | WXB65927.1 31 kDa protein [Cnidiuim virus associated satellite] | diamond | 270 | 125 | 1 | Viruses | RNA satellites | Cnidiuim virus associated satellite | |||||||
| 29676554 | 29676554 | PRJNA906294_P_NODE_121810_length_359_cov_3.653846_g117694_i0 | PRJNA906294 | 121810 | 359 | 3.653846 | 13.11730714 | Cnidiuim virus associated satellite | 3133206 | Viruses | Viruses | 174 | 1.48e-51 | NR | WXB65927.1 | 3133206 | g117694 | i0 | 81.4 | 0.81058495821727 | 97 | 18 | 81.1 | 0 | 358 | 68 | 181 | 277 | WXB65927.1 31 kDa protein [Cnidiuim virus associated satellite] | diamond | 291 | 174 | 1 | Viruses | RNA satellites | Cnidiuim virus associated satellite | |||||||
| 30510193 | 30510193 | PRJNA1112809_P_NODE_159213_length_255_cov_1.445055_g155938_i0 | PRJNA1112809 | 159213 | 255 | 1.445055 | 3.68489025 | Strawberry latent ringspot virus satellite RNA | 195062 | Viruses | Viruses | 75.9 | 3.81e-14 | NR | WIU81415.1 | 195062 | g155938 | i0 | 56.1 | 0.964705882352941 | 82 | 32 | 92.9 | 2 | 15 | 251 | 13 | 93 | WIU81415.1 hypothetical protein [Strawberry latent ringspot virus satellite RNA] | diamond | 246 | 75.9 | 1 | Viruses | RNA satellites | Strawberry latent ringspot virus satellite RNA | |||||||
| 30745459 | 30745459 | PRJNA680334_S_NODE_5214_length_381_cov_8.295977_g4729_i0 | PRJNA680334 | 5214 | 381 | 8.295977 | 31.60767237 | Blackcurrant reversion virus satellite RNA | 99930 | Viruses | Viruses | 112 | 2.11e-26 | NR | NP_624321.1 | 99930 | g4729 | i0 | 73.6 | 0.566929133858268 | 72 | 17 | 55.1 | 1 | 2 | 211 | 331 | 402 | NP_624321.1 hypothetical protein [Blackcurrant reversion virus satellite RNA] | diamond | 216 | 112 | 1 | Viruses | RNA satellites | Blackcurrant reversion virus satellite RNA | |||||||
| 31063212 | 31063212 | PRJNA715462_P_NODE_4435_length_1193_cov_8.111607_g3904_i0 | PRJNA715462 | 4435 | 1193 | 8.111607 | 96.77147151 | Green Sichuan pepper nepovirus satellite | 2851655 | Viruses | Viruses | 131 | 9.82e-31 | NR | QWY93767.1 | 2851655 | g3904 | i0 | 31.9 | 2.62782900251467 | 357 | 204 | 85 | 14 | 1137 | 124 | 28 | 364 | QWY93767.1 hypothetical protein [Green Sichuan pepper nepovirus satellite] | diamond | 3135 | 131 | 1 | Viruses | RNA satellites | Green Sichuan pepper nepovirus satellite | |||||||
| 32034062 | 32034062 | PRJNA285816_S_NODE_838_length_686_cov_3.149137_g772_i0 | PRJNA285816 | 838 | 686 | 3.149137 | 21.60307982 | Bamboo mosaic virus satellite RNA | 190811 | Viruses | Viruses | 107 | 1.28e-25 | NR | AJO26629.1 | 190811 | g772 | i0 | 51.1 | 0.787172011661808 | 90 | 44 | 39.4 | 0 | 499 | 230 | 25 | 114 | AJO26629.1 P20 protein, partial [Bamboo mosaic virus satellite RNA] | diamond | 540 | 107 | 1 | Viruses | RNA satellites | Bamboo mosaic virus satellite RNA | |||||||
| 32908151 | 32908151 | PRJEB14175_P_NODE_103129_length_351_cov_2.634483_g100863_i0 | PRJEB14175 | 103129 | 351 | 2.634483 | 9.24703533 | Blackcurrant reversion virus satellite RNA | 99930 | Viruses | Viruses | 48.9 | 7.98e-4 | NR | NP_624321.1 | 99930 | g100863 | i0 | 34.4 | 0.82051282051282 | 96 | 60 | 81.2 | 3 | 338 | 54 | 141 | 234 | NP_624321.1 hypothetical protein [Blackcurrant reversion virus satellite RNA] | diamond | 288 | 48.9 | 1 | Viruses | RNA satellites | Blackcurrant reversion virus satellite RNA | |||||||
| 33062258 | 33062258 | PRJEB14175_P_NODE_141493_length_287_cov_8.283186_g139226_i0 | PRJEB14175 | 141493 | 287 | 8.283186 | 23.77274382 | Blackcurrant reversion virus satellite RNA | 99930 | Viruses | Viruses | 48.1 | 7.58e-4 | NR | NP_624321.1 | 99930 | g139226 | i0 | 66.7 | 0.313588850174216 | 30 | 10 | 31.4 | 0 | 276 | 187 | 373 | 402 | NP_624321.1 hypothetical protein [Blackcurrant reversion virus satellite RNA] | diamond | 90 | 48.1 | 1 | Viruses | RNA satellites | Blackcurrant reversion virus satellite RNA |
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);;