contig_metadata
9 rows where bioproject = "PRJNA656952" and tax_phylum = "Duplornaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4450155 | 4450155 | PRJNA656952_P_NODE_2744_length_628_cov_2.785586_g2582_i0 | PRJNA656952 | 2744 | 628 | 2.785586 | 17.49348008 | Red mite associated cystovirus | 2936548 | Viruses | Viruses | 1094 | 0 | NTclustered | gi|2239998150|gb|ON160022.1| | 2936548 | g2582 | i0 | 100 | 0.942675159235669 | 592 | 0 | 94 | 0 | 37 | 628 | 6476 | 5885 | Red mite associated cystovirus isolate RMACTV1-L P14, P15, P7, P2, P4, and P1 genes, complete cds | blastn | 592 | 1094 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Red mite associated cystovirus | ||
| 5726062 | 5726062 | PRJNA656952_P_NODE_425_length_1210_cov_3.275286_g335_i0 | PRJNA656952 | 425 | 1210 | 3.275286 | 39.6309606 | Red mite associated cystovirus | 2936548 | Viruses | Viruses | 2230 | 0 | NTclustered | gi|2239998150|gb|ON160022.1| | 2936548 | g335 | i0 | 100 | 1.16859504132231 | 1207 | 0 | 99 | 0 | 1 | 1207 | 3 | 1209 | Red mite associated cystovirus isolate RMACTV1-L P14, P15, P7, P2, P4, and P1 genes, complete cds | blastn | 1414 | 2230 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Red mite associated cystovirus | ||
| 7001309 | 7001309 | PRJNA656952_P_NODE_6_length_4349_cov_8.724743_g5_i0 | PRJNA656952 | 6 | 4349 | 8.724743 | 379.43907307 | Pseudomonas phage ER16 | 2917704 | Viruses | Viruses | 99 | 5.74e-15 | NTclustered | gi|2209092821|gb|OM650249.1| | 2917704 | g5 | i0 | 87.5 | 0.0202345366750977 | 88 | 8 | 2 | 3 | 27 | 114 | 72 | 156 | Pseudomonas phage ER16 segment M, complete sequence | blastn | 88 | 99 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Pseudomonas phage ER16 | |||
| 13376170 | 13376170 | PRJNA656952_P_NODE_1851_length_720_cov_1.120556_g1711_i0 | PRJNA656952 | 1851 | 720 | 1.120556 | 8.0680032 | Red mite associated cystovirus | 2936548 | Viruses | Viruses | 1325 | 0 | NTclustered | gi|2239998150|gb|ON160022.1| | 2936548 | g1711 | i0 | 99.861 | 2.00972222222222 | 720 | 1 | 100 | 0 | 1 | 720 | 5142 | 4423 | Red mite associated cystovirus isolate RMACTV1-L P14, P15, P7, P2, P4, and P1 genes, complete cds | blastn | 1447 | 1325 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Red mite associated cystovirus | ||
| 19748972 | 19748972 | PRJNA656952_P_NODE_196_length_1594_cov_3.289283_g149_i0 | PRJNA656952 | 196 | 1594 | 3.289283 | 52.43117102 | Red mite associated cystovirus | 2936548 | Viruses | Viruses | 2944 | 0 | NTclustered | gi|2239998150|gb|ON160022.1| | 2936548 | g149 | i0 | 100 | 1 | 1594 | 0 | 100 | 0 | 1 | 1594 | 2318 | 3911 | Red mite associated cystovirus isolate RMACTV1-L P14, P15, P7, P2, P4, and P1 genes, complete cds | blastn | 1594 | 2944 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Red mite associated cystovirus | ||
| 23575248 | 23575248 | PRJNA656952_P_NODE_4199_length_541_cov_3.549145_g4013_i0 | PRJNA656952 | 4199 | 541 | 3.549145 | 19.20087445 | Red mite associated cystovirus | 2936548 | Viruses | Viruses | 1000 | 0 | NTclustered | gi|2239998150|gb|ON160022.1| | 2936548 | g4013 | i0 | 100 | 1 | 541 | 0 | 100 | 0 | 1 | 541 | 4436 | 3896 | Red mite associated cystovirus isolate RMACTV1-L P14, P15, P7, P2, P4, and P1 genes, complete cds | blastn | 541 | 1000 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Red mite associated cystovirus | ||
| 24848379 | 24848379 | PRJNA656952_P_NODE_1780_length_729_cov_2.112805_g1642_i0 | PRJNA656952 | 1780 | 729 | 2.112805 | 15.40234845 | Red mite associated cystovirus | 2936548 | Viruses | Viruses | 1347 | 0 | NTclustered | gi|2239998150|gb|ON160022.1| | 2936548 | g1642 | i0 | 100 | 1.99862825788752 | 729 | 0 | 100 | 0 | 1 | 729 | 2107 | 1379 | Red mite associated cystovirus isolate RMACTV1-L P14, P15, P7, P2, P4, and P1 genes, complete cds | blastn | 1457 | 1347 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Red mite associated cystovirus | ||
| 24848545 | 24848545 | PRJNA656952_P_NODE_26220_length_272_cov_2.130653_g26033_i0 | PRJNA656952 | 26220 | 272 | 2.130653 | 5.79537616 | Red mite associated cystovirus | 2936548 | Viruses | Viruses | 503 | 5.729999999999998e-138 | NTclustered | gi|2239998150|gb|ON160022.1| | 2936548 | g26033 | i0 | 100 | 1 | 272 | 0 | 100 | 0 | 1 | 272 | 5765 | 5494 | Red mite associated cystovirus isolate RMACTV1-L P14, P15, P7, P2, P4, and P1 genes, complete cds | blastn | 272 | 503 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Red mite associated cystovirus | ||
| 24848996 | 24848996 | PRJNA656952_P_NODE_60_length_2336_cov_34.779938_g42_i0 | PRJNA656952 | 60 | 2336 | 34.779938 | 812.45935168 | Red mite associated cystovirus | 2936548 | Viruses | Viruses | 4314 | 0 | NTclustered | gi|2239998157|gb|ON160023.1| | 2936548 | g42 | i0 | 100 | 1.67551369863014 | 2336 | 0 | 100 | 0 | 1 | 2336 | 5 | 2340 | Red mite associated cystovirus isolate RMACTV1-S P8, P12, P9, and P5 genes, complete cds | blastn | 3914 | 4314 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Red mite associated cystovirus |
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);;