RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA315399" and tax_kingdom = "Loebvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Loebvirae · 16 ✖

bioproject 1

  • PRJNA315399 · 16 ✖

analysis 1

  • blastn · 16 ✖

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
382447 382447 PRJNA315399_P_NODE_305641_length_178_cov_5.361702_g305193_i0 PRJNA315399 305641 178 5.361702 9.54382956 Inoviridae sp. 2219103 Viruses Viruses 141 3.12e-29   NTclustered gi|2057785266|tpg|BK054778.1| 2219103 g305193 i0 100 11.4887640449438 76 0 43 0 102 177 20245 20320 MAG TPA_asm: Inoviridae sp. isolate ctdKr19, partial genome blastn 2045 141 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
385298 385298 PRJNA315399_S_NODE_47141_length_218_cov_4.281768_g46940_i0 PRJNA315399 47141 218 4.281768 9.33425424 Ralstonia phage 1 NP-2014 1460070 Viruses Viruses 268 1.76e-67   NTclustered gi|589287117|ref|NC_023586.1| 1460070 g46940 i0 90.594 3.94495412844037 202 19 93 0 10 211 4144 4345 Ralstonia phage 1 NP-2014, complete sequence blastn 860 268 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Ralstonia phage 1 NP-2014
1656075 1656075 PRJNA315399_P_NODE_119962_length_194_cov_5.471338_g119514_i0 PRJNA315399 119962 194 5.471338 10.61439572 Inoviridae sp. 2219103 Viruses Viruses 124 3.5e-24   NTclustered gi|2056936201|tpg|BK022393.1| 2219103 g119514 i0 98.571 1.5 70 1 36 0 118 187 10989 10920 MAG TPA_asm: Inoviridae sp. isolate ct6Da14, partial genome blastn 291 124 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
2934318 2934318 PRJNA315399_P_NODE_52483_length_235_cov_2.378788_g52035_i0 PRJNA315399 52483 235 2.378788 5.5901518 Ralstonia phage 1 NP-2014 1460070 Viruses Viruses 187 5.5299999999999985e-43   NTclustered gi|589287117|ref|NC_023586.1| 1460070 g52035 i0 86.188 1.54042553191489 181 15 77 4 44 224 7656 7826 Ralstonia phage 1 NP-2014, complete sequence blastn 362 187 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Ralstonia phage 1 NP-2014
4209250 4209250 PRJNA315399_P_NODE_228364_length_183_cov_3.732877_g227916_i0 PRJNA315399 228364 183 3.732877 6.83116491 Inoviridae sp. 2219103 Viruses Viruses 132 1.95e-26   NTclustered gi|2059617279|tpg|BK037425.1| 2219103 g227916 i0 97.403 29.0819672131148 77 2 75 0 99 175 9342 9418 MAG TPA_asm: Inoviridae sp. isolate cta6A2, partial genome blastn 5322 132 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
4212130 4212130 PRJNA315399_S_NODE_192704_length_151_cov_2.833333_g192503_i0 PRJNA315399 192704 151 2.833333 4.27833283 Inoviridae sp. 2219103 Viruses Viruses 198 1.5e-46   NTclustered gi|2058135445|tpg|BK034190.1| 2219103 g192503 i0 94.531 3.43046357615894 128 7 85 0 23 150 2734 2607 MAG TPA_asm: Inoviridae sp. isolate ctoJ35, partial genome blastn 518 198 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
5486471 5486471 PRJNA315399_P_NODE_379505_length_164_cov_3.370079_g379057_i0 PRJNA315399 379505 164 3.370079 5.52692956 Inoviridae sp. 2219103 Viruses Viruses 263 5.809999999999999e-66   NTclustered gi|2059617279|tpg|BK037425.1| 2219103 g379057 i0 98.026 63.9512195121951 152 1 91 1 7 156 13026 12875 MAG TPA_asm: Inoviridae sp. isolate cta6A2, partial genome blastn 10488 263 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
5489381 5489381 PRJNA315399_S_NODE_91405_length_183_cov_1.280822_g91204_i0 PRJNA315399 91405 183 1.280822 2.34390426 Inoviridae sp. 2219103 Viruses Viruses 278 2.36e-70   NTclustered gi|2906154557|gb|PQ646804.1| 2219103 g91204 i0 93.989 1 183 11 100 0 1 183 4253 4071 MAG: Inoviridae sp. isolate k127_2957441 genomic sequence blastn 183 278 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
6762090 6762090 PRJNA315399_S_NODE_134066_length_165_cov_6.976562_g133865_i0 PRJNA315399 134066 165 6.976562 11.5113273 Inoviridae sp. 2219103 Viruses Viruses 261 2.11e-65   NTclustered gi|2059617279|tpg|BK037425.1| 2219103 g133865 i0 99.306 59.8060606060606 144 1 87 0 1 144 4384 4241 MAG TPA_asm: Inoviridae sp. isolate cta6A2, partial genome blastn 9868 261 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
8034698 8034698 PRJNA315399_P_NODE_143287_length_189_cov_17.013158_g142839_i0 PRJNA315399 143287 189 17.013158 32.15486862 Inoviridae sp. 2219103 Viruses Viruses 60.2 9.69e-5   NTclustered gi|1436201660|gb|MH616818.1| 2219103 g142839 i0 91.111 0.238095238095238 45 3 23 1 56 99 1167 1123 MAG: Inoviridae sp. isolate ctba29, complete genome blastn 45 60.2 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
10586100 10586100 PRJNA315399_P_NODE_278909_length_180_cov_2.594406_g278461_i0 PRJNA315399 278909 180 2.594406 4.6699308 Inoviridae sp. 2219103 Viruses Viruses 134 5.3e-27   NTclustered gi|2906148124|gb|PQ646371.1| 2219103 g278461 i0 98.667 0.827777777777778 75 1 64 0 103 177 5251 5177 MAG: Inoviridae sp. isolate k127_3147988 genomic sequence blastn 149 134 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
18233192 18233192 PRJNA315399_P_NODE_158055_length_188_cov_3.410596_g157607_i0 PRJNA315399 158055 188 3.410596 6.41192048 Inoviridae sp. 2219103 Viruses Viruses 141 3.34e-29   NTclustered gi|2057108830|tpg|BK038475.1| 2219103 g157607 i0 100 9.21808510638298 76 0 71 0 39 114 15928 15853 MAG TPA_asm: Inoviridae sp. isolate cts6n6, partial genome blastn 1733 141 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
19508838 19508838 PRJNA315399_P_NODE_372256_length_165_cov_3.625000_g371808_i0 PRJNA315399 372256 165 3.625 5.98125 Ralstonia phage 1 NP-2014 1460070 Viruses Viruses 93.5 8.13e-15   NTclustered gi|589287117|ref|NC_023586.1| 1460070 g371808 i0 90.141 0.860606060606061 71 7 43 0 91 161 3336 3406 Ralstonia phage 1 NP-2014, complete sequence blastn 142 93.5 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Ralstonia phage 1 NP-2014
20786672 20786672 PRJNA315399_S_NODE_36877_length_234_cov_1.578680_g36676_i0 PRJNA315399 36877 234 1.57868 3.6941112 Inoviridae sp. 2219103 Viruses Viruses 174 4.29e-39   NTclustered gi|1436206075|gb|MH617060.1| 2219103 g36676 i0 96.226 1.4957264957265 106 4 45 0 1 106 1826 1931 MAG: Inoviridae sp. isolate ctcg21, complete genome blastn 350 174 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
22061472 22061472 PRJNA315399_S_NODE_26578_length_257_cov_3.195455_g26377_i0 PRJNA315399 26578 257 3.195455 8.21231935 Ralstonia phage 1 NP-2014 1460070 Viruses Viruses 102 2.29e-17   NTclustered gi|589287117|ref|NC_023586.1| 1460070 g26377 i0 89.024 0.638132295719844 82 9 32 0 169 250 3336 3417 Ralstonia phage 1 NP-2014, complete sequence blastn 164 102 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Ralstonia phage 1 NP-2014
23333417 23333417 PRJNA315399_P_NODE_142259_length_190_cov_2.594771_g141811_i0 PRJNA315399 142259 190 2.594771 4.9300649 Inoviridae sp. 2219103 Viruses Viruses 52.8 0.016   NTclustered gi|1436202202|gb|MH616838.1| 2219103 g141811 i0 100 0.147368421052632 28 0 15 0 80 107 1128 1101 MAG: Inoviridae sp. isolate ctbh31, complete genome blastn 28 52.8 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae 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);;