contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA674050" and tax_clade = "unclassified ssRNA positive-strand 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 644288 | 644288 | PRJNA674050_P_NODE_4301_length_364_cov_2.646048_g4098_i0 | PRJNA674050 | 4301 | 364 | 2.646048 | 9.63161472 | Drosophila A virus | 595895 | Viruses | Viruses | 623 | 5.839999999999999e-174 | NTclustered | gi|253761971|ref|NC_012958.1| | 595895 | g4098 | i0 | 97.527 | 18.760989010989 | 364 | 9 | 100 | 0 | 1 | 364 | 4670 | 4307 | Drosophila A virus, complete genome | blastn | 6829 | 623 | 1 | Viruses | unclassified ssRNA positive-strand viruses | Drosophila A virus | |||||||
| 8296586 | 8296586 | PRJNA674050_P_NODE_1227_length_604_cov_1.868173_g1030_i0 | PRJNA674050 | 1227 | 604 | 1.868173 | 11.28376492 | Drosophila A virus | 595895 | Viruses | Viruses | 1057 | 0 | NTclustered | gi|822478150|gb|KP969950.1| | 595895 | g1030 | i0 | 98.339 | 30.9950331125828 | 602 | 10 | 99 | 0 | 1 | 602 | 2046 | 1445 | Drosophila A virus isolate Qdelta_DrosophilaA RNA-dependent RNA polymerase and capsid precursor, genes, partial cds | blastn | 18721 | 1057 | 1 | Viruses | unclassified ssRNA positive-strand viruses | Drosophila A virus | |||||||
| 12123728 | 12123728 | PRJNA674050_P_NODE_6210_length_333_cov_1.773077_g6007_i0 | PRJNA674050 | 6210 | 333 | 1.773077 | 5.90434641 | Drosophila A virus | 595895 | Viruses | Viruses | 571 | 1.95e-158 | NTclustered | gi|822478144|gb|KP969948.1| | 595895 | g6007 | i0 | 97.612 | 25.1501501501502 | 335 | 5 | 99 | 2 | 2 | 333 | 640 | 974 | Drosophila A virus isolate XIB_DrosophilaA RNA-dependent RNA polymerase gene, complete cds; and capsid precursor, gene, partial cds | blastn | 8375 | 571 | 1 | Viruses | unclassified ssRNA positive-strand viruses | Drosophila A virus | |||||||
| 17221535 | 17221535 | PRJNA674050_P_NODE_1774_length_501_cov_2.385514_g1575_i0 | PRJNA674050 | 1774 | 501 | 2.385514 | 11.95142514 | Drosophila A virus | 595895 | Viruses | Viruses | 887 | 0 | NTclustered | gi|822478147|gb|KP969949.1| | 595895 | g1575 | i0 | 98.603 | 31.3532934131737 | 501 | 7 | 100 | 0 | 1 | 501 | 3104 | 2604 | Drosophila A virus isolate delta11_DrosophilaA RNA-dependent RNA polymerase and capsid precursor, genes, partial cds | blastn | 15708 | 887 | 1 | Viruses | unclassified ssRNA positive-strand viruses | Drosophila A virus | |||||||
| 18496840 | 18496840 | PRJNA674050_P_NODE_715_length_829_cov_3.039683_g546_i0 | PRJNA674050 | 715 | 829 | 3.039683 | 25.19897207 | Drosophila A virus | 595895 | Viruses | Viruses | 1428 | 0 | NTclustered | gi|822478150|gb|KP969950.1| | 595895 | g546 | i0 | 97.708 | 36.8214716525935 | 829 | 19 | 100 | 0 | 1 | 829 | 4249 | 3421 | Drosophila A virus isolate Qdelta_DrosophilaA RNA-dependent RNA polymerase and capsid precursor, genes, partial cds | blastn | 30525 | 1428 | 1 | Viruses | unclassified ssRNA positive-strand viruses | Drosophila A virus | |||||||
| 22321763 | 22321763 | PRJNA674050_P_NODE_6738_length_327_cov_2.960630_g6535_i0 | PRJNA674050 | 6738 | 327 | 2.96063 | 9.6812601 | Drosophila A virus | 595895 | Viruses | Viruses | 569 | 6.869999999999998e-158 | NTclustered | gi|822478150|gb|KP969950.1| | 595895 | g6535 | i0 | 98.16 | 19.7584097859327 | 326 | 6 | 99 | 0 | 2 | 327 | 2613 | 2288 | Drosophila A virus isolate Qdelta_DrosophilaA RNA-dependent RNA polymerase and capsid precursor, genes, partial cds | blastn | 6461 | 569 | 1 | Viruses | unclassified ssRNA positive-strand viruses | Drosophila A virus | |||||||
| 22321817 | 22321817 | PRJNA674050_P_NODE_8358_length_312_cov_2.096234_g8155_i0 | PRJNA674050 | 8358 | 312 | 2.096234 | 6.54025008 | Drosophila A virus | 595895 | Viruses | Viruses | 553 | 6.559999999999998e-153 | NTclustered | gi|822478147|gb|KP969949.1| | 595895 | g8155 | i0 | 98.714 | 39.8717948717949 | 311 | 4 | 99 | 0 | 2 | 312 | 3161 | 3471 | Drosophila A virus isolate delta11_DrosophilaA RNA-dependent RNA polymerase and capsid precursor, genes, partial cds | blastn | 12440 | 553 | 1 | Viruses | unclassified ssRNA positive-strand viruses | Drosophila A virus |
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);;