contig_metadata
4 rows where bioproject = "PRJNA493244", tax_phylum = "Hofneiviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13853571 | 13853571 | PRJNA493244_P_NODE_1693151_length_204_cov_4.426573_g1670026_i0 | PRJNA493244 | 1693151 | 204 | 4.426573 | 9.03020892 | root | 1 | Root_unresolved | Root_unresolved | 163 | 7.88e-36 | NTclustered | gi|2500352645|ref|NC_075032.1| | 10863 | g1670026 | i0 | 98.901 | 64.4705882352941 | 91 | 1 | 68 | 0 | 104 | 194 | 3043 | 2953 | Enterobacteria phage f1 isolate f1_2_FR, complete genome | blastn | 13152 | 163 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inovirus | Inovirus M13 | ||
| 17034971 | 17034971 | PRJNA493244_P_NODE_870654_length_468_cov_12.022113_g847750_i0 | PRJNA493244 | 870654 | 468 | 12.022113 | 56.26348884 | Inoviridae sp. | 2219103 | Viruses | Viruses | 723 | 0 | NTclustered | gi|2054538460|tpg|BK047807.1| | 2219103 | g847750 | i0 | 95.565 | 5.8034188034188 | 451 | 20 | 96 | 0 | 9 | 459 | 2374 | 2824 | MAG TPA_asm: Inoviridae sp. isolate ctlii5, partial genome | blastn | 2716 | 723 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 32384372 | 32384372 | PRJNA493244_P_NODE_1261779_length_308_cov_8.777328_g1238655_i0 | PRJNA493244 | 1261779 | 308 | 8.777328 | 27.03417024 | Inoviridae sp. | 2219103 | Viruses | Viruses | 57.4 | 5.49e-7 | NR | XOE96144.1 | 2219103 | g1238655 | i0 | 64.7 | 0.331168831168831 | 34 | 12 | 33.1 | 0 | 306 | 205 | 80 | 113 | XOE96144.1 MAG: hypothetical protein [Inoviridae sp.] | diamond | 102 | 57.4 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 32636919 | 32636919 | PRJNA493244_P_NODE_468540_length_760_cov_4.251788_g448973_i0 | PRJNA493244 | 468540 | 760 | 4.251788 | 32.3135888 | Tubulavirales sp. | 2833306 | Viruses | Viruses | 125 | 1.9299999999999998e-32 | NR | XOF02939.1 | 2833306 | g448973 | i0 | 88.1 | 0.26447368421052603 | 67 | 8 | 26.4 | 0 | 559 | 759 | 1 | 67 | XOF02939.1 MAG: hypothetical protein [Tubulavirales sp.] | diamond | 201 | 125 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Tubulavirales 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);;