contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA725806" and tax_kingdom = "Bamfordvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4540149 | 4540149 | PRJNA725806_P_NODE_141104_length_173_cov_1.757353_g140802_i0 | PRJNA725806 | 141104 | 173 | 1.757353 | 3.04022069 | Adintovirus androctonus13035 | 3115887 | Viruses | Viruses | 270 | 3.69e-68 | NTclustered | gi|2710390252|tpg|BK066392.1| | 3115887 | g140802 | i0 | 94.798 | 1 | 173 | 9 | 100 | 0 | 1 | 173 | 2720 | 2892 | MAG TPA_asm: Adintovirus androctonus13035 isolate Adinto13035 genomic sequence | blastn | 173 | 270 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 5815632 | 5815632 | PRJNA725806_P_NODE_97285_length_199_cov_4.104938_g96983_i0 | PRJNA725806 | 97285 | 199 | 4.104938 | 8.16882662 | Mimivirus U306 | 1932880 | Viruses | Viruses | 52.8 | 0.017 | NTclustered | gi|1572561086|emb|LT717347.1| | 1932880 | g96983 | i0 | 100 | 0.14070351758794 | 28 | 0 | 14 | 0 | 115 | 142 | 623723 | 623696 | Mimivirus U306 genome assembly, complete genome: monopartite | blastn | 28 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus | Mimivirus U306 | ||
| 8847477 | 8847477 | PRJNA725806_P_NODE_30207_length_286_cov_6.843373_g29910_i0 | PRJNA725806 | 30207 | 286 | 6.843373 | 19.57204678 | Iridoviridae | 10486 | Viruses | Viruses | 52.8 | 0.026 | NTclustered | gi|1241380616|gb|MF197913.1| | 2035708 | g29910 | i0 | 100 | 0.685314685314685 | 28 | 0 | 10 | 0 | 186 | 213 | 134406 | 134433 | Cherax quadricarinatus iridovirus strain CQIV-CN01, complete genome | blastn | 196 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Decapodiridovirus | Decapodiridovirus litopenaeus1 | ||
| 9640341 | 9640341 | PRJNA725806_P_NODE_175048_length_158_cov_1.239669_g174746_i0 | PRJNA725806 | 175048 | 158 | 1.239669 | 1.95867702 | Oceanusvirus kaneohense | 3060432 | Viruses | Viruses | 58.4 | 2.81e-4 | NTclustered | gi|2500360013|ref|NC_075136.1| | 2060617 | g174746 | i0 | 81.333 | 12.4303797468354 | 75 | 11 | 47 | 3 | 50 | 123 | 49130 | 49202 | Tetraselmis virus 1, complete genome | blastn | 1964 | 58.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Allomimiviridae | Oceanusvirus | Oceanusvirus kaneohense | ||
| 12191226 | 12191226 | PRJNA725806_P_NODE_34690_length_276_cov_4.079498_g34393_i0 | PRJNA725806 | 34690 | 276 | 4.079498 | 11.25941448 | Adintovirus androctonus13035 | 3115887 | Viruses | Viruses | 182 | 3.1e-41 | NTclustered | gi|2710390252|tpg|BK066392.1| | 3115887 | g34393 | i0 | 88.125 | 0.579710144927536 | 160 | 9 | 58 | 2 | 23 | 182 | 2510 | 2361 | MAG TPA_asm: Adintovirus androctonus13035 isolate Adinto13035 genomic sequence | blastn | 160 | 182 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 13465713 | 13465713 | PRJNA725806_P_NODE_63631_length_230_cov_7.217617_g63333_i0 | PRJNA725806 | 63631 | 230 | 7.217617 | 16.6005191 | Androctonus mauritanicus toursvirus | 3394651 | Viruses | Viruses | 80.5 | 9.42e-11 | NTclustered | gi|2893384087|gb|PQ778496.1| | 3394651 | g63333 | i0 | 78.125 | 0.556521739130435 | 128 | 26 | 55 | 2 | 72 | 198 | 23189 | 23063 | Androctonus mauritanicus toursvirus, complete genome | blastn | 128 | 80.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Ascoviridae | Toursvirus | Androctonus mauritanicus toursvirus | ||
| 16014243 | 16014243 | PRJNA725806_P_NODE_133153_length_177_cov_2.050000_g132851_i0 | PRJNA725806 | 133153 | 177 | 2.05 | 3.6285 | Iridovirus LCIVAC01 | 2506607 | Viruses | Viruses | 52.8 | 0.015 | NTclustered | gi|1588058645|gb|MK500315.1| | 2506607 | g132851 | i0 | 100 | 0.15819209039548 | 28 | 0 | 16 | 0 | 132 | 159 | 603 | 630 | MAG: Iridovirus LCIVAC01 genomic sequence, sequence | blastn | 28 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Iridovirus LCIVAC01 |
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);;