RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1073005" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 6 ✖

bioproject 1

  • PRJNA1073005 · 6 ✖

analysis 1

  • diamond · 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
27098960 27098960 PRJNA1073005_P_NODE_10042_length_243_cov_0.905882_g9923_i0 PRJNA1073005 10042 243 0.905882 2.20129326 Caudoviricetes sp. 2832643 Viruses Viruses 137 4.19e-37   NR DAX91357.1 2832643 g9923 i0 72.5 0.987654320987654 80 22 98.8 0 3 242 150 229 DAX91357.1 MAG TPA: Exonuclease [Caudoviricetes sp.] diamond 240 137 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28827178 28827178 PRJNA1073005_P_NODE_7088_length_319_cov_1.471545_g6969_i0 PRJNA1073005 7088 319 1.471545 4.69422855 root 1 Root_unresolved Root_unresolved 116 1.09e-27   NR XOR52638.1 2832643 g6969 i0 57.1 5.8871473354232 105 45 98.7 0 318 4 404 508 XOR52638.1 MAG: tape measure protein [Caudoviricetes sp.] diamond 1878 117 0.991452991452991 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29372654 29372654 PRJNA1073005_P_NODE_7129_length_317_cov_1.577869_g7010_i0 PRJNA1073005 7129 317 1.577869 5.00184473 Shenzhen dicistro-like virus 2789378 Viruses Viruses 54.3 8.14e-6   NR QPN36948.1 2789378 g7010 i0 29.2 1.81703470031546 96 66 90.9 1 293 6 678 771 QPN36948.1 polyprotein [Shenzhen dicistro-like virus] diamond 576 54.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Shenzhen dicistro-like virus
32375423 32375423 PRJNA1073005_P_NODE_9799_length_245_cov_0.895349_g9680_i0 PRJNA1073005 9799 245 0.895349 2.19360505 Caudoviricetes sp. 2832643 Viruses Viruses 88.6 2.23e-18   NR XOS51193.1 2832643 g9680 i0 56.3 2.95102040816327 80 35 98 0 245 6 29 108 XOS51193.1 MAG: hypothetical protein MSP0359_1, partial [Caudoviricetes sp.] diamond 723 88.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32785420 32785420 PRJNA1073005_P_NODE_5600_length_391_cov_0.968553_g5481_i0 PRJNA1073005 5600 391 0.968553 3.78704223 Bacillus phage vB_BspM_AgentSmith 2836110 Viruses Viruses 137 6.019999999999998e-35   NR QXN70512.1 2836110 g5481 i0 52.3 0.997442455242967 130 61 99.7 1 2 391 404 532 QXN70512.1 putative virion structural protein [Bacillus phage vB_BspM_AgentSmith] diamond 390 137 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Bacillus phage vB_BspM_AgentSmith
32848484 32848484 PRJNA1073005_P_NODE_10000_length_243_cov_2.264706_g9881_i0 PRJNA1073005 10000 243 2.264706 5.50323558 Bacillus phage vB_BspM_AgentSmith 2836110 Viruses Viruses 48.9 2.49e-4   NR QXN70456.1 2836110 g9881 i0 35.8 0.827160493827161 67 43 82.7 0 1 201 400 466 QXN70456.1 hypothetical protein AGENTSMITH_52 [Bacillus phage vB_BspM_AgentSmith] diamond 201 48.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Bacillus phage vB_BspM_AgentSmith

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