RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA312615" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 6 ✖

bioproject 1

  • PRJNA312615 · 6 ✖

analysis 1

  • diamond · 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
2929458 2929458 PRJNA312615_P_NODE_7583_length_446_cov_1.410579_g7433_i0 PRJNA312615 7583 446 1.410579 6.29118234 Campylobacter phage CJLB-4 2781358 Viruses Viruses 56.2 1.31e-7   NR QPB10331.1 2781358 g7433 i0 66.7 0.302690582959641 45 15 30.3 0 290 156 10 54 QPB10331.1 hypothetical protein [Campylobacter phage CJLB-4] diamond 135 56.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Lambdavirus Campylobacter phage CJLB-4
28779468 28779468 PRJNA312615_P_NODE_6387_length_482_cov_1.279446_g6239_i0 PRJNA312615 6387 482 1.279446 6.16692972 Enterobacteria phage IME1 1090133 Viruses Viruses 117 4.56e-29   NR YP_007004316.1 1090133 g6239 i0 46.5 0.79045643153527 127 68 79 0 480 100 27 153 YP_007004316.1 regulatory protein Q [Enterobacteria phage IME10] diamond 381 117 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Lederbergvirus Enterobacteria phage IME10
28937567 28937567 PRJNA312615_P_NODE_14148_length_327_cov_1.107914_g13997_i0 PRJNA312615 14148 327 1.107914 3.62287878 Escherichia phage Lambda 2681611 Viruses Viruses 71.2 6.81e-14   NR NP_040643.1 2681611 g13997 i0 46.9 0.587155963302752 64 34 58.7 0 120 311 1 64 NP_040643.1 hypothetical protein lambdap73 [Escherichia phage Lambda] diamond 192 71.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Lambdavirus Lambdavirus lambda
29726543 29726543 PRJNA312615_P_NODE_17690_length_291_cov_1.140496_g17539_i0 PRJNA312615 17690 291 1.140496 3.31884336 Caudoviricetes sp. 2832643 Viruses Viruses 91.7 1.48e-21   NR DAH93386.1 2832643 g17539 i0 69.7 1.36082474226804 66 20 68 0 290 93 48 113 DAH93386.1 MAG TPA: hypothetical protein, partial [Caudoviricetes sp.] diamond 396 91.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30737663 30737663 PRJNA312615_P_NODE_56954_length_163_cov_0.894737_g56803_i0 PRJNA312615 56954 163 0.894737 1.45842131 uncultured Caudovirales phage 2100421 Viruses Viruses 94.7 3.78e-21   NR CAB4147586.1 2100421 g56803 i0 81.1 3.92024539877301 53 10 97.5 0 5 163 269 321 CAB4147586.1 phage_term_2, phage terminase, large subunit, PBSX family [uncultured Caudovirales phage] diamond 639 94.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
32729466 32729466 PRJNA312615_P_NODE_19580_length_275_cov_2.030973_g19429_i0 PRJNA312615 19580 275 2.030973 5.58517575 Caudoviricetes sp. 2832643 Viruses Viruses 64.3 2.52e-11   NR DAI56203.1 2832643 g19429 i0 66.7 0.523636363636364 48 16 52.4 0 192 49 24 71 DAI56203.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 144 64.3 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);;