RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA795663" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA795663 · 3 ✖

analysis 1

  • diamond · 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
28980369 28980369 PRJNA795663_S_NODE_48_length_2122_cov_6.181295_g21_i0 PRJNA795663 48 2122 6.181295 131.1670799 Orius laevigatus dicistrovirus 1 3344925 Viruses Viruses 279 5.6e-78   NR XGU09082.1 3344925 g21 i0 34.7 0.814326107445806 576 309 74.1 17 20 1591 351 911 XGU09082.1 MAG: nucleocapsid [Orius laevigatus dicistrovirus 1] diamond 1728 279 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Orius laevigatus dicistrovirus 1
30907104 30907104 PRJNA795663_S_NODE_9394_length_198_cov_1.465839_g9289_i0 PRJNA795663 9394 198 1.465839 2.90236122 Dicistroviridae sp. 1955144 Viruses Viruses 51.6 1.52e-5   NR XCO49031.1 1955144 g9289 i0 44.4 2.54545454545455 54 24 81.8 1 196 35 175 222 XCO49031.1 MAG: putative ORF2 protein [Dicistroviridae sp.] diamond 504 51.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
31065118 31065118 PRJNA795663_S_NODE_55_length_1954_cov_3.960876_g28_i0 PRJNA795663 55 1954 3.960876 77.39551704 Orius laevigatus dicistrovirus 1 3344925 Viruses Viruses 293 1.85e-81   NR XGU09081.1 3344925 g28 i0 49.8 0.922722620266121 305 143 45.6 3 1951 1061 363 665 XGU09081.1 MAG: RdRp [Orius laevigatus dicistrovirus 1] diamond 1803 293 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Orius laevigatus dicistrovirus 1

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