contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJEB65099" and tax_superkingdom = "Viruses"
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. | |||||
| 3544403 | 3544403 | PRJEB65099_P_NODE_4243_length_272_cov_1.130653_g4138_i0 | PRJEB65099 | 4243 | 272 | 1.130653 | 3.07537616 | root | 1 | Root_unresolved | Root_unresolved | 497 | 2.67e-136 | NTclustered | gi|1956765275|gb|MW161386.1| | 37124 | g4138 | i0 | 99.632 | 100 | 272 | 1 | 100 | 0 | 1 | 272 | 3230 | 2959 | Chikungunya virus strain CHIKV/Sudan154/2018 non-structural polyprotein and structural polyprotein genes, partial cds | blastn | 27200 | 497 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus chikungunya | ||
| 5232479 | 5232479 | PRJEB65099_P_NODE_4745_length_257_cov_1.103261_g4640_i0 | PRJEB65099 | 4745 | 257 | 1.103261 | 2.83538077 | Alphavirus chikungunya | 3426298 | Viruses | Viruses | 475 | 1.1699999999999999e-129 | NTclustered | gi|2669656132|gb|PP236109.1| | 37124 | g4640 | i0 | 100 | 100 | 257 | 0 | 100 | 0 | 1 | 257 | 1171 | 915 | Chikungunya virus strain IMR45-21 non-structural polyprotein and structural polyprotein genes, complete cds | blastn | 25700 | 475 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus chikungunya | ||
| 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. | |||||
| 6097032 | 6097032 | PRJEB65099_P_NODE_1765_length_453_cov_1.013158_g1660_i0 | PRJEB65099 | 1765 | 453 | 1.013158 | 4.58960574 | root | 1 | Root_unresolved | Root_unresolved | 837 | 0 | NTclustered | gi|549823107|gb|KF283987.1| | 37124 | g1660 | i0 | 100 | 100.596026490066 | 453 | 0 | 100 | 0 | 1 | 453 | 7877 | 7425 | Chikungunya virus isolate S7 nonfunctional nonstructural polyprotein gene, partial sequence; and structural polyprotein gene, complete cds | blastn | 45570 | 837 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus chikungunya | ||
| 7782314 | 7782314 | PRJEB65099_P_NODE_4287_length_270_cov_1.578680_g4182_i0 | PRJEB65099 | 4287 | 270 | 1.57868 | 4.262436 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 499 | 7.349999999999998e-137 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g4182 | i0 | 100 | 100 | 270 | 0 | 100 | 0 | 1 | 270 | 14410 | 14679 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 27000 | 499 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 9057204 | 9057204 | PRJEB65099_P_NODE_3568_length_295_cov_1.270270_g3463_i0 | PRJEB65099 | 3568 | 295 | 1.27027 | 3.7472965 | Alphavirus chikungunya | 3426298 | Viruses | Viruses | 401 | 2.3599999999999993e-107 | NTclustered | gi|2577286133|gb|OR283254.1| | 37124 | g3463 | i0 | 97.447 | 98.2135593220339 | 235 | 6 | 90 | 0 | 61 | 295 | 2547 | 2313 | Chikungunya virus isolate THSTI-CHIKV-6, complete genome | blastn | 28973 | 401 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus chikungunya | ||
| 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. | |||||
| 13747291 | 13747291 | PRJEB65099_P_NODE_3471_length_300_cov_1.339207_g3366_i0 | PRJEB65099 | 3471 | 300 | 1.339207 | 4.017621 | root | 1 | Root_unresolved | Root_unresolved | 555 | 1.7399999999999995e-153 | NTclustered | gi|1050242897|gb|KT324224.1| | 37124 | g3366 | i0 | 100 | 100 | 300 | 0 | 100 | 0 | 1 | 300 | 1949 | 1650 | Chikungunya virus isolate MY/08/1230, complete genome | blastn | 30000 | 555 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus chikungunya | ||
| 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. | |||||
| 17571746 | 17571746 | PRJEB65099_P_NODE_2754_length_348_cov_0.825455_g2649_i0 | PRJEB65099 | 2754 | 348 | 0.825455 | 2.8725834 | root | 1 | Root_unresolved | Root_unresolved | 627 | 4.3099999999999996e-175 | NTclustered | gi|334145773|gb|HQ456255.1| | 37124 | g2649 | i0 | 99.138 | 100 | 348 | 3 | 100 | 0 | 1 | 348 | 757 | 410 | Chikungunya virus strain Lamu33, complete genome | blastn | 34800 | 627 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus chikungunya | ||
| 17981482 | 17981482 | PRJEB65099_P_NODE_3955_length_281_cov_1.745192_g3850_i0 | PRJEB65099 | 3955 | 281 | 1.745192 | 4.90398952 | Alphavirus chikungunya | 3426298 | Viruses | Viruses | 497 | 2.77e-136 | NTclustered | gi|1194463477|gb|KY435472.1| | 37124 | g3850 | i0 | 99.275 | 98.3523131672598 | 276 | 0 | 98 | 2 | 4 | 277 | 297 | 22 | Chikungunya virus isolate 14.02560 non-structural polypeptide and structural polypeptide genes, complete cds | blastn | 27637 | 497 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus chikungunya | ||
| 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. | |||||
| 20120433 | 20120433 | PRJEB65099_P_NODE_2896_length_337_cov_1.340909_g2791_i0 | PRJEB65099 | 2896 | 337 | 1.340909 | 4.51886333 | root | 1 | Root_unresolved | Root_unresolved | 617 | 2.4999999999999997e-172 | NTclustered | gi|549823107|gb|KF283987.1| | 37124 | g2791 | i0 | 99.703 | 100 | 337 | 1 | 100 | 0 | 1 | 337 | 5363 | 5027 | Chikungunya virus isolate S7 nonfunctional nonstructural polyprotein gene, partial sequence; and structural polyprotein gene, complete cds | blastn | 33700 | 617 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus chikungunya |
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);;