contig_metadata
10 rows where bioproject = "PRJNA401346" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8067473 | 8067473 | PRJNA401346_P_NODE_1707_length_373_cov_1.230769_g1686_i0 | PRJNA401346 | 1707 | 373 | 1.230769 | 4.59076837 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 379 | 1.43e-100 | NTclustered | gi|1832329329|gb|MT309858.1| | 2202565 | g1686 | i0 | 85.638 | 3.35120643431635 | 376 | 36 | 100 | 11 | 1 | 373 | 727 | 1087 | MAG: Genomoviridae sp. isolate 6434_413, complete genome | blastn | 1250 | 379 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 8067483 | 8067483 | PRJNA401346_P_NODE_2127_length_342_cov_0.811388_g2106_i0 | PRJNA401346 | 2127 | 342 | 0.811388 | 2.77494696 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 322 | 2.23e-83 | NTclustered | gi|1832329329|gb|MT309858.1| | 2202565 | g2106 | i0 | 83.929 | 1.94152046783626 | 336 | 54 | 98 | 0 | 7 | 342 | 407 | 72 | MAG: Genomoviridae sp. isolate 6434_413, complete genome | blastn | 664 | 322 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 22090701 | 22090701 | PRJNA401346_P_NODE_458_length_679_cov_1.058252_g439_i0 | PRJNA401346 | 458 | 679 | 1.058252 | 7.18553108 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 1053 | 0 | NTclustered | gi|1832329329|gb|MT309858.1| | 2202565 | g439 | i0 | 94.868 | 22.3740795287187 | 682 | 22 | 99 | 2 | 1 | 669 | 1124 | 1805 | MAG: Genomoviridae sp. isolate 6434_413, complete genome | blastn | 15192 | 1053 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 22090800 | 22090800 | PRJNA401346_P_NODE_7718_length_204_cov_1.244755_g7697_i0 | PRJNA401346 | 7718 | 204 | 1.244755 | 2.5393002 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 219 | 1.66e-52 | NTclustered | gi|2896100955|gb|PQ792342.1| | 2748378 | g7697 | i0 | 98.4 | 0.985294117647059 | 125 | 0 | 75 | 1 | 31 | 153 | 2 | 126 | MAG: Cressdnaviricota sp. isolate SbovineF090_cress11 genomic sequence | blastn | 201 | 219 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 22090809 | 22090809 | PRJNA401346_P_NODE_78_length_1419_cov_4.519882_g71_i0 | PRJNA401346 | 78 | 1419 | 4.519882 | 64.13712558 | Pavo cristatus CRESS-DNA-virus sp. | 2815049 | Viruses | Viruses | 166 | 2.26e-44 | NR | QTE03529.1 | 2815049 | g71 | i0 | 43.5 | 0.408033826638478 | 193 | 108 | 40.6 | 1 | 18 | 593 | 61 | 253 | QTE03529.1 MAG: capsid protein [Pavo cristatus CRESS-DNA-virus sp.] | diamond | 579 | 166 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Pavo cristatus CRESS-DNA-virus sp. | ||||||
| 27043811 | 27043811 | PRJNA401346_P_NODE_5462_length_227_cov_1.156627_g5441_i0 | PRJNA401346 | 5462 | 227 | 1.156627 | 2.62554329 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 67.4 | 1.88e-11 | NR | UOF80228.1 | 2748378 | g5441 | i0 | 52.3 | 0.859030837004405 | 65 | 30 | 85.9 | 1 | 217 | 23 | 67 | 130 | UOF80228.1 capsid protein [Cressdnaviricota sp.] | diamond | 195 | 67.4 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 27850102 | 27850102 | PRJNA401346_P_NODE_4424_length_253_cov_1.307292_g4403_i0 | PRJNA401346 | 4424 | 253 | 1.307292 | 3.30744876 | root | 1 | Root_unresolved | Root_unresolved | 60.8 | 1.05e-8 | NR | WAE42348.1 | 2748378 | g4403 | i0 | 48.1 | 1.24505928853755 | 52 | 27 | 61.7 | 0 | 248 | 93 | 208 | 259 | WAE42348.1 MAG: capsid protein [Cressdnaviricota sp.] | diamond | 315 | 60.8 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 30170067 | 30170067 | PRJNA401346_P_NODE_392_length_729_cov_2.633234_g377_i0 | PRJNA401346 | 392 | 729 | 2.633234 | 19.19627586 | Wigfec virus K19_555 | 2986010 | Viruses | Viruses | 114 | 9.43e-27 | NR | UYD39120.1 | 2986010 | g377 | i0 | 38.4 | 2.09053497942387 | 164 | 99 | 66.7 | 2 | 200 | 685 | 24 | 187 | UYD39120.1 MAG: capsid protein [Wigfec virus K19_555] | diamond | 1524 | 114 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Wigfec virus K19_555 | ||||||
| 31180929 | 31180929 | PRJNA401346_P_NODE_4115_length_262_cov_0.955224_g4094_i0 | PRJNA401346 | 4115 | 262 | 0.955224 | 2.50268688 | Bovine faeces associated smacovirus 5 | 1843753 | Viruses | Viruses | 76.3 | 4.66e-14 | NR | YP_009252317.1 | 1843753 | g4094 | i0 | 51.6 | 0.732824427480916 | 64 | 30 | 73.3 | 1 | 205 | 14 | 212 | 274 | YP_009252317.1 putative capsid protein [Bovine faeces associated smacovirus 5] | diamond | 192 | 76.3 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cremevirales | Smacoviridae | Drosmacovirus | Drosmacovirus bovas1 | ||
| 32667515 | 32667515 | PRJNA401346_P_NODE_4120_length_262_cov_0.925373_g4099_i0 | PRJNA401346 | 4120 | 262 | 0.925373 | 2.42447726 | Circoviridae sp. | 1954248 | Viruses | Viruses | 119 | 7.85e-32 | NR | AYP28764.1 | 1954248 | g4099 | i0 | 60.5 | 3.61832061068702 | 86 | 33 | 98.5 | 1 | 260 | 3 | 27 | 111 | AYP28764.1 MAG: helicase [Circoviridae sp.] | diamond | 948 | 119 | 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);;