RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB39269" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 7 ✖

bioproject 1

  • PRJEB39269 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
1331347 1331347 PRJEB39269_P_NODE_42_length_3133_cov_3.824822_g32_i0 PRJEB39269 42 3133 3.824822 119.83167326 Leviviridae sp. 2027243 Viruses Viruses 1472 0   NTclustered gi|2183424863|gb|MZ679833.1| 2027243 g32 i0 75.886 0.982125758059368 3077 635 96 82 13 3033 909 3934 MAG: Leviviridae sp. isolate 358R-k141_998760 genomic sequence blastn 3077 1472 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae   Leviviridae sp.
5159405 5159405 PRJEB39269_P_NODE_67305_length_170_cov_2.633588_g66900_i0 PRJEB39269 67305 170 2.633588 4.4770996 Mieseafarmvirus RSL1 1980923 Viruses Viruses 80.5 6.52e-11   NTclustered gi|269838879|ref|NC_010811.2| 1980924 g66900 i0 85 0.470588235294118 80 10 46 2 91 169 192248 192326 Ralstonia phage RSL1, complete genome blastn 80 80.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Mieseafarmvirus Mieseafarmvirus RSL1
7709473 7709473 PRJEB39269_P_NODE_77387_length_160_cov_3.214876_g76982_i0 PRJEB39269 77387 160 3.214876 5.1438016 Caudoviricetes sp. 2832643 Viruses Viruses 296 5.55e-76   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g76982 i0 100 1 160 0 100 0 1 160 62477 62318 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 160 296 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
14085378 14085378 PRJEB39269_P_NODE_68612_length_169_cov_3.330769_g68207_i0 PRJEB39269 68612 169 3.330769 5.62899961 Skunavirus sv7 2845479 Viruses Viruses 267 4.63e-67   NTclustered gi|526244578|ref|NC_021855.1| 1262538 g68207 i0 93.491 93.7337278106509 169 10 100 1 1 169 14507 14340 Lactococcus phage phi7, complete genome blastn 15841 267 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Skunavirus Skunavirus sv7
15359219 15359219 PRJEB39269_P_NODE_49233_length_195_cov_7.583333_g48828_i0 PRJEB39269 49233 195 7.583333 14.78749935 Bacteriophage sp. 38018 Viruses Viruses 353 4.12e-93   NTclustered gi|2059766425|tpg|BK039054.1| 38018 g48828 i0 99.487 508.876923076923 195 0 99 1 1 194 17080 16886 MAG TPA_asm: Bacteriophage sp. isolate cttqH15, partial genome blastn 99231 353 1 Viruses               Bacteriophage sp.
16633931 16633931 PRJEB39269_P_NODE_67474_length_170_cov_2.511450_g67069_i0 PRJEB39269 67474 170 2.51145 4.269465 Pormufvirus salinum 3431827 Viruses Viruses 117 4.97e-22   NTclustered gi|2231638396|ref|NC_062761.1| 2878009 g67069 i0 77.193 1.00588235294118 171 37 99 2 1 169 1630 1460 Halorubrum virus HRTV-28, complete genome blastn 171 117 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Suolaviridae Pormufvirus Pormufvirus salinum
24282866 24282866 PRJEB39269_P_NODE_69660_length_168_cov_2.736434_g69255_i0 PRJEB39269 69660 168 2.736434 4.59720912 Thermus phage MN1 3018631 Viruses Viruses 95.3 2.31e-15   NTclustered gi|2512657565|dbj|LC754405.1| 3018631 g69255 i0 89.333 0.446428571428571 75 8 45 0 89 163 26481 26407 Thermus phage MN1 DNA, complete genome blastn 75 95.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Thermus phage MN1

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