contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA911178" and tax_phylum = "Cressdnaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5995009 | 5995009 | PRJNA911178_P_NODE_158205_length_298_cov_1.017778_g155732_i0 | PRJNA911178 | 158205 | 298 | 1.017778 | 3.03297844 | Galvornvirus isengard | 2955925 | Viruses | Viruses | 523 | 4.879999999999998e-144 | NTclustered | gi|1436204072|gb|MH616906.1| | 1954248 | g155732 | i0 | 98.328 | 1.00335570469799 | 299 | 3 | 100 | 2 | 1 | 298 | 943 | 646 | MAG: Circoviridae sp. isolate ctjd115, complete genome | blastn | 299 | 523 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 7270818 | 7270818 | PRJNA911178_P_NODE_264786_length_246_cov_1.497110_g262312_i0 | PRJNA911178 | 264786 | 246 | 1.49711 | 3.6828906 | Galvornvirus isengard | 2955925 | Viruses | Viruses | 278 | 3.37e-70 | NTclustered | gi|1436199337|gb|MH616644.1| | 1954248 | g262312 | i0 | 89.498 | 0.890243902439024 | 219 | 23 | 89 | 0 | 22 | 240 | 1769 | 1987 | MAG: Circoviridae sp. isolate ctbc359, complete genome | blastn | 219 | 278 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 7271697 | 7271697 | PRJNA911178_P_NODE_82306_length_392_cov_1.893417_g79839_i0 | PRJNA911178 | 82306 | 392 | 1.893417 | 7.42219464 | Galvornvirus isengard | 2955925 | Viruses | Viruses | 595 | 1.3799999999999994e-165 | NTclustered | gi|1436204072|gb|MH616906.1| | 1954248 | g79839 | i0 | 94.545 | 0.982142857142857 | 385 | 21 | 98 | 0 | 8 | 392 | 1432 | 1048 | MAG: Circoviridae sp. isolate ctjd115, complete genome | blastn | 385 | 595 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 17469996 | 17469996 | PRJNA911178_P_NODE_1574_length_2226_cov_19.377613_g1120_i0 | PRJNA911178 | 1574 | 2226 | 19.377613 | 431.34566538 | Avon-Heathcote Estuary associated circular virus 13 | 1618236 | Viruses | Viruses | 933 | 0 | NTclustered | gi|761263250|gb|KM874331.1| | 1618236 | g1120 | i0 | 75.93 | 2.68194070080863 | 1990 | 384 | 87 | 76 | 271 | 2216 | 2 | 1940 | Avon-Heathcote Estuary associated circular virus 13 isolate AHEaCV-13-NZ-4754GA-2012, complete genome | blastn | 5970 | 933 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Avon-Heathcote Estuary associated circular virus 13 | |||
| 22927492 | 22927492 | PRJNA911178_P_NODE_172818_length_287_cov_1.574766_g170345_i0 | PRJNA911178 | 172818 | 287 | 1.574766 | 4.51957842 | Viruses | 10239 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2302007269|gb|MT201781.1| | 2723992 | g170345 | i0 | 97.059 | 0.222996515679443 | 34 | 0 | 12 | 1 | 38 | 71 | 1843 | 1875 | MAG: Nanoviridae sp. isolate CN8_L15_3608, complete genome | blastn | 64 | 56.5 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Mulpavirales | Nanoviridae | Nanoviridae sp. | |||
| 25117781 | 25117781 | PRJNA911178_P_NODE_155460_length_300_cov_1.506608_g152987_i0 | PRJNA911178 | 155460 | 300 | 1.506608 | 4.519824 | Galvornvirus isengard | 2955925 | Viruses | Viruses | 230 | 1.2e-55 | NTclustered | gi|1436215281|gb|MH617526.1| | 1954248 | g152987 | i0 | 84.388 | 0.79 | 237 | 34 | 78 | 2 | 10 | 243 | 237 | 1 | MAG: Circoviridae sp. isolate ctcj794, complete genome | blastn | 237 | 230 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard |
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);;