RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA290839" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA290839 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
372900 372900 PRJNA290839_P_NODE_1161_length_250_cov_0.881356_g1140_i0 PRJNA290839 1161 250 0.881356 2.20339 Siphoviridae sp. ctHip2 2827830 Viruses Viruses 424 4.16e-114   NTclustered gi|2052861377|tpg|BK032497.1| 2827830 g1140 i0 97.2 2 250 7 100 0 1 250 60390 60639 MAG TPA_asm: Siphoviridae sp. ctHip2, partial genome blastn 500 424 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ctHip2
5476361 5476361 PRJNA290839_P_NODE_1285_length_248_cov_0.885714_g1264_i0 PRJNA290839 1285 248 0.885714 2.19657072 Caudoviricetes sp. 2832643 Viruses Viruses 231 2.68e-56   NTclustered gi|2914981140|gb|OR222104.1| 2832643 g1264 i0 83.673 0.987903225806452 245 40 99 0 1 245 85978 86222 MAG: Caudoviricetes sp. isolate MSP0003 genomic sequence blastn 245 231 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
10576834 10576834 PRJNA290839_P_NODE_629_length_323_cov_1.364000_g608_i0 PRJNA290839 629 323 1.364 4.40572 Caudoviricetes sp. 2832643 Viruses Viruses 91.6 6.43e-14   NTclustered gi|1433277832|gb|MH552475.1| 2832643 g608 i0 92.188 0.297213622291022 64 5 20 0 260 323 26371 26434 MAG: Caudoviricetes sp. isolate ctbe4, complete genome blastn 96 91.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
10576836 10576836 PRJNA290839_P_NODE_829_length_281_cov_1.129808_g808_i0 PRJNA290839 829 281 1.129808 3.17476048 Caudoviricetes sp. 2832643 Viruses Viruses 499 7.6999999999999985e-137   NTclustered gi|2056935437|tpg|BK022380.1| 2832643 g808 i0 98.925 0.99288256227758 279 3 99 0 3 281 25887 25609 MAG TPA_asm: Caudoviricetes sp. isolate ctg4X23, partial genome blastn 279 499 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
13126712 13126712 PRJNA290839_P_NODE_1251_length_249_cov_0.869318_g1230_i0 PRJNA290839 1251 249 0.869318 2.16460182 Caudoviricetes sp. 2832643 Viruses Viruses 460 3.16e-125   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g1230 i0 100 1 249 0 100 0 1 249 951 703 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 249 460 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
20774377 20774377 PRJNA290839_P_NODE_817_length_284_cov_1.341232_g796_i0 PRJNA290839 817 284 1.341232 3.80909888 Caudoviricetes sp. 2832643 Viruses Viruses 520 5.98e-143   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g796 i0 99.648 1 284 1 100 0 1 284 18767 19050 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 284 520 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);;