contig_metadata
10 rows where bioproject = "PRJNA356682", tax_phylum = "Lenarviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4225206 | 4225206 | PRJNA356682_P_NODE_5104_length_627_cov_4.009025_g4428_i0 | PRJNA356682 | 5104 | 627 | 4.009025 | 25.13658675 | Sonabek virus | 3131524 | Viruses | Viruses | 342 | 3.3e-89 | NTclustered | gi|2717322744|gb|PP173825.1| | 3131524 | g4428 | i0 | 83.161 | 0.615629984051037 | 386 | 54 | 61 | 11 | 191 | 571 | 846 | 467 | MAG: Sonabek virus isolate SN1_k141_109124 genomic sequence | blastn | 386 | 342 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Sonabek virus | |||
| 8051159 | 8051159 | PRJNA356682_P_NODE_42487_length_243_cov_2.094118_g41796_i0 | PRJNA356682 | 42487 | 243 | 2.094118 | 5.08870674 | Chrocagosk virus | 3129397 | Viruses | Viruses | 161 | 3.4899999999999997e-35 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g41796 | i0 | 79.297 | 1.19341563786008 | 256 | 33 | 100 | 13 | 1 | 243 | 546 | 298 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 290 | 161 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus | |||||
| 11876621 | 11876621 | PRJNA356682_P_NODE_46330_length_230_cov_2.484076_g45639_i0 | PRJNA356682 | 46330 | 230 | 2.484076 | 5.7133748 | Sopawol virus | 3131668 | Viruses | Viruses | 370 | 4.99e-98 | NTclustered | gi|2717323098|gb|PP173969.1| | 3131668 | g45639 | i0 | 95.652 | 121.8 | 230 | 10 | 100 | 0 | 1 | 230 | 6 | 235 | MAG: Sopawol virus isolate SP1B_k141_158324 genomic sequence | blastn | 28014 | 370 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopawol virus | |||||
| 13150914 | 13150914 | PRJNA356682_P_NODE_13251_length_387_cov_1.942675_g12561_i0 | PRJNA356682 | 13251 | 387 | 1.942675 | 7.51815225 | Sonabek virus | 3131524 | Viruses | Viruses | 590 | 6.329999999999998e-164 | NTclustered | gi|2717322744|gb|PP173825.1| | 3131524 | g12561 | i0 | 94.315 | 1 | 387 | 18 | 99 | 4 | 3 | 386 | 414 | 799 | MAG: Sonabek virus isolate SN1_k141_109124 genomic sequence | blastn | 387 | 590 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Sonabek virus | |||
| 26726267 | 26726267 | PRJNA356682_P_NODE_40701_length_245_cov_2.255814_g40010_i0 | PRJNA356682 | 40701 | 245 | 2.255814 | 5.5267443 | Sonabek virus | 3131524 | Viruses | Viruses | 48.9 | 1.2e-4 | NR | WZH61556.1 | 3131524 | g40010 | i0 | 74.4 | 0.477551020408163 | 39 | 10 | 47.8 | 0 | 131 | 15 | 41 | 79 | WZH61556.1 MAG: hypothetical protein [Sonabek virus] | diamond | 117 | 48.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Sonabek virus | |||
| 27454265 | 27454265 | PRJNA356682_P_NODE_18203_length_336_cov_1.543726_g17512_i0 | PRJNA356682 | 18203 | 336 | 1.543726 | 5.18691936 | ssRNA phage SRR5467 | 2845702 | Viruses | Viruses | 50.4 | 1.98e-4 | NR | YP_010770102.1 | 2786474 | g17512 | i0 | 35.2 | 0.633928571428571 | 71 | 46 | 63.4 | 0 | 2 | 214 | 321 | 391 | YP_010770102.1 maturation protein [ssRNA phage SRR5467091_9] | diamond | 213 | 50.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Solspiviridae | Oekfovirus | Oekfovirus sp. 'lutivicinum' | ||
| 28180058 | 28180058 | PRJNA356682_P_NODE_43806_length_242_cov_0.911243_g43115_i0 | PRJNA356682 | 43806 | 242 | 0.911243 | 2.20520806 | ssRNA phage ESE | 3430437 | Viruses | Viruses | 138 | 3.3e-36 | NR | YP_010769154.1 | 2786005 | g43115 | i0 | 78.8 | 0.991735537190083 | 80 | 17 | 99.2 | 0 | 242 | 3 | 442 | 521 | YP_010769154.1 RNA-directed RNA polymerase [ssRNA phage ESE029] | diamond | 240 | 138 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Lohngkovirus | Lohngkovirus defluviicola | ||
| 31686630 | 31686630 | PRJNA356682_P_NODE_8877_length_469_cov_3.174242_g8188_i0 | PRJNA356682 | 8877 | 469 | 3.174242 | 14.88719498 | Qianjiang levi-like virus 15 | 3348422 | Viruses | Viruses | 49.7 | 0.00126 | NR | XHA87311.1 | 3348422 | g8188 | i0 | 40 | 0.479744136460554 | 75 | 39 | 44.8 | 2 | 108 | 317 | 1 | 74 | XHA87311.1 MAG: putative phage maturation protein [Qianjiang levi-like virus 15] | diamond | 225 | 49.7 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Qianjiang levi-like virus 15 | |||||
| 31876367 | 31876367 | PRJNA356682_P_NODE_10537_length_431_cov_1.656425_g9847_i0 | PRJNA356682 | 10537 | 431 | 1.656425 | 7.13919175 | ssRNA phage SRR5467 | 2845702 | Viruses | Viruses | 102 | 2.25e-22 | NR | YP_010770102.1 | 2786474 | g9847 | i0 | 39.3 | 0.939675174013921 | 135 | 81 | 94 | 1 | 2 | 406 | 189 | 322 | YP_010770102.1 maturation protein [ssRNA phage SRR5467091_9] | diamond | 405 | 102 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Solspiviridae | Oekfovirus | Oekfovirus sp. 'lutivicinum' | ||
| 32792714 | 32792714 | PRJNA356682_P_NODE_10000_length_442_cov_3.907859_g9310_i0 | PRJNA356682 | 10000 | 442 | 3.907859 | 17.27273678 | Leviviridae sp. | 2027243 | Viruses | Viruses | 103 | 1.08e-22 | NR | URG15324.1 | 2027243 | g9310 | i0 | 46.5 | 0.773755656108597 | 114 | 61 | 77.4 | 0 | 87 | 428 | 88 | 201 | URG15324.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 342 | 103 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. |
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);;