contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJEB65099" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1404483 | 1404483 | PRJEB65099_P_NODE_4102_length_276_cov_1.536946_g3997_i0 | PRJEB65099 | 4102 | 276 | 1.536946 | 4.24197096 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 455 | 1.66e-123 | NTclustered | gi|2914758139|gb|OR221626.1| | 2832643 | g3997 | i0 | 96.377 | 1 | 276 | 10 | 100 | 0 | 1 | 276 | 26074 | 25799 | MAG: Caudoviricetes sp. isolate MSP1433 genomic sequence | blastn | 276 | 455 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1404496 | 1404496 | PRJEB65099_P_NODE_5922_length_247_cov_0.896552_g5817_i0 | PRJEB65099 | 5922 | 247 | 0.896552 | 2.21448344 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 363 | 9.079999999999999e-96 | NTclustered | gi|2914921323|gb|OR221391.1| | 2832643 | g5817 | i0 | 93.117 | 1 | 247 | 17 | 100 | 0 | 1 | 247 | 21427 | 21181 | MAG: Caudoviricetes sp. isolate MSP1709 genomic sequence | blastn | 247 | 363 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2680048 | 2680048 | PRJEB65099_P_NODE_5063_length_252_cov_1.296089_g4958_i0 | PRJEB65099 | 5063 | 252 | 1.296089 | 3.26614428 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 411 | 3.269999999999999e-110 | NTclustered | gi|2914927861|gb|OR221512.1| | 2832643 | g4958 | i0 | 96.032 | 1 | 252 | 10 | 100 | 0 | 1 | 252 | 240 | 491 | MAG: Caudoviricetes sp. isolate MSP1567 genomic sequence | blastn | 252 | 411 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5232482 | 5232482 | PRJEB65099_P_NODE_5605_length_249_cov_0.886364_g5500_i0 | PRJEB65099 | 5605 | 249 | 0.886364 | 2.20704636 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 230 | 9.699999999999995e-56 | NTclustered | gi|2914758139|gb|OR221626.1| | 2832643 | g5500 | i0 | 83.673 | 0.983935742971888 | 245 | 39 | 98 | 1 | 5 | 248 | 32390 | 32146 | MAG: Caudoviricetes sp. isolate MSP1433 genomic sequence | blastn | 245 | 230 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11608458 | 11608458 | PRJEB65099_P_NODE_4030_length_279_cov_1.097087_g3925_i0 | PRJEB65099 | 4030 | 279 | 1.097087 | 3.06087273 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 477 | 3.5799999999999985e-130 | NTclustered | gi|2053090304|tpg|BK020285.1| | 2832643 | g3925 | i0 | 98.168 | 1.96057347670251 | 273 | 5 | 98 | 0 | 7 | 279 | 11959 | 11687 | MAG TPA_asm: Caudoviricetes sp. isolate ct5s13, partial genome | blastn | 547 | 477 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14158359 | 14158359 | PRJEB65099_P_NODE_5892_length_247_cov_0.896552_g5787_i0 | PRJEB65099 | 5892 | 247 | 0.896552 | 2.21448344 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 457 | 4.05e-124 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g5787 | i0 | 100 | 36.6599190283401 | 247 | 0 | 100 | 0 | 1 | 247 | 12073 | 12319 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 9055 | 457 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14158362 | 14158362 | PRJEB65099_P_NODE_6112_length_246_cov_0.901734_g6007_i0 | PRJEB65099 | 6112 | 246 | 0.901734 | 2.21826564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 416 | 6.839999999999999e-112 | NTclustered | gi|2914758139|gb|OR221626.1| | 2832643 | g6007 | i0 | 97.154 | 2.15447154471545 | 246 | 7 | 100 | 0 | 1 | 246 | 15938 | 16183 | MAG: Caudoviricetes sp. isolate MSP1433 genomic sequence | blastn | 530 | 416 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14158366 | 14158366 | PRJEB65099_P_NODE_6432_length_244_cov_0.912281_g6327_i0 | PRJEB65099 | 6432 | 244 | 0.912281 | 2.22596564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 440 | 4.019999999999999e-119 | NTclustered | gi|2914913986|gb|OR221245.1| | 2832643 | g6327 | i0 | 99.18 | 10 | 244 | 2 | 100 | 0 | 1 | 244 | 31581 | 31824 | MAG: Caudoviricetes sp. isolate MSP1869 genomic sequence | blastn | 2440 | 440 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16706628 | 16706628 | PRJEB65099_P_NODE_5954_length_247_cov_0.896552_g5849_i0 | PRJEB65099 | 5954 | 247 | 0.896552 | 2.21448344 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 424 | 4.1099999999999996e-114 | NTclustered | gi|2057820972|tpg|BK055362.1| | 2832643 | g5849 | i0 | 97.571 | 3 | 247 | 6 | 100 | 0 | 1 | 247 | 37016 | 36770 | MAG TPA_asm: Caudoviricetes sp. isolate ct46z2, partial genome | blastn | 741 | 424 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17981503 | 17981503 | PRJEB65099_P_NODE_6215_length_246_cov_0.878613_g6110_i0 | PRJEB65099 | 6215 | 246 | 0.878613 | 2.16138798 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 411 | 3.1799999999999995e-110 | NTclustered | gi|2914950637|gb|OR221902.1| | 2832643 | g6110 | i0 | 96.748 | 1 | 246 | 8 | 100 | 0 | 1 | 246 | 19829 | 20074 | MAG: Caudoviricetes sp. isolate MSP1107 genomic sequence | blastn | 246 | 411 | 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);;