RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA767802" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 3 ✖

bioproject 1

  • PRJNA767802 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
7123930 7123930 PRJNA767802_P_NODE_5786_length_334_cov_1.301754_g5713_i0 PRJNA767802 5786 334 1.301754 4.34785836 Gammaretrovirus murleu 3428959 Viruses Viruses 601 2.49e-167   NTclustered gi|375344385|gb|JQ048953.1| 11786 g5713 i0 99.102 99.9640718562874 334 3 100 0 1 334 9 342 Murine leukemia virus isolate PCR amplicon 3220_2 group specific antigen (gag) gene, partial cds blastn 33388 601 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
18596921 18596921 PRJNA767802_P_NODE_255_length_1547_cov_9.919226_g239_i0 PRJNA767802 255 1547 9.919226 153.45042622 Fringilla montifringilla Circoviridae sp. 2815000 Viruses Viruses 2584 0   NTclustered gi|2015371863|gb|MW182726.1| 2815000 g239 i0 99.647 6.95604395604396 1415 4 99 1 2 1415 669 2083 MAG: Fringilla montifringilla Circoviridae sp. isolate brb26cir1 genomic sequence blastn 10761 2584 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Cirlivirales Circoviridae   Fringilla montifringilla Circoviridae sp.
19871959 19871959 PRJNA767802_P_NODE_16216_length_167_cov_0.864407_g16143_i0 PRJNA767802 16216 167 0.864407 1.44355969 Caudoviricetes sp. 2832643 Viruses Viruses 86.1 1.38e-12   NTclustered gi|2914808581|gb|OR221683.1| 2832643 g16143 i0 83.696 0.550898203592814 92 13 54 2 1 91 2561 2651 MAG: Caudoviricetes sp. isolate MSP1355 genomic sequence blastn 92 86.1 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);;