RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA886442" 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

  • PRJNA886442 · 9 ✖

analysis 1

  • blastn · 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
2137378 2137378 PRJNA886442_P_NODE_4222_length_361_cov_1.083333_g4058_i0 PRJNA886442 4222 361 1.083333 3.91083213 Xanthomonas phage RTH11 3044021 Viruses Viruses 307 6.610000000000001e-79   NTclustered gi|2523357534|gb|OQ790161.1| 3044021 g4058 i0 83.237 0.958448753462604 346 46 94 12 1 340 208280 207941 Xanthomonas phage RTH11, complete genome blastn 346 307 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Xanthomonas phage RTH11
3412683 3412683 PRJNA886442_P_NODE_2283_length_462_cov_1.071979_g2119_i0 PRJNA886442 2283 462 1.071979 4.95254298 Caudoviricetes sp. 2832643 Viruses Viruses 804 0   NTclustered gi|2915025860|gb|OR222614.1| 2832643 g2119 i0 98.052 120.290043290043 462 9 100 0 1 462 64509 64970 MAG: Caudoviricetes sp. isolate MSP0316 genomic sequence blastn 55574 804 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
3412767 3412767 PRJNA886442_P_NODE_8583_length_275_cov_1.158416_g8419_i0 PRJNA886442 8583 275 1.158416 3.185644 Ripduovirus RP12 2560700 Viruses Viruses 213 1.1e-50   NTclustered gi|1631920815|ref|NC_041911.1| 1923889 g8419 i0 81.111 1.19272727272727 270 47 97 4 1 268 40947 41214 Ralstonia phage RP12 DNA, complete genome blastn 328 213 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Ripduovirus Ripduovirus RP12
5965124 5965124 PRJNA886442_P_NODE_12205_length_249_cov_0.886364_g12041_i0 PRJNA886442 12205 249 0.886364 2.20704636 Ripduovirus RP12 2560700 Viruses Viruses 217 7.55e-52   NTclustered gi|1109658793|dbj|AP017925.1| 1923890 g12041 i0 84.615 1.72690763052209 221 30 88 4 7 225 17695 17913 Ralstonia phage RP31 DNA, complete genome blastn 430 217 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Ripduovirus Ripduovirus RP12
6345434 6345434 PRJNA886442_P_NODE_11665_length_250_cov_0.881356_g11501_i0 PRJNA886442 11665 250 0.881356 2.20339 Ripduovirus 2560215 Viruses Viruses 237 5.82e-58   NTclustered gi|1631920815|ref|NC_041911.1| 1923889 g11501 i0 84 2 250 36 99 4 3 250 79620 79867 Ralstonia phage RP12 DNA, complete genome blastn 500 237 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Ripduovirus Ripduovirus RP12
11065449 11065449 PRJNA886442_P_NODE_1869_length_506_cov_1.801386_g1705_i0 PRJNA886442 1869 506 1.801386 9.11501316 Xanthomonas phage RTH11 3044021 Viruses Viruses 307 9.57e-79   NTclustered gi|2523357534|gb|OQ790161.1| 3044021 g1705 i0 78.269 1.02766798418972 520 84 100 24 1 506 272460 272964 Xanthomonas phage RTH11, complete genome blastn 520 307 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Xanthomonas phage RTH11
17440029 17440029 PRJNA886442_P_NODE_13014_length_247_cov_0.896552_g12850_i0 PRJNA886442 13014 247 0.896552 2.21448344 Xanthomonas phage RTH11 3044021 Viruses Viruses 189 1.6299999999999999e-43   NTclustered gi|2523357534|gb|OQ790161.1| 3044021 g12850 i0 81.385 0.935222672064777 231 43 94 0 1 231 25981 25751 Xanthomonas phage RTH11, complete genome blastn 231 189 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Xanthomonas phage RTH11
23814054 23814054 PRJNA886442_P_NODE_12579_length_248_cov_0.891429_g12415_i0 PRJNA886442 12579 248 0.891429 2.21074392 Xanthomonas phage RTH11 3044021 Viruses Viruses 217 7.52e-52   NTclustered gi|2523357534|gb|OQ790161.1| 3044021 g12415 i0 83.058 0.975806451612903 242 37 97 4 4 243 275125 274886 Xanthomonas phage RTH11, complete genome blastn 242 217 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Xanthomonas phage RTH11
23814131 23814131 PRJNA886442_P_NODE_3799_length_376_cov_1.339934_g3635_i0 PRJNA886442 3799 376 1.339934 5.03815184 Caudoviricetes sp. 2832643 Viruses Viruses 678 0   NTclustered gi|2914786560|gb|OR222572.1| 2832643 g3635 i0 99.202 2.59840425531915 376 3 100 0 1 376 42315 41940 MAG: Caudoviricetes sp. isolate MSP0361 genomic sequence blastn 977 678 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);;