contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJEB14175" and tax_phylum = "Duplornaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25882768 | 25882768 | PRJEB14175_P_NODE_49603_length_529_cov_18.083333_g47370_i0 | PRJEB14175 | 49603 | 529 | 18.083333 | 95.66083157 | root | 1 | Root_unresolved | Root_unresolved | 233 | 1.73e-56 | NTclustered | gi|2396037752|gb|ON812466.1| | 46839 | g47370 | i0 | 77.336 | 2.95085066162571 | 428 | 75 | 78 | 17 | 102 | 513 | 482 | 61 | MAG: Colorado tick fever virus isolate TIGMIC_1 genomic sequence | blastn | 1561 | 233 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Coltivirus | Coltivirus dermacentoris | ||
| 26015758 | 26015758 | PRJEB14175_P_NODE_124308_length_312_cov_9.171315_g122041_i0 | PRJEB14175 | 124308 | 312 | 9.171315 | 28.6145028 | Ghabrivirales | 2732540 | Viruses | Viruses | 473 | 5.2499999999999996e-129 | NTclustered | gi|291482297|emb|AM111096.3| | 349681 | g122041 | i0 | 95.904 | 2.81410256410256 | 293 | 11 | 94 | 1 | 1 | 292 | 2196 | 1904 | Phlebiopsis gigantea mycovirus dsRNA 1 ORF1 and RdRp gene, genomic RNA, isolate TW2 | blastn | 878 | 473 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Phlebiopsis gigantea mycovirus dsRNA 1 | |||
| 26047925 | 26047925 | PRJEB14175_P_NODE_158309_length_267_cov_1.679612_g156042_i0 | PRJEB14175 | 158309 | 267 | 1.679612 | 4.48456404 | Colorado tick fever virus | 46839 | Viruses | Viruses | 274 | 4.79e-69 | NTclustered | gi|2758887253|gb|PP473574.1| | 46839 | g156042 | i0 | 95.376 | 0.647940074906367 | 173 | 7 | 65 | 1 | 3 | 175 | 4657 | 4486 | MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence | blastn | 173 | 274 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Coltivirus | Coltivirus dermacentoris | ||
| 26049312 | 26049312 | PRJEB14175_P_NODE_188589_length_237_cov_4.295455_g186322_i0 | PRJEB14175 | 188589 | 237 | 4.295455 | 10.18022835 | Tinsley toti-like virus | 2716732 | Viruses | Viruses | 172 | 1.5599999999999999e-38 | NTclustered | gi|1820428425|gb|MT129772.1| | 2716732 | g186322 | i0 | 81.279 | 0.924050632911392 | 219 | 35 | 91 | 6 | 1 | 216 | 810 | 595 | Tinsley toti-like virus strain GUNF_DN54338-24 hypothetical protein and RNA-dependent RNA polymerase genes, partial cds | blastn | 219 | 172 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Tinsley toti-like virus | |||
| 26056118 | 26056118 | PRJEB14175_P_NODE_84093_length_396_cov_24.877612_g81829_i0 | PRJEB14175 | 84093 | 396 | 24.877612 | 98.51534352 | Sclerotinia sclerotiorum megabirnavirus 1 | 1661257 | Viruses | Viruses | 63.9 | 1.75e-5 | NTclustered | gi|836593941|ref|NC_027221.1| | 1661257 | g81829 | i0 | 93.182 | 0.292929292929293 | 44 | 1 | 11 | 2 | 136 | 178 | 404 | 446 | Sclerotinia sclerotiorum megabirnavirus 1 isolate SX466 segment L1, complete sequence | blastn | 116 | 63.9 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Megabirnaviridae | Megabirnavirus | Megabirnavirus ni | ||
| 26325665 | 26325665 | PRJEB14175_P_NODE_40167_length_588_cov_407.225806_g37978_i0 | PRJEB14175 | 40167 | 588 | 407.225806 | 2394.48773928 | Colorado tick fever virus | 46839 | Viruses | Viruses | 172 | 4.28e-38 | NTclustered | gi|2396037752|gb|ON812466.1| | 46839 | g37978 | i0 | 84.884 | 0.345238095238095 | 172 | 24 | 29 | 2 | 120 | 290 | 161 | 331 | MAG: Colorado tick fever virus isolate TIGMIC_1 genomic sequence | blastn | 203 | 172 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Coltivirus | Coltivirus dermacentoris | ||
| 26326164 | 26326164 | PRJEB14175_P_NODE_48863_length_533_cov_545.881356_g46634_i0 | PRJEB14175 | 48863 | 533 | 545.881356 | 2909.54762748 | Colorado tick fever virus | 46839 | Viruses | Viruses | 324 | 1e-83 | NTclustered | gi|2396037752|gb|ON812466.1| | 46839 | g46634 | i0 | 84.923 | 0.667917448405253 | 325 | 43 | 60 | 6 | 93 | 414 | 482 | 161 | MAG: Colorado tick fever virus isolate TIGMIC_1 genomic sequence | blastn | 356 | 324 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Coltivirus | Coltivirus dermacentoris | ||
| 26328068 | 26328068 | PRJEB14175_P_NODE_82239_length_402_cov_2.208211_g79977_i0 | PRJEB14175 | 82239 | 402 | 2.208211 | 8.87700822 | Malassezia sympodialis mycovirus | 2766745 | Viruses | Viruses | 582 | 1.1099999999999999e-161 | NTclustered | gi|1895833611|gb|MN812428.1| | 2766745 | g79977 | i0 | 94.226 | 0.947761194029851 | 381 | 22 | 95 | 0 | 1 | 381 | 882 | 1262 | Malassezia sympodialis mycovirus isolate MsMV1, complete genome | blastn | 381 | 582 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus nijyushichi | ||
| 26457548 | 26457548 | PRJEB14175_P_NODE_186192_length_239_cov_4.949438_g183925_i0 | PRJEB14175 | 186192 | 239 | 4.949438 | 11.82915682 | Malassezia restricta virus MrV4 | 76775 | Viruses | Viruses | 333 | 6.849999999999999e-87 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g183925 | i0 | 94.118 | 0.924686192468619 | 221 | 10 | 91 | 2 | 22 | 239 | 862 | 642 | Malassezia restricta virus MrV40S, complete genome | blastn | 221 | 333 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 26461914 | 26461914 | PRJEB14175_P_NODE_39664_length_592_cov_14.233522_g37476_i0 | PRJEB14175 | 39664 | 592 | 14.233522 | 84.26245024 | Halyomorpha halys reo-like associated virus 1 | 2950334 | Viruses | Viruses | 1037 | 0 | NTclustered | gi|2522451379|gb|OR074981.1| | 2950334 | g37476 | i0 | 99.823 | 0.952702702702703 | 564 | 1 | 95 | 0 | 24 | 587 | 664 | 1227 | MAG: Halyomorpha halys reo-like associated virus 1 isolate COV genomic sequence | blastn | 564 | 1037 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Halyomorpha halys reo-like associated virus 1 |
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);;