RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA682774" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 6 ✖

bioproject 1

  • PRJNA682774 · 6 ✖

analysis 1

  • diamond · 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
664631 664631 PRJNA682774_P_NODE_1_length_8784_cov_195.762943_g0_i0 PRJNA682774 1 8784 195.762943 17195.81691312 Beihai picorna-like virus 48 1922592 Viruses Viruses 1819 0   NR YP_009333545.1 1922592 g0 i0 41.4 0.892418032786885 2613 1347 85.4 47 1038 8540 121 2660 YP_009333545.1 hypothetical protein [Beihai picorna-like virus 48] diamond 7839 1819 1 Viruses               Beihai picorna-like virus 48
27430041 27430041 PRJNA682774_P_NODE_4823_length_245_cov_0.906977_g4794_i0 PRJNA682774 4823 245 0.906977 2.22209365 Sylvanvirus sp. 2487774 Viruses Viruses 124 8.709999999999998e-32   NR AYV87237.1 2487774 g4794 i0 70.4 0.991836734693878 81 24 99.2 0 245 3 161 241 AYV87237.1 MAG: bifunctional aspartate aminotransferase [Sylvanvirus sp.] diamond 243 124 1 Viruses               Sylvanvirus sp.
29335886 29335886 PRJNA682774_P_NODE_2489_length_290_cov_1.437788_g2460_i0 PRJNA682774 2489 290 1.437788 4.1695852 Fadolivirus 2763561 Viruses Viruses 143 1.4e-37   NR AYV78610.1 2487765 g2460 i0 71.9 5.00689655172414 96 27 99.3 0 1 288 11 106 AYV78610.1 MAG: NCLDV major capsid protein [Edafosvirus sp.] diamond 1452 143 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Edafosvirus sp.
29682845 29682845 PRJNA682774_P_NODE_3830_length_251_cov_0.876404_g3801_i0 PRJNA682774 3830 251 0.876404 2.19977404 Pandoravirus 2060084 Viruses Viruses 83.2 2.45e-16   NR YP_009429988.1 1349410 g3801 i0 53.3 5.30677290836653 75 34 89.6 1 230 6 1051 1124 YP_009429988.1 DNA polymerase type-B [Pandoravirus salinus] diamond 1332 83.2 1 Viruses             Pandoravirus Pandoravirus salinus
31852064 31852064 PRJNA682774_P_NODE_4777_length_245_cov_1.360465_g4748_i0 PRJNA682774 4777 245 1.360465 3.33313925 Ripashaj virus 3131130 Viruses Viruses 42.7 0.0381   NR WZH60903.1 3131130 g4748 i0 37.7 0.844897959183673 69 32 71 3 2 175 193 261 WZH60903.1 MAG: RNA-dependent RNA polymerase [Ripashaj virus] diamond 207 42.7 1 Viruses   Orthornavirae Lenarviricota Leviviricetes       Ripashaj virus
31883708 31883708 PRJNA682774_P_NODE_1437_length_365_cov_1.602740_g1408_i0 PRJNA682774 1437 365 1.60274 5.850001 Edafosvirus sp. 2487765 Viruses Viruses 80.5 8.69e-15   NR AYV78268.1 2487765 g1408 i0 36.9 1.0027397260274 122 54 99.5 3 364 2 339 438 AYV78268.1 MAG: P4B major core protein [Edafosvirus sp.] diamond 366 80.5 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Edafosvirus sp.

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