RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA983848" and tax_phylum = "Cossaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cossaviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA983848 · 6 ✖

analysis 1

  • diamond · 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
20092783 20092783 PRJNA983848_P_NODE_10516_length_2120_cov_8.003420_g7900_i0 PRJNA983848 10516 2120 8.00342 169.672504 Parvovirus octopus5722 3117162 Viruses Viruses 623 5.119999999999998e-215   NR DBA49577.1 3117162 g7900 i0 66.4 0.643867924528302 455 149 64.4 2 1969 605 28 478 DBA49577.1 MAG TPA_asm: NS1 [Parvovirus octopus5722] diamond 1365 623 1 Viruses   Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Parvovirus octopus5722
29173935 29173935 PRJNA983848_P_NODE_36909_length_653_cov_1.341379_g31115_i0 PRJNA983848 36909 653 1.341379 8.75920487 Parvovirus octopus5722 3117162 Viruses Viruses 145 1.35e-36   NR DBA49577.1 3117162 g31115 i0 73.3 0.464012251148545 101 24 45 2 524 231 328 428 DBA49577.1 MAG TPA_asm: NS1 [Parvovirus octopus5722] diamond 303 145 1 Viruses   Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Parvovirus octopus5722
29426143 29426143 PRJNA983848_P_NODE_121449_length_271_cov_2.843434_g115566_i0 PRJNA983848 121449 271 2.843434 7.70570614 Parvovirus octopus5722 3117162 Viruses Viruses 124 5.7e-31   NR DBA49577.1 3117162 g115566 i0 64.3 1.08487084870849 98 27 99.6 1 2 271 115 212 DBA49577.1 MAG TPA_asm: NS1 [Parvovirus octopus5722] diamond 294 124 1 Viruses   Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Parvovirus octopus5722
29646958 29646958 PRJNA983848_P_NODE_117050_length_277_cov_1.735294_g111167_i0 PRJNA983848 117050 277 1.735294 4.80676438 Parvovirus octopus5722 3117162 Viruses Viruses 47.4 0.00131   NR DBA49577.1 3117162 g111167 i0 35.4 0.703971119133574 65 40 70.4 1 76 270 137 199 DBA49577.1 MAG TPA_asm: NS1 [Parvovirus octopus5722] diamond 195 47.4 1 Viruses   Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Parvovirus octopus5722
31037731 31037731 PRJNA983848_P_NODE_142755_length_250_cov_1.954802_g136872_i0 PRJNA983848 142755 250 1.954802 4.887005 Parvovirus octopus5722 3117162 Viruses Viruses 105 1.15e-24   NR DBA49576.1 3117162 g136872 i0 57.3 0.984 82 35 98.4 0 248 3 229 310 DBA49576.1 MAG TPA_asm: VP [Parvovirus octopus5722] diamond 246 105 1 Viruses   Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Parvovirus octopus5722
31922862 31922862 PRJNA983848_P_NODE_61957_length_412_cov_1.823009_g56075_i0 PRJNA983848 61957 412 1.823009 7.51079708 Parvovirus octopus5722 3117162 Viruses Viruses 91.7 1.38e-18   NR DBA49576.1 3117162 g56075 i0 70.2 0.41504854368932 57 16 40.8 1 169 2 175 231 DBA49576.1 MAG TPA_asm: VP [Parvovirus octopus5722] diamond 171 91.7 1 Viruses   Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Parvovirus octopus5722

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