contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1237347" and tax_kingdom = "Shotokuvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 342793 | 342793 | PRJNA1237347_P_NODE_421381_length_271_cov_1.166667_g414808_i0 | PRJNA1237347 | 421381 | 271 | 1.166667 | 3.16166757 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 52.8 | 0.025 | NTclustered | gi|1436204446|gb|MH616955.1| | 2748378 | g414808 | i0 | 100 | 0.103321033210332 | 28 | 0 | 10 | 0 | 133 | 160 | 3742 | 3715 | MAG: Cressdnaviricota sp. isolate ctbc933, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 1617575 | 1617575 | PRJNA1237347_P_NODE_426442_length_269_cov_1.030612_g419869_i0 | PRJNA1237347 | 426442 | 269 | 1.030612 | 2.77234628 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 448 | 2.6899999999999995e-121 | NTclustered | gi|1436204076|gb|MH616907.1| | 2748378 | g419869 | i0 | 96.992 | 0.988847583643123 | 266 | 8 | 99 | 0 | 4 | 269 | 620 | 355 | MAG: Cressdnaviricota sp. isolate ctca234, complete genome | blastn | 266 | 448 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 4172064 | 4172064 | PRJNA1237347_P_NODE_531304_length_244_cov_0.900585_g524731_i0 | PRJNA1237347 | 531304 | 244 | 0.900585 | 2.1974274 | Betapapillomavirus 2 | 333924 | Viruses | Viruses | 429 | 8.699999999999998e-116 | NTclustered | gi|1020234|gb|U31787.1|HPU31787 | 37959 | g524731 | i0 | 98.361 | 6.61065573770492 | 244 | 4 | 100 | 0 | 1 | 244 | 4093 | 4336 | Human papillomavirus type 38, complete genome | blastn | 1613 | 429 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 2 | ||
| 9265003 | 9265003 | PRJNA1237347_P_NODE_13008_length_2204_cov_4.557954_g11235_i0 | PRJNA1237347 | 13008 | 2204 | 4.557954 | 100.45730616 | Avon-Heathcote Estuary associated circular virus 13 | 1618236 | Viruses | Viruses | 922 | 0 | NTclustered | gi|761263250|gb|KM874331.1| | 1618236 | g11235 | i0 | 75.885 | 2.69237749546279 | 1978 | 382 | 88 | 76 | 1 | 1934 | 1928 | 2 | Avon-Heathcote Estuary associated circular virus 13 isolate AHEaCV-13-NZ-4754GA-2012, complete genome | blastn | 5934 | 922 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cirlivirales | Circoviridae | Avon-Heathcote Estuary associated circular virus 13 | |||
| 18192462 | 18192462 | PRJNA1237347_P_NODE_318235_length_322_cov_1.236948_g311662_i0 | PRJNA1237347 | 318235 | 322 | 1.236948 | 3.98297256 | Galvornvirus isengard | 2955925 | Viruses | Viruses | 595 | 1.1099999999999995e-165 | NTclustered | gi|2725932850|gb|PP750563.1| | 1954248 | g311662 | i0 | 100 | 7.18944099378882 | 322 | 0 | 100 | 0 | 1 | 322 | 847 | 526 | Circoviridae sp. isolate V10 ORF10 gene, complete cds | blastn | 2315 | 595 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 20745547 | 20745547 | PRJNA1237347_P_NODE_481157_length_250_cov_0.870056_g474584_i0 | PRJNA1237347 | 481157 | 250 | 0.870056 | 2.17514 | Human papillomavirus | 10566 | Viruses | Viruses | 462 | 8.83e-126 | NTclustered | gi|1480688325|gb|MH777241.1| | 10566 | g474584 | i0 | 100 | 3.176 | 250 | 0 | 100 | 0 | 1 | 250 | 2553 | 2304 | MAG: Human papillomavirus isolate HPV-mSK_098, complete genome | blastn | 794 | 462 | 1 | Viruses | Human papillomavirus types | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Human papillomavirus | ||
| 20745611 | 20745611 | PRJNA1237347_P_NODE_485497_length_249_cov_2.011364_g478924_i0 | PRJNA1237347 | 485497 | 249 | 2.011364 | 5.00829636 | Galvornvirus isengard | 2955925 | Viruses | Viruses | 427 | 3.2e-115 | NTclustered | gi|1436204072|gb|MH616906.1| | 1954248 | g478924 | i0 | 97.59 | 1 | 249 | 6 | 100 | 0 | 1 | 249 | 726 | 478 | MAG: Circoviridae sp. isolate ctjd115, complete genome | blastn | 249 | 427 | 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);;