contig_metadata
4 rows where bioproject = "PRJNA694770", tax_kingdom = "Loebvirae" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 673817 | 673817 | PRJNA694770_P_NODE_1821_length_1484_cov_2.073707_g1651_i0 | PRJNA694770 | 1821 | 1484 | 2.073707 | 30.77381188 | Inoviridae sp. | 2219103 | Viruses | Viruses | 691 | 0 | NTclustered | gi|2057891989|tpg|BK051014.1| | 2219103 | g1651 | i0 | 75.77 | 4.74595687331536 | 1461 | 305 | 97 | 41 | 26 | 1463 | 1176 | 2610 | MAG TPA_asm: Inoviridae sp. isolate ctfkp1, partial genome | blastn | 7043 | 691 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 23627134 | 23627134 | PRJNA694770_P_NODE_4019_length_991_cov_2.627451_g3777_i0 | PRJNA694770 | 4019 | 991 | 2.627451 | 26.03803941 | Inoviridae sp. | 2219103 | Viruses | Viruses | 1027 | 0 | NTclustered | gi|2053040871|tpg|BK024249.1| | 2219103 | g3777 | i0 | 85.485 | 70.0201816347124 | 999 | 129 | 100 | 14 | 1 | 991 | 9822 | 8832 | MAG TPA_asm: Inoviridae sp. isolate ct4CW1, partial genome | blastn | 69390 | 1027 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 23627483 | 23627483 | PRJNA694770_P_NODE_52539_length_290_cov_1.774194_g52245_i0 | PRJNA694770 | 52539 | 290 | 1.774194 | 5.1451626 | Inoviridae sp. | 2219103 | Viruses | Viruses | 536 | 6.079999999999999e-148 | NTclustered | gi|2052176507|tpg|BK033134.1| | 2219103 | g52245 | i0 | 100 | 1 | 290 | 0 | 100 | 0 | 1 | 290 | 1013 | 724 | MAG TPA_asm: Inoviridae sp. isolate ctFpB4, partial genome | blastn | 290 | 536 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 28535527 | 28535527 | PRJNA694770_P_NODE_56387_length_285_cov_1.193396_g56093_i0 | PRJNA694770 | 56387 | 285 | 1.193396 | 3.4011786 | Inoviridae sp. | 2219103 | Viruses | Viruses | 90.9 | 5.05e-19 | NR | XOE97286.1 | 2219103 | g56093 | i0 | 52.6 | 1 | 95 | 42 | 100 | 1 | 1 | 285 | 331 | 422 | XOE97286.1 MAG: Zot-like toxin [Inoviridae sp.] | diamond | 285 | 90.9 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae 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);;