contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA688931" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1944506 | 1944506 | PRJNA688931_P_NODE_26502_length_198_cov_1.389262_g26289_i0 | PRJNA688931 | 26502 | 198 | 1.389262 | 2.75073876 | Hainan alphaflexivirus 2 | 2824425 | Viruses | Viruses | 158 | 3.54e-34 | NTclustered | gi|2075444288|gb|MW897284.1| | 2824425 | g26289 | i0 | 86.713 | 5.48484848484848 | 143 | 17 | 72 | 2 | 53 | 194 | 4064 | 4205 | MAG: Hainan alphaflexivirus 2 isolate R87-k141_314575 replicase gene, partial cds; and NTP-binding helicase and hypothetical protein genes, complete cds | blastn | 1086 | 158 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Hainan alphaflexivirus 2 | |||
| 1944659 | 1944659 | PRJNA688931_P_NODE_44142_length_161_cov_2.303571_g43929_i0 | PRJNA688931 | 44142 | 161 | 2.303571 | 3.70874931 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 292 | 7.24e-75 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g43929 | i0 | 99.379 | 264.844720496894 | 161 | 1 | 100 | 0 | 1 | 161 | 18411 | 18251 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 42640 | 292 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4496646 | 4496646 | PRJNA688931_P_NODE_40264_length_164_cov_2.121739_g40051_i0 | PRJNA688931 | 40264 | 164 | 2.121739 | 3.47965196 | Kremarvirus VCM | 3430280 | Viruses | Viruses | 209 | 7.68e-50 | NTclustered | gi|985769500|ref|NC_029065.1| | 1729937 | g40051 | i0 | 89.634 | 6 | 164 | 17 | 100 | 0 | 1 | 164 | 42692 | 42529 | Pseudomonas phage VCM genome assembly VCM, chromosome : 1 | blastn | 984 | 209 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Kremarvirus | Kremarvirus VCM | |||
| 5772207 | 5772207 | PRJNA688931_P_NODE_42325_length_163_cov_0.903509_g42112_i0 | PRJNA688931 | 42325 | 163 | 0.903509 | 1.47271967 | Marine virus AFVG_250M1017 | 2693035 | Viruses | Viruses | 52.8 | 0.014 | NTclustered | gi|1789809979|gb|MN694335.1| | 2693035 | g42112 | i0 | 96.774 | 0.190184049079755 | 31 | 1 | 19 | 0 | 120 | 150 | 8465 | 8495 | MAG: Marine virus AFVG_250M1017, complete genome | blastn | 31 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marine virus AFVG_250M1017 | |||||
| 8321633 | 8321633 | PRJNA688931_P_NODE_27667_length_194_cov_1.048276_g27454_i0 | PRJNA688931 | 27667 | 194 | 1.048276 | 2.03365544 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 154 | 4.46e-33 | NTclustered | gi|2914888999|gb|OR222612.1| | 2832643 | g27454 | i0 | 81.122 | 2.02061855670103 | 196 | 33 | 100 | 4 | 1 | 194 | 22735 | 22928 | MAG: Caudoviricetes sp. isolate MSP0322 genomic sequence | blastn | 392 | 154 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12147893 | 12147893 | PRJNA688931_P_NODE_37050_length_167_cov_0.881356_g36837_i0 | PRJNA688931 | 37050 | 167 | 0.881356 | 1.47186452 | Bermuda grass latent virus | 1930269 | Viruses | Viruses | 287 | 3.53e-73 | NTclustered | gi|2221822463|gb|MZ671023.1| | 1930269 | g36837 | i0 | 97.605 | 9 | 167 | 4 | 100 | 0 | 1 | 167 | 286 | 120 | Bermuda grass latent virus isolate 5658 polyprotein, putative RNA-dependent RNA polymerase region, gene, partial cds | blastn | 1503 | 287 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Panicovirus | Bermuda grass latent virus | ||
| 13422315 | 13422315 | PRJNA688931_P_NODE_13631_length_281_cov_1.353448_g13418_i0 | PRJNA688931 | 13631 | 281 | 1.353448 | 3.80318888 | Pandoravirus salinus | 1349410 | Viruses | Viruses | 67.6 | 9.25e-7 | NTclustered | gi|531034792|ref|NC_022098.1| | 1349410 | g13418 | i0 | 85.075 | 0.238434163701068 | 67 | 8 | 23 | 2 | 4 | 69 | 2161829 | 2161764 | Pandoravirus salinus, complete genome | blastn | 67 | 67.6 | 1 | Viruses | Pandoravirus | Pandoravirus salinus | |||||||
| 18520533 | 18520533 | PRJNA688931_P_NODE_24795_length_205_cov_1.673077_g24582_i0 | PRJNA688931 | 24795 | 205 | 1.673077 | 3.42980785 | Paenibacillus phage Pahemo | 2835998 | Viruses | Viruses | 60.2 | 1.07e-4 | NTclustered | gi|2044627981|gb|MW927522.1| | 2835998 | g24582 | i0 | 97.222 | 0.175609756097561 | 36 | 0 | 17 | 1 | 171 | 205 | 41934 | 41899 | Paenibacillus phage Pahemo, complete genome | blastn | 36 | 60.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Fernvirus | Paenibacillus phage Pahemo | ||||
| 18520665 | 18520665 | PRJNA688931_P_NODE_41275_length_164_cov_0.886957_g41062_i0 | PRJNA688931 | 41275 | 164 | 0.886957 | 1.45460948 | Mimasvirus CBB | 2560628 | Viruses | Viruses | 265 | 1.6199999999999998e-66 | NTclustered | gi|1631916624|ref|NC_041878.1| | 2772511 | g41062 | i0 | 95.732 | 4.99390243902439 | 164 | 7 | 100 | 0 | 1 | 164 | 323678 | 323841 | Pectobacterium phage CBB, complete genome | blastn | 819 | 265 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Mimasvirus | Mimasvirus CBB | ||||
| 22345735 | 22345735 | PRJNA688931_P_NODE_12178_length_299_cov_1.644000_g11965_i0 | PRJNA688931 | 12178 | 299 | 1.644 | 4.91556 | uncultured human fecal virus | 239364 | Viruses | Viruses | 448 | 3.03e-121 | NTclustered | gi|1569729598|gb|MK233924.1| | 239364 | g11965 | i0 | 93.667 | 314.190635451505 | 300 | 17 | 100 | 2 | 1 | 299 | 962 | 1260 | Uncultured human fecal virus clone R.bromii_S11.J19_2_c1 sequence | blastn | 93943 | 448 | 1 | Viruses | uncultured human fecal virus | ||||||||
| 23621354 | 23621354 | PRJNA688931_P_NODE_25519_length_202_cov_1.535948_g25306_i0 | PRJNA688931 | 25519 | 202 | 1.535948 | 3.10261496 | Omahavirus UNOG1W1 | 3431222 | Viruses | Viruses | 268 | 1.5999999999999998e-67 | NTclustered | gi|2725655757|gb|PP551948.2| | 3136609 | g25306 | i0 | 90.594 | 19.3514851485149 | 202 | 19 | 100 | 0 | 1 | 202 | 59116 | 58915 | Pseudomonas phage UNO-G1W1, complete genome | blastn | 3909 | 268 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Omahavirus | Omahavirus UNOG1W1 | |||
| 24894802 | 24894802 | PRJNA688931_P_NODE_41740_length_163_cov_1.315789_g41527_i0 | PRJNA688931 | 41740 | 163 | 1.315789 | 2.14473607 | Omahavirus UNOG1W1 | 3431222 | Viruses | Viruses | 268 | 1.24e-67 | NTclustered | gi|2725655757|gb|PP551948.2| | 3136609 | g41527 | i0 | 96.319 | 11.6625766871166 | 163 | 6 | 100 | 0 | 1 | 163 | 31257 | 31419 | Pseudomonas phage UNO-G1W1, complete genome | blastn | 1901 | 268 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Omahavirus | Omahavirus UNOG1W1 | |||
| 24894809 | 24894809 | PRJNA688931_P_NODE_42500_length_163_cov_0.903509_g42287_i0 | PRJNA688931 | 42500 | 163 | 0.903509 | 1.47271967 | Tobamovirus rapae | 3432887 | Viruses | Viruses | 302 | 1.22e-77 | NTclustered | gi|167834146|gb|EU413669.1| | 29272 | g42287 | i0 | 100 | 21.6748466257669 | 163 | 0 | 100 | 0 | 1 | 163 | 977 | 1139 | Turnip vein-clearing virus isolate Pet-MS RNA replicase read-through component gene, partial cds; and movement protein and coat protein genes, complete cds | blastn | 3533 | 302 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus rapae | ||
| 25404591 | 25404591 | PRJNA688931_P_NODE_42020_length_163_cov_0.912281_g41807_i0 | PRJNA688931 | 42020 | 163 | 0.912281 | 1.48701803 | Pahexavirus | 1982251 | Viruses | Viruses | 294 | 2.04e-75 | NTclustered | gi|849254459|ref|NC_027373.1| | 1500800 | g41807 | i0 | 99.383 | 99.680981595092 | 162 | 1 | 99 | 0 | 1 | 162 | 10888 | 11049 | Propionibacterium phage PHL030N00, complete genome | blastn | 16248 | 294 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PHL117M01 |
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);;