RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA695140" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA695140 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
6285522 6285522 PRJNA695140_S_NODE_4085_length_259_cov_1.761261_g3904_i0 PRJNA695140 4085 259 1.761261 4.56166599 Biquartavirus 1912143 Viruses Viruses 148 2.9199999999999998e-31   NTclustered gi|2320097220|gb|MZ768930.1| 2973715 g3904 i0 77.47 11.969111969112 253 53 97 4 9 259 1085 835 Aeromonas phage vB_AehM_DM1 major capsid protein gene, complete cds blastn 3100 148 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Straboviridae Biquartavirus Aeromonas phage vB_AehM_DM1
16484479 16484479 PRJNA695140_S_NODE_9773_length_170_cov_2.037594_g9592_i0 PRJNA695140 9773 170 2.037594 3.4639098 Straboviridae 2946170 Viruses Viruses 115 1.79e-21   NTclustered gi|2223880102|gb|ON042478.1| 2907222 g9592 i0 95.775 42.1117647058824 71 3 42 0 100 170 150515 150445 Aeromonas phage AhFM11, partial genome blastn 7159 115 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Straboviridae Biquartavirus Aeromonas phage AhFM11
21078531 21078531 PRJNA695140_S_NODE_4997_length_235_cov_1.545455_g4816_i0 PRJNA695140 4997 235 1.545455 3.63181925 Aquaneticvirus ApT65 3154060 Viruses Viruses 115 2.6500000000000003e-21   NTclustered gi|2347352278|gb|OP491958.1| 2982914 g4816 i0 90.909 6.05106382978723 88 5 37 3 52 137 45685 45771 Aeromonas phage APT65, complete genome blastn 1422 115 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Aquaneticvirus Aquaneticvirus ApT65

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