RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA414225" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 10 ✖

bioproject 1

  • PRJNA414225 · 10 ✖

analysis 1

  • diamond · 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
26917373 26917373 PRJNA414225_P_NODE_52662_length_167_cov_0.864407_g52575_i0 PRJNA414225 52662 167 0.864407 1.44355969 Arthrobacter phage Iter 2936922 Viruses Viruses 74.3 9.63e-14   NR URQ05004.1 2936922 g52575 i0 75 0.790419161676647 44 11 79 0 3 134 470 513 URQ05004.1 tape measure protein [Arthrobacter phage Iter] diamond 132 74.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Casidaviridae Yangvirus Arthrobacter phage Iter
28559996 28559996 PRJNA414225_P_NODE_12087_length_202_cov_1.006536_g12000_i0 PRJNA414225 12087 202 1.006536 2.03320272 Pantoea phage Survivor 3232176 Viruses Viruses 46.2 0.00125   NR XCN28352.1 3232176 g12000 i0 45.8 0.712871287128713 48 26 71.3 0 200 57 322 369 XCN28352.1 RecA [Pantoea phage Survivor] diamond 144 46.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pantoea phage Survivor
28717844 28717844 PRJNA414225_P_NODE_76907_length_163_cov_1.456140_g76820_i0 PRJNA414225 76907 163 1.45614 2.3735082 Caudoviricetes sp. 2832643 Viruses Viruses 57.8 6.22e-8   NR UOF79261.1 2832643 g76820 i0 66.7 1.41717791411043 42 13 75.5 1 163 41 357 398 UOF79261.1 phage terminase [Caudoviricetes sp.] diamond 231 57.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29065172 29065172 PRJNA414225_P_NODE_50488_length_167_cov_0.864407_g50401_i0 PRJNA414225 50488 167 0.864407 1.44355969 Caudoviricetes sp. 2832643 Viruses Viruses 44.7 0.0028   NR DAW75695.1 2832643 g50401 i0 43.6 5.62275449101796 55 27 98.8 1 165 1 146 196 DAW75695.1 MAG TPA: DNA POLYMERASE [Caudoviricetes sp.] diamond 939 44.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29145162 29145162 PRJNA414225_P_NODE_55129_length_166_cov_1.213675_g55042_i0 PRJNA414225 55129 166 1.213675 2.0147005 root 1 Root_unresolved Root_unresolved 80.1 1.05e-17   NR XOR55871.1 2832643 g55042 i0 66.1 3.03614457831325 56 18 99.4 1 165 1 11 66 XOR55871.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 504 80.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29208175 29208175 PRJNA414225_P_NODE_74549_length_164_cov_0.886957_g74462_i0 PRJNA414225 74549 164 0.886957 1.45460948 Bendigovirus 2560099 Viruses Viruses 71.2 1e-12   NR YP_009273570.1 1647285 g74462 i0 66.7 2.96341463414634 54 18 98.8 0 164 3 211 264 YP_009273570.1 UvsX-like recombinase [Gordonia phage GMA6] diamond 486 71.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Bendigovirus Bendigovirus GMA6
29285933 29285933 PRJNA414225_P_NODE_4909_length_244_cov_1.046154_g4822_i0 PRJNA414225 4909 244 1.046154 2.55261576 Chuvivirus 2842604 Viruses Viruses 47.8 6.41e-4   NR WET19891.1 2842604 g4822 i0 58.8 0.418032786885246 34 14 41.8 0 235 134 464 497 WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1] diamond 102 47.8 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Chuvivirus Chuvivirus
30201696 30201696 PRJNA414225_P_NODE_57852_length_166_cov_0.871795_g57765_i0 PRJNA414225 57852 166 0.871795 1.4471797 Vibrio phage 1.151.O._1 1881430 Viruses Viruses 65.5 1.88e-12   NR AUR90904.1 1881430 g57765 i0 53.2 0.849397590361446 47 22 84.9 0 4 144 6 52 AUR90904.1 hypothetical protein NVP1151O_63 [Vibrio phage 1.151.O._10N.222.46.B1] diamond 141 65.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Vibrio phage 1.151.O._10N.222.46.B1
32098672 32098672 PRJNA414225_P_NODE_32638_length_177_cov_1.585938_g32551_i0 PRJNA414225 32638 177 1.585938 2.80711026 Caudoviricetes sp. 2832643 Viruses Viruses 72 7.43e-13   NR XOQ91032.1 2832643 g32551 i0 94.4 0.610169491525424 36 2 61 0 70 177 11 46 XOQ91032.1 MAG: gp10 protein [Caudoviricetes sp.] diamond 108 72 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32856609 32856609 PRJNA414225_P_NODE_75480_length_164_cov_0.886957_g75393_i0 PRJNA414225 75480 164 0.886957 1.45460948 Caudoviricetes sp. 2832643 Viruses Viruses 92 4.500000000000001e-22   NR XOR94955.1 2832643 g75393 i0 77.8 0.98780487804878 54 12 98.8 0 1 162 75 128 XOR94955.1 MAG: gp064 protein [Caudoviricetes sp.] diamond 162 92 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);;