contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1113956" and tax_kingdom = "Heunggongvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5324940 | 5324940 | PRJNA1113956_P_NODE_22865_length_241_cov_0.916667_g22525_i0 | PRJNA1113956 | 22865 | 241 | 0.916667 | 2.20916747 | Enterobacter phage vB_EluP_RZH | 3249627 | Viruses | Viruses | 440 | 3.959999999999999e-119 | NTclustered | gi|2795099075|gb|PQ140450.1| | 3249627 | g22525 | i0 | 99.585 | 8 | 241 | 1 | 100 | 0 | 1 | 241 | 25616 | 25376 | Enterobacter phage vB_EluP_RZH, complete genome | blastn | 1928 | 440 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Karamvirus | Enterobacter phage vB_EluP_RZH | ||
| 6126809 | 6126809 | PRJNA1113956_P_NODE_22345_length_242_cov_1.366864_g22005_i0 | PRJNA1113956 | 22345 | 242 | 1.366864 | 3.30781088 | Christensenvirus | 2732061 | Viruses | Viruses | 448 | 2.3799999999999995e-121 | NTclustered | gi|2312628476|gb|OP251154.1| | 2978981 | g22005 | i0 | 100 | 6.17768595041322 | 242 | 0 | 100 | 0 | 1 | 242 | 626 | 867 | Escherichia phage TR2, complete genome | blastn | 1495 | 448 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Escherichia phage TR2 | |||
| 9952053 | 9952053 | PRJNA1113956_P_NODE_19788_length_251_cov_0.865169_g19448_i0 | PRJNA1113956 | 19788 | 251 | 0.865169 | 2.17157419 | Christensenvirus | 2732061 | Viruses | Viruses | 464 | 2.47e-126 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g19448 | i0 | 100 | 21.4860557768924 | 251 | 0 | 100 | 0 | 1 | 251 | 40651 | 40401 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 5393 | 464 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 11227059 | 11227059 | PRJNA1113956_P_NODE_10609_length_421_cov_1.347701_g10270_i0 | PRJNA1113956 | 10609 | 421 | 1.347701 | 5.67382121 | Tequatrovirus | 10663 | Viruses | Viruses | 778 | 0 | NTclustered | gi|2721715921|emb|OZ035787.1| | 10665 | g10270 | i0 | 100 | 99.9714964370546 | 421 | 0 | 100 | 0 | 1 | 421 | 38672 | 38252 | Tequatrovirus T4 genome assembly, chromosome: 1 | blastn | 42088 | 778 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Tequatrovirus | Tequatrovirus T4 | ||
| 11227178 | 11227178 | PRJNA1113956_P_NODE_18669_length_264_cov_1.083770_g18329_i0 | PRJNA1113956 | 18669 | 264 | 1.08377 | 2.8611528 | Christensenvirus | 2732061 | Viruses | Viruses | 477 | 3.359999999999999e-130 | NTclustered | gi|2312628476|gb|OP251154.1| | 2978981 | g18329 | i0 | 99.242 | 6.15909090909091 | 264 | 2 | 100 | 0 | 1 | 264 | 24506 | 24769 | Escherichia phage TR2, complete genome | blastn | 1626 | 477 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Escherichia phage TR2 | |||
| 17601517 | 17601517 | PRJNA1113956_P_NODE_16154_length_299_cov_1.022124_g15814_i0 | PRJNA1113956 | 16154 | 299 | 1.022124 | 3.05615076 | Tequatrovirus | 10663 | Viruses | Viruses | 553 | 6.25e-153 | NTclustered | gi|2721715921|emb|OZ035787.1| | 10665 | g15814 | i0 | 100 | 99.9364548494983 | 299 | 0 | 100 | 0 | 1 | 299 | 38198 | 37900 | Tequatrovirus T4 genome assembly, chromosome: 1 | blastn | 29881 | 553 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Tequatrovirus | Tequatrovirus T4 | ||
| 20150179 | 20150179 | PRJNA1113956_P_NODE_12836_length_358_cov_1.350877_g12496_i0 | PRJNA1113956 | 12836 | 358 | 1.350877 | 4.83613966 | Christensenvirus | 2732061 | Viruses | Viruses | 662 | 0 | NTclustered | gi|2287965697|gb|OP087522.1| | 2972435 | g12496 | i0 | 100 | 54.8966480446927 | 358 | 0 | 100 | 0 | 1 | 358 | 12790 | 12433 | Escherichia phage TR1, complete genome | blastn | 19653 | 662 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Escherichia phage TR1 | |||
| 21425787 | 21425787 | PRJNA1113956_P_NODE_13117_length_352_cov_1.376344_g12777_i0 | PRJNA1113956 | 13117 | 352 | 1.376344 | 4.84473088 | Christensenvirus | 2732061 | Viruses | Viruses | 651 | 0 | NTclustered | gi|2312628476|gb|OP251154.1| | 2978981 | g12777 | i0 | 100 | 6.99715909090909 | 352 | 0 | 100 | 0 | 1 | 352 | 4289 | 3938 | Escherichia phage TR2, complete genome | blastn | 2463 | 651 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Escherichia phage TR2 | |||
| 23174192 | 23174192 | PRJNA1113956_P_NODE_12679_length_362_cov_1.598616_g12339_i0 | PRJNA1113956 | 12679 | 362 | 1.598616 | 5.78698992 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 244 | 5.28e-60 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g12339 | i0 | 79.603 | 0.975138121546961 | 353 | 62 | 97 | 7 | 12 | 362 | 29237 | 29581 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 353 | 244 | 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);;