RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1041773" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 5 ✖

bioproject 1

  • PRJNA1041773 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
170438 170438 PRJNA1041773_P_NODE_51661_length_298_cov_1.346667_g51328_i0 PRJNA1041773 51661 298 1.346667 4.01306766 Wheat associated tobamo-like virus 2908237 Viruses Viruses 121 7.489999999999999e-23   NTclustered gi|2175329316|gb|OK573480.1| 2908237 g51328 i0 84.426 0.409395973154362 122 19 41 0 177 298 10065 9944 Wheat associated tobamo-like virus methyltransferase gene, partial cds; and RNA dependent RNA polymerase, DEAD-like helicase, and hypothetical protein genes, complete cds blastn 122 121 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Wheat associated tobamo-like virus
5273335 5273335 PRJNA1041773_P_NODE_56825_length_286_cov_1.446009_g56492_i0 PRJNA1041773 56825 286 1.446009 4.13558574 Wheat associated tobamo-like virus 2908237 Viruses Viruses 396 1.06e-105   NTclustered gi|2175329316|gb|OK573480.1| 2908237 g56492 i0 92.419 0.968531468531469 277 21 97 0 1 277 9217 9493 Wheat associated tobamo-like virus methyltransferase gene, partial cds; and RNA dependent RNA polymerase, DEAD-like helicase, and hypothetical protein genes, complete cds blastn 277 396 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Wheat associated tobamo-like virus
11649459 11649459 PRJNA1041773_P_NODE_87830_length_246_cov_6.080925_g87497_i0 PRJNA1041773 87830 246 6.080925 14.9590755 Ripablet virus 3130212 Viruses Viruses 80.5 1.02e-10   NTclustered gi|2717319164|gb|PP172514.1| 3130212 g87497 i0 83.333 0.365853658536585 90 12 36 3 37 124 185 97 MAG: Ripablet virus isolate DRCP1_k141_9677 genomic sequence blastn 90 80.5 1 Viruses   Orthornavirae Lenarviricota Leviviricetes       Ripablet virus
15473413 15473413 PRJNA1041773_P_NODE_63193_length_274_cov_1.149254_g62860_i0 PRJNA1041773 63193 274 1.149254 3.14895596 Enterovirus jesimi 3428512 Viruses Viruses 52.8 0.025   NTclustered gi|2054341630|gb|MZ312494.1| 1330521 g62860 i0 100 0.102189781021898 28 0 10 0 160 187 4788 4761 Enterovirus J strain NOLA-3 polyprotein gene, complete cds blastn 28 52.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Enterovirus Enterovirus jesimi
16748099 16748099 PRJNA1041773_P_NODE_99574_length_242_cov_0.863905_g99241_i0 PRJNA1041773 99574 242 0.863905 2.0906501 Camellia chlorotic ringspot virus 2802541 Viruses Viruses 52.8 0.022   NTclustered gi|1812584275|gb|MT040101.1| 2802541 g99241 i0 100 0.115702479338843 28 0 12 0 22 49 536 509 Camellia chlorotic ringspot virus isolate JX1 clone C162 segment RNA4, complete sequence blastn 28 52.8 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes Elliovirales Fimoviridae   Camellia chlorotic ringspot 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);;