contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA688931" and tax_kingdom = "Heunggongvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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. | |||||
| 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 | ||||
| 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 | |||
| 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);;