RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB2925" 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

  • PRJEB2925 · 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
5128458 5128458 PRJEB2925_P_NODE_14145_length_273_cov_1.798319_g12867_i0 PRJEB2925 14145 273 1.798319 4.90941087 Caudoviricetes sp. 2832643 Viruses Viruses 141 3.98e-39   NR XOR79776.1 2832643 g12867 i0 82.6 0.945054945054945 86 15 94.5 0 260 3 1 86 XOR79776.1 MAG: N-acetylmuramidase [Caudoviricetes sp.] diamond 258 141 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
22664934 22664934 PRJEB2925_P_NODE_11018_length_337_cov_1.897351_g9744_i0 PRJEB2925 11018 337 1.897351 6.39407287 Caudoviricetes sp. 2832643 Viruses Viruses 70.9 1.52e-11   NR XOR07127.1 2832643 g9744 i0 59.4 1.22848664688427 69 21 55.2 1 3 188 556 624 XOR07127.1 MAG: methyltransferase [Caudoviricetes sp.] diamond 414 70.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27602141 27602141 PRJEB2925_P_NODE_10604_length_349_cov_1.656051_g9332_i0 PRJEB2925 10604 349 1.656051 5.77961799 Caudoviricetes sp. 2832643 Viruses Viruses 66.2 7.06e-10   NR XOR69375.1 2832643 g9332 i0 38.8 0.885386819484241 103 57 86 4 37 336 158 257 XOR69375.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 309 66.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29843722 29843722 PRJEB2925_P_NODE_10591_length_349_cov_2.289809_g9319_i0 PRJEB2925 10591 349 2.289809 7.99143341 Caudoviricetes sp. 2832643 Viruses Viruses 212 1.3999999999999996e-68   NR DAJ56265.1 2832643 g9319 i0 87.9 1.99426934097421 116 14 99.7 0 349 2 11 126 DAJ56265.1 MAG TPA: putative nuclease [Caudoviricetes sp.] diamond 696 212 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30286432 30286432 PRJEB2925_P_NODE_12112_length_310_cov_2.909091_g10836_i0 PRJEB2925 12112 310 2.909091 9.0181821 Caudoviricetes sp. 2832643 Viruses Viruses 104 1.65e-24   NR XOR79776.1 2832643 g10836 i0 77.2 0.551612903225806 57 12 54.2 1 308 141 84 140 XOR79776.1 MAG: N-acetylmuramidase [Caudoviricetes sp.] diamond 171 104 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31518706 31518706 PRJEB2925_P_NODE_12856_length_295_cov_2.057692_g11579_i0 PRJEB2925 12856 295 2.057692 6.0701914 Caudoviricetes sp. 2832643 Viruses Viruses 85.9 7.71e-20   NR DAJ56266.1 2832643 g11579 i0 86.7 0.457627118644068 45 6 45.8 0 287 153 1 45 DAJ56266.1 MAG TPA: putative RNA-binding protein [Caudoviricetes sp.] diamond 135 85.9 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);;