RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1120060" and tax_clade = "Marine virus AFVG"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Marine virus AFVG · 5 ✖

bioproject 1

  • PRJNA1120060 · 5 ✖

analysis 1

  • blastn · 5 ✖

tax_phylum 0

tax_kingdom 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
3576456 3576456 PRJNA1120060_P_NODE_2049403_length_271_cov_1.020202_g2031366_i0 PRJNA1120060 2049403 271 1.020202 2.76474742 Viruses 10239 Viruses Viruses 54.7 0.007   NTclustered gi|1789810207|gb|MN694563.1| 2693044 g2031366 i0 100 0.214022140221402 29 0 11 0 190 218 20398 20426 MAG: Marine virus AFVG_250M1025, complete genome blastn 58 54.7 1 Viruses Marine virus AFVG             Marine virus AFVG_250M1025
6648552 6648552 PRJNA1120060_P_NODE_75366_length_622_cov_2.934426_g62042_i0 PRJNA1120060 75366 622 2.934426 18.25212972 Marine virus AFVG_250M561 2693745 Viruses Viruses 54.7 0.017   NTclustered gi|1789809372|gb|MN693728.1| 2693745 g62042 i0 100 0.0466237942122186 29 0 5 0 541 569 18126 18154 MAG: Marine virus AFVG_250M561, complete genome blastn 29 54.7 1 Viruses Marine virus AFVG             Marine virus AFVG_250M561
7907960 7907960 PRJNA1120060_P_NODE_2728967_length_248_cov_0.880000_g2710884_i0 PRJNA1120060 2728967 248 0.88 2.1824 Marine virus AFVG_250M184 2693314 Viruses Viruses 54.7 0.006   NTclustered gi|1789810310|gb|MN694666.1| 2693314 g2710884 i0 96.97 0.133064516129032 33 0 13 1 17 49 22929 22898 MAG: Marine virus AFVG_250M184, complete genome blastn 33 54.7 1 Viruses Marine virus AFVG             Marine virus AFVG_250M184
15052897 15052897 PRJNA1120060_P_NODE_1222372_length_310_cov_2.451477_g1204432_i0 PRJNA1120060 1222372 310 2.451477 7.5995787 Viruses 10239 Viruses Viruses 54.7 0.008   NTclustered gi|1789809886|gb|MN694242.1| 2693093 g1204432 i0 100 0.187096774193548 29 0 9 0 175 203 15446 15418 MAG: Marine virus AFVG_250M107, complete genome blastn 58 54.7 1 Viruses Marine virus AFVG             Marine virus AFVG_250M107
15549343 15549343 PRJNA1120060_P_NODE_2060573_length_270_cov_2.568528_g2042536_i0 PRJNA1120060 2060573 270 2.568528 6.9350256 Marine virus AFVG_25M376 2694540 Viruses Viruses 52.8 0.025   NTclustered gi|1789809029|gb|MN693385.1| 2694540 g2042536 i0 100 0.103703703703704 28 0 10 0 95 122 34163 34190 MAG: Marine virus AFVG_25M376, complete genome blastn 28 52.8 1 Viruses Marine virus AFVG             Marine virus AFVG_25M376

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