RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA1059246" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1059246 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
27319981 27319981 PRJNA1059246_P_NODE_51043_length_286_cov_1.281690_g50417_i0 PRJNA1059246 51043 286 1.28169 3.6656334 Caudoviricetes sp. 2832643 Viruses Viruses 70.9 9.67e-14   NR XOS02355.1 2832643 g50417 i0 59.6 0.545454545454545 52 21 54.5 0 130 285 1 52 XOS02355.1 MAG: hypothetical protein MSP1207_55 [Caudoviricetes sp.] diamond 156 70.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27509532 27509532 PRJNA1059246_P_NODE_56843_length_268_cov_0.974359_g56217_i0 PRJNA1059246 56843 268 0.974359 2.61128212 Acinetobacter phage HD 2865959 Viruses Viruses 41.6 0.03   NR XKC20740.1 3373398 g56217 i0 30.4 0.884328358208955 79 46 85.1 2 8 235 11 83 XKC20740.1 hypothetical protein HD01_00066 [Acinetobacter phage HD01] diamond 237 41.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Acinetobacter phage HD01
28266985 28266985 PRJNA1059246_P_NODE_69246_length_244_cov_0.900585_g68620_i0 PRJNA1059246 69246 244 0.900585 2.1974274 Caudoviricetes sp. 2832643 Viruses Viruses 77.4 2.37e-14   NR DAD61331.1 2832643 g68620 i0 44.2 0.94672131147541 77 39 94.7 2 11 241 110 182 DAD61331.1 MAG TPA: dsDNA helicase [Caudoviricetes sp.] diamond 231 77.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28993677 28993677 PRJNA1059246_P_NODE_56748_length_268_cov_1.205128_g56122_i0 PRJNA1059246 56748 268 1.205128 3.22974304 Caudoviricetes sp. 2832643 Viruses Viruses 131 4.05e-33   NR DAS14210.1 2832643 g56122 i0 64 0.996268656716418 89 32 99.6 0 2 268 1378 1466 DAS14210.1 MAG TPA: protein of unknown function (DUF4815) [Caudoviricetes sp.] diamond 267 131 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29025299 29025299 PRJNA1059246_P_NODE_48668_length_295_cov_1.004505_g48042_i0 PRJNA1059246 48668 295 1.004505 2.96328975 Vibrio phage 1.121.O._1 2070726 Viruses Viruses 44.3 0.0187   NR AUR89142.1 2070726 g48042 i0 39.1 0.650847457627119 64 34 60 1 184 8 152 215 AUR89142.1 hypothetical protein NVP1121O_114 [Vibrio phage 1.121.O._10N.286.46.C4] diamond 192 44.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Vibrio phage 1.121.O._10N.286.46.C4
29972257 29972257 PRJNA1059246_P_NODE_72231_length_241_cov_0.916667_g71605_i0 PRJNA1059246 72231 241 0.916667 2.20916747 Pseudomonas phage vB_PsaM_M1 2995601 Viruses Viruses 77 8.9e-17   NR UZS00888.1 2995601 g71605 i0 77.8 0.560165975103734 45 10 56 0 135 1 1 45 UZS00888.1 hypothetical protein [Pseudomonas phage vB_PsaM_M1] diamond 135 77 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Andersonviridae   Pseudomonas phage vB_PaeM_M1
30383394 30383394 PRJNA1059246_P_NODE_52533_length_281_cov_2.355769_g51907_i0 PRJNA1059246 52533 281 2.355769 6.61971089 Caudoviricetes sp. 2832643 Viruses Viruses 42 0.0343   NR DAP47336.1 2832643 g51907 i0 30.5 0.875444839857651 82 40 75.8 4 14 226 26 101 DAP47336.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 246 42 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30888524 30888524 PRJNA1059246_P_NODE_53874_length_277_cov_1.509804_g53248_i0 PRJNA1059246 53874 277 1.509804 4.18215708 Caudoviricetes sp. 2832643 Viruses Viruses 42 0.019   NR DAR33416.1 2832643 g53248 i0 38.1 0.454873646209386 42 26 45.5 0 272 147 19 60 DAR33416.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 126 42 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32658986 32658986 PRJNA1059246_P_NODE_66500_length_247_cov_0.885057_g65874_i0 PRJNA1059246 66500 247 0.885057 2.18609079 Caudoviricetes sp. 2832643 Viruses Viruses 90.9 3.56e-21   NR XOR14611.1 2832643 g65874 i0 53.8 0.947368421052632 78 36 94.7 0 243 10 28 105 XOR14611.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 234 90.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);;