RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA293022" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA293022 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
2923991 2923991 PRJNA293022_P_NODE_48283_length_200_cov_6.629139_g47546_i0 PRJNA293022 48283 200 6.629139 13.258278 brine shrimp iflavirus 3 2900464 Viruses Viruses 361 2.5399999999999998e-95   NTclustered gi|2209094746|gb|OL472445.1| 2900464 g47546 i0 99.495 10.91 198 1 99 0 1 198 202 5 MAG: Brine shrimp iflavirus 3 isolate KC/14 RNA-dependent RNA polymerase gene, complete cds blastn 2182 361 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus brine shrimp iflavirus 3
4200464 4200464 PRJNA293022_P_NODE_4_length_8990_cov_8.789173_g1_i0 PRJNA293022 4 8990 8.789173 790.1466527 brine shrimp iflavirus 3 2900464 Viruses Viruses 16449 0   NTclustered gi|2209094744|gb|OL472444.1| 2900464 g1 i0 99.7 11.0094549499444 8988 27 99 0 1 8988 9230 243 MAG: Brine shrimp iflavirus 3 isolate RUS/14-15 RNA-dependent RNA polymerase gene, complete cds blastn 98975 16449 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus brine shrimp iflavirus 3
8026762 8026762 PRJNA293022_P_NODE_74227_length_165_cov_0.896552_g73490_i0 PRJNA293022 74227 165 0.896552 1.4793108 Dill cryptic virus 1 1408895 Viruses Viruses 291 2.69e-74   NTclustered gi|551701372|gb|KF484726.1| 1408895 g73490 i0 98.773 4.92121212121212 163 2 99 0 1 163 792 954 Dill cryptic virus 1 isolate IPP_hortorum segment 1, complete sequence blastn 812 291 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Dill cryptic virus 1
10577155 10577155 PRJNA293022_P_NODE_26149_length_276_cov_1.669604_g25412_i0 PRJNA293022 26149 276 1.669604 4.60810704 Chronilont virus 3129882 Viruses Viruses 182 3.1e-41   NTclustered gi|2717318562|gb|PP172279.1| 3129882 g25412 i0 89.116 241.260869565217 147 15 53 1 2 147 3672 3526 MAG: Chronilont virus isolate CN1B_k141_68688 genomic sequence blastn 66588 182 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae   Chronilont virus
20774679 20774679 PRJNA293022_P_NODE_25297_length_281_cov_0.887931_g24560_i0 PRJNA293022 25297 281 0.887931 2.49508611 brine shrimp partiti-like virus 4 2900391 Viruses Viruses 510 3.56e-140   NTclustered gi|2209094901|gb|OL472522.1| 2900391 g24560 i0 99.642 12.9074733096085 279 1 99 0 1 279 373 95 MAG: Brine shrimp partiti-like virus 4 isolate SD/17-18 RNA-dependent RNA polymerase gene, complete cds blastn 3627 510 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   brine shrimp partiti-like virus 4

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