RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1237347" and tax_phylum = "Duplornaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Duplornaviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1237347 · 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
10540606 10540606 PRJNA1237347_P_NODE_11969_length_2296_cov_9.373819_g10338_i0 PRJNA1237347 11969 2296 9.373819 215.22288424 Betacystovirus phi12 3427160 Viruses Viruses 4085 0   NTclustered gi|22855216|ref|NC_004174.1| 161736 g10338 i0 98.78 1 2296 28 100 0 1 2296 1 2296 Pseudomonas phage phi12 segment S, complete sequence blastn 2296 4085 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
13097514 13097514 PRJNA1237347_P_NODE_466971_length_252_cov_4.960894_g460398_i0 PRJNA1237347 466971 252 4.960894 12.50145288 Betacystovirus phi12 3427160 Viruses Viruses 411 3.269999999999999e-110   NTclustered gi|22855221|ref|NC_004175.1| 161736 g460398 i0 96.032 1 252 10 100 0 1 252 2964 3215 Pseudomonas phage phi12 segment M, complete sequence blastn 252 411 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
15648911 15648911 PRJNA1237347_P_NODE_73033_length_833_cov_6.953947_g67137_i0 PRJNA1237347 73033 833 6.953947 57.92637851 Betacystovirus phi12 3427160 Viruses Viruses 1373 0   NTclustered gi|22855221|ref|NC_004175.1| 161736 g67137 i0 96.399 1 833 30 100 0 1 833 4046 3214 Pseudomonas phage phi12 segment M, complete sequence blastn 833 1373 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
20742638 20742638 PRJNA1237347_P_NODE_33177_length_1346_cov_10.311076_g29398_i0 PRJNA1237347 33177 1346 10.311076 138.78708296 Betacystovirus phi12 3427160 Viruses Viruses 2292 0   NTclustered gi|22855221|ref|NC_004175.1| 161736 g29398 i0 97.4 1.02154531946508 1346 35 100 0 1 1346 2972 1627 Pseudomonas phage phi12 segment M, complete sequence blastn 1375 2292 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
23291540 23291540 PRJNA1237347_P_NODE_23239_length_1630_cov_12.861914_g20349_i0 PRJNA1237347 23239 1630 12.861914 209.6491982 Betacystovirus phi12 3427160 Viruses Viruses 2811 0   NTclustered gi|22855221|ref|NC_004175.1| 161736 g20349 i0 97.793 1.00061349693252 1631 35 100 1 1 1630 1631 1 Pseudomonas phage phi12 segment M, complete sequence blastn 1631 2811 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
23298819 23298819 PRJNA1237347_P_NODE_899_length_6745_cov_9.210582_g787_i0 PRJNA1237347 899 6745 9.210582 621.2537559 Betacystovirus phi12 3427160 Viruses Viruses 6408 0   NTclustered gi|22855209|ref|NC_004173.1| 161736 g787 i0 83.842 1.00103780578206 6752 1074 100 15 1 6745 1 6742 Pseudomonas phage phi12 segment L, complete sequence blastn 6752 6408 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12

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