RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA666695" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA666695 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
15935456 15935456 PRJNA666695_S_NODE_50013_length_293_cov_5.341270_g48919_i0 PRJNA666695 50013 293 5.34127 15.6499211 Caudoviricetes sp. 2832643 Viruses Viruses 115 1.28e-27   NR XOS11565.1 2832643 g48919 i0 67.5 0.849829351535836 83 27 85 0 2 250 55 137 XOS11565.1 MAG: putative tail fiber protein [Caudoviricetes sp.] diamond 249 115 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26891880 26891880 PRJNA666695_S_NODE_135841_length_188_cov_1.387755_g134747_i0 PRJNA666695 135841 188 1.387755 2.6089794 Pseudomonas phage Rollin 3079657 Viruses Viruses 82 8.4e-19   NR WNV50608.1 3079657 g134747 i0 71.9 0.909574468085106 57 15 89.4 1 170 3 13 69 WNV50608.1 hypothetical protein [Pseudomonas phage Rollin] diamond 171 82 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage Rollin
27429439 27429439 PRJNA666695_S_NODE_53443_length_286_cov_2.253061_g52349_i0 PRJNA666695 53443 286 2.253061 6.44375446 Caudoviricetes sp. 2832643 Viruses Viruses 95.1 9.66e-23   NR XOS11578.1 2832643 g52349 i0 73.8 1.87762237762238 61 16 64 0 185 3 1 61 XOS11578.1 MAG: hypothetical protein MSP0146_130 [Caudoviricetes sp.] diamond 537 95.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27713696 27713696 PRJNA666695_S_NODE_103664_length_216_cov_1.708571_g102570_i0 PRJNA666695 103664 216 1.708571 3.69051336 Caudoviricetes sp. 2832643 Viruses Viruses 42 0.0495   NR DAL38463.1 2832643 g102570 i0 55.3 0.527777777777778 38 17 52.8 0 166 53 669 706 DAL38463.1 MAG TPA_asm: hypothetical protein [Caudoviricetes sp.] diamond 114 42 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28660621 28660621 PRJNA666695_S_NODE_148587_length_178_cov_3.357664_g147493_i0 PRJNA666695 148587 178 3.357664 5.97664192 Caudoviricetes sp. 2832643 Viruses Viruses 63.2 3.44e-10   NR DAQ55469.1 2832643 g147493 i0 50.8 1.06179775280899 63 23 96.1 2 177 7 50 110 DAQ55469.1 MAG TPA: Thrombospondin type 1 repeat protein [Caudoviricetes sp.] diamond 189 63.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28944977 28944977 PRJNA666695_S_NODE_13508_length_483_cov_26.183258_g12425_i0 PRJNA666695 13508 483 26.183258 126.46513614 Caudoviricetes sp. 2832643 Viruses Viruses 108 1.34e-27   NR XOS03551.1 2832643 g12425 i0 71.8 0.440993788819876 71 20 44.1 0 171 383 1 71 XOS03551.1 MAG: putative site-specific phage recombinase [Caudoviricetes sp.] diamond 213 108 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30018568 30018568 PRJNA666695_S_NODE_98911_length_221_cov_1.533333_g97817_i0 PRJNA666695 98911 221 1.533333 3.38866593 Caudoviricetes sp. 2832643 Viruses Viruses 39.3 0.0492   NR DAQ40503.1 2832643 g97817 i0 60.9 0.312217194570136 23 9 31.2 0 106 38 16 38 DAQ40503.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 69 39.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30113070 30113070 PRJNA666695_S_NODE_91092_length_229_cov_3.180851_g89998_i0 PRJNA666695 91092 229 3.180851 7.28414879 uncultured Caudovirales phage 2100421 Viruses Viruses 51.6 1.49e-5   NR CAB4196898.1 2100421 g89998 i0 35.2 0.930131004366812 71 45 93 1 229 17 34 103 CAB4196898.1 Polymerase, nucleotidyl transferase domain containing protein [uncultured Caudovirales phage] diamond 213 51.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
30523811 30523811 PRJNA666695_S_NODE_13013_length_491_cov_3.188889_g11931_i0 PRJNA666695 13013 491 3.188889 15.65744499 Pseudomonas phage PS-1 1573458 Viruses Viruses 203 8.850000000000001e-64   NR YP_009222842.1 1573458 g11931 i0 91.4 0.641547861507128 105 9 64.2 0 175 489 1 105 YP_009222842.1 virion structural protein [Pseudomonas phage PS-1] diamond 315 203 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage PS-1
30839848 30839848 PRJNA666695_S_NODE_72194_length_253_cov_3.806604_g71100_i0 PRJNA666695 72194 253 3.806604 9.63070812 Caudoviricetes sp. 2832643 Viruses Viruses 65.5 1.76e-11   NR XOR17978.1 2832643 g71100 i0 52.9 3.09486166007905 68 29 78.3 2 226 29 45 111 XOR17978.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 783 65.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31503780 31503780 PRJNA666695_S_NODE_16176_length_450_cov_4.457213_g15085_i0 PRJNA666695 16176 450 4.457213 20.0574585 Caudoviricetes sp. 2832643 Viruses Viruses 136 1.7999999999999998e-35   NR XOR26816.1 2832643 g15085 i0 49 0.993333333333333 149 75 99.3 1 448 2 50 197 XOR26816.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 447 136 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32421158 32421158 PRJNA666695_S_NODE_21459_length_404_cov_5.239669_g20366_i0 PRJNA666695 21459 404 5.239669 21.16826276 Caudoviricetes sp. 2832643 Viruses Viruses 119 3.05e-28   NR XOQ95024.1 2832643 g20366 i0 47.3 1.9084158415841601 129 66 95.8 2 1 387 59 185 XOQ95024.1 MAG: hypothetical protein, partial [Caudoviricetes sp.] diamond 771 119 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);;