contig_metadata
6 rows where bioproject = "PRJEB27957" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13740249 | 13740249 | PRJEB27957_P_NODE_102971_length_169_cov_1.300000_g102861_i0 | PRJEB27957 | 102971 | 169 | 1.3 | 2.197 | Orthornavirae | 2732396 | Viruses | Viruses | 69.4 | 1.4e-7 | NTclustered | gi|2183423903|gb|MZ679790.1| | 2027243 | g102861 | i0 | 97.5 | 7.98816568047337 | 40 | 1 | 24 | 0 | 130 | 169 | 3167 | 3206 | MAG: Leviviridae sp. isolate R28-k141_67620 genomic sequence | blastn | 1350 | 69.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 15325561 | 15325561 | PRJEB27957_P_NODE_109413_length_167_cov_0.881356_g109303_i0 | PRJEB27957 | 109413 | 167 | 0.881356 | 1.47186452 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 117 | 4.900000000000001e-22 | NTclustered | gi|2396039588|gb|ON812873.1| | 2808997 | g109303 | i0 | 80.368 | 0.976047904191617 | 163 | 24 | 95 | 7 | 1 | 159 | 1260 | 1102 | MAG: Botourmiaviridae sp. isolate TIGMIC_5, complete genome | blastn | 163 | 117 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 20424102 | 20424102 | PRJEB27957_P_NODE_26197_length_297_cov_10.806452_g26087_i0 | PRJEB27957 | 26197 | 297 | 10.806452 | 32.09516244 | Lagomorph hepacivirus | 3138818 | Viruses | Viruses | 52.8 | 0.028 | NTclustered | gi|2716363320|gb|OQ576737.1| | 3138818 | g26087 | i0 | 100 | 0.0942760942760943 | 28 | 0 | 9 | 0 | 100 | 127 | 2440 | 2467 | Lagomorph hepacivirus isolate USA/CA/Orange/30026-1/2020 polyprotein gene, complete cds | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Lagomorph hepacivirus | |||
| 27696961 | 27696961 | PRJEB27957_P_NODE_116544_length_165_cov_0.896552_g116434_i0 | PRJEB27957 | 116544 | 165 | 0.896552 | 1.4793108 | Betachrysovirus aspergilli | 2164061 | Viruses | Viruses | 66.2 | 6.51e-11 | NR | YP_010088028.1 | 2164061 | g116434 | i0 | 62 | 0.909090909090909 | 50 | 19 | 90.9 | 0 | 15 | 164 | 248 | 297 | YP_010088028.1 RNA-dependent RNA polymerase [Betachrysovirus aspergilli] | diamond | 150 | 66.2 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Betachrysovirus | Betachrysovirus aspergilli | ||
| 29837106 | 29837106 | PRJEB27957_P_NODE_107111_length_168_cov_0.873950_g107001_i0 | PRJEB27957 | 107111 | 168 | 0.87395 | 1.468236 | Umbravirus | 39734 | Viruses | Viruses | 51.2 | 1.35e-5 | NR | QKW91260.1 | 2231771 | g107001 | i0 | 47.2 | 3.78571428571429 | 53 | 28 | 94.6 | 0 | 3 | 161 | 82 | 134 | QKW91260.1 replication associated protein [Sclerotinia sclerotiorum umbra-like virus 3] | diamond | 636 | 51.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Umbravirus | Sclerotinia sclerotiorum umbra-like virus 3 | ||
| 31075960 | 31075960 | PRJEB27957_P_NODE_108975_length_167_cov_0.881356_g108865_i0 | PRJEB27957 | 108975 | 167 | 0.881356 | 1.47186452 | Grapevine wood holobiome associated narna-like virus 6 | 3398663 | Viruses | Viruses | 45.8 | 0.00105 | NR | XOD45342.1 | 3398663 | g108865 | i0 | 38.9 | 0.970059880239521 | 54 | 33 | 97 | 0 | 3 | 164 | 144 | 197 | XOD45342.1 HP2 [Grapevine wood holobiome associated narna-like virus 6] | diamond | 162 | 45.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Grapevine wood holobiome associated narna-like virus 6 |
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);;