contig_metadata
5 rows where bioproject = "PRJNA526367" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1771226 | 1771226 | PRJNA526367_P_NODE_4202_length_344_cov_2.759322_g3994_i0 | PRJNA526367 | 4202 | 344 | 2.759322 | 9.49206768 | Iflavirus sp. | 1916690 | Viruses | Viruses | 54.7 | 0.009 | NTclustered | gi|2895513773|tpg|BK068507.1| | 1916690 | g3994 | i0 | 100 | 0.328488372093023 | 29 | 0 | 8 | 0 | 316 | 344 | 9336 | 9364 | TPA_asm: Iflavirus sp. isolate WUR36 polyprotein gene, complete cds | blastn | 113 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Iflavirus sp. | ||
| 4322932 | 4322932 | PRJNA526367_P_NODE_42044_length_179_cov_5.100000_g41834_i0 | PRJNA526367 | 42044 | 179 | 5.1 | 9.129 | Skokie dicistro-like virus | 2789443 | Viruses | Viruses | 294 | 2.28e-75 | NTclustered | gi|2806502719|gb|PQ054859.1| | 2789443 | g41834 | i0 | 98.214 | 1.87709497206704 | 168 | 3 | 94 | 0 | 5 | 172 | 4834 | 4667 | MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence | blastn | 336 | 294 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 15798641 | 15798641 | PRJNA526367_P_NODE_37153_length_188_cov_2.489209_g36943_i0 | PRJNA526367 | 37153 | 188 | 2.489209 | 4.67971292 | Cherry virus Trakiya | 2074132 | Viruses | Viruses | 287 | 4.06e-73 | NTclustered | gi|2187015282|gb|OK181162.1| | 2074132 | g36943 | i0 | 95.055 | 0.968085106382979 | 182 | 9 | 97 | 0 | 7 | 188 | 1245 | 1426 | Cherry virus Trakiya strain CVT-A, complete genome | blastn | 182 | 287 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Cherry virus Trakiya | ||||
| 17073539 | 17073539 | PRJNA526367_P_NODE_57454_length_161_cov_3.803571_g57244_i0 | PRJNA526367 | 57454 | 161 | 3.803571 | 6.12374931 | Ripathug virus | 3131450 | Viruses | Viruses | 165 | 1.65e-36 | NTclustered | gi|2717322555|gb|PP173752.1| | 3131450 | g57244 | i0 | 88.321 | 209.614906832298 | 137 | 16 | 85 | 0 | 2 | 138 | 4342 | 4478 | MAG: Ripathug virus isolate RCCP2_k141_20704 genomic sequence | blastn | 33748 | 165 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripathug virus | |||||
| 27866927 | 27866927 | PRJNA526367_P_NODE_18225_length_324_cov_2.589091_g18016_i0 | PRJNA526367 | 18225 | 324 | 2.589091 | 8.38865484 | Shenzhen reo-like virus 1 | 2789623 | Viruses | Viruses | 50.1 | 2.61e-4 | NR | QPN36950.1 | 2789623 | g18016 | i0 | 71 | 0.287037037037037 | 31 | 9 | 28.7 | 0 | 94 | 2 | 1155 | 1185 | QPN36950.1 hypothetical protein [Shenzhen reo-like virus 1] | diamond | 93 | 50.1 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Shenzhen reo-like 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);;