RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJEB20058" and tax_phylum = "Phixviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Phixviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJEB20058 · 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
25651372 25651372 PRJEB20058_P_NODE_161106_length_298_cov_8.658228_g158283_i0 PRJEB20058 161106 298 8.658228 25.80151944 Microviridae sp. 2202644 Viruses Viruses 139 2.07e-28   NTclustered gi|1444873752|gb|MH572284.1| 2202644 g158283 i0 87.5 2.71812080536913 120 15 40 0 1 120 961 842 Microviridae sp. isolate SD_SC_75, complete genome blastn 810 139 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
25656359 25656359 PRJEB20058_P_NODE_52242_length_581_cov_204.715385_g49505_i0 PRJEB20058 52242 581 204.715385 1189.39638685 Microvirus sp. 2202559 Viruses Viruses 289 4.019999999999999e-73   NTclustered gi|1832332398|gb|MT310348.1| 2202559 g49505 i0 82.687 1.15318416523236 335 49 57 9 1 330 3268 3598 MAG: Microvirus sp. isolate 1712115_39, complete genome blastn 670 289 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
25921738 25921738 PRJEB20058_P_NODE_11580_length_1221_cov_25.899138_g10009_i0 PRJEB20058 11580 1221 25.899138 316.22847498 Petitvirales sp. 2833078 Viruses Viruses 880 0   NTclustered gi|2906152495|gb|PQ646668.1| 2833078 g10009 i0 80.572 0.973791973791974 1189 191 97 26 24 1205 1671 516 MAG: Petitvirales sp. isolate k127_3052916 genomic sequence blastn 1189 880 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales     Petitvirales sp.
26156627 26156627 PRJEB20058_P_NODE_11917_length_1202_cov_18.503944_g10314_i0 PRJEB20058 11917 1202 18.503944 222.41740688 Viruses 10239 Viruses Viruses 863 0   NTclustered gi|2906156293|gb|PQ646937.1| 2202644 g10314 i0 80.532 2.45008319467554 1166 191 97 19 20 1181 4207 5340 MAG: Microviridae sp. isolate k127_2873311 genomic sequence blastn 2945 863 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
26472910 26472910 PRJEB20058_P_NODE_49112_length_600_cov_2.237477_g46395_i0 PRJEB20058 49112 600 2.237477 13.424862 Microviridae sp. 2202644 Viruses Viruses 196 2.59e-45   NTclustered gi|2906156293|gb|PQ646937.1| 2202644 g46395 i0 78.457 0.518333333333333 311 60 51 7 158 462 9421 9112 MAG: Microviridae sp. isolate k127_2873311 genomic sequence blastn 311 196 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.

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