contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA861969" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1236476 | 1236476 | PRJNA861969_P_NODE_32021_length_250_cov_0.870056_g31790_i0 | PRJNA861969 | 32021 | 250 | 0.870056 | 2.17514 | Pahexavirus | 1982251 | Viruses | Viruses | 407 | 4.1899999999999994e-109 | NTclustered | gi|849254167|ref|NC_027362.1| | 1500816 | g31790 | i0 | 96 | 98.672 | 250 | 10 | 100 | 0 | 1 | 250 | 11806 | 12055 | Propionibacterium phage PHL116M00, complete genome | blastn | 24668 | 407 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PHL116M00 | ||||
| 2511918 | 2511918 | PRJNA861969_P_NODE_23282_length_283_cov_1.466667_g23051_i0 | PRJNA861969 | 23282 | 283 | 1.466667 | 4.15066761 | Tequatrovirus | 10663 | Viruses | Viruses | 488 | 1.6799999999999995e-133 | NTclustered | gi|2721715921|emb|OZ035787.1| | 10665 | g23051 | i0 | 100 | 93.2862190812721 | 264 | 0 | 93 | 0 | 20 | 283 | 38777 | 38514 | Tequatrovirus T4 genome assembly, chromosome: 1 | blastn | 26400 | 488 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Tequatrovirus | Tequatrovirus T4 | ||
| 4674708 | 4674708 | PRJNA861969_P_NODE_21484_length_292_cov_1.716895_g21253_i0 | PRJNA861969 | 21484 | 292 | 1.716895 | 5.0133334 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 529 | 1.0299999999999996e-145 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g21253 | i0 | 99.315 | 1 | 292 | 2 | 100 | 0 | 1 | 292 | 38376 | 38085 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 292 | 529 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4674854 | 4674854 | PRJNA861969_P_NODE_29764_length_254_cov_1.701657_g29533_i0 | PRJNA861969 | 29764 | 254 | 1.701657 | 4.32220878 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 470 | 5.37e-128 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g29533 | i0 | 100 | 1 | 254 | 0 | 100 | 0 | 1 | 254 | 36850 | 36597 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 254 | 470 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7224587 | 7224587 | PRJNA861969_P_NODE_30626_length_251_cov_0.865169_g30395_i0 | PRJNA861969 | 30626 | 251 | 0.865169 | 2.17157419 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 392 | 1.18e-104 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g30395 | i0 | 94.821 | 3.98804780876494 | 251 | 13 | 100 | 0 | 1 | 251 | 36487 | 36737 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 1001 | 392 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8499482 | 8499482 | PRJNA861969_P_NODE_38227_length_244_cov_0.900585_g37996_i0 | PRJNA861969 | 38227 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 364 | 2.489999999999999e-96 | NTclustered | gi|2058127279|tpg|BK034035.1| | 2832643 | g37996 | i0 | 93.802 | 10.7131147540984 | 242 | 15 | 99 | 0 | 1 | 242 | 29005 | 29246 | MAG TPA_asm: Caudoviricetes sp. isolate cta2t15, partial genome | blastn | 2614 | 364 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8889506 | 8889506 | PRJNA861969_P_NODE_41687_length_241_cov_0.916667_g41456_i0 | PRJNA861969 | 41687 | 241 | 0.916667 | 2.20916747 | Christensenvirus | 2732061 | Viruses | Viruses | 446 | 8.519999999999999e-121 | NTclustered | gi|2449455461|gb|OQ357823.1| | 3069117 | g41456 | i0 | 100 | 11.1078838174274 | 241 | 0 | 100 | 0 | 1 | 241 | 31297 | 31537 | Escherichia phage CY1_Cui-2023, complete genome | blastn | 2677 | 446 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Escherichia phage CY1_Cui-2023 | |||
| 12325300 | 12325300 | PRJNA861969_P_NODE_14630_length_345_cov_2.242647_g14399_i0 | PRJNA861969 | 14630 | 345 | 2.242647 | 7.73713215 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 484 | 2.7199999999999994e-132 | NTclustered | gi|2914751195|gb|OR221308.1| | 2832643 | g14399 | i0 | 92.836 | 19.1101449275362 | 335 | 22 | 97 | 2 | 13 | 345 | 38524 | 38190 | MAG: Caudoviricetes sp. isolate MSP1799 genomic sequence | blastn | 6593 | 484 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17424595 | 17424595 | PRJNA861969_P_NODE_32594_length_249_cov_1.613636_g32363_i0 | PRJNA861969 | 32594 | 249 | 1.613636 | 4.01795364 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 455 | 1.47e-123 | NTclustered | gi|2054739831|tpg|BK038916.1| | 2832643 | g32363 | i0 | 99.598 | 99.995983935743 | 249 | 1 | 100 | 0 | 1 | 249 | 26885 | 27133 | MAG TPA_asm: Caudoviricetes sp. isolate ctqEr2, partial genome | blastn | 24899 | 455 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17424811 | 17424811 | PRJNA861969_P_NODE_42074_length_241_cov_0.916667_g41843_i0 | PRJNA861969 | 42074 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 346 | 8.89e-91 | NTclustered | gi|2915034497|gb|OR222681.1| | 2832643 | g41843 | i0 | 92.857 | 93.1203319502075 | 238 | 17 | 99 | 0 | 4 | 241 | 967 | 730 | MAG: Caudoviricetes sp. isolate MSP0250 genomic sequence | blastn | 22442 | 346 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17813881 | 17813881 | PRJNA861969_P_NODE_21774_length_290_cov_1.566820_g21543_i0 | PRJNA861969 | 21774 | 290 | 1.56682 | 4.543778 | Marchewkavirus | 3425052 | Viruses | Viruses | 307 | 5.1900000000000005e-79 | NTclustered | gi|2264474154|gb|ON529853.1| | 2948597 | g21543 | i0 | 86.477 | 4.88965517241379 | 281 | 36 | 97 | 2 | 5 | 284 | 196301 | 196022 | Brevundimonas phage vB_BpoS-Bambus, complete genome | blastn | 1418 | 307 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Brevundimonas phage vB_BpoS-Bambus | |||||
| 18697819 | 18697819 | PRJNA861969_P_NODE_33335_length_249_cov_0.875000_g33104_i0 | PRJNA861969 | 33335 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 460 | 3.16e-125 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g33104 | i0 | 100 | 1 | 249 | 0 | 100 | 0 | 1 | 249 | 39199 | 38951 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 249 | 460 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19088019 | 19088019 | PRJNA861969_P_NODE_38795_length_244_cov_0.900585_g38564_i0 | PRJNA861969 | 38795 | 244 | 0.900585 | 2.1974274 | Rogerhendrixvirus | 2733204 | Viruses | Viruses | 134 | 7.640000000000001e-27 | NTclustered | gi|1786624219|gb|MN703407.1| | 2686087 | g38564 | i0 | 78.947 | 1.71311475409836 | 209 | 34 | 84 | 8 | 28 | 231 | 63206 | 63003 | Microbacterium phage Leaf, complete genome | blastn | 418 | 134 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rogerhendrixvirus | Microbacterium phage Leaf | ||||
| 21248427 | 21248427 | PRJNA861969_P_NODE_24437_length_278_cov_1.502439_g24206_i0 | PRJNA861969 | 24437 | 278 | 1.502439 | 4.17678042 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 122 | 1.92e-23 | NTclustered | gi|2053014676|tpg|BK023756.1| | 2832643 | g24206 | i0 | 96 | 0.26978417266187 | 75 | 3 | 27 | 0 | 1 | 75 | 81684 | 81610 | MAG TPA_asm: Caudoviricetes sp. isolate ctCFb4, partial genome | blastn | 75 | 122 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21248679 | 21248679 | PRJNA861969_P_NODE_36817_length_245_cov_1.726744_g36586_i0 | PRJNA861969 | 36817 | 245 | 1.726744 | 4.2305228 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 453 | 5.1900000000000006e-123 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g36586 | i0 | 100 | 1 | 245 | 0 | 100 | 0 | 1 | 245 | 32510 | 32266 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 245 | 453 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21248718 | 21248718 | PRJNA861969_P_NODE_38717_length_244_cov_0.900585_g38486_i0 | PRJNA861969 | 38717 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 401 | 1.8999999999999998e-107 | NTclustered | gi|2057009609|tpg|BK048657.1| | 2832643 | g38486 | i0 | 96.311 | 3.92622950819672 | 244 | 9 | 100 | 0 | 1 | 244 | 4927 | 5170 | MAG TPA_asm: Caudoviricetes sp. isolate ct98G4, partial genome | blastn | 958 | 401 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22523237 | 22523237 | PRJNA861969_P_NODE_35398_length_247_cov_0.885057_g35167_i0 | PRJNA861969 | 35398 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 440 | 4.079999999999999e-119 | NTclustered | gi|2914915832|gb|OR221277.1| | 2832643 | g35167 | i0 | 98.785 | 1 | 247 | 3 | 100 | 0 | 1 | 247 | 13931 | 13685 | MAG: Caudoviricetes sp. isolate MSP1839 genomic sequence | blastn | 247 | 440 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23798791 | 23798791 | PRJNA861969_P_NODE_38519_length_244_cov_0.900585_g38288_i0 | PRJNA861969 | 38519 | 244 | 0.900585 | 2.1974274 | Propionibacterium phage PA1-14 | 1747271 | Viruses | Viruses | 401 | 1.8999999999999998e-107 | NTclustered | gi|945393407|gb|KT934381.1| | 1747271 | g38288 | i0 | 96.311 | 99.7459016393443 | 244 | 9 | 100 | 0 | 1 | 244 | 5899 | 5656 | Propionibacterium phage PA1-14, complete genome | blastn | 24338 | 401 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage PA1-14 | ||||
| 25072382 | 25072382 | PRJNA861969_P_NODE_21600_length_291_cov_1.963303_g21369_i0 | PRJNA861969 | 21600 | 291 | 1.963303 | 5.71321173 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 538 | 1.6999999999999994e-148 | NTclustered | gi|2915029488|gb|OR222647.1| | 2832643 | g21369 | i0 | 100 | 31.1546391752577 | 291 | 0 | 100 | 0 | 1 | 291 | 9360 | 9070 | MAG: Caudoviricetes sp. isolate MSP0283 genomic sequence | blastn | 9066 | 538 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 25072463 | 25072463 | PRJNA861969_P_NODE_26760_length_267_cov_1.587629_g26529_i0 | PRJNA861969 | 26760 | 267 | 1.587629 | 4.23896943 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 483 | 7.31e-132 | NTclustered | gi|2056899848|tpg|BK053894.1| | 2832643 | g26529 | i0 | 99.251 | 22.2322097378277 | 267 | 2 | 100 | 0 | 1 | 267 | 3428 | 3162 | MAG TPA_asm: Caudoviricetes sp. isolate ctyQv1, partial genome | blastn | 5936 | 483 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 25463088 | 25463088 | PRJNA861969_P_NODE_24000_length_280_cov_1.357488_g23769_i0 | PRJNA861969 | 24000 | 280 | 1.357488 | 3.8009664 | Christensenvirus | 2732061 | Viruses | Viruses | 507 | 4.58e-139 | NTclustered | gi|2287965697|gb|OP087522.1| | 2972435 | g23769 | i0 | 99.286 | 7.95714285714286 | 280 | 2 | 100 | 0 | 1 | 280 | 12648 | 12927 | Escherichia phage TR1, complete genome | blastn | 2228 | 512 | 0.990234375 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Escherichia phage TR1 |
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);;