RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJEB81171" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 5 ✖

bioproject 1

  • PRJEB81171 · 5 ✖

analysis 1

  • diamond · 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
28448365 28448365 PRJEB81171_P_NODE_7166_length_260_cov_1.668449_g7039_i0 PRJEB81171 7166 260 1.668449 4.3379674 Viruses 10239 Viruses Viruses 54.7 5.95e-7   NR YP_006560771.1 1132026 g7039 i0 48.1 1.26923076923077 54 25 58.8 1 218 66 21 74 YP_006560771.1 tail completion or Neck1 protein [Burkholderia phage vB_BceS_KL1] diamond 330 54.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Kilunavirus Kilunavirus KL1
28921641 28921641 PRJEB81171_P_NODE_6368_length_273_cov_1.560000_g6241_i0 PRJEB81171 6368 273 1.56 4.2588 Chuvivirus 2842604 Viruses Viruses 130 2.31e-33   NR WET19887.1 2842604 g6241 i0 65.6 1.97802197802198 90 31 98.9 0 272 3 303 392 WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] diamond 540 130 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Chuvivirus Chuvivirus
29560389 29560389 PRJEB81171_P_NODE_5710_length_283_cov_1.485714_g5583_i0 PRJEB81171 5710 283 1.485714 4.20457062 Rhodococcus phage Finch 2094144 Viruses Viruses 153 4.02e-41   NR YP_010059023.1 2094144 g5583 i0 71.3 0.996466431095406 94 27 99.6 0 2 283 439 532 YP_010059023.1 terminase [Rhodococcus phage Finch] diamond 282 153 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Finchvirus Finchvirus finch
32088978 32088978 PRJEB81171_P_NODE_9318_length_245_cov_0.906977_g9191_i0 PRJEB81171 9318 245 0.906977 2.22209365 uncultured Caudovirales phage 2100421 Viruses Viruses 70.9 4.51e-12   NR CAB4170702.1 2100421 g9191 i0 81.1 0.906122448979592 37 7 45.3 0 111 1 1 37 CAB4170702.1 major capsid protein [uncultured Caudovirales phage] diamond 222 70.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
32088979 32088979 PRJEB81171_P_NODE_9878_length_242_cov_1.781065_g9751_i0 PRJEB81171 9878 242 1.781065 4.3101773 Caudoviricetes sp. 2832643 Viruses Viruses 107 5.66e-26   NR XOR47457.1 2832643 g9751 i0 62 0.979338842975207 79 30 97.9 0 239 3 10 88 XOR47457.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 237 107 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);;