RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA951412" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 17 ✖

bioproject 1

  • PRJNA951412 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
26613865 26613865 PRJNA951412_P_NODE_6161_length_246_cov_1.734104_g6076_i0 PRJNA951412 6161 246 1.734104 4.26589584 Klebsiella phage RCIP 3094172 Viruses Viruses 63.2 3.81e-11   NR WPJ47647.1 3094172 g6076 i0 50.9 0.646341463414634 53 26 64.6 0 2 160 9 61 WPJ47647.1 hypothetical protein RCIP0004_00077 [Klebsiella phage RCIP0004] diamond 159 63.2 1 Viruses               Klebsiella phage RCIP0004
26740283 26740283 PRJNA951412_P_NODE_7621_length_243_cov_0.905882_g7536_i0 PRJNA951412 7621 243 0.905882 2.20129326 Erwinia phage Pastis 3056489 Viruses Viruses 50.1 9.96e-5   NR WJN64599.1 3056489 g7536 i0 37.6 1.04938271604938 85 45 98.8 3 241 2 2007 2088 WJN64599.1 virion encapsidated RNAP [Erwinia phage Pastis] diamond 255 50.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Waedenswilvirus Erwinia phage Pastis
27158252 27158252 PRJNA951412_P_NODE_1262_length_399_cov_0.950920_g1177_i0 PRJNA951412 1262 399 0.95092 3.7941708 root 1 Root_unresolved Root_unresolved 53.9 9.73e-6   NR YP_009786930.1 1897434 g1177 i0 71.9 1.24812030075188 32 9 24.1 0 303 398 101 132 YP_009786930.1 hypothetical protein HOR25_gp36 [Serratia phage SM9-3Y] diamond 498 53.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Autographivirales Autotranscriptaviridae Teetrevirus Teetrevirus SALSA
27499675 27499675 PRJNA951412_P_NODE_6383_length_246_cov_0.895954_g6298_i0 PRJNA951412 6383 246 0.895954 2.20404684 Crassvirales sp. 2960088 Viruses Viruses 130 1.5399999999999999e-34   NR DAL01330.1 2960088 g6298 i0 88.9 0.98780487804878 81 9 98.8 0 1 243 55 135 DAL01330.1 MAG TPA: hypothetical protein [Crassvirales sp.] diamond 243 130 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Crassvirales     Crassvirales sp.
27846754 27846754 PRJNA951412_P_NODE_1644_length_353_cov_1.032143_g1559_i0 PRJNA951412 1644 353 1.032143 3.64346479 Prokaryotic dsDNA virus sp. 2591644 Viruses Viruses 67 3.12e-12   NR QDP66514.1 2591644 g1559 i0 62.7 0.43342776203966 51 19 43.3 0 234 82 1 51 QDP66514.1 MAG: hypothetical protein Tp1111DCM1126091_20 [Prokaryotic dsDNA virus sp.] diamond 153 67 1 Viruses               Prokaryotic dsDNA virus sp.
28383641 28383641 PRJNA951412_P_NODE_3506_length_266_cov_1.212435_g3421_i0 PRJNA951412 3506 266 1.212435 3.2250771 Prokaryotic dsDNA virus sp. 2591644 Viruses Viruses 173 3.75e-49   NR QDP60417.1 2591644 g3421 i0 93.2 0.992481203007519 88 6 99.2 0 264 1 382 469 QDP60417.1 MAG: putative ribonucleoside-diphosphate reductase subunit alpha [Prokaryotic dsDNA virus sp.] diamond 264 173 1 Viruses               Prokaryotic dsDNA virus sp.
28447006 28447006 PRJNA951412_P_NODE_2526_length_300_cov_1.255507_g2441_i0 PRJNA951412 2526 300 1.255507 3.766521 Pseudomonas phage vB_PsaM_M1 2995601 Viruses Viruses 124 3.869999999999999e-32   NR UZS00840.1 2995601 g2441 i0 56.7 0.97 97 41 97 1 4 294 3 98 UZS00840.1 endonuclease [Pseudomonas phage vB_PsaM_M1] diamond 291 124 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Andersonviridae   Pseudomonas phage vB_PaeM_M1
28541747 28541747 PRJNA951412_P_NODE_2647_length_294_cov_2.719457_g2562_i0 PRJNA951412 2647 294 2.719457 7.99520358 Lothians earthworm bunya/orthobunya-like virus 1 2021934 Viruses Viruses 59.7 7.1e-8   NR ASM94074.1 2021934 g2562 i0 34.5 0.857142857142857 84 43 73.5 1 264 49 138 221 ASM94074.1 putative glycoprotein, partial [Lothians earthworm bunya/orthobunya-like virus 1] diamond 252 59.7 1 Viruses   Orthornavirae Negarnaviricota Ellioviricetes Bunyavirales     Lothians earthworm bunya/orthobunya-like virus 1
29804402 29804402 PRJNA951412_P_NODE_2431_length_304_cov_1.346320_g2346_i0 PRJNA951412 2431 304 1.34632 4.0928128 Caudoviricetes sp. 2832643 Viruses Viruses 160 1.4499999999999999e-43   NR DAH57130.1 2832643 g2346 i0 75.8 0.9375 95 23 93.8 0 3 287 598 692 DAH57130.1 MAG TPA: DNA polymerase [Caudoviricetes sp.] diamond 285 160 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29994150 29994150 PRJNA951412_P_NODE_1591_length_358_cov_1.350877_g1506_i0 PRJNA951412 1591 358 1.350877 4.83613966 Caudoviricetes sp. 2832643 Viruses Viruses 171 3.34e-47   NR DAH57130.1 2832643 g1506 i0 70.3 0.988826815642458 118 35 98.9 0 356 3 95 212 DAH57130.1 MAG TPA: DNA polymerase [Caudoviricetes sp.] diamond 354 171 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30214998 30214998 PRJNA951412_P_NODE_5992_length_247_cov_0.890805_g5907_i0 PRJNA951412 5992 247 0.890805 2.20028835 Xanthomonas phage DES1 2894399 Viruses Viruses 75.5 1.89e-14   NR UFK09597.1 2894399 g5907 i0 54.9 0.995951417004049 82 36 98.4 1 1 243 90 171 UFK09597.1 hypothetical protein [Xanthomonas phage DES1] diamond 246 75.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Xanthomonas phage DES1
30246986 30246986 PRJNA951412_P_NODE_1372_length_382_cov_1.288026_g1287_i0 PRJNA951412 1372 382 1.288026 4.92025932 Prokaryotic dsDNA virus sp. 2591644 Viruses Viruses 58.9 7.01e-9   NR QDP50299.1 2591644 g1287 i0 51 0.400523560209424 51 25 40.1 0 35 187 6 56 QDP50299.1 MAG: hypothetical protein Tp178MES00d2C33159851_89 [Prokaryotic dsDNA virus sp.] diamond 153 58.9 1 Viruses               Prokaryotic dsDNA virus sp.
30790421 30790421 PRJNA951412_P_NODE_2894_length_285_cov_1.466981_g2809_i0 PRJNA951412 2894 285 1.466981 4.18089585 Uavernvirus 3424914 Viruses Viruses 100 1.17e-22   NR QDP60443.1 2591644 g2809 i0 52.1 1.97894736842105 94 44 97.9 1 285 7 240 333 QDP60443.1 MAG: hypothetical protein GOVbin1096_71 [Prokaryotic dsDNA virus sp.] diamond 564 100 1 Viruses               Prokaryotic dsDNA virus sp.
30878632 30878632 PRJNA951412_P_NODE_3374_length_270_cov_1.355330_g3289_i0 PRJNA951412 3374 270 1.35533 3.659391 Caudoviricetes sp. 2832643 Viruses Viruses 103 8.07e-24   NR DAH57143.1 2832643 g3289 i0 55.1 0.988888888888889 89 39 98.9 1 268 2 213 300 DAH57143.1 MAG TPA: AAA domain protein [Caudoviricetes sp.] diamond 267 103 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31257852 31257852 PRJNA951412_P_NODE_1115_length_425_cov_0.835227_g1030_i0 PRJNA951412 1115 425 0.835227 3.54971475 Aeromonas phage vB_AceP_PAc 2996154 Viruses Viruses 96.3 1.82e-22   NR WAW11582.1 2996154 g1030 i0 45.8 0.755294117647059 107 53 72.7 2 339 31 21 126 WAW11582.1 hypothetical protein vBAcePPAc_0205 [Aeromonas phage vB_AceP_PAc] diamond 321 96.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Plateaulakevirus Aeromonas phage vB_AceP_PAc
31384530 31384530 PRJNA951412_P_NODE_4356_length_252_cov_0.865922_g4271_i0 PRJNA951412 4356 252 0.865922 2.18212344 Caudoviricetes sp. 2832643 Viruses Viruses 138 9.02e-36   NR DAH57130.1 2832643 g4271 i0 79.8 1 84 17 100 0 1 252 500 583 DAH57130.1 MAG TPA: DNA polymerase [Caudoviricetes sp.] diamond 252 138 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32901232 32901232 PRJNA951412_P_NODE_3080_length_279_cov_1.500000_g2995_i0 PRJNA951412 3080 279 1.5 4.185 uncultured Caudovirales phage 2100421 Viruses Viruses 58.2 1.16e-7   NR CAB4139099.1 2100421 g2995 i0 38.6 0.946236559139785 88 44 94.6 1 264 1 60 137 CAB4139099.1 flap endonuclease-like protein [uncultured Caudovirales phage] diamond 264 58.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch

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