RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA558770" and tax_clade = "CRESS viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • CRESS viruses · 4 ✖

bioproject 1

  • PRJNA558770 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
7507584 7507584 PRJNA558770_P_NODE_2946_length_892_cov_31.208868_g2064_i0 PRJNA558770 2946 892 31.208868 278.38310256 Viruses 10239 Viruses Viruses 1648 0   NTclustered gi|1848664582|gb|MN891788.1| 2740165 g2064 i0 100 3.2432735426009 892 0 100 0 1 892 2508 1617 Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome blastn 2893 1648 1 Viruses CRESS viruses Shotokuvirae Cressdnaviricota         Brassica caulorapa CRESS virus
8781885 8781885 PRJNA558770_P_NODE_18187_length_461_cov_17.178404_g16354_i0 PRJNA558770 18187 461 17.178404 79.19244244 Viruses 10239 Viruses Viruses 848 0   NTclustered gi|1848664582|gb|MN891788.1| 2740165 g16354 i0 100 3.06290672451193 459 0 99 0 3 461 1269 811 Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome blastn 1412 848 1 Viruses CRESS viruses Shotokuvirae Cressdnaviricota         Brassica caulorapa CRESS virus
11333399 11333399 PRJNA558770_P_NODE_8289_length_618_cov_13.795883_g6841_i0 PRJNA558770 8289 618 13.795883 85.25855694 Viruses 10239 Viruses Viruses 1129 0   NTclustered gi|1848664582|gb|MN891788.1| 2740165 g6841 i0 99.676 2.99514563106796 617 2 99 0 1 617 146 762 Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome blastn 1851 1129 1 Viruses CRESS viruses Shotokuvirae Cressdnaviricota         Brassica caulorapa CRESS virus
13883844 13883844 PRJNA558770_P_NODE_43711_length_321_cov_8.716783_g41713_i0 PRJNA558770 43711 321 8.716783 27.98087343 Viruses 10239 Viruses Viruses 573 5.199999999999999e-159   NTclustered gi|1848664582|gb|MN891788.1| 2740165 g41713 i0 99.062 2.99065420560748 320 2 99 1 1 320 1310 1628 Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome blastn 960 573 1 Viruses CRESS viruses Shotokuvirae Cressdnaviricota         Brassica caulorapa CRESS 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);;