RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA1248471" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 16 ✖

bioproject 1

  • PRJNA1248471 · 16 ✖

analysis 1

  • blastn · 16 ✖

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
2904363 2904363 PRJNA1248471_S_NODE_1263_length_365_cov_59.120253_g1178_i0 PRJNA1248471 1263 365 59.120253 215.78892345 Pseudomonas phage LPPA33 3075041 Viruses Viruses 86.1 3.42e-12   NTclustered gi|2583851639|gb|OR188720.1| 3075041 g1178 i0 100 47.7506849315068 46 0 42 0 134 179 48 3 Pseudomonas phage LPPA33, complete genome blastn 17429 86.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage LPPA33
2904528 2904528 PRJNA1248471_S_NODE_963_length_394_cov_243.553623_g878_i0 PRJNA1248471 963 394 243.553623 959.60127462 Pseudomonas phage LPPA36 3075042 Viruses Viruses 106 2.85e-18   NTclustered gi|2583851513|gb|OR188719.1| 3075042 g878 i0 90.588 68.8781725888325 85 0 58 2 112 188 261 177 Pseudomonas phage LPPA36, complete genome blastn 27138 106 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage LPPA36
5457107 5457107 PRJNA1248471_S_NODE_965_length_394_cov_14.214493_g880_i0 PRJNA1248471 965 394 14.214493 56.00510242 Pseudomonas phage LPPA36 3075042 Viruses Viruses 121 1.02e-22   NTclustered gi|2583851513|gb|OR188719.1| 3075042 g880 i0 92.135 58.1903553299492 89 2 62 3 205 293 177 260 Pseudomonas phage LPPA36, complete genome blastn 22927 121 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage LPPA36
7429899 7429899 PRJNA1248471_S_NODE_1086_length_381_cov_13.882530_g1001_i0 PRJNA1248471 1086 381 13.88253 52.8924393 Viruses 10239 Viruses Viruses 117 1.27e-21   NTclustered gi|2583851639|gb|OR188720.1| 3075041 g1001 i0 92.857 71.9448818897638 84 0 59 2 249 326 4 87 Pseudomonas phage LPPA33, complete genome blastn 27411 117 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage LPPA33
9281740 9281740 PRJNA1248471_S_NODE_1028_length_387_cov_171.251479_g943_i0 PRJNA1248471 1028 387 171.251479 662.74322373 Pseudomonas phage LPPA36 3075042 Viruses Viruses 134 1.28e-26   NTclustered gi|2583851513|gb|OR188719.1| 3075042 g943 i0 95.294 70.9922480620155 85 2 60 2 246 328 261 177 Pseudomonas phage LPPA36, complete genome blastn 27474 134 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage LPPA36
9281862 9281862 PRJNA1248471_S_NODE_2228_length_321_cov_12.617647_g2128_i0 PRJNA1248471 2228 321 12.617647 40.50264687 Pseudomonas phage LPPA33 3075041 Viruses Viruses 108 6.34e-19   NTclustered gi|2583851639|gb|OR188720.1| 3075041 g2128 i0 87.879 47.7788161993769 99 3 55 3 119 217 90 1 Pseudomonas phage LPPA33, complete genome blastn 15337 108 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage LPPA33
10557775 10557775 PRJNA1248471_S_NODE_2889_length_304_cov_10.956863_g2789_i0 PRJNA1248471 2889 304 10.956863 33.30886352 Pseudomonas phage LPPA33 3075041 Viruses Viruses 84.2 1e-11   NTclustered gi|2583851639|gb|OR188720.1| 3075041 g2789 i0 100 48.0098684210526 45 0 50 0 144 188 47 3 Pseudomonas phage LPPA33, complete genome blastn 14595 84.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage LPPA33
10557831 10557831 PRJNA1248471_S_NODE_909_length_403_cov_13.135593_g827_i0 PRJNA1248471 909 403 13.135593 52.93643979 Pseudomonas phage LPPA36 3075042 Viruses Viruses 115 4.860000000000001e-21   NTclustered gi|2583851513|gb|OR188719.1| 3075042 g827 i0 88.889 54.4565756823821 99 3 62 4 54 144 173 271 Pseudomonas phage LPPA36, complete genome blastn 21946 115 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage LPPA36
16354440 16354440 PRJNA1248471_S_NODE_2653_length_310_cov_109.954023_g2553_i0 PRJNA1248471 2653 310 109.954023 340.8574713 root 1 Root_unresolved Root_unresolved 110 1.69e-19   NTclustered gi|2583851639|gb|OR188720.1| 3075041 g2553 i0 90.805 44.7774193548387 87 1 40 3 122 201 87 1 Pseudomonas phage LPPA33, complete genome blastn 13881 111 0.990990990990991 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage LPPA33
18205387 18205387 PRJNA1248471_S_NODE_3775_length_281_cov_3.512931_g3675_i0 PRJNA1248471 3775 281 3.512931 9.87133611 Pseudomonas phage LPPA33 3075041 Viruses Viruses 124 5.41e-24   NTclustered gi|2583851639|gb|OR188720.1| 3075041 g3675 i0 93.023 48.44128113879 86 5 45 1 78 162 88 3 Pseudomonas phage LPPA33, complete genome blastn 13612 124 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage LPPA33
20755041 20755041 PRJNA1248471_S_NODE_1077_length_382_cov_38.687688_g992_i0 PRJNA1248471 1077 382 38.687688 147.78696816 Pseudomonas phage LPPA36 3075042 Viruses Viruses 108 7.67e-19   NTclustered gi|2583851513|gb|OR188719.1| 3075042 g992 i0 90.698 68.5811518324607 86 0 59 3 100 177 262 177 Pseudomonas phage LPPA36, complete genome blastn 26198 108 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage LPPA36
21453802 21453802 PRJNA1248471_S_NODE_1097_length_380_cov_38.770393_g1012_i0 PRJNA1248471 1097 380 38.770393 147.3274934 Viruses 10239 Viruses Viruses 124 7.57e-24   NTclustered gi|2583851639|gb|OR188720.1| 3075041 g1012 i0 93.103 64.5131578947368 87 3 62 2 93 177 4 89 Pseudomonas phage LPPA33, complete genome blastn 24515 124 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage LPPA33
23305878 23305878 PRJNA1248471_S_NODE_1019_length_388_cov_92.560472_g934_i0 PRJNA1248471 1019 388 92.560472 359.13463136 Pseudomonas phage LPPA36 3075042 Viruses Viruses 106 2.8e-18   NTclustered gi|2583851513|gb|OR188719.1| 3075042 g934 i0 90.588 67.2268041237113 85 0 60 2 112 188 261 177 Pseudomonas phage LPPA36, complete genome blastn 26084 106 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage LPPA36
24004027 24004027 PRJNA1248471_S_NODE_699_length_437_cov_148.136598_g621_i0 PRJNA1248471 699 437 148.136598 647.35693326 root 1 Root_unresolved Root_unresolved 117 1.48e-21   NTclustered gi|2583851639|gb|OR188720.1| 3075041 g621 i0 92.857 72.6933638443936 84 0 62 3 153 230 4 87 Pseudomonas phage LPPA33, complete genome blastn 31767 117 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage LPPA33
24579881 24579881 PRJNA1248471_S_NODE_1000_length_390_cov_17.011730_g915_i0 PRJNA1248471 1000 390 17.01173 66.345747 Pseudomonas phage LPPA33 3075041 Viruses Viruses 132 4.65e-26   NTclustered gi|2583851639|gb|OR188720.1| 3075041 g915 i0 95.294 67.825641025641 85 0 60 3 258 338 4 88 Pseudomonas phage LPPA33, complete genome blastn 26452 132 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage LPPA33
25278125 25278125 PRJNA1248471_S_NODE_760_length_426_cov_16.509284_g682_i0 PRJNA1248471 760 426 16.509284 70.32954984 root 1 Root_unresolved Root_unresolved 117 1.44e-21   NTclustered gi|2583851639|gb|OR188720.1| 3075041 g682 i0 92.857 71.7558685446009 84 0 63 3 153 230 4 87 Pseudomonas phage LPPA33, complete genome blastn 30568 117 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage LPPA33

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