contig_metadata
10 rows where bioproject = "PRJNA1144090" and tax_kingdom = "Shotokuvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2838354 | 2838354 | PRJNA1144090_P_NODE_63_length_4738_cov_159.509110_g51_i0 | PRJNA1144090 | 63 | 4738 | 159.50911 | 7557.5416318 | Bocaparvovirus rodent2 | 3052044 | Viruses | Viruses | 4645 | 0 | NTclustered | gi|2047107868|ref|NC_055487.1| | 2171381 | g51 | i0 | 96.321 | 2.32946390882229 | 2827 | 104 | 99 | 0 | 2 | 2828 | 4914 | 2088 | Murine bocavirus isolate MBV/NYC/2014/Q055/1700, partial genome | blastn | 11037 | 4645 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Bocaparvovirus | Bocaparvovirus rodent2 | ||
| 4114470 | 4114470 | PRJNA1144090_P_NODE_5784_length_1192_cov_44.465594_g5468_i0 | PRJNA1144090 | 5784 | 1192 | 44.465594 | 530.02988048 | Galvornvirus | 2948715 | Viruses | Viruses | 115 | 5.14e-26 | NR | AXQ66095.1 | 1954248 | g5468 | i0 | 41.6 | 1.71392617449664 | 166 | 94 | 41.3 | 3 | 635 | 1126 | 27 | 191 | AXQ66095.1 MAG: capsid protein [Circoviridae sp.] | diamond | 2043 | 115 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 4114821 | 4114821 | PRJNA1144090_P_NODE_884_length_2431_cov_232.732400_g51_i3 | PRJNA1144090 | 884 | 2431 | 232.7324 | 5657.724644 | Bocaparvovirus rodent2 | 3052044 | Viruses | Viruses | 3533 | 0 | NTclustered | gi|2047107868|ref|NC_055487.1| | 2171381 | g51 | i3 | 96.081 | 2.3048128342246 | 2169 | 84 | 99 | 1 | 2 | 2170 | 4914 | 2747 | Murine bocavirus isolate MBV/NYC/2014/Q055/1700, partial genome | blastn | 5603 | 3533 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Bocaparvovirus | Bocaparvovirus rodent2 | ||
| 7940088 | 7940088 | PRJNA1144090_P_NODE_147_length_3814_cov_191.081262_g51_i2 | PRJNA1144090 | 147 | 3814 | 191.081262 | 7287.83933268 | Bocaparvovirus rodent2 | 3052044 | Viruses | Viruses | 4645 | 0 | NTclustered | gi|2047107868|ref|NC_055487.1| | 2171381 | g51 | i2 | 96.321 | 1.96643943366544 | 2827 | 104 | 99 | 0 | 987 | 3813 | 2088 | 4914 | Murine bocavirus isolate MBV/NYC/2014/Q055/1700, partial genome | blastn | 7500 | 4645 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Bocaparvovirus | Bocaparvovirus rodent2 | ||
| 18139526 | 18139526 | PRJNA1144090_P_NODE_86375_length_270_cov_80.883249_g85840_i0 | PRJNA1144090 | 86375 | 270 | 80.883249 | 218.3847723 | Bocaparvovirus rodent2 | 3052044 | Viruses | Viruses | 455 | 1.6100000000000002e-123 | NTclustered | gi|2047107868|ref|NC_055487.1| | 2171381 | g85840 | i0 | 97.037 | 1 | 270 | 8 | 100 | 0 | 1 | 270 | 2160 | 1891 | Murine bocavirus isolate MBV/NYC/2014/Q055/1700, partial genome | blastn | 270 | 455 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Bocaparvovirus | Bocaparvovirus rodent2 | ||
| 24512708 | 24512708 | PRJNA1144090_P_NODE_100_length_4164_cov_155.163774_g51_i1 | PRJNA1144090 | 100 | 4164 | 155.163774 | 6461.01954936 | Bocaparvovirus rodent2 | 3052044 | Viruses | Viruses | 3533 | 0 | NTclustered | gi|2047107868|ref|NC_055487.1| | 2171381 | g51 | i1 | 96.081 | 2.38928914505283 | 2169 | 84 | 99 | 1 | 1995 | 4163 | 2747 | 4914 | Murine bocavirus isolate MBV/NYC/2014/Q055/1700, partial genome | blastn | 9949 | 3533 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Bocaparvovirus | Bocaparvovirus rodent2 | ||
| 26880829 | 26880829 | PRJNA1144090_P_NODE_62781_length_320_cov_1.866397_g62246_i0 | PRJNA1144090 | 62781 | 320 | 1.866397 | 5.9724704 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 131 | 9.3e-34 | NR | AYP28721.1 | 2748378 | g62246 | i0 | 60.4 | 0.99375 | 106 | 37 | 99.4 | 2 | 1 | 318 | 71 | 171 | AYP28721.1 MAG: coat protein [Cressdnaviricota sp.] | diamond | 318 | 131 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 27196741 | 27196741 | PRJNA1144090_P_NODE_48442_length_367_cov_1.571429_g47907_i0 | PRJNA1144090 | 48442 | 367 | 1.571429 | 5.76714443 | Circoviridae sp. | 1954248 | Viruses | Viruses | 85.5 | 1.48e-17 | NR | AXQ66095.1 | 1954248 | g47907 | i0 | 44.8 | 3.60490463215259 | 96 | 52 | 78.5 | 1 | 363 | 76 | 47 | 141 | AXQ66095.1 MAG: capsid protein [Circoviridae sp.] | diamond | 1323 | 85.5 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 31777265 | 31777265 | PRJNA1144090_P_NODE_97297_length_253_cov_2.566667_g96762_i0 | PRJNA1144090 | 97297 | 253 | 2.566667 | 6.49366751 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 89.7 | 8.9e-19 | NR | AYP28721.1 | 2748378 | g96762 | i0 | 50.6 | 0.984189723320158 | 83 | 39 | 98.4 | 1 | 251 | 3 | 167 | 247 | AYP28721.1 MAG: coat protein [Cressdnaviricota sp.] | diamond | 249 | 89.7 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 31840314 | 31840314 | PRJNA1144090_P_NODE_119317_length_231_cov_2.791139_g118782_i0 | PRJNA1144090 | 119317 | 231 | 2.791139 | 6.44753109 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 52.4 | 9.35e-6 | NR | WAE42276.1 | 2748378 | g118782 | i0 | 38.2 | 0.883116883116883 | 68 | 39 | 84.4 | 1 | 24 | 218 | 176 | 243 | WAE42276.1 MAG: capsid protein [Cressdnaviricota sp.] | diamond | 204 | 52.4 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota 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);;