contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJEB56027" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2672327 | 2672327 | PRJEB56027_P_NODE_111903_length_253_cov_1.711111_g109094_i0 | PRJEB56027 | 111903 | 253 | 1.711111 | 4.32911083 | Lactococcus phage C41431 | 1868861 | Viruses | Viruses | 468 | 1.92e-127 | NTclustered | gi|1043845555|gb|KX160219.1| | 1868861 | g109094 | i0 | 100 | 42.9446640316206 | 253 | 0 | 100 | 0 | 1 | 253 | 15328 | 15580 | Lactococcus phage C41431, complete genome | blastn | 10865 | 468 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lactococcus phage C41431 | |||||
| 3948291 | 3948291 | PRJEB56027_P_NODE_111284_length_254_cov_1.513812_g108475_i0 | PRJEB56027 | 111284 | 254 | 1.513812 | 3.84508248 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 464 | 2.4999999999999994e-126 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g108475 | i0 | 99.606 | 1 | 254 | 1 | 100 | 0 | 1 | 254 | 1348 | 1601 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 254 | 464 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7774694 | 7774694 | PRJEB56027_P_NODE_111907_length_253_cov_1.711111_g109098_i0 | PRJEB56027 | 111907 | 253 | 1.711111 | 4.32911083 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 363 | 9.339999999999996e-96 | NTclustered | gi|2914915209|gb|OR221265.1| | 2832643 | g109098 | i0 | 92.52 | 1.00395256916996 | 254 | 17 | 100 | 2 | 1 | 253 | 11786 | 12038 | MAG: Caudoviricetes sp. isolate MSP1851 genomic sequence | blastn | 254 | 363 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7774782 | 7774782 | PRJEB56027_P_NODE_115307_length_250_cov_1.949153_g112498_i0 | PRJEB56027 | 115307 | 250 | 1.949153 | 4.8728825 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 385 | 1.97e-102 | NTclustered | gi|2058042518|tpg|BK042373.1| | 2832643 | g112498 | i0 | 94.4 | 98.604 | 250 | 14 | 100 | 0 | 1 | 250 | 15189 | 14940 | MAG TPA_asm: Caudoviricetes sp. isolate ct9fW3, partial genome | blastn | 24651 | 385 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10325258 | 10325258 | PRJEB56027_P_NODE_110549_length_255_cov_1.362637_g107740_i0 | PRJEB56027 | 110549 | 255 | 1.362637 | 3.47472435 | Inoviridae sp. | 2219103 | Viruses | Viruses | 455 | 1.51e-123 | NTclustered | gi|2057891989|tpg|BK051014.1| | 2219103 | g107740 | i0 | 98.824 | 1 | 255 | 3 | 100 | 0 | 1 | 255 | 3742 | 3996 | MAG TPA_asm: Inoviridae sp. isolate ctfkp1, partial genome | blastn | 255 | 455 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 10325332 | 10325332 | PRJEB56027_P_NODE_113009_length_252_cov_1.374302_g110200_i0 | PRJEB56027 | 113009 | 252 | 1.374302 | 3.46324104 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 350 | 7.24e-92 | NTclustered | gi|2058122705|tpg|BK033955.1| | 2832643 | g110200 | i0 | 91.667 | 4.71031746031746 | 252 | 21 | 100 | 0 | 1 | 252 | 28762 | 29013 | MAG TPA_asm: Caudoviricetes sp. isolate ctRu133, partial genome | blastn | 1187 | 350 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10325409 | 10325409 | PRJEB56027_P_NODE_115949_length_250_cov_0.988701_g113140_i0 | PRJEB56027 | 115949 | 250 | 0.988701 | 2.4717525 | Percavirus equidgamma2 | 3050281 | Viruses | Viruses | 440 | 4.1399999999999976e-119 | NTclustered | gi|2271301500|gb|MW322569.1| | 12657 | g113140 | i0 | 98.4 | 28 | 250 | 4 | 100 | 0 | 1 | 250 | 104231 | 103982 | Equid gammaherpesvirus 2 strain 1-141/67, complete genome | blastn | 7000 | 440 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Percavirus | Percavirus equidgamma2 | ||
| 12876057 | 12876057 | PRJEB56027_P_NODE_120491_length_248_cov_0.880000_g117682_i0 | PRJEB56027 | 120491 | 248 | 0.88 | 2.1824 | Adintovirus homo13306 | 3115911 | Viruses | Viruses | 364 | 2.539999999999999e-96 | NTclustered | gi|2710391106|tpg|BK066467.1| | 3115911 | g117682 | i0 | 93.173 | 1.00403225806452 | 249 | 16 | 100 | 1 | 1 | 248 | 507 | 755 | MAG TPA_asm: Adintovirus homo13306 isolate Adinto13306 genomic sequence | blastn | 249 | 364 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus homo13306 | |||
| 15425293 | 15425293 | PRJEB56027_P_NODE_135713_length_234_cov_2.074534_g132904_i0 | PRJEB56027 | 135713 | 234 | 2.074534 | 4.85440956 | Pandoravirus aubagnensis | 2848915 | Viruses | Viruses | 52.8 | 0.021 | NTclustered | gi|2203411877|gb|MZ420563.1| | 2848915 | g132904 | i0 | 96.774 | 0.132478632478632 | 31 | 1 | 13 | 0 | 11 | 41 | 1160412 | 1160442 | Pandoravirus aubagnensis, partial genome | blastn | 31 | 52.8 | 1 | Viruses | Pandoravirus | Pandoravirus aubagnensis | |||||||
| 15426686 | 15426686 | PRJEB56027_P_NODE_88273_length_285_cov_1.495283_g85464_i0 | PRJEB56027 | 88273 | 285 | 1.495283 | 4.26155655 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 516 | 7.77e-142 | NTclustered | gi|2914808225|gb|OR221671.1| | 2832643 | g85464 | i0 | 99.298 | 4 | 285 | 2 | 100 | 0 | 1 | 285 | 24701 | 24985 | MAG: Caudoviricetes sp. isolate MSP1372 genomic sequence | blastn | 1140 | 516 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19247595 | 19247595 | PRJEB56027_P_NODE_103536_length_264_cov_1.335079_g100727_i0 | PRJEB56027 | 103536 | 264 | 1.335079 | 3.52460856 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 86.1 | 2.38e-12 | NTclustered | gi|2914823613|gb|OR222127.1| | 2832643 | g100727 | i0 | 96.226 | 0.375 | 53 | 1 | 37 | 1 | 213 | 264 | 13842 | 13894 | MAG: Caudoviricetes sp. isolate MSP0858 genomic sequence | blastn | 99 | 86.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21394040 | 21394040 | PRJEB56027_P_NODE_138737_length_202_cov_4.379845_g135928_i0 | PRJEB56027 | 138737 | 202 | 4.379845 | 8.8472869 | root | 1 | Root_unresolved | Root_unresolved | 267 | 5.77e-67 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g135928 | i0 | 99.324 | 73.2673267326733 | 148 | 0 | 73 | 1 | 56 | 202 | 11403 | 11550 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 14800 | 267 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 21798937 | 21798937 | PRJEB56027_P_NODE_110898_length_254_cov_2.303867_g108089_i0 | PRJEB56027 | 110898 | 254 | 2.303867 | 5.85182218 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 202 | 2.1599999999999998e-47 | NTclustered | gi|2915004160|gb|OR222349.1| | 2832643 | g108089 | i0 | 98.261 | 2.67716535433071 | 115 | 2 | 45 | 0 | 1 | 115 | 2897 | 2783 | MAG: Caudoviricetes sp. isolate MSP1049 genomic sequence | blastn | 680 | 202 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21801193 | 21801193 | PRJEB56027_P_NODE_95258_length_275_cov_1.524752_g92449_i0 | PRJEB56027 | 95258 | 275 | 1.524752 | 4.193068 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 198 | 3.07e-46 | NTclustered | gi|2058073035|tpg|BK042980.1| | 2832643 | g92449 | i0 | 88.82 | 2.40363636363636 | 161 | 18 | 59 | 0 | 10 | 170 | 10476 | 10636 | MAG TPA_asm: Caudoviricetes sp. isolate ctjPb1, partial genome | blastn | 661 | 198 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23076339 | 23076339 | PRJEB56027_P_NODE_89739_length_283_cov_1.466667_g86930_i0 | PRJEB56027 | 89739 | 283 | 1.466667 | 4.15066761 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 351 | 2.3e-92 | NTclustered | gi|2914889217|gb|OR222626.1| | 2832643 | g86930 | i0 | 89.161 | 2.02120141342756 | 286 | 25 | 100 | 5 | 1 | 283 | 37929 | 38211 | MAG: Caudoviricetes sp. isolate MSP0308 genomic sequence | blastn | 572 | 351 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24348475 | 24348475 | PRJEB56027_P_NODE_126220_length_244_cov_3.736842_g123411_i0 | PRJEB56027 | 126220 | 244 | 3.736842 | 9.11789448 | Brussowvirus CHPC869 | 3059803 | Viruses | Viruses | 446 | 8.639999999999999e-121 | NTclustered | gi|2438273853|ref|NC_071069.1| | 2365041 | g123411 | i0 | 99.59 | 4.4016393442623 | 244 | 1 | 100 | 0 | 1 | 244 | 18718 | 18475 | Streptococcus phage CHPC869, complete genome | blastn | 1074 | 446 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aliceevansviridae | Brussowvirus | Brussowvirus CHPC869 |
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);;