contig_metadata
12 rows where bioproject = "PRJEB6097" and tax_phylum = "Uroviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 125567 | 125567 | PRJEB6097_S_NODE_1941_length_302_cov_44129.741573_g1887_i0 | PRJEB6097 | 1941 | 302 | 44129.741573 | 133271.81955046 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 104 | 7.65e-18 | NTclustered | gi|2914981140|gb|OR222104.1| | 2832643 | g1887 | i0 | 90.476 | 32.9503311258278 | 84 | 1 | 47 | 1 | 133 | 209 | 155979 | 155896 | MAG: Caudoviricetes sp. isolate MSP0003 genomic sequence | blastn | 9951 | 104 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5228113 | 5228113 | PRJEB6097_S_NODE_1625_length_318_cov_42187.053004_g1571_i0 | PRJEB6097 | 1625 | 318 | 42187.053004 | 134154.82855272 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 102 | 2.92e-17 | NTclustered | gi|2914955111|gb|OR221941.1| | 2832643 | g1571 | i0 | 90.361 | 31.4308176100629 | 83 | 0 | 55 | 2 | 132 | 207 | 97053 | 97134 | MAG: Caudoviricetes sp. isolate MSP0186 genomic sequence | blastn | 9995 | 102 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6503800 | 6503800 | PRJEB6097_S_NODE_1086_length_351_cov_36635.768987_g1032_i0 | PRJEB6097 | 1086 | 351 | 36635.768987 | 128591.54914437 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 108 | 6.98e-19 | NTclustered | gi|2914955111|gb|OR221941.1| | 2832643 | g1032 | i0 | 91.566 | 28.4786324786325 | 83 | 0 | 41 | 1 | 145 | 220 | 51333 | 51251 | MAG: Caudoviricetes sp. isolate MSP0186 genomic sequence | blastn | 9996 | 108 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7778068 | 7778068 | PRJEB6097_S_NODE_367_length_455_cov_14351.033333_g313_i0 | PRJEB6097 | 367 | 455 | 14351.033333 | 65297.20166515 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 97.1 | 2.01e-15 | NTclustered | gi|2059795870|tpg|BK039626.1| | 2832643 | g313 | i0 | 100 | 10.8593406593407 | 52 | 0 | 23 | 0 | 4 | 55 | 1 | 52 | MAG TPA_asm: Caudoviricetes sp. isolate ctWIh5, partial genome | blastn | 4941 | 97.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9052853 | 9052853 | PRJEB6097_S_NODE_928_length_363_cov_18573.365854_g874_i0 | PRJEB6097 | 928 | 363 | 18573.365854 | 67421.31805002 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 97.1 | 1.57e-15 | NTclustered | gi|2059795870|tpg|BK039626.1| | 2832643 | g874 | i0 | 100 | 13.6088154269972 | 52 | 0 | 29 | 0 | 4 | 55 | 1 | 52 | MAG TPA_asm: Caudoviricetes sp. isolate ctWIh5, partial genome | blastn | 4940 | 97.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11604010 | 11604010 | PRJEB6097_S_NODE_370_length_454_cov_55729.563246_g316_i0 | PRJEB6097 | 370 | 454 | 55729.563246 | 253012.21713684 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 102 | 4.31e-17 | NTclustered | gi|2914955111|gb|OR221941.1| | 2832643 | g316 | i0 | 90.361 | 43.5616740088106 | 83 | 0 | 62 | 2 | 132 | 207 | 97053 | 97134 | MAG: Caudoviricetes sp. isolate MSP0186 genomic sequence | blastn | 19777 | 102 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12879222 | 12879222 | PRJEB6097_S_NODE_451_length_448_cov_14962.924939_g397_i0 | PRJEB6097 | 451 | 448 | 14962.924939 | 67033.90372672 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 97.1 | 1.98e-15 | NTclustered | gi|2059795870|tpg|BK039626.1| | 2832643 | g397 | i0 | 100 | 11.0267857142857 | 52 | 0 | 23 | 0 | 4 | 55 | 1 | 52 | MAG TPA_asm: Caudoviricetes sp. isolate ctWIh5, partial genome | blastn | 4940 | 97.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16702268 | 16702268 | PRJEB6097_S_NODE_674_length_394_cov_32949.426184_g620_i0 | PRJEB6097 | 674 | 394 | 32949.426184 | 129820.73916496 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 104 | 1.03e-17 | NTclustered | gi|2914955111|gb|OR221941.1| | 2832643 | g620 | i0 | 90.476 | 25.2791878172589 | 84 | 0 | 37 | 2 | 132 | 208 | 97053 | 97135 | MAG: Caudoviricetes sp. isolate MSP0186 genomic sequence | blastn | 9960 | 104 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16702270 | 16702270 | PRJEB6097_S_NODE_774_length_381_cov_17498.673410_g720_i0 | PRJEB6097 | 774 | 381 | 17498.67341 | 66669.9456921 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 97.1 | 1.65e-15 | NTclustered | gi|2059795870|tpg|BK039626.1| | 2832643 | g720 | i0 | 100 | 12.9790026246719 | 52 | 0 | 27 | 0 | 4 | 55 | 1 | 52 | MAG TPA_asm: Caudoviricetes sp. isolate ctWIh5, partial genome | blastn | 4945 | 97.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17977164 | 17977164 | PRJEB6097_S_NODE_835_length_374_cov_21806.032448_g781_i0 | PRJEB6097 | 835 | 374 | 21806.032448 | 81554.56135552 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 97.1 | 1.62e-15 | NTclustered | gi|2059795870|tpg|BK039626.1| | 2832643 | g781 | i0 | 100 | 26.427807486631 | 52 | 0 | 28 | 0 | 4 | 55 | 1 | 52 | MAG TPA_asm: Caudoviricetes sp. isolate ctWIh5, partial genome | blastn | 9884 | 97.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19251115 | 19251115 | PRJEB6097_S_NODE_1596_length_321_cov_23621.486014_g1542_i0 | PRJEB6097 | 1596 | 321 | 23621.486014 | 75824.97010494 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 97.1 | 1.37e-15 | NTclustered | gi|2059795870|tpg|BK039626.1| | 2832643 | g1542 | i0 | 100 | 30.5358255451713 | 52 | 0 | 32 | 0 | 4 | 55 | 1 | 52 | MAG TPA_asm: Caudoviricetes sp. isolate ctWIh5, partial genome | blastn | 9802 | 97.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23077584 | 23077584 | PRJEB6097_S_NODE_1599_length_321_cov_14.713287_g1545_i0 | PRJEB6097 | 1599 | 321 | 14.713287 | 47.22965127 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.03 | NTclustered | gi|2054736360|tpg|BK038839.1| | 2832643 | g1545 | i0 | 100 | 0.0872274143302181 | 28 | 0 | 9 | 0 | 289 | 316 | 14872 | 14899 | MAG TPA_asm: Caudoviricetes sp. isolate ctrNu3, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes 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);;