contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1137393" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1559393 | 1559393 | PRJNA1137393_P_NODE_6102_length_348_cov_3.040134_g5586_i0 | PRJNA1137393 | 6102 | 348 | 3.040134 | 10.57966632 | Sopatrul virus | 3131609 | Viruses | Viruses | 350 | 1.04e-91 | NTclustered | gi|2717322931|gb|PP173910.1| | 3131609 | g5586 | i0 | 86.462 | 53.7873563218391 | 325 | 37 | 92 | 5 | 29 | 348 | 687 | 365 | MAG: Sopatrul virus isolate SP1A_k141_123728 genomic sequence | blastn | 18718 | 350 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopatrul virus | |||||
| 7937705 | 7937705 | PRJNA1137393_P_NODE_21547_length_197_cov_2.290541_g21031_i0 | PRJNA1137393 | 21547 | 197 | 2.290541 | 4.51236577 | Ripagron virus | 3130596 | Viruses | Viruses | 119 | 1.66e-22 | NTclustered | gi|2717320202|gb|PP172898.1| | 3130596 | g21031 | i0 | 80.503 | 2.34010152284264 | 159 | 27 | 80 | 4 | 26 | 182 | 238 | 394 | MAG: Ripagron virus isolate KCAP2_k141_176596 genomic sequence | blastn | 461 | 119 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Ripagron virus | |||
| 14313774 | 14313774 | PRJNA1137393_P_NODE_70812_length_162_cov_0.920354_g70296_i0 | PRJNA1137393 | 70812 | 162 | 0.920354 | 1.49097348 | Tobamovirus capsici | 3432865 | Viruses | Viruses | 300 | 4.36e-77 | NTclustered | gi|20177424|ref|NC_003630.1| | 12239 | g70296 | i0 | 100 | 99.9567901234568 | 162 | 0 | 100 | 0 | 1 | 162 | 5744 | 5583 | Pepper mild mottle virus, complete genome | blastn | 16193 | 300 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 18136376 | 18136376 | PRJNA1137393_P_NODE_18315_length_208_cov_1.238994_g17799_i0 | PRJNA1137393 | 18315 | 208 | 1.238994 | 2.57710752 | Moss associated botourmia-like virus 63 | 3066699 | Viruses | Viruses | 176 | 1.04e-39 | NTclustered | gi|2626076699|gb|OQ987193.1| | 3066699 | g17799 | i0 | 84.699 | 1.34134615384615 | 183 | 20 | 86 | 8 | 10 | 188 | 972 | 1150 | MAG: Moss associated botourmia-like virus 63 isolate DICBIL genomic sequence | blastn | 279 | 176 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Moss associated botourmia-like virus 63 | |||
| 21961436 | 21961436 | PRJNA1137393_P_NODE_22758_length_194_cov_1.434483_g22242_i0 | PRJNA1137393 | 22758 | 194 | 1.434483 | 2.78289702 | Potexvirus flavitrifolii | 3433843 | Viruses | Viruses | 331 | 1.92e-86 | NTclustered | gi|2217161454|gb|OL584354.1| | 12177 | g22242 | i0 | 97.423 | 10 | 194 | 5 | 100 | 0 | 1 | 194 | 698 | 505 | Clover yellow mosaic virus isolate DSMZ PV-0851 genomic sequence | blastn | 1940 | 331 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus flavitrifolii | ||
| 21961661 | 21961661 | PRJNA1137393_P_NODE_8998_length_277_cov_1.192982_g8482_i0 | PRJNA1137393 | 8998 | 277 | 1.192982 | 3.30456014 | Chemarfal virus 262 | 3063354 | Viruses | Viruses | 490 | 4.56e-134 | NTclustered | gi|2626080003|gb|OR270572.1| | 3063354 | g8482 | i0 | 98.556 | 2 | 277 | 4 | 100 | 0 | 1 | 277 | 760 | 1036 | MAG: Chemarfal virus 262 isolate ML188 genomic sequence | blastn | 554 | 490 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Chemarfal virus 262 | ||||
| 23236945 | 23236945 | PRJNA1137393_P_NODE_12359_length_238_cov_3.994709_g11843_i0 | PRJNA1137393 | 12359 | 238 | 3.994709 | 9.50740742 | Chrocaryrb virus | 3129548 | Viruses | Viruses | 257 | 4.22e-64 | NTclustered | gi|2717317854|gb|PP171996.1| | 3129548 | g11843 | i0 | 86.42 | 205.012605042017 | 243 | 24 | 100 | 6 | 1 | 238 | 1305 | 1543 | MAG: Chrocaryrb virus isolate CC1C_k141_106130 genomic sequence | blastn | 48793 | 257 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocaryrb virus | |||||
| 24510656 | 24510656 | PRJNA1137393_P_NODE_37580_length_171_cov_1.295082_g37064_i0 | PRJNA1137393 | 37580 | 171 | 1.295082 | 2.21459022 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 316 | 4.6e-82 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g37064 | i0 | 100 | 100 | 171 | 0 | 100 | 0 | 1 | 171 | 13946 | 13776 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 17100 | 316 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 24510691 | 24510691 | PRJNA1137393_P_NODE_48060_length_167_cov_0.881356_g47544_i0 | PRJNA1137393 | 48060 | 167 | 0.881356 | 1.47186452 | Sopapen virus | 3131614 | Viruses | Viruses | 71.3 | 3.87e-8 | NTclustered | gi|2717322942|gb|PP173915.1| | 3131614 | g47544 | i0 | 88.136 | 1.61077844311377 | 59 | 7 | 35 | 0 | 109 | 167 | 527 | 469 | MAG: Sopapen virus isolate SP1A_k141_131186 genomic sequence | blastn | 269 | 71.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopapen virus |
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);;