RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA379145" and tax_phylum = "Kitrinoviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kitrinoviricota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA379145 · 7 ✖

analysis 1

  • blastn · 7 ✖

tax_clade 0

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
2349358 2349358 PRJNA379145_P_NODE_51162_length_227_cov_1.716495_g49008_i0 PRJNA379145 51162 227 1.716495 3.89644365 Potexvirus 12176 Viruses Viruses 418 1.7299999999999996e-112   NTclustered gi|1839430140|gb|MK860513.1| 112229 g49008 i0 100 99.5594713656388 226 0 99 0 1 226 739 964 Pepino mosaic virus isolate MU14_4.19a_Mo TGB1 protein, TGB2 protein, TGB3 protein, and CP protein genes, complete cds blastn 22600 418 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus pepini
2951321 2951321 PRJNA379145_P_NODE_23343_length_526_cov_1.933063_g21360_i0 PRJNA379145 23343 526 1.933063 10.16791138 Martellivirales sp. 2809552 Viruses Viruses 54.7 0.014   NTclustered gi|2647548574|gb|OR843378.1| 2809552 g21360 i0 100 0.0551330798479087 29 0 6 0 245 273 12322 12294 Martellivirales sp. strain MR233-17E/76 polyprotein gene, partial cds blastn 29 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales     Martellivirales sp.
6177009 6177009 PRJNA379145_P_NODE_63625_length_177_cov_1.006944_g61471_i0 PRJNA379145 63625 177 1.006944 1.78229088 Potexvirus 12176 Viruses Viruses 311 2.23e-80   NTclustered gi|1805119874|gb|MN038406.1| 112229 g61471 i0 98.305 93.9604519774011 177 3 100 0 1 177 2374 2198 Pepino mosaic virus strain MZ3, complete genome blastn 16631 311 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus pepini
13154683 13154683 PRJNA379145_P_NODE_45811_length_259_cov_1.420354_g43658_i0 PRJNA379145 45811 259 1.420354 3.67871686 Potexvirus pepini 3433856 Viruses Viruses 468 1.98e-127   NTclustered gi|148283741|gb|EF408821.3| 112229 g43658 i0 99.228 96.030888030888 259 2 100 0 1 259 19 277 Pepino mosaic virus isolate PepMV-PK, complete genome blastn 24872 468 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus pepini
15703846 15703846 PRJNA379145_P_NODE_67953_length_165_cov_1.037879_g65799_i0 PRJNA379145 67953 165 1.037879 1.71250035 Tobamovirus tabaci 3432891 Viruses Viruses 294 2.08e-75   NTclustered gi|2813525801|dbj|LC846392.1| 12242 g65799 i0 98.788 100.012121212121 165 2 100 0 1 165 3948 3784 Tobacco mosaic virus TMV-Du-CNU1 genomic RNA, complete genome blastn 16502 294 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tabaci
19526992 19526992 PRJNA379145_P_NODE_67916_length_165_cov_1.136364_g65762_i0 PRJNA379145 67916 165 1.136364 1.8750006 Tobamovirus tabaci 3432891 Viruses Viruses 300 4.46e-77   NTclustered gi|388240225|emb|HE818435.1| 12242 g65762 i0 99.394 99.9333333333333 165 1 100 0 1 165 4278 4442 Tobacco mosaic virus isolate Ludian, complete genome blastn 16489 300 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tabaci
20802393 20802393 PRJNA379145_P_NODE_47037_length_251_cov_1.866972_g44884_i0 PRJNA379145 47037 251 1.866972 4.68609972 Ripothoz virus 3131336 Viruses Viruses 130 1.02e-25   NTclustered gi|2717322249|gb|PP173638.1| 3131336 g44884 i0 96.25 1.51792828685259 80 2 31 1 19 97 5631 5552 MAG: Ripothoz virus isolate MP3_k141_314104 genomic sequence blastn 381 130 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales     Ripothoz virus

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;