contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA558770" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27647762 | 27647762 | PRJNA558770_P_NODE_395024_length_160_cov_3.736000_g393019_i0 | PRJNA558770 | 395024 | 160 | 3.736 | 5.9776 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 66.2 | 4.32e-11 | NR | AXH76405.1 | 2748378 | g393019 | i0 | 56.9 | 0.95625 | 51 | 22 | 95.6 | 0 | 6 | 158 | 172 | 222 | AXH76405.1 MAG: Rep [Cressdnaviricota sp.] | diamond | 153 | 66.2 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 27805674 | 27805674 | PRJNA558770_P_NODE_63384_length_262_cov_4.440529_g61379_i0 | PRJNA558770 | 63384 | 262 | 4.440529 | 11.63418598 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 103 | 1.05e-24 | NR | WAE42985.1 | 2748378 | g61379 | i0 | 61 | 0.938931297709924 | 82 | 29 | 90.5 | 1 | 248 | 12 | 164 | 245 | WAE42985.1 MAG: capsid protein [Cressdnaviricota sp.] | diamond | 246 | 103 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 27931783 | 27931783 | PRJNA558770_P_NODE_385165_length_195_cov_2.806250_g383160_i0 | PRJNA558770 | 385165 | 195 | 2.80625 | 5.4721875 | Arizlama virus | 2859451 | Viruses | Viruses | 43.1 | 0.0148 | NR | QXP07767.1 | 2859451 | g383160 | i0 | 35.8 | 1.55384615384615 | 53 | 34 | 81.5 | 0 | 189 | 31 | 254 | 306 | QXP07767.1 MAG: putative capsid protein [Arizlama virus] | diamond | 303 | 43.1 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arizlama virus | ||||||
| 29163403 | 29163403 | PRJNA558770_P_NODE_389109_length_180_cov_1.731034_g387104_i0 | PRJNA558770 | 389109 | 180 | 1.731034 | 3.1158612 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 58.9 | 2.35e-8 | NR | WAE43074.1 | 2748378 | g387104 | i0 | 76.7 | 0.5 | 30 | 7 | 50 | 0 | 174 | 85 | 241 | 270 | WAE43074.1 MAG: replication associated protein [Cressdnaviricota sp.] | diamond | 90 | 58.9 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 29257654 | 29257654 | PRJNA558770_P_NODE_62489_length_264_cov_4.091703_g60484_i0 | PRJNA558770 | 62489 | 264 | 4.091703 | 10.80209592 | Arizlama virus | 2859451 | Viruses | Viruses | 70.5 | 3.51e-12 | NR | QXP07768.1 | 2859451 | g60484 | i0 | 47.1 | 0.988636363636364 | 87 | 19 | 98.9 | 1 | 263 | 3 | 48 | 107 | QXP07768.1 MAG: replication associated protein [Arizlama virus] | diamond | 261 | 70.5 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arizlama virus | ||||||
| 29713554 | 29713554 | PRJNA558770_P_NODE_336650_length_233_cov_4.575758_g334645_i0 | PRJNA558770 | 336650 | 233 | 4.575758 | 10.66151614 | Viruses | 10239 | Viruses | Viruses | 50.4 | 5.87e-5 | NR | AXH73775.1 | 2748378 | g334645 | i0 | 83.3 | 1.59656652360515 | 24 | 4 | 30.9 | 0 | 162 | 233 | 49 | 72 | AXH73775.1 MAG: putative viral replication protein [Cressdnaviricota sp.] | diamond | 372 | 50.4 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 31311165 | 31311165 | PRJNA558770_P_NODE_394675_length_161_cov_4.388889_g392670_i0 | PRJNA558770 | 394675 | 161 | 4.388889 | 7.06611129 | Arizlama virus | 2859451 | Viruses | Viruses | 66.6 | 2.46e-11 | NR | QXP07768.1 | 2859451 | g392670 | i0 | 73 | 0.68944099378882 | 37 | 10 | 68.9 | 0 | 113 | 3 | 1 | 37 | QXP07768.1 MAG: replication associated protein [Arizlama virus] | diamond | 111 | 66.6 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arizlama virus | ||||||
| 31690753 | 31690753 | PRJNA558770_P_NODE_381977_length_209_cov_4.821839_g379972_i0 | PRJNA558770 | 381977 | 209 | 4.821839 | 10.07764351 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 58.9 | 3.61e-8 | NR | AXH76040.1 | 2748378 | g379972 | i0 | 49 | 0.703349282296651 | 49 | 25 | 70.3 | 0 | 204 | 58 | 235 | 283 | AXH76040.1 MAG: putative viral replication protein [Cressdnaviricota sp.] | diamond | 147 | 58.9 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 32007196 | 32007196 | PRJNA558770_P_NODE_58738_length_273_cov_2.802521_g56734_i0 | PRJNA558770 | 58738 | 273 | 2.802521 | 7.65088233 | Circoviridae sp. | 1954248 | Viruses | Viruses | 48.9 | 2.13e-4 | NR | QRI44238.1 | 1954248 | g56734 | i0 | 75 | 0.307692307692308 | 28 | 7 | 30.8 | 0 | 240 | 157 | 1 | 28 | QRI44238.1 MAG: replication-associated protein, partial [Circoviridae sp.] | diamond | 84 | 48.9 | 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);;