RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 4 ✖

bioproject 1

  • PRJNA888821 · 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
9791182 9791182 PRJNA888821_P_NODE_768_length_596_cov_18.875717_g696_i0 PRJNA888821 768 596 18.875717 112.49927332 Ripaglys virus 3130696 Viruses Viruses 259 3.2400000000000005e-64   NTclustered gi|2717320496|gb|PP172998.1| 3130696 g696 i0 75.203 307.008389261745 617 117 99 32 1 595 2452 1850 MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence blastn 182977 259 1 Viruses   Orthornavirae Lenarviricota Leviviricetes       Ripaglys virus
11066784 11066784 PRJNA888821_P_NODE_9049_length_310_cov_12.421941_g8967_i0 PRJNA888821 9049 310 12.421941 38.508017100000004 brine shrimp yue-like virus 3 2900455 Viruses Viruses 272 2.04e-68   NTclustered gi|2209094280|gb|OL472816.1| 2900455 g8967 i0 99.333 3.83548387096774 150 1 96 0 1 150 4888 4739 MAG: Brine shrimp yue-like virus 3 isolate 02/QH/92-02 segment 1 RNA-dependent RNA polymerase gene, complete cds blastn 1189 272 1 Viruses   Orthornavirae Negarnaviricota Yunchangviricetes Goujianvirales Yueviridae   brine shrimp yue-like virus 3
11445675 11445675 PRJNA888821_P_NODE_3389_length_377_cov_1.467105_g3308_i0 PRJNA888821 3389 377 1.467105 5.53098585 Orthorubulavirus 2560195 Viruses Viruses 689 0   NTclustered gi|1806608684|gb|MN604146.1| 2560580 g3308 i0 99.735 70.867374005305 377 0 100 1 1 377 1675 1300 Mammalian orthorubulavirus 5 isolate XJ033, complete genome blastn 26717 689 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Paramyxoviridae Orthorubulavirus Orthorubulavirus mammalis
13616807 13616807 PRJNA888821_P_NODE_4931_length_333_cov_0.892308_g4849_i0 PRJNA888821 4931 333 0.892308 2.97138564 Pestivirus bovis 3052619 Viruses Viruses 494 4.34e-135   NTclustered gi|2905035930|gb|PQ782224.1| 11099 g4849 i0 93.636 49.8708708708709 330 21 99 0 4 333 7189 6860 Bovine viral diarrhea virus 1 isolate BVDV-1c-IM-2018, complete genome blastn 16607 494 1 Viruses   Orthornavirae Kitrinoviricota Flasuviricetes Amarillovirales Flaviviridae Pestivirus Pestivirus bovis

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