RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJEB81171" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 10 ✖

bioproject 1

  • PRJEB81171 · 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
996645 996645 PRJEB81171_P_NODE_7801_length_252_cov_1.385475_g7674_i0 PRJEB81171 7801 252 1.385475 3.491397 Jamesmcgillvirus 2948768 Viruses Viruses 449 6.94e-122   NTclustered gi|48697070|ref|NC_005884.1| 270673 g7674 i0 98.81 7.36111111111111 252 3 100 0 1 252 38307 38558 Pseudomonas phage PaP2, complete genome blastn 1855 449 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Fredfastierviridae Jamesmcgillvirus Pseudomonas phage PaP2
1414107 1414107 PRJEB81171_P_NODE_9362_length_245_cov_0.906977_g9235_i0 PRJEB81171 9362 245 0.906977 2.22209365 Caudoviricetes sp. 2832643 Viruses Viruses 309 1.19e-79   NTclustered gi|2060040681|tpg|BK027668.1| 2832643 g9235 i0 89.388 2 245 26 100 0 1 245 26151 26395 MAG TPA_asm: Caudoviricetes sp. isolate ct6vn6, partial genome blastn 490 309 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
2689528 2689528 PRJEB81171_P_NODE_7923_length_252_cov_0.871508_g7796_i0 PRJEB81171 7923 252 0.871508 2.19620016 Betacoronavirus pandemicum 3418604 Viruses Viruses 466 6.89e-127   NTclustered gi|2316342856|gb|OP624554.1| 2697049 g7796 i0 100 100 252 0 100 0 1 252 29444 29695 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/OH-CDC-QDX41755282/2022, complete genome blastn 25200 466 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
6517689 6517689 PRJEB81171_P_NODE_9746_length_243_cov_0.917647_g9619_i0 PRJEB81171 9746 243 0.917647 2.22988221 Pormufvirus salinum 3431827 Viruses Viruses 261 3.34e-65   NTclustered gi|2231638396|ref|NC_062761.1| 2878009 g9619 i0 86.008 1 243 34 100 0 1 243 20733 20491 Halorubrum virus HRTV-28, complete genome blastn 243 261 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Suolaviridae Pormufvirus Pormufvirus salinum
7791766 7791766 PRJEB81171_P_NODE_9067_length_246_cov_0.901734_g8940_i0 PRJEB81171 9067 246 0.901734 2.21826564 Bacillus phage vB_BpuM-ZY1 3096073 Viruses Viruses 303 5.56e-78   NTclustered gi|2622943848|gb|OR820920.1| 3096073 g8940 i0 89.256 0.983739837398374 242 26 98 0 3 244 36791 37032 Bacillus phage vB_BpuM-ZY1, complete genome blastn 242 303 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae   Bacillus phage vB_BpuM-ZY1
7791774 7791774 PRJEB81171_P_NODE_9547_length_244_cov_0.912281_g9420_i0 PRJEB81171 9547 244 0.912281 2.22596564 Microviridae sp. 2202644 Viruses Viruses 424 4.05e-114   NTclustered gi|2054416160|tpg|BK035639.1| 2202644 g9420 i0 97.951 14.9877049180328 244 5 100 0 1 244 16910 16667 MAG TPA_asm: Microviridae sp. isolate cteV86, partial genome blastn 3657 424 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
10342486 10342486 PRJEB81171_P_NODE_7549_length_254_cov_1.292818_g7422_i0 PRJEB81171 7549 254 1.292818 3.28375772 Prokaryotic dsDNA virus sp. 2591644 Viruses Viruses 350 7.3e-92   NTclustered gi|1707910805|gb|MK892832.1| 2591644 g7422 i0 91.7 0.996062992125984 253 20 99 1 1 253 17968 17717 MAG: Prokaryotic dsDNA virus sp. isolate Tp1_111_DCM_112609_1, complete genome blastn 253 350 1 Viruses               Prokaryotic dsDNA virus sp.
16716156 16716156 PRJEB81171_P_NODE_5254_length_291_cov_1.146789_g5127_i0 PRJEB81171 5254 291 1.146789 3.33715599 Caudoviricetes sp. 2832643 Viruses Viruses 442 1.3699999999999994e-119   NTclustered gi|2053078945|tpg|BK020046.1| 2832643 g5127 i0 94.425 1.96219931271478 287 16 99 0 2 288 11652 11938 MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome blastn 571 442 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
17991026 17991026 PRJEB81171_P_NODE_8155_length_251_cov_0.876404_g8028_i0 PRJEB81171 8155 251 0.876404 2.19977404 Prokaryotic dsDNA virus sp. 2591644 Viruses Viruses 337 5.609999999999998e-88   NTclustered gi|1707910805|gb|MK892832.1| 2591644 g8028 i0 90.837 1 251 23 100 0 1 251 46507 46257 MAG: Prokaryotic dsDNA virus sp. isolate Tp1_111_DCM_112609_1, complete genome blastn 251 337 1 Viruses               Prokaryotic dsDNA virus sp.
24365291 24365291 PRJEB81171_P_NODE_9360_length_245_cov_0.906977_g9233_i0 PRJEB81171 9360 245 0.906977 2.22209365 Escherichia phage Turkey3 3375710 Viruses Viruses 60.2 1.32e-4   NTclustered gi|2890139370|gb|PQ471515.1| 3375710 g9233 i0 100 0.130612244897959 32 0 13 0 31 62 151731 151762 Escherichia phage Turkey3, complete genome blastn 32 60.2 1 Viruses               Escherichia phage Turkey3

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