RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA217180" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA217180 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
4194167 4194167 PRJNA217180_P_NODE_12564_length_167_cov_0.864407_g12464_i0 PRJNA217180 12564 167 0.864407 1.44355969 Caudoviricetes sp. 2832643 Viruses Viruses 209 7.85e-50   NTclustered gi|2906149211|gb|PQ646444.1| 2832643 g12464 i0 89.222 1 167 18 100 0 1 167 11558 11724 MAG: Caudoviricetes sp. isolate k127_3058080 genomic sequence blastn 167 209 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
6744717 6744717 PRJNA217180_P_NODE_12626_length_167_cov_0.864407_g12526_i0 PRJNA217180 12626 167 0.864407 1.44355969 Maltschvirus maltsch 2956182 Viruses Viruses 130 6.29e-26   NTclustered gi|1839221816|emb|LR797096.1| 2100421 g12526 i0 90 2.9940119760479 100 10 60 0 66 165 37340 37241 uncultured Caudovirales phage genome assembly blastn 500 130 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
11845665 11845665 PRJNA217180_P_NODE_14110_length_164_cov_0.886957_g14010_i0 PRJNA217180 14110 164 0.886957 1.45460948 Maltschvirus maltsch 2956182 Viruses Viruses 291 2.67e-74   NTclustered gi|1839227244|emb|LR797178.1| 2100421 g14010 i0 98.773 0.99390243902439 163 2 99 0 1 163 12116 11954 uncultured Caudovirales phage genome assembly blastn 163 291 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
15669884 15669884 PRJNA217180_P_NODE_13073_length_166_cov_0.871795_g12973_i0 PRJNA217180 13073 166 0.871795 1.4471797 Maltschvirus maltsch 2956182 Viruses Viruses 265 1.64e-66   NTclustered gi|1839141244|emb|LR796211.1| 2100421 g12973 i0 95.732 0.987951807228916 164 7 99 0 1 164 12670 12507 uncultured Caudovirales phage genome assembly blastn 164 265 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
20768586 20768586 PRJNA217180_P_NODE_10197_length_185_cov_1.338235_g10097_i0 PRJNA217180 10197 185 1.338235 2.47573475 Caudoviricetes sp. 2832643 Viruses Viruses 52.8 0.016   NTclustered gi|2058128472|tpg|BK034062.1| 2832643 g10097 i0 100 0.151351351351351 28 0 15 0 1 28 24678 24651 MAG TPA_asm: Caudoviricetes sp. isolate ctw8r9, partial genome blastn 28 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24593373 24593373 PRJNA217180_P_NODE_9780_length_188_cov_1.467626_g9680_i0 PRJNA217180 9780 188 1.467626 2.75913688 Caudoviricetes sp. 2832643 Viruses Viruses 196 7.029999999999999e-46   NTclustered gi|2054791465|tpg|BK049930.1| 2832643 g9680 i0 92.701 3.8936170212766 137 9 73 1 3 139 3251 3116 MAG TPA_asm: Caudoviricetes sp. isolate ct7mf1, partial genome blastn 732 196 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes 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);;