RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1174770" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1174770 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
316305 316305 PRJNA1174770_P_NODE_10261_length_165_cov_0.887931_g10172_i0 PRJNA1174770 10261 165 0.887931 1.46508615 Caudoviricetes sp. 2832643 Viruses Viruses 272 9.73e-69   NTclustered gi|2914962682|gb|OR221991.1| 2832643 g10172 i0 96.914 1.96363636363636 162 5 98 0 4 165 53697 53536 MAG: Caudoviricetes sp. isolate MSP0133 genomic sequence blastn 324 272 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
1590976 1590976 PRJNA1174770_P_NODE_9682_length_166_cov_0.880342_g9593_i0 PRJNA1174770 9682 166 0.880342 1.46136772 Caudoviricetes sp. 2832643 Viruses Viruses 302 1.2500000000000001e-77   NTclustered gi|2914986982|gb|OR222125.1| 2832643 g9593 i0 99.398 3.75301204819277 166 1 100 0 1 166 22646 22811 MAG: Caudoviricetes sp. isolate MSP0855 genomic sequence blastn 623 302 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
5419358 5419358 PRJNA1174770_P_NODE_6505_length_184_cov_1.237037_g6416_i0 PRJNA1174770 6505 184 1.237037 2.27614808 Caudoviricetes sp. 2832643 Viruses Viruses 65.8 2.02e-6   NTclustered gi|2059917061|tpg|BK041566.1| 2832643 g6416 i0 93.182 0.239130434782609 44 3 24 0 57 100 3333 3376 MAG TPA_asm: Caudoviricetes sp. isolate ctKPv40, partial genome blastn 44 65.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
6694255 6694255 PRJNA1174770_P_NODE_9546_length_166_cov_0.888889_g9457_i0 PRJNA1174770 9546 166 0.888889 1.47555574 Caudoviricetes sp. 2832643 Viruses Viruses 291 2.7099999999999998e-74   NTclustered gi|2915045223|gb|OR222781.1| 2832643 g9457 i0 98.193 1 166 3 100 0 1 166 18910 19075 MAG: Caudoviricetes sp. isolate MSP0579 genomic sequence blastn 166 291 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
7969520 7969520 PRJNA1174770_P_NODE_10667_length_164_cov_0.904348_g10578_i0 PRJNA1174770 10667 164 0.904348 1.48313072 Caudoviricetes sp. 2832643 Viruses Viruses 303 3.42e-78   NTclustered gi|2056734783|tpg|BK044972.1| 2832643 g10578 i0 100 25.890243902439 164 0 100 0 1 164 2038 1875 MAG TPA_asm: Caudoviricetes sp. isolate ctaxg3, partial genome blastn 4246 303 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
15619055 15619055 PRJNA1174770_P_NODE_7153_length_176_cov_1.622047_g7064_i0 PRJNA1174770 7153 176 1.622047 2.85480272 Caudoviricetes sp. 2832643 Viruses Viruses 224 2.9699999999999996e-54   NTclustered gi|2914824635|gb|OR222226.1| 2832643 g7064 i0 92.357 1.78977272727273 157 12 89 0 19 175 16933 17089 MAG: Caudoviricetes sp. isolate MSP0745 genomic sequence blastn 315 224 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
16893397 16893397 PRJNA1174770_P_NODE_9554_length_166_cov_0.888889_g9465_i0 PRJNA1174770 9554 166 0.888889 1.47555574 Lactococcus phage D6890 2979363 Viruses Viruses 307 2.69e-79   NTclustered gi|2306485016|gb|OP323077.1| 2979363 g9465 i0 100 60.2590361445783 166 0 100 0 1 166 25893 25728 Lactococcus phage D6890, complete genome blastn 10003 307 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Lactococcus phage D6890
18167897 18167897 PRJNA1174770_P_NODE_4255_length_223_cov_2.333333_g4166_i0 PRJNA1174770 4255 223 2.333333 5.20333259 Maltschvirus maltsch 2956182 Viruses Viruses 65.8 2.54e-6   NTclustered gi|1862931302|emb|LR798196.1| 2100421 g4166 i0 93.182 0.197309417040359 44 3 20 0 65 108 7986 7943 uncultured Caudovirales phage genome assembly blastn 44 65.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
20717623 20717623 PRJNA1174770_P_NODE_11157_length_163_cov_1.368421_g11068_i0 PRJNA1174770 11157 163 1.368421 2.23052623 Caudoviricetes sp. 2832643 Viruses Viruses 237 3.49e-58   NTclustered gi|2914852300|gb|OR221708.1| 2832643 g11068 i0 93.252 1 163 8 100 3 1 163 881 722 MAG: Caudoviricetes sp. isolate MSP1326 genomic sequence blastn 163 237 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
20717686 20717686 PRJNA1174770_P_NODE_8957_length_167_cov_0.881356_g8868_i0 PRJNA1174770 8957 167 0.881356 1.47186452 Caudoviricetes sp. 2832643 Viruses Viruses 276 7.64e-70   NTclustered gi|2057046044|tpg|BK049375.1| 2832643 g8868 i0 96.407 1 167 6 100 0 1 167 44113 43947 MAG TPA_asm: Caudoviricetes sp. isolate ctqLd1, partial genome blastn 167 276 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);;