contig_metadata
19 rows where bioproject = "PRJNA1068513", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 181895 | 181895 | PRJNA1068513_S_NODE_1581_length_607_cov_7.705993_g1540_i0 | PRJNA1068513 | 1581 | 607 | 7.705993 | 46.77537751 | Emesvirus zinderi | 329852 | Viruses | Viruses | 63.9 | 2.78e-5 | NTclustered | gi|2494998033|dbj|LC710218.1| | 12022 | g1540 | i0 | 100 | 6.02306425041186 | 34 | 0 | 6 | 0 | 1 | 34 | 17 | 50 | Escherichia phage MS2 GI_B RNA, complete genome | blastn | 3656 | 63.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Emesvirus | Emesvirus zinderi | ||
| 1456496 | 1456496 | PRJNA1068513_S_NODE_12442_length_249_cov_2.818182_g12396_i0 | PRJNA1068513 | 12442 | 249 | 2.818182 | 7.01727318 | Emesvirus zinderi | 329852 | Viruses | Viruses | 62.1 | 3.74e-5 | NTclustered | gi|2494998033|dbj|LC710218.1| | 12022 | g12396 | i0 | 100 | 13.85140562249 | 33 | 0 | 13 | 0 | 216 | 248 | 51 | 19 | Escherichia phage MS2 GI_B RNA, complete genome | blastn | 3449 | 62.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Emesvirus | Emesvirus zinderi | ||
| 2288882 | 2288882 | PRJNA1068513_S_NODE_3662_length_464_cov_1.230179_g3617_i0 | PRJNA1068513 | 3662 | 464 | 1.230179 | 5.70803056 | Viruses | 10239 | Viruses | Viruses | 62.1 | 7.49e-5 | NTclustered | gi|2494998033|dbj|LC710218.1| | 12022 | g3617 | i0 | 100 | 7.67672413793103 | 33 | 0 | 7 | 0 | 430 | 462 | 51 | 19 | Escherichia phage MS2 GI_B RNA, complete genome | blastn | 3562 | 62.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Emesvirus | Emesvirus zinderi | ||
| 2288885 | 2288885 | PRJNA1068513_S_NODE_4782_length_414_cov_2.243402_g4737_i0 | PRJNA1068513 | 4782 | 414 | 2.243402 | 9.28768428 | Viruses | 10239 | Viruses | Viruses | 67.6 | 1.42e-6 | NTclustered | gi|2494998033|dbj|LC710218.1| | 12022 | g4737 | i0 | 97.5 | 9.11352657004831 | 40 | 0 | 10 | 1 | 366 | 405 | 55 | 17 | Escherichia phage MS2 GI_B RNA, complete genome | blastn | 3773 | 67.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Emesvirus | Emesvirus zinderi | ||
| 4008401 | 4008401 | PRJNA1068513_S_NODE_7984_length_321_cov_1.822581_g7938_i0 | PRJNA1068513 | 7984 | 321 | 1.822581 | 5.85048501 | Emesvirus zinderi | 329852 | Viruses | Viruses | 65.8 | 3.87e-6 | NTclustered | gi|2494998033|dbj|LC710218.1| | 12022 | g7938 | i0 | 100 | 11.809968847352 | 35 | 0 | 11 | 0 | 287 | 321 | 51 | 17 | Escherichia phage MS2 GI_B RNA, complete genome | blastn | 3791 | 65.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Emesvirus | Emesvirus zinderi | ||
| 6116786 | 6116786 | PRJNA1068513_S_NODE_2065_length_563_cov_5.840816_g2023_i0 | PRJNA1068513 | 2065 | 563 | 5.840816 | 32.88379408 | Viruses | 10239 | Viruses | Viruses | 63.9 | 2.56e-5 | NTclustered | gi|2494998033|dbj|LC710218.1| | 12022 | g2023 | i0 | 100 | 6.36234458259325 | 34 | 0 | 6 | 0 | 530 | 563 | 51 | 18 | Escherichia phage MS2 GI_B RNA, complete genome | blastn | 3582 | 63.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Emesvirus | Emesvirus zinderi | ||
| 6116805 | 6116805 | PRJNA1068513_S_NODE_8785_length_305_cov_2.491379_g8739_i0 | PRJNA1068513 | 8785 | 305 | 2.491379 | 7.59870595 | Orthornavirae | 2732396 | Viruses | Viruses | 65.8 | 3.65e-6 | NTclustered | gi|2494998033|dbj|LC710218.1| | 12022 | g8739 | i0 | 100 | 12.0229508196721 | 35 | 0 | 11 | 0 | 2 | 36 | 17 | 51 | Escherichia phage MS2 GI_B RNA, complete genome | blastn | 3667 | 65.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Emesvirus | Emesvirus zinderi | ||
| 8666798 | 8666798 | PRJNA1068513_S_NODE_11647_length_258_cov_1.340541_g11601_i0 | PRJNA1068513 | 11647 | 258 | 1.340541 | 3.45859578 | Orthornavirae | 2732396 | Viruses | Viruses | 67.6 | 8.39e-7 | NTclustered | gi|2494998033|dbj|LC710218.1| | 12022 | g11601 | i0 | 100 | 15.1511627906977 | 36 | 0 | 14 | 0 | 220 | 255 | 52 | 17 | Escherichia phage MS2 GI_B RNA, complete genome | blastn | 3909 | 67.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Emesvirus | Emesvirus zinderi | ||
| 11660525 | 11660525 | PRJNA1068513_S_NODE_5650_length_382_cov_3.922330_g5604_i0 | PRJNA1068513 | 5650 | 382 | 3.92233 | 14.9833006 | Emesvirus zinderi | 329852 | Viruses | Viruses | 52.8 | 0.036 | NTclustered | gi|2494998033|dbj|LC710218.1| | 12022 | g5604 | i0 | 100 | 0.0732984293193717 | 28 | 0 | 7 | 0 | 1 | 28 | 23 | 50 | Escherichia phage MS2 GI_B RNA, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Emesvirus | Emesvirus zinderi | ||
| 12492457 | 12492457 | PRJNA1068513_S_NODE_1630_length_602_cov_6.956522_g1589_i0 | PRJNA1068513 | 1630 | 602 | 6.956522 | 41.87826244 | Viruses | 10239 | Viruses | Viruses | 62.1 | 9.9e-5 | NTclustered | gi|2494998033|dbj|LC710218.1| | 12022 | g1589 | i0 | 100 | 5.9202657807309 | 33 | 0 | 5 | 0 | 568 | 600 | 51 | 19 | Escherichia phage MS2 GI_B RNA, complete genome | blastn | 3564 | 62.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Emesvirus | Emesvirus zinderi | ||
| 12935603 | 12935603 | PRJNA1068513_S_NODE_2631_length_521_cov_4.142857_g2587_i0 | PRJNA1068513 | 2631 | 521 | 4.142857 | 21.58428497 | Emesvirus zinderi | 329852 | Viruses | Viruses | 58.4 | 0.001 | NTclustered | gi|2494998033|dbj|LC710218.1| | 12022 | g2587 | i0 | 100 | 0.0595009596928983 | 31 | 0 | 6 | 0 | 2 | 32 | 23 | 53 | Escherichia phage MS2 GI_B RNA, complete genome | blastn | 31 | 58.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Emesvirus | Emesvirus zinderi | ||
| 14210561 | 14210561 | PRJNA1068513_S_NODE_3652_length_464_cov_3.429668_g3607_i0 | PRJNA1068513 | 3652 | 464 | 3.429668 | 15.91365952 | Emesvirus zinderi | 329852 | Viruses | Viruses | 62.1 | 7.49e-5 | NTclustered | gi|2494998033|dbj|LC710218.1| | 12022 | g3607 | i0 | 97.222 | 7.63577586206897 | 36 | 1 | 8 | 0 | 429 | 464 | 54 | 19 | Escherichia phage MS2 GI_B RNA, complete genome | blastn | 3543 | 62.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Emesvirus | Emesvirus zinderi | ||
| 18033618 | 18033618 | PRJNA1068513_S_NODE_5595_length_384_cov_3.077170_g5549_i0 | PRJNA1068513 | 5595 | 384 | 3.07717 | 11.8163328 | Emesvirus zinderi | 329852 | Viruses | Viruses | 52.8 | 0.037 | NTclustered | gi|2494998033|dbj|LC710218.1| | 12022 | g5549 | i0 | 100 | 0.0729166666666667 | 28 | 0 | 7 | 0 | 1 | 28 | 23 | 50 | Escherichia phage MS2 GI_B RNA, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Emesvirus | Emesvirus zinderi | ||
| 18865159 | 18865159 | PRJNA1068513_S_NODE_3595_length_466_cov_94.569975_g3550_i0 | PRJNA1068513 | 3595 | 466 | 94.569975 | 440.6960835 | root | 1 | Root_unresolved | Root_unresolved | 63.9 | 2.09e-5 | NTclustered | gi|2494998033|dbj|LC710218.1| | 12022 | g3550 | i0 | 100 | 8.5 | 34 | 0 | 8 | 0 | 433 | 466 | 50 | 17 | Escherichia phage MS2 GI_B RNA, complete genome | blastn | 3961 | 63.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Emesvirus | Emesvirus zinderi | ||
| 19307480 | 19307480 | PRJNA1068513_S_NODE_5636_length_383_cov_1.506452_g5590_i0 | PRJNA1068513 | 5636 | 383 | 1.506452 | 5.76971116 | Emesvirus zinderi | 329852 | Viruses | Viruses | 63.9 | 1.69e-5 | NTclustered | gi|2494998033|dbj|LC710218.1| | 12022 | g5590 | i0 | 100 | 8.86945169712794 | 34 | 0 | 9 | 0 | 1 | 34 | 20 | 53 | Escherichia phage MS2 GI_B RNA, complete genome | blastn | 3397 | 63.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Emesvirus | Emesvirus zinderi | ||
| 19307483 | 19307483 | PRJNA1068513_S_NODE_5956_length_373_cov_2.416667_g5910_i0 | PRJNA1068513 | 5956 | 373 | 2.416667 | 9.01416791 | Emesvirus zinderi | 329852 | Viruses | Viruses | 58.4 | 7.63e-4 | NTclustered | gi|2494998033|dbj|LC710218.1| | 12022 | g5910 | i0 | 100 | 9.41018766756032 | 31 | 0 | 8 | 0 | 1 | 31 | 21 | 51 | Escherichia phage MS2 GI_B RNA, complete genome | blastn | 3510 | 58.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Emesvirus | Emesvirus zinderi | ||
| 22690453 | 22690453 | PRJNA1068513_S_NODE_7938_length_322_cov_2.421687_g7892_i0 | PRJNA1068513 | 7938 | 322 | 2.421687 | 7.79783214 | Viruses | 10239 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2494998033|dbj|LC710218.1| | 12022 | g7892 | i0 | 100 | 9.75776397515528 | 30 | 0 | 9 | 0 | 1 | 30 | 22 | 51 | Escherichia phage MS2 GI_B RNA, complete genome | blastn | 3142 | 56.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Emesvirus | Emesvirus zinderi | ||
| 24407716 | 24407716 | PRJNA1068513_S_NODE_13940_length_217_cov_4.861111_g13894_i0 | PRJNA1068513 | 13940 | 217 | 4.861111 | 10.54861087 | Emesvirus zinderi | 329852 | Viruses | Viruses | 52.8 | 0.019 | NTclustered | gi|2494998033|dbj|LC710218.1| | 12022 | g13894 | i0 | 100 | 0.129032258064516 | 28 | 0 | 13 | 0 | 190 | 217 | 50 | 23 | Escherichia phage MS2 GI_B RNA, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Emesvirus | Emesvirus zinderi | ||
| 25239874 | 25239874 | PRJNA1068513_S_NODE_5140_length_400_cov_6.021407_g5095_i0 | PRJNA1068513 | 5140 | 400 | 6.021407 | 24.085628 | Viruses | 10239 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|2494998033|dbj|LC710218.1| | 12022 | g5095 | i0 | 96.97 | 0.2575 | 33 | 1 | 8 | 0 | 366 | 398 | 51 | 19 | Escherichia phage MS2 GI_B RNA, complete genome | blastn | 103 | 56.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Emesvirus | Emesvirus zinderi |
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);;