RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA1013345" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 9 ✖

bioproject 1

  • PRJNA1013345 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
15030188 15030188 PRJNA1013345_P_NODE_13952_length_185_cov_1.318841_g13822_i0 PRJNA1013345 13952 185 1.318841 2.43985585 Bacteriophage sp. 38018 Viruses Viruses 119 1.37e-29   NR DAX96258.1 38018 g13822 i0 96.6 0.940540540540541 58 2 94.1 0 11 184 962 1019 DAX96258.1 MAG TPA: Tail tape measure [Bacteriophage sp.] diamond 174 119 1 Viruses               Bacteriophage sp.
27666886 27666886 PRJNA1013345_P_NODE_28444_length_160_cov_1.442478_g28314_i0 PRJNA1013345 28444 160 1.442478 2.3079648 Tupanvirus soda lake 2126985 Viruses Viruses 58.5 3.23e-8   NR YP_010781722.1 2126985 g28314 i0 47.2 1.9875 53 28 99.4 0 159 1 91 143 YP_010781722.1 ankyrin repeat protein [Tupanvirus soda lake] diamond 318 58.5 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Tupanvirus Tupanvirus salinum
27698651 27698651 PRJNA1013345_P_NODE_29004_length_160_cov_0.902655_g28874_i0 PRJNA1013345 29004 160 0.902655 1.444248 Caudoviricetes sp. 2832643 Viruses Viruses 65.9 8.46e-11   NR DAS80423.1 2832643 g28874 i0 62.7 0.95625 51 19 95.6 0 153 1 72 122 DAS80423.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 153 65.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27785475 27785475 PRJNA1013345_P_NODE_5964_length_251_cov_1.000000_g5834_i0 PRJNA1013345 5964 251 1 2.51 root 1 Root_unresolved Root_unresolved 100 1.0099999999999999e-23   NR DAS80236.1 2832643 g5834 i0 62.9 1.80478087649402 70 26 83.7 0 2 211 111 180 DAS80236.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 453 100 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27950931 27950931 PRJNA1013345_P_NODE_19325_length_173_cov_1.253968_g19195_i0 PRJNA1013345 19325 173 1.253968 2.16936464 Caudoviricetes sp. 2832643 Viruses Viruses 45.4 0.00165   NR DAS80424.1 2832643 g19195 i0 48.1 0.901734104046243 52 21 90.2 2 173 18 1056 1101 DAS80424.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 156 45.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28266411 28266411 PRJNA1013345_P_NODE_9646_length_207_cov_1.225000_g9516_i0 PRJNA1013345 9646 207 1.225 2.53575 Caudoviricetes sp. 2832643 Viruses Viruses 100 5.78e-24   NR DAS80151.1 2832643 g9516 i0 69.1 0.985507246376812 68 21 98.6 0 3 206 14 81 DAS80151.1 MAG TPA: LexA-binding, inner membrane-associated putative hydrolase [Caudoviricetes sp.] diamond 204 100 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29182461 29182461 PRJNA1013345_P_NODE_9849_length_206_cov_2.761006_g9719_i0 PRJNA1013345 9849 206 2.761006 5.68767236 Gordonia phage Cashline 2812936 Viruses Viruses 47 6.8e-4   NR QSM00084.1 2812936 g9719 i0 42.9 1.01941747572816 70 20 77.2 2 165 7 26 92 QSM00084.1 antirepressor [Gordonia phage Cashline] diamond 210 47 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Gordonia phage Cashline
29214082 29214082 PRJNA1013345_P_NODE_24549_length_164_cov_0.871795_g24419_i0 PRJNA1013345 24549 164 0.871795 1.4297438 Podoviridae sp. ctlpi2 2826574 Viruses Viruses 42.7 0.0064   NR DAD83119.1 2826574 g24419 i0 45.2 0.768292682926829 42 23 76.8 0 37 162 6 47 DAD83119.1 MAG TPA: hydrolase [Podoviridae sp. ctlpi2] diamond 126 42.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Podoviridae sp. ctlpi2
31962984 31962984 PRJNA1013345_P_NODE_33078_length_154_cov_3.654206_g32948_i0 PRJNA1013345 33078 154 3.654206 5.62747724 Gordonia phage Stormageddon 2656541 Viruses Viruses 76.3 8.62e-15   NR YP_010059506.1 2656541 g32948 i0 69.4 0.954545454545455 49 15 95.5 0 149 3 241 289 YP_010059506.1 minor tail protein [Gordonia phage Stormageddon] diamond 147 76.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Stormageddonvirus Stormageddonvirus Stormageddon

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