RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJEB25583" and tax_phylum = "Cossaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cossaviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJEB25583 · 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
27917500 27917500 PRJEB25583_P_NODE_3685_length_211_cov_1.333333_g3508_i0 PRJEB25583 3685 211 1.333333 2.81333263 Phylloscopus inornatus ambidensovirus 2794452 Viruses Viruses 86.7 1.72e-18   NR QVW56792.1 2794452 g3508 i0 65.1 0.895734597156398 63 22 89.6 0 23 211 171 233 QVW56792.1 MAG: structural protein VP1 [Phylloscopus inornatus ambidensovirus] diamond 189 86.7 1 Viruses   Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Ambidensovirus Phylloscopus inornatus ambidensovirus
29496304 29496304 PRJEB25583_P_NODE_2730_length_245_cov_2.701923_g2553_i0 PRJEB25583 2730 245 2.701923 6.61971135 Parvoviridae sp. 1940570 Viruses Viruses 56.2 6.43e-7   NR WAQ80602.1 1940570 g2553 i0 43.7 5.11836734693878 71 34 86.9 2 223 11 43 107 WAQ80602.1 MAG: replication protein [Parvoviridae sp.] diamond 1254 56.2 1 Viruses   Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Parvoviridae sp.
29653814 29653814 PRJEB25583_P_NODE_870_length_510_cov_4.534884_g698_i0 PRJEB25583 870 510 4.534884 23.1279084 Accipiter gentilis parvo-like hybrid virus 2794564 Viruses Viruses 155 8.19e-42   NR QTE04017.1 2794564 g698 i0 58 0.841176470588235 143 58 82.9 2 490 68 310 452 QTE04017.1 MAG: putative capsid protein [Accipiter gentilis parvo-like hybrid virus] diamond 429 155 1 Viruses   Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Accipiter gentilis parvo-like hybrid 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);;