RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "blastn", bioproject = "PRJNA400171" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 19 ✖

tax_kingdom 1

bioproject 1

  • PRJNA400171 · 19 ✖

analysis 1

  • blastn · 19 ✖

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
413659 413659 PRJNA400171_S_NODE_3081_length_233_cov_3.534314_g2991_i0 PRJNA400171 3081 233 3.534314 8.23495162 Caudoviricetes sp. 2832643 Viruses Viruses 320 5.18e-83   NTclustered gi|2914804707|gb|OR221415.1| 2832643 g2991 i0 91.416 2.27038626609442 233 20 100 0 1 233 993 761 MAG: Caudoviricetes sp. isolate MSP1673 genomic sequence blastn 529 320 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
5517684 5517684 PRJNA400171_S_NODE_8845_length_154_cov_2.816000_g8755_i0 PRJNA400171 8845 154 2.816 4.33664 Caudoviricetes sp. 2832643 Viruses Viruses 93.5 7.45e-15   NTclustered gi|2914808323|gb|OR221678.1| 2832643 g8755 i0 86.047 0.558441558441558 86 12 56 0 69 154 15175 15260 MAG: Caudoviricetes sp. isolate MSP1370 genomic sequence blastn 86 93.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
6791460 6791460 PRJNA400171_S_NODE_3646_length_219_cov_2.926316_g3556_i0 PRJNA400171 3646 219 2.926316 6.40863204 Caudoviricetes sp. 2832643 Viruses Viruses 117 6.77e-22   NTclustered gi|2914784350|gb|OR222496.1| 2832643 g3556 i0 91.011 0.406392694063927 89 5 39 1 134 219 12582 12670 MAG: Caudoviricetes sp. isolate MSP0887 genomic sequence blastn 89 117 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
6791527 6791527 PRJNA400171_S_NODE_5326_length_190_cov_3.807453_g5236_i0 PRJNA400171 5326 190 3.807453 7.2341607 Caudoviricetes sp. 2832643 Viruses Viruses 285 1.4799999999999998e-72   NTclustered gi|2914804707|gb|OR221415.1| 2832643 g5236 i0 93.684 1 190 12 100 0 1 190 2463 2652 MAG: Caudoviricetes sp. isolate MSP1673 genomic sequence blastn 190 285 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
8067139 8067139 PRJNA400171_S_NODE_5887_length_183_cov_3.000000_g5797_i0 PRJNA400171 5887 183 3 5.49 Caudoviricetes sp. 2832643 Viruses Viruses 119 1.52e-22   NTclustered gi|2914804707|gb|OR221415.1| 2832643 g5797 i0 86.364 0.601092896174863 110 13 60 2 39 147 5269 5161 MAG: Caudoviricetes sp. isolate MSP1673 genomic sequence blastn 110 119 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
10617588 10617588 PRJNA400171_S_NODE_2969_length_236_cov_4.628019_g2879_i0 PRJNA400171 2969 236 4.628019 10.92212484 Caudoviricetes sp. 2832643 Viruses Viruses 285 1.92e-72   NTclustered gi|2914804707|gb|OR221415.1| 2832643 g2879 i0 94.565 0.779661016949153 184 10 78 0 1 184 2767 2950 MAG: Caudoviricetes sp. isolate MSP1673 genomic sequence blastn 184 285 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
11892546 11892546 PRJNA400171_S_NODE_3150_length_231_cov_3.099010_g3060_i0 PRJNA400171 3150 231 3.09901 7.1587131 Caudoviricetes sp. 2832643 Viruses Viruses 147 9.2e-31   NTclustered gi|2914808323|gb|OR221678.1| 2832643 g3060 i0 79.167 0.935064935064935 216 41 93 4 18 231 14346 14559 MAG: Caudoviricetes sp. isolate MSP1370 genomic sequence blastn 216 147 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
13167464 13167464 PRJNA400171_S_NODE_2091_length_266_cov_3.236287_g2001_i0 PRJNA400171 2091 266 3.236287 8.60852342 Caudoviricetes sp. 2832643 Viruses Viruses 473 4.379999999999999e-129   NTclustered gi|2914804707|gb|OR221415.1| 2832643 g2001 i0 99.614 0.973684210526316 259 1 97 0 1 259 2285 2027 MAG: Caudoviricetes sp. isolate MSP1673 genomic sequence blastn 259 473 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
13167552 13167552 PRJNA400171_S_NODE_4731_length_199_cov_3.576471_g4641_i0 PRJNA400171 4731 199 3.576471 7.11717729 Caudoviricetes sp. 2832643 Viruses Viruses 313 7.18e-81   NTclustered gi|2914804707|gb|OR221415.1| 2832643 g4641 i0 94.975 1 199 10 100 0 1 199 1347 1149 MAG: Caudoviricetes sp. isolate MSP1673 genomic sequence blastn 199 313 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
13167743 13167743 PRJNA400171_S_NODE_991_length_339_cov_2.890323_g901_i0 PRJNA400171 991 339 2.890323 9.79819497 Caudoviricetes sp. 2832643 Viruses Viruses 296 1.34e-75   NTclustered gi|2054455785|tpg|BK031419.1| 2832643 g901 i0 82.558 3.04424778761062 344 53 100 7 1 339 1461 1802 MAG TPA_asm: Caudoviricetes sp. isolate ctlOd2, partial genome blastn 1032 296 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
15716402 15716402 PRJNA400171_S_NODE_2833_length_240_cov_2.905213_g2743_i0 PRJNA400171 2833 240 2.905213 6.9725112 Caudoviricetes sp. 2832643 Viruses Viruses 113 9.76e-21   NTclustered gi|2915036206|gb|OR222694.1| 2832643 g2743 i0 84.034 0.495833333333333 119 18 50 1 44 162 45360 45243 MAG: Caudoviricetes sp. isolate MSP0234 genomic sequence blastn 119 113 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
15716546 15716546 PRJNA400171_S_NODE_6253_length_179_cov_2.346667_g6163_i0 PRJNA400171 6253 179 2.346667 4.20053393 Caudoviricetes sp. 2832643 Viruses Viruses 281 1.78e-71   NTclustered gi|2914804707|gb|OR221415.1| 2832643 g6163 i0 94.972 1 179 9 100 0 1 179 731 553 MAG: Caudoviricetes sp. isolate MSP1673 genomic sequence blastn 179 281 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
16991194 16991194 PRJNA400171_S_NODE_1254_length_314_cov_3.214035_g1164_i0 PRJNA400171 1254 314 3.214035 10.0920699 Caudoviricetes sp. 2832643 Viruses Viruses 580 3.0299999999999992e-161   NTclustered gi|2914804707|gb|OR221415.1| 2832643 g1164 i0 100 2.5318471337579598 314 0 100 0 1 314 1615 1928 MAG: Caudoviricetes sp. isolate MSP1673 genomic sequence blastn 795 580 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
16991230 16991230 PRJNA400171_S_NODE_2194_length_262_cov_3.330472_g2104_i0 PRJNA400171 2194 262 3.330472 8.72583664 Caudoviricetes sp. 2832643 Viruses Viruses 429 9.449999999999999e-116   NTclustered gi|2914804707|gb|OR221415.1| 2832643 g2104 i0 96.183 3.12213740458015 262 10 100 0 1 262 1583 1322 MAG: Caudoviricetes sp. isolate MSP1673 genomic sequence blastn 818 429 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
16991285 16991285 PRJNA400171_S_NODE_354_length_479_cov_3.391111_g265_i0 PRJNA400171 354 479 3.391111 16.24342169 Caudoviricetes sp. 2832643 Viruses Viruses 228 7.219999999999997e-55   NTclustered gi|2054455785|tpg|BK031419.1| 2832643 g265 i0 77.03 0.899791231732777 431 77 88 19 46 467 739 1156 MAG TPA_asm: Caudoviricetes sp. isolate ctlOd2, partial genome blastn 431 228 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
18265380 18265380 PRJNA400171_S_NODE_4575_length_202_cov_2.161850_g4485_i0 PRJNA400171 4575 202 2.16185 4.366937 Caudoviricetes sp. 2832643 Viruses Viruses 307 3.4e-79   NTclustered gi|2914804707|gb|OR221415.1| 2832643 g4485 i0 94.059 1 202 12 100 0 1 202 974 1175 MAG: Caudoviricetes sp. isolate MSP1673 genomic sequence blastn 202 307 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
19539472 19539472 PRJNA400171_S_NODE_2976_length_236_cov_3.270531_g2886_i0 PRJNA400171 2976 236 3.270531 7.71845316 Caudoviricetes sp. 2832643 Viruses Viruses 152 2.03e-32   NTclustered gi|2914784644|gb|OR222505.1| 2832643 g2886 i0 90.435 1.10169491525424 115 11 49 0 79 193 1460 1346 MAG: Caudoviricetes sp. isolate MSP0876 genomic sequence blastn 260 152 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
19539675 19539675 PRJNA400171_S_NODE_7836_length_163_cov_1.970149_g7746_i0 PRJNA400171 7836 163 1.970149 3.21134287 Caudoviricetes sp. 2832643 Viruses Viruses 187 3.569999999999999e-43   NTclustered gi|2914804707|gb|OR221415.1| 2832643 g7746 i0 87.73 3 163 17 100 1 1 163 8793 8634 MAG: Caudoviricetes sp. isolate MSP1673 genomic sequence blastn 489 187 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
20815422 20815422 PRJNA400171_S_NODE_4597_length_201_cov_3.284884_g4507_i0 PRJNA400171 4597 201 3.284884 6.60261684 Caudoviricetes sp. 2832643 Viruses Viruses 99 2.21e-16   NTclustered gi|2914784350|gb|OR222496.1| 2832643 g4507 i0 96.61 1.15422885572139 59 2 29 0 2 60 12648 12706 MAG: Caudoviricetes sp. isolate MSP0887 genomic sequence blastn 232 99 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);;