contig_metadata
7 rows where bioproject = "PRJNA436017" and tax_phylum = "Pisuviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 430742 | 430742 | PRJNA436017_P_NODE_19761_length_184_cov_1.170068_g19463_i0 | PRJNA436017 | 19761 | 184 | 1.170068 | 2.15292512 | brine shrimp partiti-like virus 4 | 2900391 | Viruses | Viruses | 335 | 1.3899999999999996e-87 | NTclustered | gi|2209094901|gb|OL472522.1| | 2900391 | g19463 | i0 | 99.457 | 13 | 184 | 1 | 100 | 0 | 1 | 184 | 1149 | 966 | MAG: Brine shrimp partiti-like virus 4 isolate SD/17-18 RNA-dependent RNA polymerase gene, complete cds | blastn | 2392 | 335 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | brine shrimp partiti-like virus 4 | |||
| 6808410 | 6808410 | PRJNA436017_P_NODE_18186_length_192_cov_1.554839_g17888_i0 | PRJNA436017 | 18186 | 192 | 1.554839 | 2.98529088 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 344 | 2.44e-90 | NTclustered | gi|2209094748|gb|OL472446.1| | 2900464 | g17888 | i0 | 98.958 | 11 | 192 | 2 | 100 | 0 | 1 | 192 | 5487 | 5678 | MAG: Brine shrimp iflavirus 3 isolate VIE/10 RNA-dependent RNA polymerase gene, complete cds | blastn | 2112 | 344 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 9358896 | 9358896 | PRJNA436017_P_NODE_22508_length_172_cov_1.600000_g22210_i0 | PRJNA436017 | 22508 | 172 | 1.6 | 2.752 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 318 | 1.2899999999999999e-82 | NTclustered | gi|2209094754|gb|OL472449.1| | 2900464 | g22210 | i0 | 100 | 11 | 172 | 0 | 100 | 0 | 1 | 172 | 5016 | 5187 | MAG: Brine shrimp iflavirus 3 isolate NM/94-18 RNA-dependent RNA polymerase gene, complete cds | blastn | 1892 | 318 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 13184374 | 13184374 | PRJNA436017_P_NODE_17511_length_196_cov_1.578616_g17213_i0 | PRJNA436017 | 17511 | 196 | 1.578616 | 3.09408736 | brine shrimp partiti-like virus 4 | 2900391 | Viruses | Viruses | 357 | 3.2099999999999996e-94 | NTclustered | gi|2209094901|gb|OL472522.1| | 2900391 | g17213 | i0 | 99.49 | 13 | 196 | 1 | 100 | 0 | 1 | 196 | 660 | 465 | MAG: Brine shrimp partiti-like virus 4 isolate SD/17-18 RNA-dependent RNA polymerase gene, complete cds | blastn | 2548 | 357 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | brine shrimp partiti-like virus 4 | |||
| 24656979 | 24656979 | PRJNA436017_P_NODE_15000_length_214_cov_2.983051_g14702_i0 | PRJNA436017 | 15000 | 214 | 2.983051 | 6.38372914 | Sopidub virus | 3131684 | Viruses | Viruses | 108 | 3.97e-19 | NTclustered | gi|2717323145|gb|PP173985.1| | 3131684 | g14702 | i0 | 93.243 | 1.39719626168224 | 74 | 3 | 34 | 1 | 137 | 208 | 2139 | 2212 | MAG: Sopidub virus isolate SP1B_k141_213983 genomic sequence | blastn | 299 | 108 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Sopidub virus | |||
| 24657144 | 24657144 | PRJNA436017_P_NODE_23760_length_167_cov_1.907692_g23462_i0 | PRJNA436017 | 23760 | 167 | 1.907692 | 3.18584564 | brine shrimp partiti-like virus 4 | 2900391 | Viruses | Viruses | 309 | 7.53e-80 | NTclustered | gi|2209094901|gb|OL472522.1| | 2900391 | g23462 | i0 | 100 | 13 | 167 | 0 | 100 | 0 | 1 | 167 | 1173 | 1339 | MAG: Brine shrimp partiti-like virus 4 isolate SD/17-18 RNA-dependent RNA polymerase gene, complete cds | blastn | 2171 | 309 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | brine shrimp partiti-like virus 4 | |||
| 30928986 | 30928986 | PRJNA436017_P_NODE_26074_length_160_cov_0.926829_g25776_i0 | PRJNA436017 | 26074 | 160 | 0.926829 | 1.4829264 | Plasmopara viticola lesion associated Partitivirus 8 | 2692006 | Viruses | Viruses | 56.2 | 2.11e-7 | NR | QHD64792.1 | 2692006 | g25776 | i0 | 52.3 | 0.825 | 44 | 21 | 82.5 | 0 | 10 | 141 | 271 | 314 | QHD64792.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated Partitivirus 8] | diamond | 132 | 56.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Plasmopara viticola lesion associated Partitivirus 8 |
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);;