contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA734348" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3268435 | 3268435 | PRJNA734348_P_NODE_123223_length_243_cov_1.358824_g122525_i0 | PRJNA734348 | 123223 | 243 | 1.358824 | 3.30194232 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 427 | 3.11e-115 | NTclustered | gi|22855216|ref|NC_004174.1| | 161736 | g122525 | i0 | 98.354 | 1 | 243 | 4 | 100 | 0 | 1 | 243 | 1162 | 920 | Pseudomonas phage phi12 segment S, complete sequence | blastn | 243 | 427 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 4545617 | 4545617 | PRJNA734348_P_NODE_124724_length_243_cov_0.905882_g124026_i0 | PRJNA734348 | 124724 | 243 | 0.905882 | 2.20129326 | Chemarfal virus 258 | 3063149 | Viruses | Viruses | 375 | 1.14e-99 | NTclustered | gi|2626079799|gb|OR270470.1| | 3063149 | g124026 | i0 | 94.628 | 1.9917695473251 | 242 | 13 | 99 | 0 | 2 | 243 | 411 | 170 | MAG: Chemarfal virus 258 isolate ML188 genomic sequence | blastn | 484 | 375 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 258 | ||||
| 7096021 | 7096021 | PRJNA734348_P_NODE_134566_length_240_cov_3.868263_g133868_i0 | PRJNA734348 | 134566 | 240 | 3.868263 | 9.2838312 | Ripastyr virus | 3131364 | Viruses | Viruses | 435 | 1.83e-117 | NTclustered | gi|2717322326|gb|PP173666.1| | 3131364 | g133868 | i0 | 99.58 | 1071.22916666667 | 238 | 1 | 99 | 0 | 1 | 238 | 289 | 526 | MAG: Ripastyr virus isolate MP3_k141_6580 genomic sequence | blastn | 257095 | 435 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripastyr virus | |||||
| 7096438 | 7096438 | PRJNA734348_P_NODE_20886_length_438_cov_1.454795_g20195_i0 | PRJNA734348 | 20886 | 438 | 1.454795 | 6.3720021 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 719 | 0 | NTclustered | gi|22855221|ref|NC_004175.1| | 161736 | g20195 | i0 | 96.339 | 0.997716894977169 | 437 | 16 | 99 | 0 | 2 | 438 | 602 | 1038 | Pseudomonas phage phi12 segment M, complete sequence | blastn | 437 | 719 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 8371091 | 8371091 | PRJNA734348_P_NODE_22707_length_414_cov_2.158358_g22012_i0 | PRJNA734348 | 22707 | 414 | 2.158358 | 8.93560212 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 726 | 0 | NTclustered | gi|22855221|ref|NC_004175.1| | 161736 | g22012 | i0 | 98.313 | 1.0024154589372 | 415 | 6 | 100 | 1 | 1 | 414 | 554 | 140 | Pseudomonas phage phi12 segment M, complete sequence | blastn | 415 | 726 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 9647033 | 9647033 | PRJNA734348_P_NODE_5928_length_1068_cov_3.165829_g5446_i0 | PRJNA734348 | 5928 | 1068 | 3.165829 | 33.81105372 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 1524 | 0 | NTclustered | gi|22855209|ref|NC_004173.1| | 161736 | g5446 | i0 | 92.416 | 1 | 1068 | 81 | 100 | 0 | 1 | 1068 | 20 | 1087 | Pseudomonas phage phi12 segment L, complete sequence | blastn | 1068 | 1524 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 10921849 | 10921849 | PRJNA734348_P_NODE_27369_length_372_cov_2.096990_g26674_i0 | PRJNA734348 | 27369 | 372 | 2.09699 | 7.8008028 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 582 | 1.0099999999999999e-161 | NTclustered | gi|22855221|ref|NC_004175.1| | 161736 | g26674 | i0 | 94.892 | 1 | 372 | 19 | 100 | 0 | 1 | 372 | 3354 | 2983 | Pseudomonas phage phi12 segment M, complete sequence | blastn | 372 | 582 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 12197248 | 12197248 | PRJNA734348_P_NODE_26850_length_376_cov_1.930693_g26155_i0 | PRJNA734348 | 26850 | 376 | 1.930693 | 7.25940568 | Tobamovirus capsici | 3432865 | Viruses | Viruses | 667 | 0 | NTclustered | gi|1893169063|gb|MT130388.1| | 12239 | g26155 | i0 | 99.455 | 95.5478723404255 | 367 | 2 | 98 | 0 | 10 | 376 | 2769 | 3135 | Pepper mild mottle virus isolate M2-PMMoV 180k replication protein gene, partial cds; and movement protein and coat protein genes, complete cds | blastn | 35926 | 667 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 12197299 | 12197299 | PRJNA734348_P_NODE_29550_length_358_cov_1.059649_g28854_i0 | PRJNA734348 | 29550 | 358 | 1.059649 | 3.7935434200000002 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 579 | 1.2599999999999999e-160 | NTclustered | gi|22855221|ref|NC_004175.1| | 161736 | g28854 | i0 | 95.81 | 1 | 358 | 15 | 100 | 0 | 1 | 358 | 1895 | 2252 | Pseudomonas phage phi12 segment M, complete sequence | blastn | 358 | 579 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 12197796 | 12197796 | PRJNA734348_P_NODE_53370_length_286_cov_2.169014_g52673_i0 | PRJNA734348 | 53370 | 286 | 2.169014 | 6.20338004 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 435 | 2.25e-117 | NTclustered | gi|22855221|ref|NC_004175.1| | 161736 | g52673 | i0 | 94.056 | 1 | 286 | 17 | 100 | 0 | 1 | 286 | 3481 | 3766 | Pseudomonas phage phi12 segment M, complete sequence | blastn | 286 | 435 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 12198146 | 12198146 | PRJNA734348_P_NODE_71250_length_268_cov_2.758974_g70552_i0 | PRJNA734348 | 71250 | 268 | 2.758974 | 7.39405032 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 479 | 9.499999999999996e-131 | NTclustered | gi|22855216|ref|NC_004174.1| | 161736 | g70552 | i0 | 98.881 | 1 | 268 | 3 | 100 | 0 | 1 | 268 | 1563 | 1830 | Pseudomonas phage phi12 segment S, complete sequence | blastn | 268 | 479 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 13471578 | 13471578 | PRJNA734348_P_NODE_21051_length_435_cov_6.121547_g20360_i0 | PRJNA734348 | 21051 | 435 | 6.121547 | 26.62872945 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 776 | 0 | NTclustered | gi|22855216|ref|NC_004174.1| | 161736 | g20360 | i0 | 98.851 | 1 | 435 | 5 | 100 | 0 | 1 | 435 | 32 | 466 | Pseudomonas phage phi12 segment S, complete sequence | blastn | 435 | 776 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 13951507 | 13951507 | PRJNA734348_P_NODE_93291_length_251_cov_0.865169_g92593_i0 | PRJNA734348 | 93291 | 251 | 0.865169 | 2.17157419 | Orthorubulavirus | 2560195 | Viruses | Viruses | 459 | 1.1499999999999996e-124 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g92593 | i0 | 99.602 | 67.99203187251 | 251 | 1 | 100 | 0 | 1 | 251 | 4128 | 3878 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 17066 | 459 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 16020314 | 16020314 | PRJNA734348_P_NODE_19853_length_452_cov_2.678100_g19162_i0 | PRJNA734348 | 19853 | 452 | 2.6781 | 12.105012 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 409 | 2.2599999999999996e-109 | NTclustered | gi|22855209|ref|NC_004173.1| | 161736 | g19162 | i0 | 82.965 | 1 | 452 | 77 | 100 | 0 | 1 | 452 | 1724 | 1273 | Pseudomonas phage phi12 segment L, complete sequence | blastn | 452 | 409 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 18570801 | 18570801 | PRJNA734348_P_NODE_83795_length_257_cov_2.135870_g83097_i0 | PRJNA734348 | 83795 | 257 | 2.13587 | 5.4891859 | Tobamovirus capsici | 3432865 | Viruses | Viruses | 440 | 4.269999999999998e-119 | NTclustered | gi|1893169063|gb|MT130388.1| | 12239 | g83097 | i0 | 99.18 | 94.0155642023346 | 244 | 2 | 95 | 0 | 4 | 247 | 1782 | 1539 | Pepper mild mottle virus isolate M2-PMMoV 180k replication protein gene, partial cds; and movement protein and coat protein genes, complete cds | blastn | 24162 | 440 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 22395562 | 22395562 | PRJNA734348_P_NODE_34678_length_331_cov_1.720930_g33982_i0 | PRJNA734348 | 34678 | 331 | 1.72093 | 5.6962783 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 606 | 5.299999999999998e-169 | NTclustered | gi|22855216|ref|NC_004174.1| | 161736 | g33982 | i0 | 99.698 | 1 | 331 | 1 | 100 | 0 | 1 | 331 | 1497 | 1167 | Pseudomonas phage phi12 segment S, complete sequence | blastn | 331 | 606 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 23669960 | 23669960 | PRJNA734348_P_NODE_10999_length_697_cov_1.761218_g10358_i0 | PRJNA734348 | 10999 | 697 | 1.761218 | 12.27568946 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 1158 | 0 | NTclustered | gi|22855221|ref|NC_004175.1| | 161736 | g10358 | i0 | 96.7 | 1 | 697 | 22 | 100 | 1 | 1 | 697 | 2258 | 2953 | Pseudomonas phage phi12 segment M, complete sequence | blastn | 697 | 1158 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 23670375 | 23670375 | PRJNA734348_P_NODE_134159_length_241_cov_0.916667_g133461_i0 | PRJNA734348 | 134159 | 241 | 0.916667 | 2.20916747 | Betascleroulivirus thetaplasmoparae | 2955488 | Viruses | Viruses | 265 | 2.5599999999999996e-66 | NTclustered | gi|2500381320|ref|NC_076772.1| | 2686512 | g133461 | i0 | 86.611 | 2.74273858921162 | 239 | 32 | 99 | 0 | 1 | 239 | 1082 | 844 | Plasmopara viticola lesion associated ourmia-like virus 42 isolate DMG-G_38207 RNA dependent RNA polymerase (QKR47_gp1) gene, complete cds | blastn | 661 | 265 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Betascleroulivirus | Betascleroulivirus thetaplasmoparae | ||
| 24944583 | 24944583 | PRJNA734348_P_NODE_36860_length_321_cov_3.891129_g36164_i0 | PRJNA734348 | 36860 | 321 | 3.891129 | 12.49052409 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 466 | 9.08e-127 | NTclustered | gi|22855221|ref|NC_004175.1| | 161736 | g36164 | i0 | 92.835 | 1 | 321 | 23 | 100 | 0 | 1 | 321 | 1381 | 1061 | Pseudomonas phage phi12 segment M, complete sequence | blastn | 321 | 466 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 |
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);;