contig_metadata
12 rows where bioproject = "PRJNA1120060", tax_kingdom = "Loebvirae" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5338197 | 5338197 | PRJNA1120060_P_NODE_12425_length_1362_cov_2.862684_g7328_i0 | PRJNA1120060 | 12425 | 1362 | 2.862684 | 38.98975608 | Inoviridae sp. | 2219103 | Viruses | Viruses | 966 | 0 | NTclustered | gi|2057940741|tpg|BK045985.1| | 2219103 | g7328 | i0 | 79.65 | 2.69162995594714 | 1371 | 257 | 99 | 19 | 3 | 1362 | 9951 | 8592 | MAG TPA_asm: Inoviridae sp. isolate ctGPG1, partial genome | blastn | 3666 | 966 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 6650346 | 6650346 | PRJNA1120060_P_NODE_875926_length_313_cov_0.950000_g858002_i0 | PRJNA1120060 | 875926 | 313 | 0.95 | 2.9735 | Inoviridae sp. | 2219103 | Viruses | Viruses | 512 | 1.12e-140 | NTclustered | gi|2059610912|tpg|BK037300.1| | 2219103 | g858002 | i0 | 96.166 | 23.9936102236422 | 313 | 12 | 100 | 0 | 1 | 313 | 797 | 1109 | MAG TPA_asm: Inoviridae sp. isolate cteXp24, partial genome | blastn | 7510 | 512 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 9168615 | 9168615 | PRJNA1120060_P_NODE_1642688_length_287_cov_2.836449_g1624690_i0 | PRJNA1120060 | 1642688 | 287 | 2.836449 | 8.14060863 | Inoviridae sp. | 2219103 | Viruses | Viruses | 520 | 6.049999999999999e-143 | NTclustered | gi|2054444724|tpg|BK036222.1| | 2219103 | g1624690 | i0 | 99.303 | 14.8571428571429 | 287 | 2 | 100 | 0 | 1 | 287 | 47832 | 48118 | MAG TPA_asm: Inoviridae sp. isolate ctSjg4, partial genome | blastn | 4264 | 520 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 11715132 | 11715132 | PRJNA1120060_P_NODE_1335430_length_303_cov_2.395652_g1317465_i0 | PRJNA1120060 | 1335430 | 303 | 2.395652 | 7.25882556 | Inoviridae sp. | 2219103 | Viruses | Viruses | 444 | 3.99e-120 | NTclustered | gi|2058141318|tpg|BK034306.1| | 2219103 | g1317465 | i0 | 93.069 | 3.15181518151815 | 303 | 21 | 100 | 0 | 1 | 303 | 4653 | 4955 | MAG TPA_asm: Inoviridae sp. isolate ctRTX5, partial genome | blastn | 955 | 444 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 12997834 | 12997834 | PRJNA1120060_P_NODE_1875131_length_278_cov_1.102439_g1857115_i0 | PRJNA1120060 | 1875131 | 278 | 1.102439 | 3.06478042 | Inoviridae sp. | 2219103 | Viruses | Viruses | 364 | 2.889999999999999e-96 | NTclustered | gi|2056756337|tpg|BK045429.1| | 2219103 | g1857115 | i0 | 90.141 | 29.4604316546763 | 284 | 22 | 100 | 4 | 1 | 278 | 4373 | 4656 | MAG TPA_asm: Inoviridae sp. isolate ctpv15, partial genome | blastn | 8190 | 364 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 14277904 | 14277904 | PRJNA1120060_P_NODE_2233452_length_263_cov_5.252632_g2215398_i0 | PRJNA1120060 | 2233452 | 263 | 5.252632 | 13.81442216 | Inoviridae sp. ct6Op23 | 2826757 | Viruses | Viruses | 448 | 2.6199999999999995e-121 | NTclustered | gi|2051143877|tpg|BK015782.1| | 2826757 | g2215398 | i0 | 97.692 | 12.5095057034221 | 260 | 6 | 99 | 0 | 1 | 260 | 8354 | 8613 | MAG TPA_asm: Inoviridae sp. ct6Op23, partial genome | blastn | 3290 | 448 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. ct6Op23 | |||
| 18103634 | 18103634 | PRJNA1120060_P_NODE_2462935_length_255_cov_2.170330_g2444865_i0 | PRJNA1120060 | 2462935 | 255 | 2.17033 | 5.5343415 | Inoviridae sp. | 2219103 | Viruses | Viruses | 472 | 1.5e-128 | NTclustered | gi|2059782188|tpg|BK039359.1| | 2219103 | g2444865 | i0 | 100 | 66.7294117647059 | 255 | 0 | 100 | 0 | 1 | 255 | 1807 | 1553 | MAG TPA_asm: Inoviridae sp. isolate ct4y91, partial genome | blastn | 17016 | 472 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 18116863 | 18116863 | PRJNA1120060_P_NODE_367915_length_397_cov_3.916667_g350583_i0 | PRJNA1120060 | 367915 | 397 | 3.916667 | 15.54916799 | Inoviridae sp. | 2219103 | Viruses | Viruses | 580 | 3.92e-161 | NTclustered | gi|2058141318|tpg|BK034306.1| | 2219103 | g350583 | i0 | 92.982 | 3.84886649874055 | 399 | 26 | 100 | 1 | 1 | 397 | 1451 | 1849 | MAG TPA_asm: Inoviridae sp. isolate ctRTX5, partial genome | blastn | 1528 | 580 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 19379096 | 19379096 | PRJNA1120060_P_NODE_2561616_length_252_cov_1.307263_g2543541_i0 | PRJNA1120060 | 2561616 | 252 | 1.307263 | 3.29430276 | Inoviridae sp. | 2219103 | Viruses | Viruses | 466 | 6.89e-127 | NTclustered | gi|2052948579|tpg|BK029953.1| | 2219103 | g2543541 | i0 | 100 | 2.98809523809524 | 252 | 0 | 100 | 0 | 1 | 252 | 559 | 810 | MAG TPA_asm: Inoviridae sp. isolate ctZqZ3, partial genome | blastn | 753 | 466 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 24463967 | 24463967 | PRJNA1120060_P_NODE_1424600_length_297_cov_2.258929_g1406618_i0 | PRJNA1120060 | 1424600 | 297 | 2.258929 | 6.70901913 | Inoviridae sp. | 2219103 | Viruses | Viruses | 544 | 3.7299999999999996e-150 | NTclustered | gi|2906148673|gb|PQ646408.1| | 2219103 | g1406618 | i0 | 99.663 | 7.62962962962963 | 297 | 1 | 100 | 0 | 1 | 297 | 2079 | 2375 | MAG: Inoviridae sp. isolate k127_4036430 genomic sequence | blastn | 2266 | 544 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 24472016 | 24472016 | PRJNA1120060_P_NODE_2005140_length_272_cov_3.668342_g1987107_i0 | PRJNA1120060 | 2005140 | 272 | 3.668342 | 9.97789024 | Inoviridae sp. | 2219103 | Viruses | Viruses | 398 | 2.7799999999999997e-106 | NTclustered | gi|2058141318|tpg|BK034306.1| | 2219103 | g1987107 | i0 | 93.015 | 3.99632352941176 | 272 | 19 | 100 | 0 | 1 | 272 | 1029 | 758 | MAG TPA_asm: Inoviridae sp. isolate ctRTX5, partial genome | blastn | 1087 | 398 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 27922596 | 27922596 | PRJNA1120060_P_NODE_47125_length_734_cov_2.462935_g36011_i0 | PRJNA1120060 | 47125 | 734 | 2.462935 | 18.0779429 | Inoviridae sp. | 2219103 | Viruses | Viruses | 137 | 2.3499999999999997e-37 | NR | XOE98887.1 | 2219103 | g36011 | i0 | 66.3 | 0.376021798365123 | 92 | 31 | 37.6 | 0 | 734 | 459 | 13 | 104 | XOE98887.1 MAG: hypothetical protein [Inoviridae sp.] | diamond | 276 | 137 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae 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);;