RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJEB30004" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Heunggongvirae · 5 ✖

bioproject 1

  • PRJEB30004 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
37093 37093 PRJEB30004_P_NODE_326001_length_265_cov_1.632743_g310374_i0 PRJEB30004 326001 265 1.632743 4.32676895 Pijolavirus Pf17397FPD1 3431676 Viruses Viruses 390 4.519999999999999e-104   NTclustered gi|2190146233|gb|OM131411.1| 2914026 g310374 i0 93.258 2.86037735849057 267 14 100 3 1 265 15808 16072 Pseudomonas phage Pf17397_F_PD1, complete genome blastn 758 390 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Autographivirales Autotranscriptaviridae Pijolavirus Pijolavirus Pf17397FPD1
1313459 1313459 PRJEB30004_P_NODE_369582_length_241_cov_1.915842_g353955_i0 PRJEB30004 369582 241 1.915842 4.61717922 Caudoviricetes sp. 2832643 Viruses Viruses 76.8 1.29e-9   NTclustered gi|2914928093|gb|OR221516.1| 2832643 g353955 i0 100 18.0497925311203 41 0 17 0 1 41 43866 43826 MAG: Caudoviricetes sp. isolate MSP1560 genomic sequence blastn 4350 76.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
12467607 12467607 PRJEB30004_P_NODE_232870_length_339_cov_2.070000_g217243_i0 PRJEB30004 232870 339 2.07 7.0173 Viruses 10239 Viruses Viruses 69.4 3.18e-7   NTclustered gi|1953437643|gb|MT157331.1| 47929 g217243 i0 100 11.8053097345133 37 0 11 0 1 37 162922 162886 Macacine betaherpesvirus 3 strain UCD59, complete genome blastn 4002 69.4 1 Viruses   Heunggongvirae Peploviricota Herviviricetes Herpesvirales Orthoherpesviridae Cytomegalovirus Cytomegalovirus macacinebeta3
12804190 12804190 PRJEB30004_P_NODE_607411_length_165_cov_1.801587_g591784_i0 PRJEB30004 607411 165 1.801587 2.97261855 Caudoviricetes sp. 2832643 Viruses Viruses 305 9.59e-79   NTclustered gi|2054434277|tpg|BK035998.1| 2832643 g591784 i0 100 223.927272727273 165 0 100 0 1 165 18168 18332 MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome blastn 36948 305 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
19165269 19165269 PRJEB30004_P_NODE_382216_length_235_cov_1.698980_g366589_i0 PRJEB30004 382216 235 1.69898 3.992603 Caulobacter phage Ccr29 1959737 Viruses Viruses 71.3 5.81e-8   NTclustered gi|1168054551|gb|KY555145.1| 1959737 g366589 i0 95.455 17.0978723404255 44 2 19 0 1 44 150508 150551 Caulobacter phage Ccr29, complete genome blastn 4018 71.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Jeanschmidtviridae Shapirovirus Caulobacter phage Ccr29

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);;