contig_metadata
12 rows where bioproject = "PRJNA896758", tax_phylum = "Kitrinoviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 872860 | 872860 | PRJNA896758_P_NODE_22201_length_249_cov_1.369318_g21811_i0 | PRJNA896758 | 22201 | 249 | 1.369318 | 3.40960182 | Carlavirus vignae | 3427805 | Viruses | Viruses | 372 | 1.52e-98 | NTclustered | gi|2505219822|gb|OP611426.1| | 67761 | g21811 | i0 | 93.574 | 87.8875502008032 | 249 | 16 | 100 | 0 | 1 | 249 | 8182 | 7934 | Cowpea mild mottle virus isolate Buritama_BR, complete genome | blastn | 21884 | 372 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae | ||
| 4701359 | 4701359 | PRJNA896758_P_NODE_16824_length_282_cov_0.842105_g16434_i0 | PRJNA896758 | 16824 | 282 | 0.842105 | 2.3747361 | Carlavirus vignae | 3427805 | Viruses | Viruses | 494 | 3.6e-135 | NTclustered | gi|2017771285|gb|MW657188.1| | 67761 | g16434 | i0 | 98.233 | 100.354609929078 | 283 | 4 | 100 | 1 | 1 | 282 | 381 | 99 | Cowpea mild mottle virus clone BP1:1 triple gene block 1 (ORF2) gene, complete cds | blastn | 28300 | 494 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae | ||
| 5976241 | 5976241 | PRJNA896758_P_NODE_9585_length_368_cov_2.915254_g9195_i0 | PRJNA896758 | 9585 | 368 | 2.915254 | 10.72813472 | Carlavirus vignae | 3427805 | Viruses | Viruses | 438 | 2.3e-118 | NTclustered | gi|2505219822|gb|OP611426.1| | 67761 | g9195 | i0 | 88.108 | 3.01086956521739 | 370 | 42 | 100 | 1 | 1 | 368 | 6528 | 6897 | Cowpea mild mottle virus isolate Buritama_BR, complete genome | blastn | 1108 | 438 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae | ||
| 11076371 | 11076371 | PRJNA896758_P_NODE_22509_length_249_cov_0.875000_g22119_i0 | PRJNA896758 | 22509 | 249 | 0.875 | 2.17875 | Carlavirus vignae | 3427805 | Viruses | Viruses | 455 | 1.47e-123 | NTclustered | gi|2505219822|gb|OP611426.1| | 67761 | g22119 | i0 | 99.598 | 100 | 249 | 1 | 100 | 0 | 1 | 249 | 6114 | 6362 | Cowpea mild mottle virus isolate Buritama_BR, complete genome | blastn | 24900 | 455 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae | ||
| 12351807 | 12351807 | PRJNA896758_P_NODE_23290_length_247_cov_1.321839_g22900_i0 | PRJNA896758 | 23290 | 247 | 1.321839 | 3.26494233 | Carlavirus vignae | 3427805 | Viruses | Viruses | 446 | 8.759999999999998e-121 | NTclustered | gi|2017770961|gb|MW657026.1| | 67761 | g22900 | i0 | 99.19 | 99.9878542510122 | 247 | 2 | 100 | 0 | 1 | 247 | 5242 | 5488 | Cowpea mild mottle virus clone P3a:9 viral replicase (ORF1) gene, complete cds | blastn | 24697 | 446 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae | ||
| 12351812 | 12351812 | PRJNA896758_P_NODE_23590_length_247_cov_0.885057_g23200_i0 | PRJNA896758 | 23590 | 247 | 0.885057 | 2.18609079 | Carlavirus vignae | 3427805 | Viruses | Viruses | 446 | 8.759999999999998e-121 | NTclustered | gi|2909031160|gb|PQ825743.1| | 67761 | g23200 | i0 | 99.19 | 25.3805668016194 | 247 | 2 | 100 | 0 | 1 | 247 | 252 | 6 | Cowpea mild mottle virus isolate CPMMV-Soy coat protein gene, partial cds | blastn | 6269 | 446 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae | ||
| 12351849 | 12351849 | PRJNA896758_P_NODE_470_length_1604_cov_2.387329_g310_i0 | PRJNA896758 | 470 | 1604 | 2.387329 | 38.29275716 | Carlavirus vignae | 3427805 | Viruses | Viruses | 2839 | 0 | NTclustered | gi|2505219801|gb|OP611423.1| | 67761 | g310 | i0 | 98.628 | 79.5317955112219 | 1604 | 21 | 99 | 1 | 2 | 1604 | 8191 | 6588 | Cowpea mild mottle virus isolate LEM1_BR, complete genome | blastn | 127569 | 2839 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae | ||
| 14900771 | 14900771 | PRJNA896758_P_NODE_21572_length_250_cov_1.757062_g21182_i0 | PRJNA896758 | 21572 | 250 | 1.757062 | 4.392655 | Zhejiang betaflexivirus 2 | 2824414 | Viruses | Viruses | 431 | 2.489999999999999e-116 | NTclustered | gi|2075444446|gb|MW897315.1| | 2824414 | g21182 | i0 | 97.984 | 93.388 | 248 | 5 | 99 | 0 | 1 | 248 | 7790 | 8037 | MAG: Zhejiang betaflexivirus 2 isolate 15-k141_99752, complete genome | blastn | 23347 | 431 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Zhejiang betaflexivirus 2 | |||
| 20370277 | 20370277 | PRJNA896758_P_NODE_21916_length_250_cov_0.870056_g21526_i0 | PRJNA896758 | 21916 | 250 | 0.870056 | 2.17514 | Carlavirus | 12163 | Viruses | Viruses | 440 | 4.1399999999999976e-119 | NTclustered | gi|2907520831|gb|PQ834430.1| | 67761 | g21526 | i0 | 98.406 | 100.24 | 251 | 3 | 100 | 1 | 1 | 250 | 353 | 603 | Cowpea mild mottle virus isolate CPMMV-Soy-Seed coat protein gene, complete cds | blastn | 25060 | 440 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae | ||
| 22549705 | 22549705 | PRJNA896758_P_NODE_25398_length_243_cov_0.905882_g25008_i0 | PRJNA896758 | 25398 | 243 | 0.905882 | 2.20129326 | Zhejiang betaflexivirus 2 | 2824414 | Viruses | Viruses | 449 | 6.65e-122 | NTclustered | gi|2075444446|gb|MW897315.1| | 2824414 | g25008 | i0 | 100 | 26.4115226337449 | 243 | 0 | 100 | 0 | 1 | 243 | 7552 | 7794 | MAG: Zhejiang betaflexivirus 2 isolate 15-k141_99752, complete genome | blastn | 6418 | 449 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Zhejiang betaflexivirus 2 | |||
| 25098766 | 25098766 | PRJNA896758_P_NODE_10020_length_361_cov_1.222222_g9630_i0 | PRJNA896758 | 10020 | 361 | 1.222222 | 4.41222142 | Carlavirus vignae | 3427805 | Viruses | Viruses | 638 | 2.0699999999999996e-178 | NTclustered | gi|555431087|gb|KF554101.1| | 67761 | g9630 | i0 | 98.615 | 87.8504155124654 | 361 | 4 | 100 | 1 | 1 | 361 | 2504 | 2145 | Cowpea mild mottle virus isolate CPMMV:BR:GO:10:4 triple gene block 1, triple gene block 2, triple gene block 3, coat protein, and putative nucleic acid binding protein genes, complete cds | blastn | 31714 | 638 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae | ||
| 25098847 | 25098847 | PRJNA896758_P_NODE_20100_length_259_cov_1.241935_g19710_i0 | PRJNA896758 | 20100 | 259 | 1.241935 | 3.21661165 | Carlavirus vignae | 3427805 | Viruses | Viruses | 457 | 4.279999999999999e-124 | NTclustered | gi|2505219829|gb|OP611427.1| | 67761 | g19710 | i0 | 98.456 | 74.5057915057915 | 259 | 4 | 100 | 0 | 1 | 259 | 6715 | 6973 | Cowpea mild mottle virus isolate Rubiacea_BR, complete genome | blastn | 19297 | 457 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae |
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);;