contig_metadata
9 rows where bioproject = "PRJEB25789", tax_phylum = "Lenarviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1297607 | 1297607 | PRJEB25789_S_NODE_9642_length_309_cov_2.631356_g9563_i0 | PRJEB25789 | 9642 | 309 | 2.631356 | 8.13089004 | Insect narna-like virus 1 | 2819083 | Viruses | Viruses | 560 | 3.88e-155 | NTclustered | gi|2069595893|gb|MW297845.1| | 2819083 | g9563 | i0 | 99.353 | 1 | 309 | 2 | 100 | 0 | 1 | 309 | 1104 | 796 | Insect narna-like virus 1 isolate THR-D_DN17285 segment RNA2 hypothetical protein gene, complete cds | blastn | 309 | 560 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Insect narna-like virus 1 | |||
| 2573030 | 2573030 | PRJEB25789_S_NODE_16043_length_254_cov_2.303867_g15964_i0 | PRJEB25789 | 16043 | 254 | 2.303867 | 5.85182218 | Insect narna-like virus 1 | 2819083 | Viruses | Viruses | 442 | 1.1699999999999995e-119 | NTclustered | gi|1904958697|gb|MN764145.1| | 2819083 | g15964 | i0 | 98.031 | 1 | 254 | 5 | 100 | 0 | 1 | 254 | 2106 | 1853 | Insect narna-like virus 1 isolate THR-D_DN17285 segment RNA1 putative RNA dependent RNA polymerase gene, complete cds | blastn | 254 | 442 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Insect narna-like virus 1 | |||
| 6401353 | 6401353 | PRJEB25789_S_NODE_19846_length_241_cov_2.553571_g19767_i0 | PRJEB25789 | 19846 | 241 | 2.553571 | 6.15410611 | Insect narna-like virus 1 | 2819083 | Viruses | Viruses | 424 | 3.99e-114 | NTclustered | gi|1904958697|gb|MN764145.1| | 2819083 | g19767 | i0 | 98.34 | 1 | 241 | 4 | 100 | 0 | 1 | 241 | 2215 | 2455 | Insect narna-like virus 1 isolate THR-D_DN17285 segment RNA1 putative RNA dependent RNA polymerase gene, complete cds | blastn | 241 | 424 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Insect narna-like virus 1 | |||
| 10226062 | 10226062 | PRJEB25789_S_NODE_5769_length_377_cov_1.342105_g5690_i0 | PRJEB25789 | 5769 | 377 | 1.342105 | 5.05973585 | Insect narna-like virus 1 | 2819083 | Viruses | Viruses | 680 | 0 | NTclustered | gi|2069595893|gb|MW297845.1| | 2819083 | g5690 | i0 | 99.204 | 1 | 377 | 3 | 100 | 0 | 1 | 377 | 665 | 289 | Insect narna-like virus 1 isolate THR-D_DN17285 segment RNA2 hypothetical protein gene, complete cds | blastn | 377 | 680 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Insect narna-like virus 1 | |||
| 11501263 | 11501263 | PRJEB25789_S_NODE_2970_length_500_cov_1.763466_g2891_i0 | PRJEB25789 | 2970 | 500 | 1.763466 | 8.81733 | Insect narna-like virus 1 | 2819083 | Viruses | Viruses | 869 | 0 | NTclustered | gi|1904958697|gb|MN764145.1| | 2819083 | g2891 | i0 | 98 | 1 | 500 | 10 | 100 | 0 | 1 | 500 | 565 | 1064 | Insect narna-like virus 1 isolate THR-D_DN17285 segment RNA1 putative RNA dependent RNA polymerase gene, complete cds | blastn | 500 | 869 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Insect narna-like virus 1 | |||
| 19148772 | 19148772 | PRJEB25789_S_NODE_5216_length_393_cov_2.578125_g5137_i0 | PRJEB25789 | 5216 | 393 | 2.578125 | 10.13203125 | Insect narna-like virus 1 | 2819083 | Viruses | Viruses | 713 | 0 | NTclustered | gi|2069595893|gb|MW297845.1| | 2819083 | g5137 | i0 | 99.49 | 0.997455470737914 | 392 | 2 | 99 | 0 | 2 | 393 | 1926 | 1535 | Insect narna-like virus 1 isolate THR-D_DN17285 segment RNA2 hypothetical protein gene, complete cds | blastn | 392 | 713 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Insect narna-like virus 1 | |||
| 22975165 | 22975165 | PRJEB25789_S_NODE_18099_length_246_cov_1.982659_g18020_i0 | PRJEB25789 | 18099 | 246 | 1.982659 | 4.87734114 | Insect narna-like virus 1 | 2819083 | Viruses | Viruses | 444 | 3.14e-120 | NTclustered | gi|2069595893|gb|MW297845.1| | 2819083 | g18020 | i0 | 99.187 | 1 | 246 | 2 | 100 | 0 | 1 | 246 | 312 | 67 | Insect narna-like virus 1 isolate THR-D_DN17285 segment RNA2 hypothetical protein gene, complete cds | blastn | 246 | 444 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Insect narna-like virus 1 | |||
| 24248928 | 24248928 | PRJEB25789_S_NODE_13620_length_271_cov_1.762626_g13541_i0 | PRJEB25789 | 13620 | 271 | 1.762626 | 4.77671646 | Insect narna-like virus 1 | 2819083 | Viruses | Viruses | 451 | 2.0999999999999997e-122 | NTclustered | gi|1904958697|gb|MN764145.1| | 2819083 | g13541 | i0 | 96.679 | 1 | 271 | 9 | 100 | 0 | 1 | 271 | 271 | 541 | Insect narna-like virus 1 isolate THR-D_DN17285 segment RNA1 putative RNA dependent RNA polymerase gene, complete cds | blastn | 271 | 451 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Insect narna-like virus 1 | |||
| 24249062 | 24249062 | PRJEB25789_S_NODE_20880_length_206_cov_4.421053_g20801_i0 | PRJEB25789 | 20880 | 206 | 4.421053 | 9.10736918 | Insect narna-like virus 1 | 2819083 | Viruses | Viruses | 368 | 1.57e-97 | NTclustered | gi|1904958697|gb|MN764145.1| | 2819083 | g20801 | i0 | 99.024 | 0.995145631067961 | 205 | 2 | 99 | 0 | 1 | 205 | 69 | 273 | Insect narna-like virus 1 isolate THR-D_DN17285 segment RNA1 putative RNA dependent RNA polymerase gene, complete cds | blastn | 205 | 368 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Insect narna-like virus 1 |
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);;