contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA758398" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3291040 | 3291040 | PRJNA758398_S_NODE_33223_length_185_cov_3.669118_g33082_i0 | PRJNA758398 | 33223 | 185 | 3.669118 | 6.7878683 | Mitovirus sp. | 2587224 | Viruses | Viruses | 108 | 3.32e-19 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g33082 | i0 | 93.151 | 0.394594594594595 | 73 | 5 | 39 | 0 | 113 | 185 | 111 | 39 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 73 | 108 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 4567868 | 4567868 | PRJNA758398_S_NODE_11844_length_283_cov_2.243590_g11703_i0 | PRJNA758398 | 11844 | 283 | 2.24359 | 6.3493597 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 507 | 4.64e-139 | NTclustered | gi|2756423236|gb|PP745408.1| | 1955144 | g11703 | i0 | 98.94 | 3.18374558303887 | 283 | 3 | 100 | 0 | 1 | 283 | 4117 | 3835 | MAG: Dicistroviridae sp. isolate 145_122521 genomic sequence | blastn | 901 | 507 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 5843107 | 5843107 | PRJNA758398_S_NODE_1805_length_677_cov_2.563694_g1685_i0 | PRJNA758398 | 1805 | 677 | 2.563694 | 17.35620838 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 1234 | 0 | NTclustered | gi|2756423555|gb|PP745568.1| | 1955144 | g1685 | i0 | 99.557 | 6.77991137370753 | 677 | 3 | 100 | 0 | 1 | 677 | 1516 | 840 | MAG: Dicistroviridae sp. isolate 024_1469 genomic sequence | blastn | 4590 | 1234 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 8392761 | 8392761 | PRJNA758398_S_NODE_11107_length_291_cov_3.020661_g10966_i0 | PRJNA758398 | 11107 | 291 | 3.020661 | 8.79012351 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 527 | 3.67e-145 | NTclustered | gi|2756423425|gb|PP745503.1| | 1955144 | g10966 | i0 | 99.313 | 2.45704467353952 | 291 | 2 | 100 | 0 | 1 | 291 | 1802 | 2092 | MAG: Dicistroviridae sp. isolate 146_82882 genomic sequence | blastn | 715 | 527 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 8393001 | 8393001 | PRJNA758398_S_NODE_29787_length_194_cov_2.365517_g29646_i0 | PRJNA758398 | 29787 | 194 | 2.365517 | 4.58910298 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 342 | 8.869999999999999e-90 | NTclustered | gi|2756423236|gb|PP745408.1| | 1955144 | g29646 | i0 | 98.454 | 1 | 194 | 3 | 100 | 0 | 1 | 194 | 1008 | 1201 | MAG: Dicistroviridae sp. isolate 145_122521 genomic sequence | blastn | 194 | 342 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 8393290 | 8393290 | PRJNA758398_S_NODE_6147_length_385_cov_0.842262_g6006_i0 | PRJNA758398 | 6147 | 385 | 0.842262 | 3.2427087 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 689 | 0 | NTclustered | gi|2756423236|gb|PP745408.1| | 1955144 | g6006 | i0 | 98.961 | 1.88051948051948 | 385 | 4 | 100 | 0 | 1 | 385 | 268 | 652 | MAG: Dicistroviridae sp. isolate 145_122521 genomic sequence | blastn | 724 | 689 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 8393361 | 8393361 | PRJNA758398_S_NODE_9627_length_311_cov_2.702290_g9486_i0 | PRJNA758398 | 9627 | 311 | 2.70229 | 8.4041219 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 547 | 3.0399999999999987e-151 | NTclustered | gi|2756423555|gb|PP745568.1| | 1955144 | g9486 | i0 | 98.392 | 4 | 311 | 5 | 100 | 0 | 1 | 311 | 540 | 850 | MAG: Dicistroviridae sp. isolate 024_1469 genomic sequence | blastn | 1244 | 547 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 12219210 | 12219210 | PRJNA758398_S_NODE_15130_length_255_cov_1.058252_g14989_i0 | PRJNA758398 | 15130 | 255 | 1.058252 | 2.6985426 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 449 | 7.03e-122 | NTclustered | gi|2756423236|gb|PP745408.1| | 1955144 | g14989 | i0 | 98.431 | 2 | 255 | 4 | 100 | 0 | 1 | 255 | 2557 | 2811 | MAG: Dicistroviridae sp. isolate 145_122521 genomic sequence | blastn | 510 | 449 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 17318206 | 17318206 | PRJNA758398_S_NODE_49174_length_163_cov_1.789474_g49033_i0 | PRJNA758398 | 49174 | 163 | 1.789474 | 2.91684262 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 302 | 1.22e-77 | NTclustered | gi|2756423236|gb|PP745408.1| | 1955144 | g49033 | i0 | 100 | 1 | 163 | 0 | 100 | 0 | 1 | 163 | 1375 | 1213 | MAG: Dicistroviridae sp. isolate 145_122521 genomic sequence | blastn | 163 | 302 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 18591258 | 18591258 | PRJNA758398_S_NODE_15775_length_250_cov_2.024876_g15634_i0 | PRJNA758398 | 15775 | 250 | 2.024876 | 5.06219 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 457 | 4.1099999999999985e-124 | NTclustered | gi|2756423236|gb|PP745408.1| | 1955144 | g15634 | i0 | 99.6 | 2 | 250 | 1 | 100 | 0 | 1 | 250 | 1951 | 1702 | MAG: Dicistroviridae sp. isolate 145_122521 genomic sequence | blastn | 500 | 457 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 19866352 | 19866352 | PRJNA758398_S_NODE_10056_length_305_cov_2.039062_g9915_i0 | PRJNA758398 | 10056 | 305 | 2.039062 | 6.2191391 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 514 | 3.02e-141 | NTclustered | gi|2756423425|gb|PP745503.1| | 1955144 | g9915 | i0 | 97.973 | 1.94098360655738 | 296 | 6 | 97 | 0 | 10 | 305 | 383 | 678 | MAG: Dicistroviridae sp. isolate 146_82882 genomic sequence | blastn | 592 | 514 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 22416925 | 22416925 | PRJNA758398_S_NODE_18158_length_236_cov_1.363636_g18017_i0 | PRJNA758398 | 18158 | 236 | 1.363636 | 3.21818096 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 409 | 1.09e-109 | NTclustered | gi|2756423236|gb|PP745408.1| | 1955144 | g18017 | i0 | 97.881 | 2.99152542372881 | 236 | 5 | 100 | 0 | 1 | 236 | 841 | 606 | MAG: Dicistroviridae sp. isolate 145_122521 genomic sequence | blastn | 706 | 409 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 24966603 | 24966603 | PRJNA758398_S_NODE_9220_length_318_cov_1.520446_g9079_i0 | PRJNA758398 | 9220 | 318 | 1.520446 | 4.83501828 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 577 | 3.9799999999999996e-160 | NTclustered | gi|2756423236|gb|PP745408.1| | 1955144 | g9079 | i0 | 99.371 | 1.25157232704403 | 318 | 2 | 100 | 0 | 1 | 318 | 1673 | 1356 | MAG: Dicistroviridae sp. isolate 145_122521 genomic sequence | blastn | 398 | 577 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae 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);;