contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA798905" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4620013 | 4620013 | PRJNA798905_S_NODE_10044_length_435_cov_11.132597_g9595_i0 | PRJNA798905 | 10044 | 435 | 11.132597 | 48.42679695 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 699 | 0 | NTclustered | gi|1851855983|gb|MT138075.1| | 2748378 | g9595 | i0 | 96.056 | 0.990804597701149 | 431 | 14 | 99 | 3 | 1 | 429 | 2448 | 2877 | MAG: Cressdnaviricota sp. isolate tou80cre3 genomic sequence | blastn | 431 | 699 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 4620711 | 4620711 | PRJNA798905_S_NODE_40524_length_238_cov_2.830303_g40075_i0 | PRJNA798905 | 40524 | 238 | 2.830303 | 6.73612114 | Red panda feces-associated circular DNA virus 23 | 2863977 | Viruses | Viruses | 244 | 3.2899999999999996e-60 | NTclustered | gi|2099633381|gb|MZ556221.1| | 2863977 | g40075 | i0 | 93.865 | 2.36974789915966 | 163 | 8 | 81 | 2 | 73 | 235 | 2071 | 1911 | Red panda feces-associated circular DNA virus 23 isolate Rpf113unssDNA01-8 genomic sequence | blastn | 564 | 244 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Red panda feces-associated circular DNA virus 23 | ||||||
| 5895405 | 5895405 | PRJNA798905_S_NODE_20645_length_328_cov_3.713725_g20196_i0 | PRJNA798905 | 20645 | 328 | 3.713725 | 12.181018 | Smacoviridae sp. | 2715094 | Viruses | Viruses | 372 | 2.09e-98 | NTclustered | gi|2635142644|gb|OR370861.1| | 2715094 | g20196 | i0 | 96.053 | 1.45731707317073 | 228 | 9 | 70 | 0 | 99 | 326 | 639 | 412 | MAG: Smacoviridae sp. isolate YakFeces01-11706 genomic sequence | blastn | 478 | 372 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cremevirales | Smacoviridae | Smacoviridae sp. | |||
| 12271572 | 12271572 | PRJNA798905_S_NODE_35550_length_251_cov_5.550562_g35101_i0 | PRJNA798905 | 35550 | 251 | 5.550562 | 13.93191062 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 106 | 1.72e-18 | NTclustered | gi|2896100834|gb|PQ792294.1| | 2748378 | g35101 | i0 | 96.825 | 0.250996015936255 | 63 | 2 | 25 | 0 | 189 | 251 | 18 | 80 | MAG: Cressdnaviricota sp. isolate SbovineF087_cress11 genomic sequence | blastn | 63 | 106 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 12271761 | 12271761 | PRJNA798905_S_NODE_45030_length_198_cov_6.136000_g44581_i0 | PRJNA798905 | 45030 | 198 | 6.136 | 12.14928 | Smacoviridae sp. | 2715094 | Viruses | Viruses | 276 | 9.36e-70 | NTclustered | gi|2635142644|gb|OR370861.1| | 2715094 | g44581 | i0 | 91.878 | 0.994949494949495 | 197 | 16 | 99 | 0 | 2 | 198 | 20 | 216 | MAG: Smacoviridae sp. isolate YakFeces01-11706 genomic sequence | blastn | 197 | 276 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Cremevirales | Smacoviridae | Smacoviridae sp. | |||
| 13545384 | 13545384 | PRJNA798905_S_NODE_17591_length_350_cov_14.953069_g17142_i0 | PRJNA798905 | 17591 | 350 | 14.953069 | 52.3357415 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 228 | 5.119999999999998e-55 | NTclustered | gi|2896100810|gb|PQ792283.1| | 2748378 | g17142 | i0 | 84.615 | 0.705714285714286 | 247 | 19 | 65 | 10 | 121 | 349 | 872 | 627 | MAG: Cressdnaviricota sp. isolate SbovineF086_cress3 genomic sequence | blastn | 247 | 228 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 13545574 | 13545574 | PRJNA798905_S_NODE_25791_length_297_cov_4.558036_g25342_i0 | PRJNA798905 | 25791 | 297 | 4.558036 | 13.53736692 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 394 | 3.98e-105 | NTclustered | gi|1851855983|gb|MT138075.1| | 2748378 | g25342 | i0 | 90.635 | 1.00673400673401 | 299 | 24 | 100 | 3 | 1 | 297 | 2667 | 2371 | MAG: Cressdnaviricota sp. isolate tou80cre3 genomic sequence | blastn | 299 | 394 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 16094392 | 16094392 | PRJNA798905_S_NODE_18753_length_341_cov_7.914179_g18304_i0 | PRJNA798905 | 18753 | 341 | 7.914179 | 26.98735039 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 182 | 3.94e-41 | NTclustered | gi|2896100810|gb|PQ792283.1| | 2748378 | g18304 | i0 | 77.077 | 1.02346041055718 | 349 | 58 | 98 | 15 | 1 | 335 | 287 | 627 | MAG: Cressdnaviricota sp. isolate SbovineF086_cress3 genomic sequence | blastn | 349 | 182 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. |
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);;