RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", tax_clade = "Marine virus AFVG" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 12 ✖

tax_clade 1

  • Marine virus AFVG · 12 ✖

analysis 1

  • blastn · 12 ✖

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
6653231 6653231 PRJNA1120203_P_NODE_79166_length_251_cov_0.865169_g78150_i0 PRJNA1120203 79166 251 0.865169 2.17157419 Marine virus AFVG_25M460 2694634 Viruses Viruses 283 7.409999999999999e-72   NTclustered gi|1789808766|gb|MN693122.1| 2694634 g78150 i0 88.186 6.72111553784861 237 28 94 0 15 251 32237 32473 MAG: Marine virus AFVG_25M460, complete genome blastn 1687 283 1 Viruses Marine virus AFVG             Marine virus AFVG_25M460
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
9378102 9378102 PRJNA489308_P_NODE_4448_length_490_cov_2.985612_g4372_i0 PRJNA489308 4448 490 2.985612 14.6294988 Marine virus AFVG_250M428 2693597 Viruses Viruses 52.8 0.048   NTclustered gi|1789809847|gb|MN694203.1| 2693597 g4372 i0 100 0.0571428571428571 28 0 6 0 104 131 19701 19674 MAG: Marine virus AFVG_250M428, complete genome blastn 28 52.8 1 Viruses Marine virus AFVG             Marine virus AFVG_250M428
11365755 11365755 PRJNA664479_S_NODE_14189_length_167_cov_1.686441_g14113_i0 PRJNA664479 14189 167 1.686441 2.81635647 Viruses 10239 Viruses Viruses 52.8 0.014   NTclustered gi|1789809212|gb|MN693568.1| 2694428 g14113 i0 100 0.335329341317365 28 0 17 0 134 161 19091 19064 MAG: Marine virus AFVG_25M275, complete genome blastn 56 52.8 1 Viruses Marine virus AFVG             Marine virus AFVG_25M275
13309147 13309147 PRJNA565584_P_NODE_144451_length_266_cov_1.279793_g143299_i0 PRJNA565584 144451 266 1.279793 3.40424938 Marine virus AFVG_250M168 2693296 Viruses Viruses 62.1 4.04e-5   NTclustered gi|1789809613|gb|MN693969.1| 2693296 g143299 i0 100 0.240601503759398 33 0 13 0 156 188 29429 29461 MAG: Marine virus AFVG_250M168, complete genome blastn 64 62.1 1 Viruses Marine virus AFVG             Marine virus AFVG_250M168
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
15061770 15061770 PRJNA1148190_P_NODE_164812_length_410_cov_1.878338_g153644_i0 PRJNA1148190 164812 410 1.878338 7.7011858 Viruses 10239 Viruses Viruses 60.2 2.35e-4   NTclustered gi|1789808767|gb|MN693123.1| 2694418 g153644 i0 77.778 0.526829268292683 108 16 25 4 229 329 19738 19632 MAG: Marine virus AFVG_25M266, complete genome blastn 216 60.2 1 Viruses Marine virus AFVG             Marine virus AFVG_25M266
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
18127298 18127298 PRJNA1120203_P_NODE_93975_length_245_cov_0.895349_g92959_i0 PRJNA1120203 93975 245 0.895349 2.19360505 Marine virus AFVG_25M487 2694663 Viruses Viruses 281 2.59e-71   NTclustered gi|1789808913|gb|MN693269.1| 2694663 g92959 i0 87.347 2.6530612244898 245 31 100 0 1 245 42733 42489 MAG: Marine virus AFVG_25M487, complete genome blastn 650 281 1 Viruses Marine virus AFVG             Marine virus AFVG_25M487
20371108 20371108 PRJNA900028_P_NODE_142396_length_165_cov_1.051724_g141647_i0 PRJNA900028 142396 165 1.051724 1.7353446 Viruses 10239 Viruses Viruses 52.8 0.014   NTclustered gi|1789809103|gb|MN693459.1| 2694411 g141647 i0 100 0.509090909090909 28 0 17 0 14 41 23464 23437 MAG: Marine virus AFVG_25M26, complete genome blastn 84 52.8 1 Viruses Marine virus AFVG             Marine virus AFVG_25M26

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