contig_metadata
9 rows where bioproject = "PRJNA450632" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 439287 | 439287 | PRJNA450632_P_NODE_15661_length_199_cov_1.390244_g15482_i0 | PRJNA450632 | 15661 | 199 | 1.390244 | 2.7665855600000002 | Drosophila A virus | 595895 | Viruses | Viruses | 368 | 1.51e-97 | NTclustered | gi|1417910672|gb|MH384369.1| | 595895 | g15482 | i0 | 100 | 45.8391959798995 | 199 | 0 | 100 | 0 | 1 | 199 | 507 | 309 | Drosophila A virus strain MEL181D RNA-dependent RNA polymerase and capsid protein genes, complete cds | blastn | 9122 | 368 | 1 | Viruses | unclassified ssRNA positive-strand viruses | Drosophila A virus | |||||||
| 1714084 | 1714084 | PRJNA450632_P_NODE_1462_length_956_cov_21.664495_g1341_i0 | PRJNA450632 | 1462 | 956 | 21.664495 | 207.1125722 | Senecavirus valles | 3241303 | Viruses | Viruses | 1711 | 0 | NTclustered | gi|1776925997|gb|MN233021.1| | 390157 | g1341 | i0 | 98.955 | 99.5177824267782 | 957 | 9 | 100 | 1 | 1 | 956 | 6327 | 7283 | Senecavirus A isolate USA/IA05-401302/2005, complete genome | blastn | 95139 | 1711 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Senecavirus | Senecavirus valles | ||
| 4266541 | 4266541 | PRJNA450632_P_NODE_5404_length_417_cov_1.243455_g5225_i0 | PRJNA450632 | 5404 | 417 | 1.243455 | 5.18520735 | Drosophila A virus | 595895 | Viruses | Viruses | 715 | 0 | NTclustered | gi|1417910474|gb|MH384282.1| | 595895 | g5225 | i0 | 97.602 | 21.9976019184652 | 417 | 10 | 100 | 0 | 1 | 417 | 4010 | 4426 | Drosophila A virus strain DAV-HUNminus7422 RNA-dependent RNA polymerase and capsid protein genes, complete cds | blastn | 9173 | 715 | 1 | Viruses | unclassified ssRNA positive-strand viruses | Drosophila A virus | |||||||
| 9367114 | 9367114 | PRJNA450632_P_NODE_14148_length_213_cov_1.280899_g13969_i0 | PRJNA450632 | 14148 | 213 | 1.280899 | 2.72831487 | Drosophila A virus | 595895 | Viruses | Viruses | 370 | 4.5599999999999996e-98 | NTclustered | gi|1417910672|gb|MH384369.1| | 595895 | g13969 | i0 | 98.113 | 22.3708920187793 | 212 | 4 | 99 | 0 | 2 | 213 | 2184 | 1973 | Drosophila A virus strain MEL181D RNA-dependent RNA polymerase and capsid protein genes, complete cds | blastn | 4765 | 370 | 1 | Viruses | unclassified ssRNA positive-strand viruses | Drosophila A virus | |||||||
| 10643033 | 10643033 | PRJNA450632_P_NODE_12969_length_225_cov_1.921053_g12790_i0 | PRJNA450632 | 12969 | 225 | 1.921053 | 4.32236925 | Drosophila A virus | 595895 | Viruses | Viruses | 405 | 1.33e-108 | NTclustered | gi|1417910474|gb|MH384282.1| | 595895 | g12790 | i0 | 99.111 | 30.4933333333333 | 225 | 2 | 100 | 0 | 1 | 225 | 2988 | 2764 | Drosophila A virus strain DAV-HUNminus7422 RNA-dependent RNA polymerase and capsid protein genes, complete cds | blastn | 6861 | 405 | 1 | Viruses | unclassified ssRNA positive-strand viruses | Drosophila A virus | |||||||
| 15742178 | 15742178 | PRJNA450632_P_NODE_6033_length_382_cov_2.224784_g5854_i0 | PRJNA450632 | 6033 | 382 | 2.224784 | 8.49867488 | Drosophila A virus | 595895 | Viruses | Viruses | 678 | 0 | NTclustered | gi|1417910474|gb|MH384282.1| | 595895 | g5854 | i0 | 98.691 | 21.4659685863874 | 382 | 5 | 100 | 0 | 1 | 382 | 738 | 1119 | Drosophila A virus strain DAV-HUNminus7422 RNA-dependent RNA polymerase and capsid protein genes, complete cds | blastn | 8200 | 678 | 1 | Viruses | unclassified ssRNA positive-strand viruses | Drosophila A virus | |||||||
| 18290852 | 18290852 | PRJNA450632_P_NODE_14375_length_210_cov_2.200000_g14196_i0 | PRJNA450632 | 14375 | 210 | 2.2 | 4.62 | Drosophila A virus | 595895 | Viruses | Viruses | 377 | 2.68e-100 | NTclustered | gi|1417910672|gb|MH384369.1| | 595895 | g14196 | i0 | 99.048 | 44.0285714285714 | 210 | 2 | 100 | 0 | 1 | 210 | 79 | 288 | Drosophila A virus strain MEL181D RNA-dependent RNA polymerase and capsid protein genes, complete cds | blastn | 9246 | 377 | 1 | Viruses | unclassified ssRNA positive-strand viruses | Drosophila A virus | |||||||
| 18290930 | 18290930 | PRJNA450632_P_NODE_17255_length_186_cov_1.562914_g17076_i0 | PRJNA450632 | 17255 | 186 | 1.562914 | 2.90702004 | Drosophila A virus | 595895 | Viruses | Viruses | 331 | 1.82e-86 | NTclustered | gi|1417910672|gb|MH384369.1| | 595895 | g17076 | i0 | 98.919 | 30.8279569892473 | 185 | 2 | 99 | 0 | 2 | 186 | 675 | 491 | Drosophila A virus strain MEL181D RNA-dependent RNA polymerase and capsid protein genes, complete cds | blastn | 5734 | 331 | 1 | Viruses | unclassified ssRNA positive-strand viruses | Drosophila A virus | |||||||
| 23391705 | 23391705 | PRJNA450632_P_NODE_239_length_2096_cov_5.788452_g209_i0 | PRJNA450632 | 239 | 2096 | 5.788452 | 121.32595392 | Moloney murine leukemia virus | 11801 | Viruses | Viruses | 1362 | 0 | NR | NP_057933.2 | 11801 | g209 | i0 | 99.1 | 2.91125954198473 | 678 | 6 | 97 | 0 | 2044 | 11 | 658 | 1335 | NP_057933.2 Pr180 [Moloney murine leukemia virus] | diamond | 6102 | 1362 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu |
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);;