RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA685060" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA685060 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
666187 666187 PRJNA685060_P_NODE_3901_length_493_cov_1.028571_g3811_i0 PRJNA685060 3901 493 1.028571 5.07085503 Caudoviricetes sp. 2832643 Viruses Viruses 708 0   NTclustered gi|2914802716|gb|OR221306.1| 2832643 g3811 i0 92.668 3.09330628803245 491 36 99 0 1 491 18548 18058 MAG: Caudoviricetes sp. isolate MSP1798 genomic sequence blastn 1525 708 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
666197 666197 PRJNA685060_P_NODE_501_length_1262_cov_2.858705_g461_i0 PRJNA685060 501 1262 2.858705 36.0768571 Caudoviricetes sp. 2832643 Viruses Viruses 1916 0   NTclustered gi|2914802716|gb|OR221306.1| 2832643 g461 i0 94.057 3.75990491283677 1262 75 100 0 1 1262 16383 17644 MAG: Caudoviricetes sp. isolate MSP1798 genomic sequence blastn 4745 1916 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
4494074 4494074 PRJNA685060_P_NODE_1624_length_783_cov_5.143662_g1544_i0 PRJNA685060 1624 783 5.143662 40.27487346 Caudoviricetes sp. 2832643 Viruses Viruses 1266 0   NTclustered gi|2914802716|gb|OR221306.1| 2832643 g1544 i0 95.903 1.99489144316731 781 32 99 0 3 783 28392 27612 MAG: Caudoviricetes sp. isolate MSP1798 genomic sequence blastn 1562 1266 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
8319309 8319309 PRJNA685060_P_NODE_4987_length_431_cov_3.530726_g4897_i0 PRJNA685060 4987 431 3.530726 15.21742906 Caudoviricetes sp. 2832643 Viruses Viruses 758 0   NTclustered gi|2914802716|gb|OR221306.1| 2832643 g4897 i0 98.376 2 431 7 100 0 1 431 33836 33406 MAG: Caudoviricetes sp. isolate MSP1798 genomic sequence blastn 862 758 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
9594749 9594749 PRJNA685060_P_NODE_15288_length_246_cov_1.988439_g15198_i0 PRJNA685060 15288 246 1.988439 4.89155994 Caudoviricetes sp. 2832643 Viruses Viruses 178 3.5099999999999993e-40   NTclustered gi|2914802716|gb|OR221306.1| 2832643 g15198 i0 96.296 3.41463414634146 108 4 44 0 1 108 10526 10419 MAG: Caudoviricetes sp. isolate MSP1798 genomic sequence blastn 840 178 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
9594811 9594811 PRJNA685060_P_NODE_6828_length_364_cov_5.525773_g6738_i0 PRJNA685060 6828 364 5.525773 20.11381372 Caudoviricetes sp. 2832643 Viruses Viruses 604 2.1099999999999991e-168   NTclustered gi|2914802716|gb|OR221306.1| 2832643 g6738 i0 96.694 1.99725274725275 363 12 99 0 2 364 27294 27656 MAG: Caudoviricetes sp. isolate MSP1798 genomic sequence blastn 727 604 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
10870129 10870129 PRJNA685060_P_NODE_11529_length_275_cov_1.772277_g11439_i0 PRJNA685060 11529 275 1.772277 4.87376175 Caudoviricetes sp. 2832643 Viruses Viruses 414 2.7999999999999992e-111   NTclustered gi|2914802716|gb|OR221306.1| 2832643 g11439 i0 95.057 1.94181818181818 263 13 96 0 9 271 38842 38580 MAG: Caudoviricetes sp. isolate MSP1798 genomic sequence blastn 534 414 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
10870132 10870132 PRJNA685060_P_NODE_11669_length_273_cov_2.130000_g11579_i0 PRJNA685060 11669 273 2.13 5.8149 Caudoviricetes sp. 2832643 Viruses Viruses 268 2.2899999999999994e-67   NTclustered gi|2914802716|gb|OR221306.1| 2832643 g11579 i0 84.502 2.01465201465201 271 42 99 0 1 271 25184 24914 MAG: Caudoviricetes sp. isolate MSP1798 genomic sequence blastn 550 268 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
12145452 12145452 PRJNA685060_P_NODE_11150_length_281_cov_1.480769_g11060_i0 PRJNA685060 11150 281 1.480769 4.16096089 Caudoviricetes sp. 2832643 Viruses Viruses 305 1.8e-78   NTclustered gi|2915033327|gb|OR222674.1| 2832643 g11060 i0 86.594 0.98220640569395 276 37 98 0 1 276 55224 55499 MAG: Caudoviricetes sp. isolate MSP0256 genomic sequence blastn 276 305 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
14695082 14695082 PRJNA685060_P_NODE_11552_length_275_cov_1.371287_g11462_i0 PRJNA685060 11552 275 1.371287 3.77103925 Caudoviricetes sp. 2832643 Viruses Viruses 409 1.3e-109   NTclustered gi|2915033327|gb|OR222674.1| 2832643 g11462 i0 93.75 0.989090909090909 272 17 99 0 4 275 89152 88881 MAG: Caudoviricetes sp. isolate MSP0256 genomic sequence blastn 272 409 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
17244156 17244156 PRJNA685060_P_NODE_5594_length_406_cov_1.090090_g5504_i0 PRJNA685060 5594 406 1.09009 4.4257654 Caudoviricetes sp. 2832643 Viruses Viruses 651 0   NTclustered gi|2914802716|gb|OR221306.1| 2832643 g5504 i0 95.567 2.26354679802956 406 18 100 0 1 406 33859 34264 MAG: Caudoviricetes sp. isolate MSP1798 genomic sequence blastn 919 651 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
19793075 19793075 PRJNA685060_P_NODE_11516_length_275_cov_2.247525_g11426_i0 PRJNA685060 11516 275 2.247525 6.18069375 Caudoviricetes sp. 2832643 Viruses Viruses 296 1.06e-75   NTclustered gi|2914975773|gb|OR222072.1| 2832643 g11426 i0 96.133 6.10909090909091 181 7 66 0 21 201 31265 31085 MAG: Caudoviricetes sp. isolate MSP0041 genomic sequence blastn 1680 296 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);;