RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where tax_clade = "Caudoviricetes code 15 clade" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 21 ✖

tax_clade 1

  • Caudoviricetes code 15 clade · 21 ✖
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
1907301 1907301 PRJNA666695_S_NODE_160522_length_170_cov_3.077519_g159428_i0 PRJNA666695 160522 170 3.077519 5.2317823 phage Lak_Megaphage_Sonny 3109229 Viruses Viruses 54.7 0.004   NTclustered gi|2637653278|gb|OR769223.1| 3109229 g159428 i0 78.824 0.5 85 14 49 4 77 159 6932 6850 MAG: Phage Lak_Megaphage_Sonny, complete sequence blastn 85 54.7 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_Sonny
4068833 4068833 PRJNA1120060_P_NODE_172344_length_488_cov_2.243373_g156200_i0 PRJNA1120060 172344 488 2.243373 10.94766024 phage Lak_Megaphage_Sonny 3109229 Viruses Viruses 58.4 0.001   NTclustered gi|2637653278|gb|OR769223.1| 3109229 g156200 i0 100 0.120901639344262 31 0 6 0 238 268 490711 490741 MAG: Phage Lak_Megaphage_Sonny, complete sequence blastn 59 58.4 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_Sonny
5495658 5495658 PRJNA340009_P_NODE_26165_length_241_cov_1.588542_g25858_i0 PRJNA340009 26165 241 1.588542 3.82838622 phage Lak_Megaphage_Sonny 3109229 Viruses Viruses 102 2.12e-17   NTclustered gi|2637653278|gb|OR769223.1| 3109229 g25858 i0 85.859 0.842323651452282 99 11 41 1 111 209 72677 72772 MAG: Phage Lak_Megaphage_Sonny, complete sequence blastn 203 102 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_Sonny
6996920 6996920 PRJNA643700_P_NODE_65526_length_516_cov_4.229122_g64003_i0 PRJNA643700 65526 516 4.229122 21.82226952 phage Lak_Megaphage_RVC_AP1_GC26 3109224 Viruses Viruses 56.5 0.004   NTclustered gi|2637654041|gb|OR769218.1| 3109224 g64003 i0 92.308 0.0755813953488372 39 3 8 0 172 210 28868 28906 MAG: Phage Lak_Megaphage_RVC_AP1_GC26, complete sequence blastn 39 56.5 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_RVC_AP1_GC26
7011471 7011471 PRJNA666695_S_NODE_63486_length_267_cov_2.588496_g62392_i0 PRJNA666695 63486 267 2.588496 6.91128432 phage Lak_Megaphage_Sonny 3109229 Viruses Viruses 63.9 1.13e-5   NTclustered gi|2637653278|gb|OR769223.1| 3109229 g62392 i0 76.562 0.591760299625468 128 22 46 6 7 130 122279 122156 MAG: Phage Lak_Megaphage_Sonny, complete sequence blastn 158 63.9 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_Sonny
9785711 9785711 PRJNA879314_P_NODE_5088_length_252_cov_0.871508_g5038_i0 PRJNA879314 5088 252 0.871508 2.19620016 phage Lak_Megaphage_Sonny 3109229 Viruses Viruses 99 2.89e-16   NTclustered gi|2637653278|gb|OR769223.1| 3109229 g5038 i0 80.451 0.694444444444444 133 22 52 4 4 134 580316 580186 MAG: Phage Lak_Megaphage_Sonny, complete sequence blastn 175 99 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_Sonny
11372522 11372522 PRJNA675638_P_NODE_17069_length_173_cov_1.588710_g16872_i0 PRJNA675638 17069 173 1.58871 2.7484683 Viruses 10239 Viruses Viruses 97.1 6.62e-16   NTclustered gi|2637651136|gb|OR769219.1| 3109225 g16872 i0 81.301 1.42196531791908 123 19 70 4 1 121 331019 331139 MAG: Phage Lak_Megaphage_RVC_AP3_GC26, complete sequence blastn 246 97.1 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_RVC_AP3_GC26
11442891 11442891 PRJNA879067_P_NODE_62789_length_431_cov_1.631285_g59304_i0 PRJNA879067 62789 431 1.631285 7.03083835 Viruses 10239 Viruses Viruses 785 0   NTclustered gi|2637651136|gb|OR769219.1| 3109225 g59304 i0 99.766 16.2993039443155 428 1 99 0 4 431 392041 391614 MAG: Phage Lak_Megaphage_RVC_AP3_GC26, complete sequence blastn 7025 785 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_RVC_AP3_GC26
16368700 16368700 PRJNA315399_P_NODE_429253_length_158_cov_6.363636_g428805_i0 PRJNA315399 429253 158 6.363636 10.05454488 Viruses 10239 Viruses Viruses 148 1.6199999999999998e-31   NTclustered gi|2637651136|gb|OR769219.1| 3109225 g428805 i0 86.184 7.69620253164557 152 3 85 5 14 147 504392 504543 MAG: Phage Lak_Megaphage_RVC_AP3_GC26, complete sequence blastn 1216 148 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_RVC_AP3_GC26
17816710 17816710 PRJNA879067_P_NODE_72314_length_376_cov_1.016502_g68829_i0 PRJNA879067 72314 376 1.016502 3.82204752 Viruses 10239 Viruses Viruses 630 3.619999999999999e-176   NTclustered gi|2637651136|gb|OR769219.1| 3109225 g68829 i0 99.143 8.41489361702128 350 3 93 0 1 350 320884 320535 MAG: Phage Lak_Megaphage_RVC_AP3_GC26, complete sequence blastn 3164 630 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_RVC_AP3_GC26
20153902 20153902 PRJNA1120060_P_NODE_978696_length_312_cov_2.794979_g960767_i0 PRJNA1120060 978696 312 2.794979 8.72033448 Viruses 10239 Viruses Viruses 52.8 0.029   NTclustered gi|2637651136|gb|OR769219.1| 3109225 g960767 i0 100 0.179487179487179 28 0 9 0 121 148 363036 363063 MAG: Phage Lak_Megaphage_RVC_AP3_GC26, complete sequence blastn 56 52.8 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_RVC_AP3_GC26
22440205 22440205 PRJNA781453_P_NODE_35338_length_247_cov_0.885057_g35223_i0 PRJNA781453 35338 247 0.885057 2.18609079 phage Lak_Megaphage_RVC_AP1_GC26 3109224 Viruses Viruses 435 1.9e-117   NTclustered gi|2637654041|gb|OR769218.1| 3109224 g35223 i0 98.381 7.78137651821862 247 4 100 0 1 247 381301 381055 MAG: Phage Lak_Megaphage_RVC_AP1_GC26, complete sequence blastn 1922 435 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_RVC_AP1_GC26
26916200 26916200 PRJNA315399_P_NODE_385062_length_163_cov_5.238095_g384614_i0 PRJNA315399 385062 163 5.238095 8.53809485 phage Lak_Megaphage_RVC_AP3_GC31 3109226 Viruses Viruses 66.6 5.72e-12   NR WQJ51768.1 3109226 g384614 i0 61.9 0.773006134969325 42 16 77.3 0 142 17 113 154 WQJ51768.1 MAG: hypothetical protein [phage Lak_Megaphage_RVC_AP3_GC31] diamond 126 66.6 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_RVC_AP3_GC31
27074017 27074017 PRJNA270367_P_NODE_32782_length_192_cov_1.104895_g32577_i0 PRJNA270367 32782 192 1.104895 2.1213984 phage Lak_Megaphage_RVC_AP1_GC26 3109224 Viruses Viruses 44.3 0.00551   NR WQJ54389.1 3109224 g32577 i0 39.6 0.828125 53 30 79.7 1 168 16 142 194 WQJ54389.1 MAG: nucleotidyltransferase [phage Lak_Megaphage_RVC_AP1_GC26] diamond 159 44.3 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_RVC_AP1_GC26
28160917 28160917 PRJNA879314_P_NODE_10165_length_244_cov_0.912281_g10115_i0 PRJNA879314 10165 244 0.912281 2.22596564 phage Lak_Megaphage_RVC_AP3_GC31 3109226 Viruses Viruses 84 1.13e-16   NR WQJ52055.1 3109226 g10115 i0 48.8 0.983606557377049 80 40 98.4 1 242 3 503 581 WQJ52055.1 MAG: Neutral endopeptidase [phage Lak_Megaphage_RVC_AP3_GC31] diamond 240 84 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_RVC_AP3_GC31
29206228 29206228 PRJNA1010780_S_NODE_25429_length_312_cov_1.765343_g24140_i0 PRJNA1010780 25429 312 1.765343 5.50787016 Viruses 10239 Viruses Viruses 93.6 8.07e-21   NR WQJ54341.1 3109224 g24140 i0 48.5 1.98076923076923 103 52 99 1 312 4 21 122 WQJ54341.1 MAG: hypothetical protein [phage Lak_Megaphage_RVC_AP1_GC26] diamond 618 93.6 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_RVC_AP1_GC26
29897535 29897535 PRJNA883229_P_NODE_8811_length_253_cov_0.866667_g8765_i0 PRJNA883229 8811 253 0.866667 2.19266751 phage Lak_Megaphage_RVC_AP3_GC26 3109225 Viruses Viruses 55.1 1.97e-6   NR WQJ51155.1 3109225 g8765 i0 40.6 0.758893280632411 64 37 75.9 1 253 62 32 94 WQJ51155.1 MAG: SbcC-like subunit of palindrome specific endonuclease [phage Lak_Megaphage_RVC_AP3_GC26] diamond 192 55.1 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_RVC_AP3_GC26
30539104 30539104 PRJEB58983_P_NODE_23933_length_270_cov_1.492386_g23518_i0 PRJEB58983 23933 270 1.492386 4.0294422 phage Lak_Megaphage_Sonny 3109229 Viruses Viruses 47.4 0.00102   NR WQJ53232.1 3109229 g23518 i0 61.3 0.344444444444444 31 12 34.4 0 267 175 107 137 WQJ53232.1 MAG: hypothetical protein [phage Lak_Megaphage_Sonny] diamond 93 47.4 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_Sonny
31433474 31433474 PRJNA340009_P_NODE_47516_length_187_cov_2.572464_g47209_i0 PRJNA340009 47516 187 2.572464 4.81050768 phage Lak_Megaphage_Sonny 3109229 Viruses Viruses 53.5 5.05e-7   NR WQJ53760.1 3109229 g47209 i0 50 0.737967914438503 46 22 73.8 1 47 184 19 63 WQJ53760.1 MAG: hypothetical protein [phage Lak_Megaphage_Sonny] diamond 138 53.5 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_Sonny
32037458 32037458 PRJNA529241_P_NODE_62698_length_263_cov_5.336283_g60376_i0 PRJNA529241 62698 263 5.336283 14.03442429 phage Lak_Megaphage_RVC_AP1_GC26 3109224 Viruses Viruses 90.5 2.57e-20   NR WQJ54391.1 3109224 g60376 i0 51.4 0.821292775665399 72 35 82.1 0 47 262 1 72 WQJ54391.1 MAG: hypothetical protein [phage Lak_Megaphage_RVC_AP1_GC26] diamond 216 90.5 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_RVC_AP1_GC26
33018091 33018091 PRJNA1233465d_S_NODE_127268_length_166_cov_1.675214_g126157_i0 PRJNA1233465 127268 166 1.675214 2.78085524 phage Lak_Megaphage_Sonny 3109229 Viruses Viruses 55.5 4.12e-7   NR WQJ53519.1 3109229 g126157 i0 57.4 1.95180722891566 54 23 97.6 0 164 3 239 292 WQJ53519.1 MAG: transposase [phage Lak_Megaphage_Sonny] diamond 324 55.5 1 Viruses Caudoviricetes code 15 clade Heunggongvirae Uroviricota Caudoviricetes       phage Lak_Megaphage_Sonny

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