RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "blastn", bioproject = "PRJNA1241156" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 21 ✖

bioproject 1

  • PRJNA1241156 · 21 ✖

analysis 1

  • blastn · 21 ✖

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
350015 350015 PRJNA1241156_S_NODE_53921_length_266_cov_3237.426009_g53461_i0 PRJNA1241156 53921 266 3237.426009 8611.55318394 Pseudomonas phage vB_PaeM_RP14 2951336 Viruses Viruses 63.9 1.12e-5   NTclustered gi|2374403479|gb|ON524870.1| 2951336 g53461 i0 100 0.473684210526316 34 0 13 0 10 43 81 114 Pseudomonas phage vB_PaeM_RP14, complete genome blastn 126 63.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Vandenendeviridae Nankokuvirus Pseudomonas phage vB_PaeM_RP14
1624798 1624798 PRJNA1241156_S_NODE_49802_length_276_cov_7.557940_g49342_i0 PRJNA1241156 49802 276 7.55794 20.8599144 Caudoviricetes sp. 2832643 Viruses Viruses 150 8.75e-32   NTclustered gi|2057108305|tpg|BK038469.1| 2832643 g49342 i0 85.034 1.72826086956522 147 22 53 0 22 168 12992 12846 MAG TPA_asm: Caudoviricetes sp. isolate ct3Gt1, partial genome blastn 477 150 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
1624902 1624902 PRJNA1241156_S_NODE_57582_length_258_cov_3030.851163_g57122_i0 PRJNA1241156 57582 258 3030.851163 7819.59600054 Macdonaldcampvirus SB28 2956145 Viruses Viruses 124 4.91e-24   NTclustered gi|2852223284|gb|PQ336902.1| 3377757 g57122 i0 93.103 24.8759689922481 87 3 33 3 1 85 45854 45769 Salmonella phage CHRF_10023.1, partial genome blastn 6418 124 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Macdonaldcampvirus Macdonaldcampvirus SB28
2900727 2900727 PRJNA1241156_S_NODE_35723_length_314_cov_2.808118_g35263_i0 PRJNA1241156 35723 314 2.808118 8.81749052 Caudoviricetes sp. 2832643 Viruses Viruses 407 5.439999999999999e-109   NTclustered gi|2914933639|gb|OR221620.1| 2832643 g35263 i0 90.127 2 314 29 99 2 1 313 36243 35931 MAG: Caudoviricetes sp. isolate MSP1439 genomic sequence blastn 628 407 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
4177241 4177241 PRJNA1241156_S_NODE_47724_length_281_cov_1700.647059_g47264_i0 PRJNA1241156 47724 281 1700.647059 4778.81823579 Macdonaldcampvirus SB28 2956145 Viruses Viruses 130 1.16e-25   NTclustered gi|2852223542|gb|PQ336906.1| 3377761 g47264 i0 92.553 66.0533807829182 94 2 32 4 1 91 44954 44863 Salmonella phage CHRF_10034, partial genome blastn 18561 130 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Macdonaldcampvirus Macdonaldcampvirus SB28
4177639 4177639 PRJNA1241156_S_NODE_9424_length_428_cov_1695.574026_g8968_i0 PRJNA1241156 9424 428 1695.574026 7257.05683128 Macdonaldcampvirus SB28 2956145 Viruses Viruses 124 8.62e-24   NTclustered gi|2852223284|gb|PQ336902.1| 3377757 g8968 i0 93.103 14.7616822429907 87 3 20 3 1 85 45854 45769 Salmonella phage CHRF_10023.1, partial genome blastn 6318 124 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Macdonaldcampvirus Macdonaldcampvirus SB28
6153497 6153497 PRJNA1241156_S_NODE_56125_length_262_cov_1.273973_g55665_i0 PRJNA1241156 56125 262 1.273973 3.3378092599999998 Viruses 10239 Viruses Viruses 329 9.859999999999998e-86   NTclustered gi|1955693760|gb|MW349129.1| 2797424 g55665 i0 91.915 2.69465648854962 235 19 90 0 2 236 162471 162237 Staphylococcus phage Madawaska, complete genome blastn 706 329 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Staphylococcus phage Madawaska
8002964 8002964 PRJNA1241156_S_NODE_21367_length_360_cov_3.268139_g20907_i0 PRJNA1241156 21367 360 3.268139 11.7653004 Caudoviricetes sp. 2832643 Viruses Viruses 540 5.97e-149   NTclustered gi|1799113936|gb|MN855733.1| 2832643 g20907 i0 93.906 30.5861111111111 361 17 99 5 1 358 31728 31370 MAG: Caudoviricetes sp. isolate 355, complete genome blastn 11011 540 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
8003078 8003078 PRJNA1241156_S_NODE_28247_length_336_cov_2.552901_g27787_i0 PRJNA1241156 28247 336 2.552901 8.57774736 Caudoviricetes sp. 2832643 Viruses Viruses 440 5.789999999999997e-119   NTclustered gi|2914944268|gb|OR221794.1| 2832643 g27787 i0 92.787 5.24702380952381 305 21 91 1 21 325 34017 34320 MAG: Caudoviricetes sp. isolate MSP1228 genomic sequence blastn 1763 440 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
10554199 10554199 PRJNA1241156_S_NODE_49749_length_276_cov_1914.952790_g49289_i0 PRJNA1241156 49749 276 1914.95279 5285.2697004 Macdonaldcampvirus SB28 2956145 Viruses Viruses 130 1.14e-25   NTclustered gi|2852223542|gb|PQ336906.1| 3377761 g49289 i0 92.553 27.2246376811594 94 2 33 4 1 91 44954 44863 Salmonella phage CHRF_10034, partial genome blastn 7514 130 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Macdonaldcampvirus Macdonaldcampvirus SB28
10554497 10554497 PRJNA1241156_S_NODE_72989_length_213_cov_315.141176_g72529_i0 PRJNA1241156 72989 213 315.141176 671.25070488 Caudoviricetes sp. 2832643 Viruses Viruses 69.4 1.86e-7   NTclustered gi|2914750866|gb|OR221291.1| 2832643 g72529 i0 95.455 19.9906103286385 44 1 21 1 1 44 15 57 MAG: Caudoviricetes sp. isolate MSP1819 genomic sequence blastn 4258 69.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
11829012 11829012 PRJNA1241156_S_NODE_71390_length_224_cov_5.093923_g70930_i0 PRJNA1241156 71390 224 5.093923 11.41038752 Caudoviricetes sp. 2832643 Viruses Viruses 414 2.1999999999999996e-111   NTclustered gi|2914933639|gb|OR221620.1| 2832643 g70930 i0 100 3.37053571428571 224 0 100 0 1 224 31082 30859 MAG: Caudoviricetes sp. isolate MSP1439 genomic sequence blastn 755 414 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
13104340 13104340 PRJNA1241156_S_NODE_9631_length_427_cov_3.018229_g9175_i0 PRJNA1241156 9631 427 3.018229 12.88783783 Caudoviricetes sp. 2832643 Viruses Viruses 54.7 0.011   NTclustered gi|2915000066|gb|OR222291.1| 2832643 g9175 i0 100 0.0679156908665105 29 0 7 0 399 427 65497 65525 MAG: Caudoviricetes sp. isolate MSP0675 genomic sequence blastn 29 54.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
14378936 14378936 PRJNA1241156_S_NODE_34152_length_318_cov_4.887273_g33692_i0 PRJNA1241156 34152 318 4.887273 15.54152814 Caudoviricetes sp. 2832643 Viruses Viruses 134 1.03e-26   NTclustered gi|2054742008|tpg|BK043247.1| 2832643 g33692 i0 82.692 1.42452830188679 156 22 48 4 142 294 37078 36925 MAG TPA_asm: Caudoviricetes sp. isolate ct3xS12, partial genome blastn 453 134 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
15652889 15652889 PRJNA1241156_S_NODE_36673_length_311_cov_5.186567_g36213_i0 PRJNA1241156 36673 311 5.186567 16.13022337 Caudoviricetes sp. 2832643 Viruses Viruses 420 6.92e-113   NTclustered gi|2054434277|tpg|BK035998.1| 2832643 g36213 i0 91.054 398.652733118971 313 24 100 4 1 311 17949 18259 MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome blastn 123981 420 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
19475883 19475883 PRJNA1241156_S_NODE_31896_length_324_cov_4026.701068_g31436_i0 PRJNA1241156 31896 324 4026.701068 13046.51146032 Enterococcus phage SSMH01 3075855 Viruses Viruses 150 1.05e-31   NTclustered gi|2583824285|gb|OR360270.1| 3075855 g31436 i0 93.204 26.4814814814815 103 5 32 2 222 324 41599 41699 Enterococcus phage SSMH01, complete genome blastn 8580 150 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Efquatrovirus Enterococcus phage SSMH01
19476168 19476168 PRJNA1241156_S_NODE_50936_length_273_cov_2832.369565_g50476_i0 PRJNA1241156 50936 273 2832.369565 7732.36891245 Macdonaldcampvirus SB28 2956145 Viruses Viruses 124 5.24e-24   NTclustered gi|2852223284|gb|PQ336902.1| 3377757 g50476 i0 93.103 25.1941391941392 87 3 31 3 1 85 45854 45769 Salmonella phage CHRF_10023.1, partial genome blastn 6878 124 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Macdonaldcampvirus Macdonaldcampvirus SB28
19476464 19476464 PRJNA1241156_S_NODE_72836_length_214_cov_903.093567_g72376_i0 PRJNA1241156 72836 214 903.093567 1932.62023338 Caudoviricetes sp. 2832643 Viruses Viruses 73.1 1.45e-8   NTclustered gi|2914814355|gb|OR221918.1| 2832643 g72376 i0 92.308 19.8271028037383 52 2 24 2 1 52 111522 111473 MAG: Caudoviricetes sp. isolate MSP0212 genomic sequence blastn 4243 73.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
20751807 20751807 PRJNA1241156_S_NODE_64617_length_244_cov_2.358209_g64157_i0 PRJNA1241156 64617 244 2.358209 5.7540299600000004 Caudoviricetes sp. 2832643 Viruses Viruses 67.6 7.86e-7   NTclustered gi|2914755157|gb|OR221483.1| 2832643 g64157 i0 97.5 0.163934426229508 40 0 16 1 191 229 53 14 MAG: Caudoviricetes sp. isolate MSP1602 genomic sequence blastn 40 67.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
20751895 20751895 PRJNA1241156_S_NODE_72477_length_217_cov_3.925287_g72017_i0 PRJNA1241156 72477 217 3.925287 8.51787279 Caudoviricetes sp. 2832643 Viruses Viruses 75 4.09e-9   NTclustered gi|2914760312|gb|OR221747.1| 2832643 g72017 i0 100 19.7188940092166 40 0 18 0 177 216 52 13 MAG: Caudoviricetes sp. isolate MSP1289 genomic sequence blastn 4279 75 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
22027008 22027008 PRJNA1241156_S_NODE_61898_length_249_cov_657.067961_g61438_i0 PRJNA1241156 61898 249 657.067961 1636.09922289 Caudoviricetes sp. 2832643 Viruses Viruses 71.3 6.22e-8   NTclustered gi|2914852300|gb|OR221708.1| 2832643 g61438 i0 100 15.8835341365462 38 0 17 0 11 48 46788 46751 MAG: Caudoviricetes sp. isolate MSP1326 genomic sequence blastn 3955 71.3 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);;