contig_metadata
17 rows where bioproject = "PRJNA942359", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8576078 | 8576078 | PRJNA942359_P_NODE_7_length_3912_cov_70.755145_g4_i0 | PRJNA942359 | 7 | 3912 | 70.755145 | 2767.9412724 | Leviviridae sp. | 2027243 | Viruses | Viruses | 1074 | 0 | NTclustered | gi|2245486811|gb|ON162519.1| | 2027243 | g4 | i0 | 84.573 | 0.601226993865031 | 1089 | 161 | 28 | 6 | 636 | 1722 | 1084 | 1 | MAG: Leviviridae sp. isolate s42-k141_44103 RNA dependent RNA polymerase gene, partial cds | blastn | 2352 | 1074 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 14950839 | 14950839 | PRJNA942359_P_NODE_12_length_3462_cov_19.731779_g9_i0 | PRJNA942359 | 12 | 3462 | 19.731779 | 683.11418898 | Sholavirus sp. 'caenicola' | 2846211 | Viruses | Viruses | 1507 | 0 | NTclustered | gi|2497514791|ref|NC_074095.1| | 2786397 | g9 | i0 | 76.053 | 2.40843443096476 | 3086 | 634 | 88 | 91 | 1 | 3031 | 3486 | 451 | SsRNA phage SRR5466364_3 genomic sequence | blastn | 8338 | 1507 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Sholavirus | Sholavirus sp. 'caenicola' | ||
| 14951056 | 14951056 | PRJNA942359_P_NODE_592_length_966_cov_3.968645_g514_i0 | PRJNA942359 | 592 | 966 | 3.968645 | 38.3371107 | Leviviridae sp. | 2027243 | Viruses | Viruses | 405 | 6.52e-108 | NTclustered | gi|2245488938|gb|ON163587.1| | 2027243 | g514 | i0 | 80.791 | 0.819875776397516 | 531 | 90 | 54 | 11 | 10 | 534 | 765 | 1289 | MAG: Leviviridae sp. isolate 83-k141_204414 RNA dependent RNA polymerase gene, partial cds | blastn | 792 | 405 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 21661098 | 21661098 | PRJNA942359_P_NODE_5097_length_366_cov_3.484642_g4982_i0 | PRJNA942359 | 5097 | 366 | 3.484642 | 12.75378972 | Leviviridae sp. | 2027243 | Viruses | Viruses | 162 | 3.1199999999999996e-45 | NR | URG15504.1 | 2027243 | g4982 | i0 | 63.6 | 1.95081967213115 | 118 | 43 | 96.7 | 0 | 354 | 1 | 289 | 406 | URG15504.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 714 | 162 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 26676735 | 26676735 | PRJNA942359_P_NODE_3981_length_405_cov_1.924699_g3866_i0 | PRJNA942359 | 3981 | 405 | 1.924699 | 7.79503095 | Sanya atkins-like virus 1 | 2970316 | Viruses | Viruses | 145 | 4.03e-38 | NR | UUW20972.1 | 2970316 | g3866 | i0 | 53 | 0.977777777777778 | 132 | 58 | 97.8 | 1 | 398 | 3 | 263 | 390 | UUW20972.1 MAG: RNA replicase beta chain, partial [Sanya atkins-like virus 1] | diamond | 396 | 145 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Atkinsviridae | Barchevirus | Barchevirus pontederiivicinum | ||
| 27530802 | 27530802 | PRJNA942359_P_NODE_2263_length_520_cov_5.606264_g2149_i0 | PRJNA942359 | 2263 | 520 | 5.606264 | 29.1525728 | Leviviridae sp. | 2027243 | Viruses | Viruses | 180 | 7.939999999999998e-55 | NR | UJQ85757.1 | 2027243 | g2149 | i0 | 77.8 | 0.675 | 117 | 26 | 67.5 | 0 | 354 | 4 | 1 | 117 | UJQ85757.1 MAG: hypothetical protein 2 [Leviviridae sp.] | diamond | 351 | 180 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 27689081 | 27689081 | PRJNA942359_P_NODE_24_length_2878_cov_3.854189_g18_i0 | PRJNA942359 | 24 | 2878 | 3.854189 | 110.92355942 | Ripalit virus | 3130888 | Viruses | Viruses | 241 | 2.11e-65 | NR | WZH60503.1 | 3130888 | g18 | i0 | 38.5 | 0.408617095205003 | 392 | 220 | 39.5 | 8 | 864 | 2000 | 188 | 571 | WZH60503.1 MAG: maturation protein [Ripalit virus] | diamond | 1176 | 241 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripalit virus | |||||
| 27909429 | 27909429 | PRJNA942359_P_NODE_10325_length_277_cov_2.808824_g10210_i0 | PRJNA942359 | 10325 | 277 | 2.808824 | 7.78044248 | Leviviridae sp. | 2027243 | Viruses | Viruses | 167 | 7.459999999999998e-48 | NR | URG16228.1 | 2027243 | g10210 | i0 | 88 | 0.996389891696751 | 92 | 11 | 99.6 | 0 | 277 | 2 | 113 | 204 | URG16228.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 276 | 167 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 28509654 | 28509654 | PRJNA942359_P_NODE_4267_length_393_cov_1.612500_g4152_i0 | PRJNA942359 | 4267 | 393 | 1.6125 | 6.337125 | Sanya atkins-like virus 1 | 2970316 | Viruses | Viruses | 92.8 | 2.98e-19 | NR | UUW20970.1 | 2970316 | g4152 | i0 | 39.2 | 0.99236641221374 | 130 | 77 | 97.7 | 1 | 387 | 4 | 253 | 382 | UUW20970.1 MAG: maturation protein [Sanya atkins-like virus 1] | diamond | 390 | 92.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Atkinsviridae | Barchevirus | Barchevirus pontederiivicinum | ||
| 28572736 | 28572736 | PRJNA942359_P_NODE_8027_length_305_cov_2.823276_g7912_i0 | PRJNA942359 | 8027 | 305 | 2.823276 | 8.6109918 | ssRNA phage Esthiorhiza.4_1 | 2786089 | Viruses | Viruses | 67.8 | 1.22e-10 | NR | YP_010769950.1 | 2786089 | g7912 | i0 | 42.9 | 2.38032786885246 | 119 | 50 | 99.3 | 3 | 305 | 3 | 486 | 604 | YP_010769950.1 RNA-directed RNA polymerase [ssRNA phage Esthiorhiza.4_1] | diamond | 726 | 67.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Thidevirus | Thidevirus sp. 'edaphovivens' | ||
| 29488217 | 29488217 | PRJNA942359_P_NODE_310_length_1277_cov_3.975083_g259_i0 | PRJNA942359 | 310 | 1277 | 3.975083 | 50.76180991 | Leviviridae sp. | 2027243 | Viruses | Viruses | 205 | 8.43e-58 | NR | UJQ85756.1 | 2027243 | g259 | i0 | 38.3 | 0.833985904463587 | 355 | 197 | 80.8 | 7 | 161 | 1192 | 1 | 344 | UJQ85756.1 MAG: hypothetical protein 1 [Leviviridae sp.] | diamond | 1065 | 205 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 30056708 | 30056708 | PRJNA942359_P_NODE_2971_length_458_cov_3.218182_g2857_i0 | PRJNA942359 | 2971 | 458 | 3.218182 | 14.739273560000001 | ssRNA phage SRR79763 | 2843940 | Viruses | Viruses | 121 | 7.040000000000001e-29 | NR | YP_010768718.1 | 2786663 | g2857 | i0 | 46.9 | 0.962882096069869 | 147 | 75 | 95 | 3 | 456 | 22 | 383 | 528 | YP_010768718.1 RNA-directed RNA polymerase [ssRNA phage SRR7976301_2] | diamond | 441 | 121 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Atkinsviridae | Chinihovirus | Chinihovirus lutihabitans | ||
| 30442948 | 30442948 | PRJNA942359_P_NODE_2373_length_510_cov_2.048055_g2259_i0 | PRJNA942359 | 2373 | 510 | 2.048055 | 10.4450805 | Norzivirales | 2842247 | Viruses | Viruses | 154 | 2.29e-41 | NR | URG16228.1 | 2027243 | g2259 | i0 | 52.4 | 2.97058823529412 | 166 | 77 | 97.6 | 2 | 13 | 510 | 93 | 256 | URG16228.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 1515 | 154 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 32048373 | 32048373 | PRJNA942359_P_NODE_458_length_1078_cov_2.087562_g393_i0 | PRJNA942359 | 458 | 1078 | 2.087562 | 22.50391836 | ssRNA phage SRR79763 | 2843940 | Viruses | Viruses | 88.6 | 1.98e-15 | NR | YP_010768716.1 | 2786663 | g393 | i0 | 28.3 | 1.360853432282 | 240 | 156 | 64 | 7 | 692 | 3 | 34 | 267 | YP_010768716.1 maturation protein [ssRNA phage SRR7976301_2] | diamond | 1467 | 88.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Atkinsviridae | Chinihovirus | Chinihovirus lutihabitans | ||
| 32055094 | 32055094 | PRJNA942359_P_NODE_6918_length_324_cov_1.091633_g6803_i0 | PRJNA942359 | 6918 | 324 | 1.091633 | 3.53689092 | Viruses | 10239 | Viruses | Viruses | 92.4 | 3.48e-19 | NR | WPR17228.1 | 3066858 | g6803 | i0 | 52.7 | 1.66666666666667 | 93 | 43 | 86.1 | 1 | 2 | 280 | 496 | 587 | WPR17228.1 MAG: RNA-dependent RNA polymerase, partial [Dracophyllum associated narna-like virus 22] | diamond | 540 | 92.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Dracophyllum associated narna-like virus 22 | |||
| 32617640 | 32617640 | PRJNA942359_P_NODE_2740_length_475_cov_3.656716_g2626_i0 | PRJNA942359 | 2740 | 475 | 3.656716 | 17.369401 | Leviviridae sp. | 2027243 | Viruses | Viruses | 171 | 3.37e-48 | NR | URG16228.1 | 2027243 | g2626 | i0 | 72.7 | 0.694736842105263 | 110 | 30 | 69.5 | 0 | 330 | 1 | 4 | 113 | URG16228.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 330 | 171 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 32617641 | 32617641 | PRJNA942359_P_NODE_4240_length_394_cov_1.971963_g4125_i0 | PRJNA942359 | 4240 | 394 | 1.971963 | 7.76953422 | ssRNA phage Gerhypos.2_14 | 2786246 | Viruses | Viruses | 145 | 1.15e-37 | NR | YP_010769796.1 | 2786246 | g4125 | i0 | 55.3 | 2.01015228426396 | 132 | 56 | 99.7 | 2 | 393 | 1 | 101 | 230 | YP_010769796.1 RNA-directed RNA polymerase [ssRNA phage Gerhypos.2_14] | diamond | 792 | 145 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Radbaivirus | Radbaivirus edaphohabitans |
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);;