contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA576995" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 560707 | 560707 | PRJNA576995_P_NODE_22561_length_320_cov_1.246964_g21969_i0 | PRJNA576995 | 22561 | 320 | 1.246964 | 3.9902848 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 89.8 | 2.29e-13 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g21969 | i0 | 90 | 0.35625 | 70 | 6 | 22 | 1 | 1 | 69 | 5 | 74 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 114 | 89.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 560723 | 560723 | PRJNA576995_P_NODE_23521_length_314_cov_1.278008_g22929_i0 | PRJNA576995 | 23521 | 314 | 1.278008 | 4.01294512 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 132 | 3.67e-26 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g22929 | i0 | 100 | 1.52547770700637 | 71 | 0 | 23 | 0 | 244 | 314 | 72 | 2 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 479 | 132 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 560907 | 560907 | PRJNA576995_P_NODE_36021_length_250_cov_0.870056_g35429_i0 | PRJNA576995 | 36021 | 250 | 0.870056 | 2.17514 | Hepacivirus hominis | 3052230 | Viruses | Viruses | 52.8 | 0.023 | NTclustered | gi|1783579944|gb|MN628595.1| | 3052230 | g35429 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 223 | 250 | 28 | 1 | Hepacivirus hominis strain SL4 polyprotein (POLY) gene, complete cds | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Hepacivirus | Hepacivirus hominis | ||
| 1835838 | 1835838 | PRJNA576995_P_NODE_11902_length_442_cov_1.650407_g11310_i0 | PRJNA576995 | 11902 | 442 | 1.650407 | 7.29479894 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 76.8 | 2.54e-9 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g11310 | i0 | 100 | 0.714932126696833 | 41 | 0 | 9 | 0 | 402 | 442 | 63 | 23 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 316 | 76.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 1836317 | 1836317 | PRJNA576995_P_NODE_43522_length_241_cov_0.886905_g42930_i0 | PRJNA576995 | 43522 | 241 | 0.886905 | 2.13744105 | Monilinia fructicola binarnavirus 1 | 2964624 | Viruses | Viruses | 82.4 | 2.77e-11 | NTclustered | gi|2273758213|gb|ON038387.1| | 2964624 | g42930 | i0 | 88.235 | 1.39419087136929 | 68 | 8 | 28 | 0 | 1 | 68 | 2465 | 2398 | Monilinia fructicola binarnavirus 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 336 | 82.4 | 1 | Viruses | Orthornavirae | Birnaviridae | Monilinia fructicola binarnavirus 1 | ||||||
| 4388060 | 4388060 | PRJNA576995_P_NODE_20864_length_331_cov_1.193798_g20272_i0 | PRJNA576995 | 20864 | 331 | 1.193798 | 3.95147138 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 89.8 | 2.38e-13 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g20272 | i0 | 100 | 0.145015105740181 | 48 | 0 | 15 | 0 | 1 | 48 | 1 | 48 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 48 | 89.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 4388123 | 4388123 | PRJNA576995_P_NODE_24084_length_311_cov_1.180672_g23492_i0 | PRJNA576995 | 24084 | 311 | 1.180672 | 3.67188992 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 130 | 1.31e-25 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g23492 | i0 | 100 | 1.54340836012862 | 70 | 0 | 23 | 0 | 242 | 311 | 73 | 4 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 480 | 130 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 5664563 | 5664563 | PRJNA576995_P_NODE_42845_length_241_cov_1.375000_g42253_i0 | PRJNA576995 | 42845 | 241 | 1.375 | 3.31375 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 104 | 5.9e-18 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g42253 | i0 | 100 | 0.609958506224066 | 56 | 0 | 23 | 0 | 1 | 56 | 1 | 56 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 147 | 104 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 9489185 | 9489185 | PRJNA576995_P_NODE_35968_length_250_cov_0.870056_g35376_i0 | PRJNA576995 | 35968 | 250 | 0.870056 | 2.17514 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 80.5 | 1.04e-10 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g35376 | i0 | 100 | 0.172 | 43 | 0 | 17 | 0 | 1 | 43 | 43 | 1 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 43 | 80.5 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 14589614 | 14589614 | PRJNA576995_P_NODE_32432_length_265_cov_0.968750_g31840_i0 | PRJNA576995 | 32432 | 265 | 0.96875 | 2.5671875 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 110 | 1.42e-19 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g31840 | i0 | 98.387 | 0.577358490566038 | 62 | 1 | 23 | 0 | 1 | 62 | 9 | 70 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 153 | 110 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 15863086 | 15863086 | PRJNA576995_P_NODE_11193_length_458_cov_1.246753_g10601_i0 | PRJNA576995 | 11193 | 458 | 1.246753 | 5.71012874 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 121 | 1.2e-22 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g10601 | i0 | 97.222 | 0.943231441048035 | 72 | 1 | 16 | 1 | 1 | 71 | 2 | 73 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 432 | 121 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 19687006 | 19687006 | PRJNA576995_P_NODE_16596_length_368_cov_1.332203_g16004_i0 | PRJNA576995 | 16596 | 368 | 1.332203 | 4.90250704 | Enterovirus alphacoxsackie | 3428500 | Viruses | Viruses | 52.8 | 0.035 | NTclustered | gi|2148068742|gb|MN541018.1| | 31704 | g16004 | i0 | 100 | 0.0760869565217391 | 28 | 0 | 8 | 0 | 228 | 255 | 3424 | 3397 | Coxsackievirus A16 strain CV-A16/SWG50/SD/CHN/2018 polyprotein gene, partial cds | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Enterovirus | Enterovirus alphacoxsackie | ||
| 20962883 | 20962883 | PRJNA576995_P_NODE_28257_length_287_cov_1.439252_g27665_i0 | PRJNA576995 | 28257 | 287 | 1.439252 | 4.13065324 | Orius laevigatus associated narnavirus 2 | 3344919 | Viruses | Viruses | 69.4 | 2.64e-7 | NTclustered | gi|2802859156|gb|PP908628.1| | 3344919 | g27665 | i0 | 100 | 0.857142857142857 | 37 | 0 | 13 | 0 | 251 | 287 | 2450 | 2486 | MAG: Orius laevigatus associated narnavirus 2 isolate OlaeANaV2 polyprotein gene, complete cds | blastn | 246 | 69.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Orius laevigatus associated narnavirus 2 | ||
| 20962926 | 20962926 | PRJNA576995_P_NODE_31757_length_269_cov_1.173469_g31165_i0 | PRJNA576995 | 31757 | 269 | 1.173469 | 3.15663161 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 130 | 1.11e-25 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g31165 | i0 | 100 | 1.69516728624535 | 70 | 0 | 26 | 0 | 1 | 70 | 1 | 70 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 456 | 130 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 23512798 | 23512798 | PRJNA576995_P_NODE_13399_length_411_cov_1.976331_g12807_i0 | PRJNA576995 | 13399 | 411 | 1.976331 | 8.12272041 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 126 | 2.2899999999999998e-24 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g12807 | i0 | 96.154 | 1.05839416058394 | 78 | 2 | 19 | 1 | 1 | 77 | 1 | 78 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 435 | 126 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 24786914 | 24786914 | PRJNA576995_P_NODE_30440_length_276_cov_1.098522_g29848_i0 | PRJNA576995 | 30440 | 276 | 1.098522 | 3.03192072 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 115 | 3.1900000000000003e-21 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g29848 | i0 | 100 | 1.51811594202899 | 62 | 0 | 22 | 0 | 1 | 62 | 6 | 67 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 419 | 115 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 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);;