RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJEB58983" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB58983 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
992069 992069 PRJEB58983_P_NODE_12781_length_353_cov_2.707143_g12366_i0 PRJEB58983 12781 353 2.707143 9.55621479 Agricanvirus 1984776 Viruses Viruses 63.9 1.54e-5   NTclustered gi|1631927333|ref|NC_041972.1| 1815986 g12366 i0 93.023 0.691218130311615 43 3 12 0 145 187 257795 257753 Erwinia phage vB_EamM_Deimos-Minion, complete genome blastn 244 63.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Agricanvirus Agricanvirus deimos
1399129 1399129 PRJEB58983_P_NODE_142_length_2843_cov_15.824910_g108_i0 PRJEB58983 142 2843 15.82491 449.9021913 Caudoviricetes sp. 2832643 Viruses Viruses 649 0   NTclustered gi|2914814131|gb|OR221916.1| 2832643 g108 i0 78.62 0.361941610974323 1029 184 36 22 1760 2770 98237 99247 MAG: Caudoviricetes sp. isolate MSP0211 genomic sequence blastn 1029 649 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
1399432 1399432 PRJEB58983_P_NODE_27982_length_253_cov_0.866667_g27567_i0 PRJEB58983 27982 253 0.866667 2.19266751 Epseptimavirus KKP3831 3428535 Viruses Viruses 62.1 3.81e-5   NTclustered gi|2484169613|gb|OQ674103.1| 3027684 g27567 i0 89.796 0.193675889328063 49 4 19 1 62 110 34591 34544 Salmonella phage KKP_3831, complete genome blastn 49 62.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Epseptimavirus Epseptimavirus KKP3831
2674763 2674763 PRJEB58983_P_NODE_143_length_2843_cov_13.603971_g108_i1 PRJEB58983 143 2843 13.603971 386.76089553 Caudoviricetes sp. 2832643 Viruses Viruses 638 1.7799999999999995e-177   NTclustered gi|2914814131|gb|OR221916.1| 2832643 g108 i1 78.468 0.362645093211396 1031 182 36 26 1760 2770 98237 99247 MAG: Caudoviricetes sp. isolate MSP0211 genomic sequence blastn 1031 638 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
3950920 3950920 PRJEB58983_P_NODE_21164_length_283_cov_4.009524_g20749_i0 PRJEB58983 21164 283 4.009524 11.34695292 Acinetobacter phage vB_AbaP_Alexa 2736223 Viruses Viruses 93.5 1.54e-14   NTclustered gi|1851854878|gb|MT375042.1| 2736223 g20749 i0 83.333 0.360424028268551 102 15 35 2 137 236 35146 35045 Acinetobacter phage vB_AbaP_Alexa chromosome linear, complete genome blastn 102 93.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Acinetobacter phage vB_AbaP_Alexa
23077001 23077001 PRJEB58983_P_NODE_27439_length_254_cov_2.668508_g27024_i0 PRJEB58983 27439 254 2.668508 6.77801032 Caudoviricetes sp. 2832643 Viruses Viruses 63.9 1.07e-5   NTclustered gi|2059991927|tpg|BK026284.1| 2832643 g27024 i0 97.297 0.145669291338583 37 1 15 0 177 213 20935 20971 MAG TPA_asm: Caudoviricetes sp. isolate ctWCC9, partial genome blastn 37 63.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);;