RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJEB7366" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Orthornavirae · 6 ✖

bioproject 1

  • PRJEB7366 · 6 ✖

analysis 1

  • blastn · 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
135245 135245 PRJEB7366_P_NODE_14901_length_203_cov_1.904762_g14467_i0 PRJEB7366 14901 203 1.904762 3.86666686 Picornaviridae sp. 1530251 Viruses Viruses 348 2.0100000000000006e-91   NTclustered gi|2780183578|gb|PP818844.1| 1530251 g14467 i0 97.537 1 203 5 100 0 1 203 1937 2139 Picornaviridae sp. polyprotein and capsid protein genes, complete cds blastn 203 348 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
135265 135265 PRJEB7366_P_NODE_2201_length_657_cov_2.440514_g1837_i0 PRJEB7366 2201 657 2.440514 16.03417698 Picornaviridae sp. 1530251 Viruses Viruses 702 0   NTclustered gi|2780183578|gb|PP818844.1| 1530251 g1837 i0 85.997 1 657 90 99 2 2 657 3802 3147 Picornaviridae sp. polyprotein and capsid protein genes, complete cds blastn 657 702 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
9062504 9062504 PRJEB7366_P_NODE_12708_length_225_cov_1.631579_g12274_i0 PRJEB7366 12708 225 1.631579 3.67105275 Picornaviridae sp. 1530251 Viruses Viruses 399 6.199999999999999e-107   NTclustered gi|2780183578|gb|PP818844.1| 1530251 g12274 i0 99.099 0.986666666666667 222 2 99 0 4 225 1541 1762 Picornaviridae sp. polyprotein and capsid protein genes, complete cds blastn 222 399 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
11613753 11613753 PRJEB7366_P_NODE_18490_length_178_cov_1.398601_g18056_i0 PRJEB7366 18490 178 1.398601 2.48950978 Picornaviridae sp. 1530251 Viruses Viruses 307 2.91e-79   NTclustered gi|2780183578|gb|PP818844.1| 1530251 g18056 i0 97.753 1.15730337078652 178 4 100 0 1 178 574 751 Picornaviridae sp. polyprotein and capsid protein genes, complete cds blastn 206 307 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
11613755 11613755 PRJEB7366_P_NODE_190_length_1803_cov_3.829186_g139_i0 PRJEB7366 190 1803 3.829186 69.04022358 Picornaviridae sp. 1530251 Viruses Viruses 1081 0   NTclustered gi|2780183578|gb|PP818844.1| 1530251 g139 i0 77.772 1.01053799223516 1822 361 99 37 1 1801 7734 5936 Picornaviridae sp. polyprotein and capsid protein genes, complete cds blastn 1822 1081 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
12888784 12888784 PRJEB7366_P_NODE_10991_length_247_cov_1.816038_g10557_i0 PRJEB7366 10991 247 1.816038 4.48561386 Picornaviridae sp. 1530251 Viruses Viruses 418 1.9099999999999998e-112   NTclustered gi|2780183578|gb|PP818844.1| 1530251 g10557 i0 97.166 1 247 7 100 0 1 247 982 1228 Picornaviridae sp. polyprotein and capsid protein genes, complete cds blastn 247 418 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae 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);;