RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA966993" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 4 ✖

bioproject 1

  • PRJNA966993 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
1265524 1265524 PRJNA966993_P_NODE_40901_length_337_cov_1.166667_g40449_i0 PRJNA966993 40901 337 1.166667 3.93166779 root 1 Root_unresolved Root_unresolved 610 4.18e-170   NTclustered gi|62011|emb|X17008.1| 12730 g40449 i0 99.407 51.6824925816024 337 1 100 1 1 337 1314 979 Sendai virus polymerase (P) gene (strain fushimi) blastn 17417 616 0.99025974025974 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Paramyxoviridae Respirovirus Respirovirus laryngotracheitidis
2217343 2217343 PRJNA966993_P_NODE_2_length_8533_cov_92.980024_g1_i0 PRJNA966993 2 8533 92.980024 7933.98544792 Picornaviridae sp. 1530251 Viruses Viruses 8564 0   NTclustered gi|2780183578|gb|PP818844.1| 1530251 g1 i0 86.569 0.916207664361889 7818 988 91 56 1 7789 7785 1 Picornaviridae sp. polyprotein and capsid protein genes, complete cds blastn 7818 8564 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
16245522 16245522 PRJNA966993_P_NODE_98993_length_241_cov_0.916667_g98541_i0 PRJNA966993 98993 241 0.916667 2.20916747 Mitovirus sp. 2587224 Viruses Viruses 130 9.74e-26   NTclustered gi|1698234317|gb|MN033515.1| 2587224 g98541 i0 89.32 0.817427385892116 103 11 43 0 139 241 116 14 MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence blastn 197 130 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae Mitovirus Mitovirus sp.
17520321 17520321 PRJNA966993_P_NODE_57254_length_288_cov_3.786047_g56802_i0 PRJNA966993 57254 288 3.786047 10.90381536 Mitovirus sp. 2587224 Viruses Viruses 126 1.5499999999999998e-24   NTclustered gi|1698234317|gb|MN033515.1| 2587224 g56802 i0 95 0.277777777777778 80 4 28 0 185 264 112 33 MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence blastn 80 126 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae Mitovirus Mitovirus 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);;