contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA745923" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 724611 | 724611 | PRJNA745923_S_NODE_18341_length_231_cov_1.276596_g18009_i0 | PRJNA745923 | 18341 | 231 | 1.276596 | 2.94893676 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 111 | 3.36e-20 | NTclustered | gi|2053084802|tpg|BK020171.1| | 2832643 | g18009 | i0 | 94.521 | 6.07792207792208 | 73 | 3 | 32 | 1 | 1 | 73 | 1271 | 1200 | MAG TPA_asm: Caudoviricetes sp. isolate ctkEe11, partial genome | blastn | 1404 | 111 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 724708 | 724708 | PRJNA745923_S_NODE_24361_length_196_cov_1.980392_g24029_i0 | PRJNA745923 | 24361 | 196 | 1.980392 | 3.88156832 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 213 | 7.35e-51 | NTclustered | gi|2054791465|tpg|BK049930.1| | 2832643 | g24029 | i0 | 90.184 | 1.71938775510204 | 163 | 16 | 83 | 0 | 1 | 163 | 5296 | 5458 | MAG TPA_asm: Caudoviricetes sp. isolate ct7mf1, partial genome | blastn | 337 | 213 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 724758 | 724758 | PRJNA745923_S_NODE_2741_length_908_cov_18.077457_g2495_i0 | PRJNA745923 | 2741 | 908 | 18.077457 | 164.14330956 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 785 | 0 | NTclustered | gi|2915029488|gb|OR222647.1| | 2832643 | g2495 | i0 | 82.697 | 30.9151982378855 | 890 | 149 | 97 | 2 | 24 | 908 | 79246 | 80135 | MAG: Caudoviricetes sp. isolate MSP0283 genomic sequence | blastn | 28071 | 785 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2001010 | 2001010 | PRJNA745923_S_NODE_4722_length_520_cov_4.532495_g4399_i0 | PRJNA745923 | 4722 | 520 | 4.532495 | 23.568974 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 628 | 1.8499999999999994e-175 | NTclustered | gi|2915029488|gb|OR222647.1| | 2832643 | g4399 | i0 | 89.655 | 3.79230769230769 | 493 | 51 | 95 | 0 | 1 | 493 | 72238 | 72730 | MAG: Caudoviricetes sp. isolate MSP0283 genomic sequence | blastn | 1972 | 628 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8378314 | 8378314 | PRJNA745923_S_NODE_6407_length_423_cov_2.492105_g6076_i0 | PRJNA745923 | 6407 | 423 | 2.492105 | 10.54160415 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 477 | 5.669999999999998e-130 | NTclustered | gi|2053220447|tpg|BK017336.1| | 2832643 | g6076 | i0 | 87.089 | 9.87234042553191 | 426 | 49 | 100 | 5 | 1 | 423 | 18252 | 18674 | MAG TPA_asm: Caudoviricetes sp. isolate ctjqC1, partial genome | blastn | 4176 | 477 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14753449 | 14753449 | PRJNA745923_S_NODE_14672_length_263_cov_2.881818_g14340_i0 | PRJNA745923 | 14672 | 263 | 2.881818 | 7.57918134 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 481 | 2.58e-131 | NTclustered | gi|2053220447|tpg|BK017336.1| | 2832643 | g14340 | i0 | 99.62 | 38.3498098859316 | 263 | 1 | 100 | 0 | 1 | 263 | 1000 | 1262 | MAG TPA_asm: Caudoviricetes sp. isolate ctjqC1, partial genome | blastn | 10086 | 481 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17302756 | 17302756 | PRJNA745923_S_NODE_2094_length_1190_cov_3.185702_g1885_i0 | PRJNA745923 | 2094 | 1190 | 3.185702 | 37.9098538 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 2069 | 0 | NTclustered | gi|2059647249|tpg|BK028718.1| | 2832643 | g1885 | i0 | 98.712 | 96.4857142857143 | 1165 | 15 | 98 | 0 | 1 | 1165 | 6390 | 5226 | MAG TPA_asm: Caudoviricetes sp. isolate ctQcn1, partial genome | blastn | 114818 | 2069 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17776571 | 17776571 | PRJNA745923_S_NODE_19754_length_221_cov_1.061798_g19422_i0 | PRJNA745923 | 19754 | 221 | 1.061798 | 2.34657358 | root | 1 | Root_unresolved | Root_unresolved | 167 | 6.7e-37 | NTclustered | gi|2054791465|tpg|BK049930.1| | 2832643 | g19422 | i0 | 98.925 | 5.98642533936652 | 93 | 1 | 42 | 0 | 1 | 93 | 12248 | 12156 | MAG TPA_asm: Caudoviricetes sp. isolate ct7mf1, partial genome | blastn | 1323 | 167 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19852025 | 19852025 | PRJNA745923_S_NODE_816_length_2710_cov_27.151106_g706_i0 | PRJNA745923 | 816 | 2710 | 27.151106 | 735.7949726 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1105 | 0 | NTclustered | gi|2915042807|gb|OR222762.1| | 2832643 | g706 | i0 | 87.067 | 17.7394833948339 | 982 | 121 | 36 | 6 | 1709 | 2687 | 47208 | 46230 | MAG: Caudoviricetes sp. isolate MSP0596 genomic sequence | blastn | 48074 | 1105 | 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);;