contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA1016321" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1434766 | 1434766 | PRJNA1016321_P_NODE_53942_length_244_cov_0.900585_g53711_i0 | PRJNA1016321 | 53942 | 244 | 0.900585 | 2.1974274 | Bacteriophage sp. | 38018 | Viruses | Viruses | 418 | 1.8799999999999994e-112 | NTclustered | gi|1977365072|gb|MW462191.1| | 38018 | g53711 | i0 | 97.541 | 2.65163934426229 | 244 | 6 | 100 | 0 | 1 | 244 | 58993 | 59236 | Bacteriophage sp. isolate contig405706 genomic sequence | blastn | 647 | 418 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 2277846 | 2277846 | PRJNA1016321_P_NODE_102_length_3038_cov_8.709612_g90_i0 | PRJNA1016321 | 102 | 3038 | 8.709612 | 264.59801256 | Respirovirus | 186938 | Viruses | Viruses | 5566 | 0 | NTclustered | gi|60898|emb|X03614.1| | 12730 | g90 | i0 | 99.737 | 45.7314022383147 | 3039 | 6 | 100 | 2 | 1 | 3038 | 3315 | 278 | Sendai virus (strain Z) genome RNA 5'end | blastn | 138932 | 5566 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus laryngotracheitidis | ||
| 2709487 | 2709487 | PRJNA1016321_P_NODE_11343_length_594_cov_4.606526_g11120_i0 | PRJNA1016321 | 11343 | 594 | 4.606526 | 27.36276444 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 701 | 0 | NTclustered | gi|2396039586|gb|ON812872.1| | 2808997 | g11120 | i0 | 89.317 | 1.91919191919192 | 571 | 44 | 95 | 13 | 1 | 562 | 563 | 1 | MAG: Botourmiaviridae sp. isolate TIGMIC_4, complete genome | blastn | 1140 | 701 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 2709656 | 2709656 | PRJNA1016321_P_NODE_20283_length_423_cov_29.865714_g20052_i0 | PRJNA1016321 | 20283 | 423 | 29.865714 | 126.33197022 | Penoulivirus aspergilli | 3431565 | Viruses | Viruses | 102 | 3.99e-17 | NTclustered | gi|2500378724|ref|NC_076348.1| | 2501288 | g20052 | i0 | 78.659 | 0.387706855791962 | 164 | 28 | 38 | 5 | 176 | 337 | 209 | 51 | Aspergillus neoniger ourmia-like virus 1 strain AnOlv1CBS 115656, complete genome | blastn | 164 | 102 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Penoulivirus | Penoulivirus aspergilli | ||
| 2710090 | 2710090 | PRJNA1016321_P_NODE_42103_length_271_cov_2.141414_g41872_i0 | PRJNA1016321 | 42103 | 271 | 2.141414 | 5.80323194 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 429 | 9.83e-116 | NTclustered | gi|2053209494|tpg|BK017127.1| | 2832643 | g41872 | i0 | 97.984 | 4.12177121771218 | 248 | 4 | 92 | 1 | 24 | 271 | 11611 | 11857 | MAG TPA_asm: Caudoviricetes sp. isolate ctfoB3, partial genome | blastn | 1117 | 429 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5262371 | 5262371 | PRJNA1016321_P_NODE_30165_length_331_cov_1.689922_g29934_i0 | PRJNA1016321 | 30165 | 331 | 1.689922 | 5.59364182 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 309 | 1.68e-79 | NTclustered | gi|2914783463|gb|OR222447.1| | 2832643 | g29934 | i0 | 91.228 | 0.688821752265861 | 228 | 18 | 69 | 2 | 89 | 315 | 50991 | 51217 | MAG: Caudoviricetes sp. isolate MSP0948 genomic sequence | blastn | 228 | 309 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5262402 | 5262402 | PRJNA1016321_P_NODE_32245_length_318_cov_1.551020_g32014_i0 | PRJNA1016321 | 32245 | 318 | 1.55102 | 4.9322436 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 313 | 1.24e-80 | NTclustered | gi|2914783463|gb|OR222447.1| | 2832643 | g32014 | i0 | 84.591 | 1 | 318 | 46 | 100 | 1 | 1 | 318 | 36409 | 36095 | MAG: Caudoviricetes sp. isolate MSP0948 genomic sequence | blastn | 318 | 313 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7812307 | 7812307 | PRJNA1016321_P_NODE_42287_length_271_cov_1.131313_g42056_i0 | PRJNA1016321 | 42287 | 271 | 1.131313 | 3.06585823 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 207 | 5.01e-49 | NTclustered | gi|2914783463|gb|OR222447.1| | 2832643 | g42056 | i0 | 80.755 | 2.4169741697417 | 265 | 51 | 98 | 0 | 7 | 271 | 38464 | 38200 | MAG: Caudoviricetes sp. isolate MSP0948 genomic sequence | blastn | 655 | 207 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9087654 | 9087654 | PRJNA1016321_P_NODE_8_length_6986_cov_38.244756_g6_i0 | PRJNA1016321 | 8 | 6986 | 38.244756 | 2671.77865416 | Respirovirus muris | 3052731 | Viruses | Viruses | 8661 | 0 | NTclustered | gi|546225824|dbj|AB855655.1| | 3052731 | g6 | i0 | 99.725 | 50.150014314343 | 4730 | 12 | 99 | 1 | 2207 | 6936 | 4842 | 114 | Respirovirus muris genomic RNA, complete genome, strain: Z | blastn | 350348 | 8661 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus muris | ||
| 10362364 | 10362364 | PRJNA1016321_P_NODE_12889_length_552_cov_2.319415_g12666_i0 | PRJNA1016321 | 12889 | 552 | 2.319415 | 12.8031708 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 346 | 2.23e-90 | NTclustered | gi|1436214368|gb|MH617486.1| | 2832643 | g12666 | i0 | 78.707 | 1.90036231884058 | 526 | 106 | 95 | 5 | 28 | 551 | 31551 | 31030 | MAG: Caudoviricetes sp. isolate ctce_1, complete genome | blastn | 1049 | 346 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10362452 | 10362452 | PRJNA1016321_P_NODE_17309_length_466_cov_1.997455_g17079_i0 | PRJNA1016321 | 17309 | 466 | 1.997455 | 9.3081403 | Respirovirus muris | 3052731 | Viruses | Viruses | 850 | 0 | NTclustered | gi|546225824|dbj|AB855655.1| | 3052731 | g17079 | i0 | 99.571 | 40.8669527896996 | 466 | 2 | 100 | 0 | 1 | 466 | 10375 | 9910 | Respirovirus muris genomic RNA, complete genome, strain: Z | blastn | 19044 | 850 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus muris | ||
| 10362509 | 10362509 | PRJNA1016321_P_NODE_20809_length_416_cov_3.069971_g20578_i0 | PRJNA1016321 | 20809 | 416 | 3.069971 | 12.77107936 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 438 | 2.629999999999999e-118 | NTclustered | gi|1990397921|gb|MW347459.1| | 2832643 | g20578 | i0 | 86.098 | 0.985576923076923 | 410 | 53 | 98 | 4 | 9 | 416 | 237 | 644 | MAG: Caudoviricetes sp. isolate 3nj-TERL-60 terminase large subunit gene, partial cds | blastn | 410 | 438 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11638597 | 11638597 | PRJNA1016321_P_NODE_56130_length_241_cov_0.916667_g55899_i0 | PRJNA1016321 | 56130 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 418 | 1.8599999999999995e-112 | NTclustered | gi|2914760312|gb|OR221747.1| | 2832643 | g55899 | i0 | 97.925 | 4.78423236514523 | 241 | 5 | 100 | 0 | 1 | 241 | 7332 | 7572 | MAG: Caudoviricetes sp. isolate MSP1289 genomic sequence | blastn | 1153 | 418 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12912878 | 12912878 | PRJNA1016321_P_NODE_17051_length_470_cov_2.801008_g16821_i0 | PRJNA1016321 | 17051 | 470 | 2.801008 | 13.1647376 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 830 | 0 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g16821 | i0 | 98.511 | 412.234042553192 | 470 | 7 | 100 | 0 | 1 | 470 | 17951 | 18420 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 193750 | 830 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16305227 | 16305227 | PRJNA1016321_P_NODE_54613_length_243_cov_0.905882_g54382_i0 | PRJNA1016321 | 54613 | 243 | 0.905882 | 2.20129326 | root | 1 | Root_unresolved | Root_unresolved | 449 | 6.65e-122 | NTclustered | gi|1447724975|gb|MH341447.1| | 10245 | g54382 | i0 | 100 | 100.868312757202 | 243 | 0 | 100 | 0 | 1 | 243 | 141554 | 141796 | Vaccinia virus strain L-IVP_oncoQ | blastn | 24511 | 449 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus vaccinia | ||
| 16736147 | 16736147 | PRJNA1016321_P_NODE_14494_length_517_cov_1.029279_g14266_i0 | PRJNA1016321 | 14494 | 517 | 1.029279 | 5.32137243 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 399 | 1.5699999999999997e-106 | NTclustered | gi|2914783463|gb|OR222447.1| | 2832643 | g14266 | i0 | 82.378 | 0.911025145067698 | 471 | 71 | 90 | 10 | 45 | 509 | 42907 | 43371 | MAG: Caudoviricetes sp. isolate MSP0948 genomic sequence | blastn | 471 | 399 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16736437 | 16736437 | PRJNA1016321_P_NODE_30994_length_326_cov_1.217391_g30763_i0 | PRJNA1016321 | 30994 | 326 | 1.217391 | 3.96869466 | Betaretrovirus murmamtum | 3427295 | Viruses | Viruses | 575 | 1.4699999999999996e-159 | NTclustered | gi|6911279|gb|AF228551.1|AF228551 | 46608 | g30763 | i0 | 98.466 | 26.6503067484663 | 326 | 5 | 100 | 0 | 1 | 326 | 1771 | 1446 | Exogenous mouse mammary tumor virus HeJ complete proviral genome | blastn | 8688 | 575 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus murmamtum | ||
| 18011800 | 18011800 | PRJNA1016321_P_NODE_55935_length_241_cov_1.339286_g55704_i0 | PRJNA1016321 | 55935 | 241 | 1.339286 | 3.22767926 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 169 | 2.0599999999999997e-37 | NTclustered | gi|2914783463|gb|OR222447.1| | 2832643 | g55704 | i0 | 82.653 | 0.813278008298755 | 196 | 28 | 80 | 5 | 1 | 193 | 40881 | 40689 | MAG: Caudoviricetes sp. isolate MSP0948 genomic sequence | blastn | 196 | 169 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20561179 | 20561179 | PRJNA1016321_P_NODE_56717_length_238_cov_2.490909_g56486_i0 | PRJNA1016321 | 56717 | 238 | 2.490909 | 5.92836342 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 385 | 1.86e-102 | NTclustered | gi|2057899373|tpg|BK051134.1| | 2832643 | g56486 | i0 | 95.798 | 36.3445378151261 | 238 | 10 | 100 | 0 | 1 | 238 | 7552 | 7789 | MAG TPA_asm: Caudoviricetes sp. isolate ctS2e9, partial genome | blastn | 8650 | 385 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22679521 | 22679521 | PRJNA1016321_P_NODE_23438_length_386_cov_2.920128_g23207_i0 | PRJNA1016321 | 23438 | 386 | 2.920128 | 11.27169408 | Respirovirus | 186938 | Viruses | Viruses | 713 | 0 | NTclustered | gi|60898|emb|X03614.1| | 12730 | g23207 | i0 | 100 | 37.7512953367876 | 386 | 0 | 100 | 0 | 1 | 386 | 6177 | 5792 | Sendai virus (strain Z) genome RNA 5'end | blastn | 14572 | 713 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus laryngotracheitidis | ||
| 23955056 | 23955056 | PRJNA1016321_P_NODE_34919_length_303_cov_4.765217_g34688_i0 | PRJNA1016321 | 34919 | 303 | 4.765217 | 14.43860751 | Respirovirus | 186938 | Viruses | Viruses | 560 | 3.79e-155 | NTclustered | gi|60898|emb|X03614.1| | 12730 | g34688 | i0 | 100 | 35.2376237623762 | 303 | 0 | 100 | 0 | 1 | 303 | 17 | 319 | Sendai virus (strain Z) genome RNA 5'end | blastn | 10677 | 560 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus laryngotracheitidis | ||
| 24385771 | 24385771 | PRJNA1016321_P_NODE_4000_length_1014_cov_3.747078_g3840_i0 | PRJNA1016321 | 4000 | 1014 | 3.747078 | 37.99537092 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1821 | 0 | NTclustered | gi|2915047850|gb|OR222814.1| | 2832643 | g3840 | i0 | 99.698 | 1.73175542406312 | 995 | 3 | 98 | 0 | 20 | 1014 | 57973 | 56979 | MAG: Caudoviricetes sp. isolate MSP0542 genomic sequence | blastn | 1756 | 1821 | 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);;