RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA939369" and tax_phylum = "Kitrinoviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kitrinoviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA939369 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
21316570 21316570 PRJNA939369_S_NODE_61757_length_248_cov_0.880000_g61340_i0 PRJNA939369 61757 248 0.88 2.1824 Orthoflavivirus denguei 3052464 Viruses Viruses 52.8 0.022   NTclustered gi|2126762592|gb|OL314736.1| 11070 g61340 i0 100 0.67741935483871 28 0 11 0 57 84 9735 9762 Dengue virus 4 isolate JBB-007, complete genome blastn 168 52.8 1 Viruses   Orthornavirae Kitrinoviricota Flasuviricetes Amarillovirales Flaviviridae Orthoflavivirus Orthoflavivirus denguei
21316707 21316707 PRJNA939369_S_NODE_79837_length_213_cov_12.328571_g79420_i0 PRJNA939369 79837 213 12.328571 26.25985623 Carlavirus latensdianthi 3427766 Viruses Viruses 54.7 0.005   NTclustered gi|1995060321|gb|MN450069.1| 12164 g79420 i0 100 0.7981220657277 29 0 14 0 1 29 13 41 Carnation latent virus isolate KL, complete genome blastn 170 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
22591253 22591253 PRJNA939369_S_NODE_18578_length_345_cov_17.915441_g18161_i0 PRJNA939369 18578 345 17.915441 61.80827145 Carlavirus latensdianthi 3427766 Viruses Viruses 56.5 0.003   NTclustered gi|1995060321|gb|MN450069.1| 12164 g18161 i0 94.444 0.510144927536232 36 2 10 0 310 345 48 13 Carnation latent virus isolate KL, complete genome blastn 176 56.5 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
25140423 25140423 PRJNA939369_S_NODE_28400_length_305_cov_2.383621_g27983_i0 PRJNA939369 28400 305 2.383621 7.27004405 Carlavirus latensdianthi 3427766 Viruses Viruses 54.7 0.008   NTclustered gi|1995060321|gb|MN450069.1| 12164 g27983 i0 100 0.462295081967213 29 0 10 0 1 29 13 41 Carnation latent virus isolate KL, complete genome blastn 141 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi

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