RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJEB6584" and tax_kingdom = "Sangervirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Sangervirae · 12 ✖

bioproject 1

  • PRJEB6584 · 12 ✖

analysis 1

  • blastn · 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
3956400 3956400 PRJEB6584_P_NODE_204_length_301_cov_759.812500_g190_i0 PRJEB6584 204 301 759.8125 2287.035625 Microviridae sp. 2202644 Viruses Viruses 52.8 0.028   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g190 i0 100 0.0930232558139535 28 0 9 0 164 191 2829 2802 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 28 52.8 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
25523821 25523821 PRJEB6584h_S_NODE_2633_length_303_cov_633.406716_g2571_i0 PRJEB6584 2633 303 633.406716 1919.22234948 Microviridae sp. 2202644 Viruses Viruses 56.5 0.002   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g2571 i0 100 0.099009900990099 30 0 10 0 262 291 2800 2829 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 30 56.5 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
25616317 25616317 PRJEB6584p_S_NODE_897_length_294_cov_58.791506_g866_i0 PRJEB6584 897 294 58.791506 172.84702764 Viruses 10239 Viruses Viruses 65.8 3.5e-6   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g866 i0 100 12.0714285714286 35 0 12 0 1 35 2835 2801 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 3549 65.8 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
25752118 25752118 PRJEB6584h_S_NODE_15346_length_186_cov_16.933775_g15284_i0 PRJEB6584 15346 186 16.933775 31.4968215 Viruses 10239 Viruses Viruses 60.2 9.5e-5   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g15284 i0 92.857 20.6881720430108 42 2 22 1 8 48 2840 2799 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 3848 60.2 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
25752163 25752163 PRJEB6584k_S_NODE_2274_length_207_cov_49.180233_g2253_i0 PRJEB6584 2274 207 49.180233 101.80308231 Viruses 10239 Viruses Viruses 62.1 3.01e-5   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g2253 i0 93.023 17.8454106280193 43 2 20 1 164 205 2798 2840 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 3694 62.1 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
26068079 26068079 PRJEB6584h_S_NODE_8693_length_210_cov_958.074286_g8631_i0 PRJEB6584 8693 210 958.074286 2011.9560006 Microviridae sp. 2202644 Viruses Viruses 52.8 0.018   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g8631 i0 100 0.133333333333333 28 0 13 0 171 198 2802 2829 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 28 52.8 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
26204321 26204321 PRJEB6584h_S_NODE_13286_length_191_cov_9.378205_g13224_i0 PRJEB6584 13286 191 9.378205 17.91237155 Microviridae sp. 2202644 Viruses Viruses 71.3 4.54e-8   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g13224 i0 100 19.9528795811518 38 0 20 0 1 38 2838 2801 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 3811 71.3 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
26205153 26205153 PRJEB6584o_S_NODE_19262_length_205_cov_3.758824_g19154_i0 PRJEB6584 19262 205 3.758824 7.7055892 Microviridae sp. 2202644 Viruses Viruses 52.8 0.018   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g19154 i0 100 0.136585365853659 28 0 14 0 178 205 2801 2828 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 28 52.8 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
26205182 26205182 PRJEB6584o_S_NODE_20078_length_202_cov_3.437126_g19970_i0 PRJEB6584 20078 202 3.437126 6.94299452 Microviridae sp. 2202644 Viruses Viruses 60.2 1.05e-4   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g19970 i0 100 2.5990099009901 32 0 16 0 1 32 2832 2801 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 525 60.2 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
26205205 26205205 PRJEB6584o_S_NODE_20710_length_200_cov_2.466667_g20602_i0 PRJEB6584 20710 200 2.466667 4.933334 Microviridae sp. 2202644 Viruses Viruses 54.7 0.005   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g20602 i0 100 0.145 29 0 15 0 169 197 2801 2829 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 29 54.7 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
26296523 26296523 PRJEB6584p_S_NODE_1838_length_242_cov_11.062802_g1807_i0 PRJEB6584 1838 242 11.062802 26.77198084 Viruses 10239 Viruses Viruses 67.6 7.78e-7   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g1807 i0 100 16.3140495867769 36 0 15 0 1 36 2839 2804 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 3948 67.6 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
26340229 26340229 PRJEB6584j_S_NODE_319_length_391_cov_63.250000_g290_i0 PRJEB6584 319 391 63.25 247.3075 Microviridae sp. 2202644 Viruses Viruses 52.8 0.037   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g290 i0 100 0.0716112531969309 28 0 7 0 1 28 2828 2801 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 28 52.8 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae 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);;