RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 6 ✖

bioproject 1

  • PRJNA951412 · 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
4763152 4763152 PRJNA951412_P_NODE_2924_length_284_cov_1.469194_g2839_i0 PRJNA951412 2924 284 1.4691940000000001 4.17251096 Taphios ghabri-like virus 1 2980097 Viruses Viruses 520 5.98e-143   NTclustered gi|2306601784|gb|OP191687.1| 2980097 g2839 i0 99.648 2 284 1 100 0 1 284 2433 2150 MAG: Taphios ghabri-like virus 1 isolate Nanocea1, partial genome blastn 568 520 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales     Taphios ghabri-like virus 1
4763223 4763223 PRJNA951412_P_NODE_844_length_496_cov_2.780142_g759_i0 PRJNA951412 844 496 2.780142 13.78950432 Shenzhen dicistro-like virus 2789378 Viruses Viruses 833 0   NTclustered gi|1940198121|gb|MT757492.1| 2789378 g759 i0 96.976 1.99798387096774 496 15 100 0 1 496 7502 7997 Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds blastn 991 833 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Shenzhen dicistro-like virus
8587806 8587806 PRJNA951412_P_NODE_627_length_584_cov_4.379648_g542_i0 PRJNA951412 627 584 4.379648 25.57714432 Shenzhen dicistro-like virus 2789378 Viruses Viruses 1026 0   NTclustered gi|1940198121|gb|MT757492.1| 2789378 g542 i0 98.294 3.81678082191781 586 8 100 2 1 584 8377 8962 Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds blastn 2229 1026 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Shenzhen dicistro-like virus
14962639 14962639 PRJNA951412_P_NODE_3052_length_280_cov_1.497585_g2967_i0 PRJNA951412 3052 280 1.497585 4.193238 Shenzhen dicistro-like virus 2789378 Viruses Viruses 496 9.92e-136   NTclustered gi|1940198121|gb|MT757492.1| 2789378 g2967 i0 98.571 3 280 4 100 0 1 280 4389 4110 Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds blastn 840 496 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Shenzhen dicistro-like virus
20061447 20061447 PRJNA951412_P_NODE_3076_length_279_cov_1.514563_g2991_i0 PRJNA951412 3076 279 1.514563 4.22563077 Shenzhen dicistro-like virus 2789378 Viruses Viruses 488 1.6499999999999999e-133   NTclustered gi|1935607040|gb|MT747995.1| 2789378 g2991 i0 98.208 3 279 5 100 0 1 279 5561 5839 Shenzhen dicistro-like virus strain USAdp-3 polyprotein gene, complete cds blastn 837 488 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Shenzhen dicistro-like virus
23887114 23887114 PRJNA951412_P_NODE_1399_length_377_cov_4.381579_g1314_i0 PRJNA951412 1399 377 4.381579 16.51855283 Shenzhen dicistro-like virus 2789378 Viruses Viruses 636 7.789999999999999e-178   NTclustered gi|1940198121|gb|MT757492.1| 2789378 g1314 i0 97.082 2 377 11 100 0 1 377 7999 8375 Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds blastn 754 636 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Shenzhen dicistro-like 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);;