RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1134759 · 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
6661997 6661997 PRJNA1134759_P_NODE_30866_length_303_cov_1.134783_g30690_i0 PRJNA1134759 30866 303 1.134783 3.43839249 Caudoviricetes sp. 2832643 Viruses Viruses 287 7.11e-73   NTclustered gi|2914832067|gb|OR222576.1| 2832643 g30690 i0 97.605 0.815181518151815 167 4 81 0 59 225 87437 87603 MAG: Caudoviricetes sp. isolate MSP0358 genomic sequence blastn 247 287 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
6662071 6662071 PRJNA1134759_P_NODE_52206_length_248_cov_0.891429_g52030_i0 PRJNA1134759 52206 248 0.891429 2.21074392 Caudoviricetes sp. 2832643 Viruses Viruses 353 5.49e-93   NTclustered gi|2914889217|gb|OR222626.1| 2832643 g52030 i0 92.339 4.00403225806452 248 19 100 0 1 248 52230 51983 MAG: Caudoviricetes sp. isolate MSP0308 genomic sequence blastn 993 353 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
14313146 14313146 PRJNA1134759_P_NODE_55852_length_243_cov_0.917647_g55676_i0 PRJNA1134759 55852 243 0.917647 2.22988221 Caudoviricetes sp. 2832643 Viruses Viruses 444 3.09e-120   NTclustered gi|2914927861|gb|OR221512.1| 2832643 g55676 i0 99.588 1 243 1 100 0 1 243 39571 39813 MAG: Caudoviricetes sp. isolate MSP1567 genomic sequence blastn 243 444 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
15059587 15059587 PRJNA1134759_P_NODE_50932_length_249_cov_2.795455_g50756_i0 PRJNA1134759 50932 249 2.795455 6.96068295 Viruses 10239 Viruses Viruses 344 3.32e-90   NTclustered gi|670140887|gb|KJ936628.1| 1524880 g50756 i0 91.566 9.01606425702811 249 21 100 0 1 249 42284 42036 Vibrio phage VPp1, complete genome blastn 2245 344 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Vibrio phage VPp1
16334306 16334306 PRJNA1134759_P_NODE_31833_length_299_cov_1.548673_g31657_i0 PRJNA1134759 31833 299 1.548673 4.63053227 Viruses 10239 Viruses Viruses 252 2.55e-62   NTclustered gi|1227483992|gb|MF431726.1| 2024229 g31657 i0 85.957 1.5752508361204 235 33 79 0 65 299 11983 11749 Vibrio phage vB_ValP_IME271, complete genome blastn 471 252 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Vibrio phage vB_ValP_IME271
18135870 18135870 PRJNA1134759_P_NODE_24415_length_333_cov_1.776923_g24239_i0 PRJNA1134759 24415 333 1.776923 5.91715359 Caudoviricetes sp. 2832643 Viruses Viruses 472 2.03e-128   NTclustered gi|2914887418|gb|OR222536.1| 2832643 g24239 i0 92.192 2 333 26 100 0 1 333 27532 27200 MAG: Caudoviricetes sp. isolate MSP0404 genomic sequence blastn 666 472 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);;