contig_metadata
7 rows where bioproject = "PRJNA1092581", tax_kingdom = "Orthornavirae" and tax_phylum = "Lenarviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7848817 | 7848817 | PRJNA1092581_P_NODE_14127_length_733_cov_4.307576_g13638_i0 | PRJNA1092581 | 14127 | 733 | 4.307576 | 31.57453208 | Phytophthora infestans RNA virus 4 | 1077832 | Viruses | Viruses | 1293 | 0 | NTclustered | gi|1008869902|gb|KU295723.1| | 1077832 | g13638 | i0 | 99.438 | 9.71350613915416 | 712 | 4 | 97 | 0 | 22 | 733 | 1718 | 2429 | Phytophthora infestans RNA virus 4 isolate PiRV-4-YN17, partial genome | blastn | 7120 | 1293 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Phytophthora infestans RNA virus 4 | |||
| 9124771 | 9124771 | PRJNA1092581_P_NODE_51508_length_374_cov_3.029900_g50975_i0 | PRJNA1092581 | 51508 | 374 | 3.0299 | 11.331826 | Hulunbuir Botou tick virus 2 | 2972054 | Viruses | Viruses | 612 | 1.2999999999999995e-170 | NTclustered | gi|2820295208|gb|PQ180956.1| | 2972054 | g50975 | i0 | 99.701 | 13.0935828877005 | 334 | 1 | 89 | 0 | 13 | 346 | 334 | 1 | MAG: Hulunbuir Botou tick virus 2 isolate Hebei_059 genomic sequence | blastn | 4897 | 612 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Hulunbuir Botou tick virus 2 | |||
| 18047629 | 18047629 | PRJNA1092581_P_NODE_118875_length_225_cov_7.355263_g118342_i0 | PRJNA1092581 | 118875 | 225 | 7.355263 | 16.54934175 | Chrocagost virus | 3129398 | Viruses | Viruses | 296 | 8.37e-76 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g118342 | i0 | 93.532 | 94.5244444444444 | 201 | 10 | 88 | 3 | 27 | 225 | 5868 | 5669 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 21268 | 296 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 21873341 | 21873341 | PRJNA1092581_P_NODE_28018_length_525_cov_2.599558_g27486_i0 | PRJNA1092581 | 28018 | 525 | 2.599558 | 13.6476795 | Phytophthora infestans RNA virus 4 | 1077832 | Viruses | Viruses | 959 | 0 | NTclustered | gi|1012306342|ref|NC_029782.1| | 1077832 | g27486 | i0 | 99.619 | 8.15619047619048 | 525 | 2 | 100 | 0 | 1 | 525 | 2414 | 2938 | Phytophthora infestans RNA virus 4 isolate FLa2005, complete genome | blastn | 4282 | 959 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Phytophthora infestans RNA virus 4 | |||
| 24421395 | 24421395 | PRJNA1092581_P_NODE_101200_length_251_cov_2.488764_g100667_i0 | PRJNA1092581 | 101200 | 251 | 2.488764 | 6.24679764 | Ripachij virus | 3130407 | Viruses | Viruses | 241 | 4.52e-59 | NTclustered | gi|2717319663|gb|PP172709.1| | 3130407 | g100667 | i0 | 86.916 | 157.872509960159 | 214 | 28 | 85 | 0 | 19 | 232 | 479 | 692 | MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence | blastn | 39626 | 241 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripachij virus | |||||
| 28615103 | 28615103 | PRJNA1092581_P_NODE_117227_length_228_cov_3.406452_g116694_i0 | PRJNA1092581 | 117227 | 228 | 3.406452 | 7.76671056 | Grapevine wood holobiome associated narna-like virus 2 | 3398656 | Viruses | Viruses | 65.9 | 2.17e-10 | NR | XOD45334.1 | 3398656 | g116694 | i0 | 48.5 | 3.96052631578947 | 66 | 33 | 86.8 | 1 | 18 | 215 | 123 | 187 | XOD45334.1 RdRp [Grapevine wood holobiome associated narna-like virus 2] | diamond | 903 | 65.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Grapevine wood holobiome associated narna-like virus 2 | |||
| 30257489 | 30257489 | PRJNA1092581_P_NODE_71372_length_309_cov_5.576271_g70839_i0 | PRJNA1092581 | 71372 | 309 | 5.576271 | 17.23067739 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 99.4 | 1.07e-21 | NR | UJQ91993.1 | 2808997 | g70839 | i0 | 52.7 | 0.902912621359223 | 93 | 44 | 90.3 | 0 | 283 | 5 | 587 | 679 | UJQ91993.1 MAG: putative RNA-dependent RNA polymerase, partial [Botourmiaviridae sp.] | diamond | 279 | 99.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. |
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);;