RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "blastn", bioproject = "PRJNA289590" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 28 ✖

tax_kingdom 1

bioproject 1

  • PRJNA289590 · 28 ✖

analysis 1

  • blastn · 28 ✖

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
372387 372387 PRJNA289590_P_NODE_14761_length_235_cov_1.629032_g14537_i0 PRJNA289590 14761 235 1.629032 3.8282252 Caudoviricetes sp. 2832643 Viruses Viruses 435 1.79e-117   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g14537 i0 100 1 235 0 100 0 1 235 20981 21215 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 235 435 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
372726 372726 PRJNA289590_P_NODE_31461_length_162_cov_0.911504_g31237_i0 PRJNA289590 31461 162 0.911504 1.47663648 Caudoviricetes sp. 2832643 Viruses Viruses 294 2.03e-75   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g31237 i0 100 4.52469135802469 159 0 98 0 4 162 58984 58826 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 733 294 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
1647198 1647198 PRJNA289590_P_NODE_19222_length_204_cov_1.006452_g18998_i0 PRJNA289590 19222 204 1.006452 2.05316208 Caudoviricetes sp. 2832643 Viruses Viruses 377 2.59e-100   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g18998 i0 100 1 204 0 100 0 1 204 47243 47446 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 204 377 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
2922980 2922980 PRJNA289590_P_NODE_12403_length_260_cov_0.914692_g12179_i0 PRJNA289590 12403 260 0.914692 2.3781992 Caudoviricetes sp. 2832643 Viruses Viruses 470 5.519999999999998e-128   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g12179 i0 99.231 1 260 2 100 0 1 260 9484 9743 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 260 470 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
2923226 2923226 PRJNA289590_P_NODE_23323_length_182_cov_1.172932_g23099_i0 PRJNA289590 23323 182 1.172932 2.13473624 Caudoviricetes sp. 2832643 Viruses Viruses 337 3.82e-88   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g23099 i0 100 1.78571428571429 182 0 100 0 1 182 12785 12966 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 325 337 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
4199541 4199541 PRJNA289590_P_NODE_16904_length_219_cov_0.941176_g16680_i0 PRJNA289590 16904 219 0.941176 2.06117544 Caudoviricetes sp. 2832643 Viruses Viruses 399 6.009999999999999e-107   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g16680 i0 99.543 1 219 1 100 0 1 219 61763 61545 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 219 399 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
4199591 4199591 PRJNA289590_P_NODE_19084_length_205_cov_0.910256_g18860_i0 PRJNA289590 19084 205 0.910256 1.8660248 Caudoviricetes sp. 2832643 Viruses Viruses 379 7.229999999999999e-101   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g18860 i0 100 1 205 0 100 0 1 205 60367 60571 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 205 379 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
5476148 5476148 PRJNA289590_P_NODE_30005_length_164_cov_0.895652_g29781_i0 PRJNA289590 30005 164 0.895652 1.46886928 Caudoviricetes sp. 2832643 Viruses Viruses 169 1.3000000000000001e-37   NTclustered gi|2914931772|gb|OR221591.1| 2832643 g29781 i0 87.586 61.030487804878 145 18 88 0 18 162 16978 17122 MAG: Caudoviricetes sp. isolate MSP1468 genomic sequence blastn 10009 169 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
6750176 6750176 PRJNA289590_P_NODE_18486_length_208_cov_1.603774_g18262_i0 PRJNA289590 18486 208 1.603774 3.33584992 Caudoviricetes sp. 2832643 Viruses Viruses 385 1.58e-102   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g18262 i0 100 1 208 0 100 0 1 208 8957 9164 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 208 385 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
6750182 6750182 PRJNA289590_P_NODE_18806_length_206_cov_1.656051_g18582_i0 PRJNA289590 18806 206 1.656051 3.41146506 Caudoviricetes sp. 2832643 Viruses Viruses 379 7.269999999999998e-101   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g18582 i0 100 0.995145631067961 205 0 99 0 2 206 55187 54983 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 205 379 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
6750295 6750295 PRJNA289590_P_NODE_24746_length_174_cov_1.664000_g24522_i0 PRJNA289590 24746 174 1.664 2.89536 Caudoviricetes sp. 2832643 Viruses Viruses 322 1.01e-83   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g24522 i0 100 1 174 0 100 0 1 174 62480 62653 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 174 322 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
10576472 10576472 PRJNA289590_P_NODE_21709_length_190_cov_1.106383_g21485_i0 PRJNA289590 21709 190 1.106383 2.1021277 Caudoviricetes sp. 2832643 Viruses Viruses 351 1.4399999999999997e-92   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g21485 i0 100 1 190 0 100 0 1 190 61429 61240 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 190 351 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
10576533 10576533 PRJNA289590_P_NODE_24389_length_176_cov_1.574803_g24165_i0 PRJNA289590 24389 176 1.574803 2.77165328 Caudoviricetes sp. 2832643 Viruses Viruses 313 6.1699999999999985e-81   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g24165 i0 99.419 0.977272727272727 172 1 98 0 1 172 14989 14818 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 172 313 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
13126106 13126106 PRJNA289590_P_NODE_10751_length_281_cov_1.103448_g10527_i0 PRJNA289590 10751 281 1.103448 3.10068888 Caudoviricetes sp. 2832643 Viruses Viruses 508 1.28e-139   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g10527 i0 99.288 1 281 2 100 0 1 281 59100 59380 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 281 508 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
14401376 14401376 PRJNA289590_P_NODE_16372_length_223_cov_0.896552_g16148_i0 PRJNA289590 16372 223 0.896552 1.99931096 Caudoviricetes sp. 2832643 Viruses Viruses 412 7.88e-111   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g16148 i0 100 1 223 0 100 0 1 223 31796 31574 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 223 412 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
14401574 14401574 PRJNA289590_P_NODE_25812_length_169_cov_1.575000_g25588_i0 PRJNA289590 25812 169 1.575 2.66175 Caudoviricetes sp. 2832643 Viruses Viruses 307 2.73e-79   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g25588 i0 99.408 1 169 1 100 0 1 169 43941 43773 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 169 307 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
14401613 14401613 PRJNA289590_P_NODE_28132_length_166_cov_0.888889_g27908_i0 PRJNA289590 28132 166 0.888889 1.47555574 Caudoviricetes sp. 2832643 Viruses Viruses 307 2.69e-79   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g27908 i0 100 1 166 0 100 0 1 166 16886 17051 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 166 307 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
15675115 15675115 PRJNA289590_P_NODE_15173_length_232_cov_1.027322_g14949_i0 PRJNA289590 15173 232 1.027322 2.38338704 Caudoviricetes sp. 2832643 Viruses Viruses 429 8.2e-116   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g14949 i0 100 1 232 0 100 0 1 232 46596 46827 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 232 429 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
16949914 16949914 PRJNA289590_P_NODE_23354_length_182_cov_1.142857_g23130_i0 PRJNA289590 23354 182 1.142857 2.07999974 Caudoviricetes sp. 2832643 Viruses Viruses 337 3.82e-88   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g23130 i0 100 1 182 0 100 0 1 182 22568 22387 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 182 337 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
18224337 18224337 PRJNA289590_P_NODE_28915_length_165_cov_0.896552_g28691_i0 PRJNA289590 28915 165 0.896552 1.4793108 Caudoviricetes sp. 2832643 Viruses Viruses 305 9.59e-79   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g28691 i0 100 1 165 0 100 0 1 165 20579 20415 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 165 305 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
21461165 21461165 PRJNA289590_P_NODE_23197_length_182_cov_2.383459_g22973_i0 PRJNA289590 23197 182 2.383459 4.33789538 Ghunavirus 2732683 Viruses Viruses 60.2 9.25e-5   NTclustered gi|1842037723|ref|NC_048201.1| 1729936 g22973 i0 91.111 2.22527472527473 45 2 24 1 81 123 1739 1695 Pseudomonas phage 17A chromosome 1, complete sequence blastn 405 60.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Autographivirales Autotranscriptaviridae Ghunavirus Ghunavirus gv17A
22048912 22048912 PRJNA289590_P_NODE_18898_length_206_cov_0.993631_g18674_i0 PRJNA289590 18898 206 0.993631 2.04687986 Caudoviricetes sp. 2832643 Viruses Viruses 377 2.62e-100   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g18674 i0 99.515 2.25728155339806 206 1 100 0 1 206 51306 51101 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 465 377 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
22049129 22049129 PRJNA289590_P_NODE_31118_length_162_cov_0.920354_g30894_i0 PRJNA289590 31118 162 0.920354 1.49097348 Caudoviricetes sp. 2832643 Viruses Viruses 294 2.03e-75   NTclustered gi|2914941530|gb|OR221752.1| 2832643 g30894 i0 99.383 1 162 1 100 0 1 162 40960 40799 MAG: Caudoviricetes sp. isolate MSP1281 genomic sequence blastn 162 294 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
23324322 23324322 PRJNA289590_P_NODE_11399_length_272_cov_1.506726_g11175_i0 PRJNA289590 11399 272 1.506726 4.09829472 Caudoviricetes sp. 2832643 Viruses Viruses 503 5.729999999999998e-138   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g11175 i0 100 1 272 0 100 0 1 272 53070 53341 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 272 503 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24598662 24598662 PRJNA289590_P_NODE_22940_length_184_cov_1.118519_g22716_i0 PRJNA289590 22940 184 1.118519 2.05807496 Caudoviricetes sp. 2832643 Viruses Viruses 337 3.869999999999999e-88   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g22716 i0 99.457 1 184 1 100 0 1 184 57891 58074 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 184 337 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24598793 24598793 PRJNA289590_P_NODE_29800_length_164_cov_0.904348_g29576_i0 PRJNA289590 29800 164 0.904348 1.48313072 Caudoviricetes sp. 2832643 Viruses Viruses 287 3.45e-73   NTclustered gi|2054429284|tpg|BK035902.1| 2832643 g29576 i0 98.171 3.65853658536585 164 3 100 0 1 164 23643 23806 MAG TPA_asm: Caudoviricetes sp. isolate ct8Wk4, partial genome blastn 600 287 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24598920 24598920 PRJNA289590_P_NODE_6920_length_364_cov_1.558730_g6696_i0 PRJNA289590 6920 364 1.55873 5.6737772 Caudoviricetes sp. 2832643 Viruses Viruses 667 0   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g6696 i0 99.725 1 364 1 100 0 1 364 19010 18647 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 364 667 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24598979 24598979 PRJNA289590_P_NODE_9360_length_305_cov_0.980469_g9136_i0 PRJNA289590 9360 305 0.980469 2.99043045 Caudoviricetes sp. 2832643 Viruses Viruses 553 6.39e-153   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g9136 i0 99.344 1 305 2 100 0 1 305 50553 50249 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 305 553 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);;