contig_metadata
18 rows where bioproject = "PRJNA1068830" and tax_phylum = "Preplasmiviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 183762 | 183762 | PRJNA1068830_P_NODE_81_length_4092_cov_11.190097_g57_i0 | PRJNA1068830 | 81 | 4092 | 11.190097 | 457.89876924 | red squirrel adenovirus 1 | 2773314 | Viruses | Viruses | 832 | 5.48e-289 | NR | YP_009389494.1 | 2773314 | g57 | i0 | 86.7 | 0.69208211143695 | 473 | 62 | 34.6 | 1 | 3832 | 2417 | 1 | 473 | YP_009389494.1 pIII [red squirrel adenovirus 1] | diamond | 2832 | 832 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus sciuri | ||
| 4009207 | 4009207 | PRJNA1068830_P_NODE_4164_length_1257_cov_23.336149_g57_i1 | PRJNA1068830 | 4164 | 1257 | 23.336149 | 293.33539293 | Yunan rodent mastadenovirus 3 | 3386056 | Viruses | Viruses | 686 | 0 | NTclustered | gi|2902559670|gb|PQ678111.1| | 3386056 | g57 | i1 | 83.531 | 0.60381861575179 | 759 | 99 | 60 | 14 | 247 | 999 | 1251 | 513 | MAG: Yunan rodent mastadenovirus 3 isolate LCGM-YNSC172 pV protein and pX protein genes, complete cds; and pVI protein gene, partial cds | blastn | 759 | 686 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Yunan rodent mastadenovirus 3 | ||
| 11661209 | 11661209 | PRJNA1068830_P_NODE_3530_length_1348_cov_6.532549_g3198_i0 | PRJNA1068830 | 3530 | 1348 | 6.532549 | 88.05876052 | Yunan rodent mastadenovirus 3 | 3386056 | Viruses | Viruses | 1048 | 0 | NTclustered | gi|2902559680|gb|PQ678114.1| | 3386056 | g3198 | i0 | 82.377 | 2.38575667655786 | 1220 | 200 | 98 | 8 | 132 | 1348 | 1583 | 376 | MAG: Yunan rodent mastadenovirus 3 isolate LCGM-YNSC172 22 kDa protein and pVIII protein genes, complete cds; and fiber protein gene, partial cds | blastn | 3216 | 1048 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Yunan rodent mastadenovirus 3 | ||
| 11661432 | 11661432 | PRJNA1068830_P_NODE_45110_length_328_cov_2.262745_g44407_i0 | PRJNA1068830 | 45110 | 328 | 2.262745 | 7.4218036 | Yunan rodent mastadenovirus 3 | 3386056 | Viruses | Viruses | 195 | 1.52e-57 | NR | XOB76067.1 | 3386056 | g44407 | i0 | 82.4 | 0.98780487804878 | 108 | 19 | 98.8 | 0 | 3 | 326 | 281 | 388 | XOB76067.1 MAG: DNA polymerase, partial [Yunan rodent mastadenovirus 3] | diamond | 324 | 195 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Yunan rodent mastadenovirus 3 | ||
| 21860708 | 21860708 | PRJNA1068830_P_NODE_87358_length_243_cov_0.917647_g86655_i0 | PRJNA1068830 | 87358 | 243 | 0.917647 | 2.22988221 | Yunan rodent mastadenovirus 3 | 3386056 | Viruses | Viruses | 285 | 1.98e-72 | NTclustered | gi|2902559663|gb|PQ678109.1| | 3386056 | g86655 | i0 | 91.346 | 0.8559670781893 | 208 | 18 | 86 | 0 | 2 | 209 | 3254 | 3461 | MAG: Yunan rodent mastadenovirus 3 isolate LCGM-YNSC172 DNA polymerase gene, partial cds; pTP protein gene, complete cds; and 52 kDa protein gene, partial cds | blastn | 208 | 285 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Yunan rodent mastadenovirus 3 | ||
| 23134609 | 23134609 | PRJNA1068830_P_NODE_1999_length_1679_cov_6.196139_g1784_i0 | PRJNA1068830 | 1999 | 1679 | 6.196139 | 104.03317381 | Mastadenovirus | 10509 | Viruses | Viruses | 636 | 1.85e-219 | NR | WRQ19856.1 | 10535 | g1784 | i0 | 65.9 | 1.68135795116141 | 452 | 150 | 80.2 | 2 | 1353 | 7 | 54 | 504 | WRQ19856.1 MAG: 100 kDa protein [unidentified adenovirus] | diamond | 2823 | 636 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | unidentified adenovirus | ||
| 23966393 | 23966393 | PRJNA1068830_P_NODE_159_length_3555_cov_8.231476_g118_i0 | PRJNA1068830 | 159 | 3555 | 8.231476 | 292.6289718 | red squirrel adenovirus 1 | 2773314 | Viruses | Viruses | 1614 | 0 | NR | YP_009389499.1 | 2773314 | g118 | i0 | 85.8 | 1.53755274261603 | 911 | 123 | 76.5 | 5 | 267 | 2987 | 1 | 909 | YP_009389499.1 hexon [red squirrel adenovirus 1] | diamond | 5466 | 1614 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus sciuri | ||
| 24408037 | 24408037 | PRJNA1068830_P_NODE_12840_length_692_cov_3.336026_g12173_i0 | PRJNA1068830 | 12840 | 692 | 3.336026 | 23.08529992 | Yunan rodent mastadenovirus 3 | 3386056 | Viruses | Viruses | 481 | 7.43e-131 | NTclustered | gi|2902559676|gb|PQ678113.1| | 3386056 | g12173 | i0 | 79.191 | 1 | 692 | 144 | 100 | 0 | 1 | 692 | 1731 | 1040 | MAG: Yunan rodent mastadenovirus 3 isolate LCGM-YNSC172 genomic sequence | blastn | 692 | 481 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Yunan rodent mastadenovirus 3 | ||
| 24408463 | 24408463 | PRJNA1068830_P_NODE_3400_length_1370_cov_2.814958_g1784_i1 | PRJNA1068830 | 3400 | 1370 | 2.814958 | 38.5649246 | Mastadenovirus | 10509 | Viruses | Viruses | 474 | 1.9799999999999993e-157 | NR | WRQ19856.1 | 10535 | g1784 | i1 | 66.6 | 1.45839416058394 | 335 | 108 | 72.7 | 2 | 369 | 1364 | 171 | 504 | WRQ19856.1 MAG: 100 kDa protein [unidentified adenovirus] | diamond | 1998 | 478 | 0.99163179916318 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | unidentified adenovirus | ||
| 27636125 | 27636125 | PRJNA1068830_P_NODE_47544_length_318_cov_2.706122_g46841_i0 | PRJNA1068830 | 47544 | 318 | 2.706122 | 8.60546796 | European ground squirrel adenovirus 2 | 3078375 | Viruses | Viruses | 152 | 4.87e-43 | NR | WNO15803.1 | 3078375 | g46841 | i0 | 66.7 | 2.95283018867925 | 105 | 35 | 99.1 | 0 | 317 | 3 | 63 | 167 | WNO15803.1 IVa2, partial [European ground squirrel adenovirus 2] | diamond | 939 | 152 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | European ground squirrel adenovirus 2 | |||
| 28077937 | 28077937 | PRJNA1068830_P_NODE_545_length_2539_cov_3.053933_g458_i0 | PRJNA1068830 | 545 | 2539 | 3.053933 | 77.53935887 | Yunan rodent mastadenovirus 3 | 3386056 | Viruses | Viruses | 782 | 1.56e-276 | NR | XOB76070.1 | 3386056 | g458 | i0 | 83.8 | 0.568333989759748 | 481 | 75 | 56.7 | 3 | 1464 | 25 | 1 | 479 | XOB76070.1 MAG: pIIIa protein [Yunan rodent mastadenovirus 3] | diamond | 1443 | 782 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Yunan rodent mastadenovirus 3 | ||
| 28204117 | 28204117 | PRJNA1068830_P_NODE_15966_length_610_cov_1.832402_g15282_i0 | PRJNA1068830 | 15966 | 610 | 1.832402 | 11.1776522 | Yunan rodent mastadenovirus 3 | 3386056 | Viruses | Viruses | 193 | 4.669999999999999e-55 | NR | XOB76067.1 | 3386056 | g15282 | i0 | 59.4 | 0.678688524590164 | 138 | 56 | 67.9 | 0 | 197 | 610 | 3 | 140 | XOB76067.1 MAG: DNA polymerase, partial [Yunan rodent mastadenovirus 3] | diamond | 414 | 193 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Yunan rodent mastadenovirus 3 | ||
| 28551807 | 28551807 | PRJNA1068830_P_NODE_36187_length_373_cov_1.560000_g35484_i0 | PRJNA1068830 | 36187 | 373 | 1.56 | 5.8188 | unidentified adenovirus | 10535 | Viruses | Viruses | 155 | 3.3299999999999993e-43 | NR | WRQ19841.1 | 10535 | g35484 | i0 | 52.8 | 2.01072386058981 | 125 | 57 | 98.9 | 1 | 4 | 372 | 181 | 305 | WRQ19841.1 MAG: putative E1B 55 kDa protein [unidentified adenovirus] | diamond | 750 | 155 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | unidentified adenovirus | ||
| 29624668 | 29624668 | PRJNA1068830_P_NODE_25110_length_466_cov_1.521628_g24408_i0 | PRJNA1068830 | 25110 | 466 | 1.521628 | 7.09078648 | red squirrel adenovirus 1 | 2773314 | Viruses | Viruses | 157 | 8.45e-45 | NR | YP_009389509.1 | 2773314 | g24408 | i0 | 42.9 | 0.991416309012876 | 154 | 88 | 99.1 | 0 | 466 | 5 | 88 | 241 | YP_009389509.1 34 kDa protein [red squirrel adenovirus 1] | diamond | 462 | 157 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus sciuri | ||
| 31552928 | 31552928 | PRJNA1068830_P_NODE_27036_length_444_cov_2.512129_g26333_i0 | PRJNA1068830 | 27036 | 444 | 2.512129 | 11.15385276 | Adenovirus myodes3864 | 3430675 | Viruses | Viruses | 45.4 | 0.0326 | NR | DBA47025.1 | 3115880 | g26333 | i0 | 32.6 | 0.891891891891892 | 132 | 69 | 84.5 | 8 | 398 | 24 | 577 | 695 | DBA47025.1 MAG TPA_asm: Fiber [Adenovirus myodes38640] | diamond | 396 | 45.4 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus arvicolinae | ||
| 32240489 | 32240489 | PRJNA1068830_P_NODE_2818_length_1486_cov_6.000708_g2531_i0 | PRJNA1068830 | 2818 | 1486 | 6.000708 | 89.17052088 | Mastadenovirus | 10509 | Viruses | Viruses | 484 | 1.0699999999999997e-166 | NR | WRQ19842.1 | 10535 | g2531 | i0 | 65.9 | 1.54239569313594 | 343 | 114 | 68.8 | 2 | 1029 | 7 | 9 | 350 | WRQ19842.1 MAG: IX protein [unidentified adenovirus] | diamond | 2292 | 484 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | unidentified adenovirus | ||
| 32280516 | 32280516 | PRJNA1068830_P_NODE_19679_length_539_cov_2.706009_g18981_i0 | PRJNA1068830 | 19679 | 539 | 2.706009 | 14.58538851 | unidentified adenovirus | 10535 | Viruses | Viruses | 185 | 4.75e-51 | NR | WRQ19856.1 | 10535 | g18981 | i0 | 72.4 | 0.706864564007421 | 127 | 34 | 70.1 | 1 | 538 | 161 | 545 | 671 | WRQ19856.1 MAG: 100 kDa protein [unidentified adenovirus] | diamond | 381 | 185 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | unidentified adenovirus | ||
| 32312262 | 32312262 | PRJNA1068830_P_NODE_27079_length_444_cov_1.681941_g26376_i0 | PRJNA1068830 | 27079 | 444 | 1.681941 | 7.46781804 | unidentified adenovirus | 10535 | Viruses | Viruses | 157 | 1.0299999999999998e-43 | NR | WRQ19841.1 | 10535 | g26376 | i0 | 49.3 | 0.986486486486487 | 146 | 74 | 98.6 | 0 | 2 | 439 | 17 | 162 | WRQ19841.1 MAG: putative E1B 55 kDa protein [unidentified adenovirus] | diamond | 438 | 157 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | unidentified adenovirus |
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);;