RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA207343" and tax_kingdom = "Pararnavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Pararnavirae · 3 ✖

bioproject 1

  • PRJNA207343 · 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
1641603 1641603 PRJNA207343_S_NODE_2102_length_646_cov_6.954023_g1636_i0 PRJNA207343 2102 646 6.954023 44.92298858 Tasmanian devil retrovirus 1332312 Viruses Viruses 754 0   NTclustered gi|618757818|gb|KC845928.1| 1332312 g1636 i0 98.818 93.109907120743 423 5 99 0 215 637 1261 839 Tasmanian devil retrovirus strain DRV2010 polymerase (pol) and envelope protein (env) genes, partial cds blastn 60149 754 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Alpharetrovirus Tasmanian devil retrovirus
4883908 4883908 PRJNA207343_S_NODE_5304_length_295_cov_3.802326_g4767_i0 PRJNA207343 5304 295 3.802326 11.2168617 Alpharetrovirus 153057 Viruses Viruses 252 2.52e-62   NTclustered gi|538525|dbj|D10932.1|MAV202 11960 g4767 i0 85.938 12.0779661016949 256 12 87 3 27 282 307 76 Avian myeloblastosis-associated virus MAV-2(0)2 proviral DNA, long terminal repeat region blastn 3563 252 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Alpharetrovirus Avian myeloblastosis-associated virus
14396026 14396026 PRJNA207343_S_NODE_6372_length_248_cov_4.180095_g5835_i0 PRJNA207343 6372 248 4.180095 10.3666356 Avian myeloblastosis-associated virus 11960 Viruses Viruses 355 1.53e-93   NTclustered gi|407987|gb|L10924.1|MAVTYP2AAA 31670 g5835 i0 93.496 64.1612903225806 246 4 99 1 1 246 7202 7435 Myeloblastosis-associated virus type 2 env gene, complete cds; gag gene, complete cds; pol gene, 3' end of cds blastn 15912 355 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Alpharetrovirus Avian myeloblastosis-associated virus

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