RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn" and tax_clade = "Cruciviruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Cruciviruses · 6 ✖

analysis 1

  • blastn · 6 ✖

tax_phylum 0

tax_kingdom 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
292344 292344 PRJNA1148190_P_NODE_212261_length_367_cov_1.486395_g201091_i0 PRJNA1148190 212261 367 1.486395 5.45506965 Crucivirus-295 2761264 Viruses Viruses 56.5 0.003   NTclustered gi|1886984574|gb|MT263594.1| 2761264 g201091 i0 96.97 0.0899182561307902 33 1 9 0 217 249 1228 1196 Crucivirus-295 isolate BS_189, complete genome blastn 33 56.5 1 Viruses Cruciviruses             Crucivirus-295
14156875 14156875 PRJEB64798_P_NODE_244412_length_153_cov_13.798077_g242646_i0 PRJEB64798 244412 153 13.798077 21.11105781 Cruciviridae sp. 1955495 Viruses Viruses 241 2.49e-59   NTclustered gi|1150480486|gb|KX388499.1| 1955495 g242646 i0 95.946 1.71895424836601 148 6 97 0 1 148 3368 3221 Cruciviridae sp. isolate CRUV-20-B genomic sequence blastn 263 241 1 Viruses Cruciviruses             Cruciviridae sp.
14458731 14458731 PRJNA432257_S_NODE_58772_length_217_cov_134.261111_g58391_i0 PRJNA432257 58772 217 134.261111 291.34661087 Crucivirus sp. 2569971 Viruses Viruses 313 7.96e-81   NTclustered gi|1859808830|gb|MT478455.1| 2569971 g58391 i0 97.79 0.834101382488479 181 4 83 0 2 182 800 620 Crucivirus sp. isolate Crucivirus-535 000452_virusbaton, complete genome blastn 181 313 1 Viruses Cruciviruses             Crucivirus sp.
14740813 14740813 PRJNA725806_P_NODE_132132_length_177_cov_6.800000_g131830_i0 PRJNA725806 132132 177 6.8 12.036 Crucivirus-119 2761219 Viruses Viruses 52.8 0.015   NTclustered gi|1886984420|gb|MT263550.1| 2761219 g131830 i0 100 0.15819209039548 28 0 16 0 129 156 1450 1477 Crucivirus-119 isolate SR1_16099, complete genome blastn 28 52.8 1 Viruses Cruciviruses             Crucivirus-119
21609219 21609219 PRJNA773247_P_NODE_30557_length_250_cov_2.372881_g30473_i0 PRJNA773247 30557 250 2.372881 5.9322025 Circovirus 39725 Viruses Viruses 457 4.1099999999999985e-124   NTclustered gi|2717314883|gb|OR224871.1| 2569971 g30473 i0 99.6 3 250 1 100 0 1 250 3727 3478 Crucivirus sp. isolate C23N3/AU, complete genome blastn 750 457 1 Viruses Cruciviruses             Crucivirus sp.
21831326 21831326 PRJNA1008624_P_NODE_37498_length_155_cov_3.632075_g37310_i0 PRJNA1008624 37498 155 3.632075 5.62971625 Crucivirus-like circular genetic element-85 2761503 Viruses Viruses 209 7.15e-50   NTclustered gi|1886984940|gb|MT263538.1| 2761503 g37310 i0 94.203 0.890322580645161 138 6 88 2 1 137 137 1 Crucivirus-like circular genetic element-85 isolate LSCO_103299, complete sequence blastn 138 209 1 Viruses Cruciviruses             Crucivirus-like circular genetic element-85

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