RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond" and bioproject = "PRJNA1022587"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 3

tax_superkingdom 2

tax_clade 2

bioproject 1

  • PRJNA1022587 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
9090267 9090267 PRJNA1022587_S_NODE_1248_length_253_cov_1.033333_g1246_i0 PRJNA1022587 1248 253 1.033333 2.61433249 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 162 2.04e-44   NR KAI9989039.1 4787 g1246 i0 100 4.9802371541502 84 0 99.6 0 1 252 286 369 KAI9989039.1 hypothetical protein PInf_022762 [Phytophthora infestans] diamond 1260 162 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
9090270 9090270 PRJNA1022587_S_NODE_528_length_336_cov_1.376426_g526_i0 PRJNA1022587 528 336 1.376426 4.62479136 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 128 1.1e-31   NR KAI9998245.1 4787 g526 i0 90 0.625 70 7 62.5 0 211 2 357 426 KAI9998245.1 hypothetical protein PInf_002605 [Phytophthora infestans] diamond 210 128 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
25230356 25230356 PRJNA1022587_S_NODE_900_length_284_cov_0.947867_g898_i0 PRJNA1022587 900 284 0.947867 2.69194228 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 180 4.989999999999999e-55   NR KAF4132174.1 4787 g898 i0 93.6 0.992957746478873 94 6 99.3 0 2 283 99 192 KAF4132174.1 hypothetical protein GN958_ATG18628 [Phytophthora infestans] diamond 282 180 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
26749686 26749686 PRJNA1022587_S_NODE_481_length_344_cov_1.431734_g479_i0 PRJNA1022587 481 344 1.431734 4.92516496 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 207 4.91e-63   NR KAI9983278.1 4787 g479 i0 90.4 0.994186046511628 114 8 99.4 1 342 1 37 147 KAI9983278.1 hypothetical protein PInf_007233 [Phytophthora infestans] diamond 342 207 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
26908448 26908448 PRJNA1022587_S_NODE_162_length_501_cov_0.957944_g160_i0 PRJNA1022587 162 501 0.957944 4.79929944 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 352 2.7099999999999996e-109   NR KAF4143623.1 4787 g160 i0 98.8 0.994011976047904 166 2 99.4 0 499 2 1625 1790 KAF4143623.1 hypothetical protein GN958_ATG07187 [Phytophthora infestans] diamond 498 352 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
27698775 27698775 PRJNA1022587_S_NODE_1144_length_262_cov_0.846561_g1142_i0 PRJNA1022587 1144 262 0.846561 2.21798982 Snodgrassella sp. 2815304 Bacteria Bacteria 91.3 2.58e-20   NR MCO6517203.1 2815304 g1142 i0 52.4 0.961832061068702 84 39 95 1 259 11 93 176 MCO6517203.1 hypothetical protein [Snodgrassella sp.] diamond 252 91.3 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Neisseriaceae Snodgrassella Snodgrassella sp.
28866631 28866631 PRJNA1022587_S_NODE_808_length_294_cov_3.574661_g806_i0 PRJNA1022587 808 294 3.574661 10.50950334 Mycoplasmopsis fermentans 2115 Bacteria Bacteria 173 4.459999999999999e-52   NR WP_122484913.1 2115 g806 i0 100 1.79591836734694 88 0 89.8 0 29 292 1 88 WP_122484913.1 ABC transporter ATP-binding protein [Mycoplasmopsis fermentans] diamond 528 173 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
28993288 28993288 PRJNA1022587_S_NODE_368_length_379_cov_1.058824_g366_i0 PRJNA1022587 368 379 1.058824 4.01294296 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 161 3.85e-43   NR KAF4133169.1 4787 g366 i0 94.4 10.5514511873351 125 7 98.9 0 376 2 517 641 KAF4133169.1 hypothetical protein GN958_ATG17640 [Phytophthora infestans] diamond 3999 161 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
29434697 29434697 PRJNA1022587_S_NODE_610_length_320_cov_0.935223_g608_i0 PRJNA1022587 610 320 0.935223 2.9927136 Phytophthora palmivora 4796 SAR_Eukaryotes SAR_Eukaryotes 157 2.76e-45   NR POM74466.1 4796 g608 i0 96.1 0.721875 77 3 72.2 0 304 74 147 223 POM74466.1 Hypothetical protein PHPALM_8576 [Phytophthora palmivora] diamond 231 157 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora palmivora
29592472 29592472 PRJNA1022587_S_NODE_1130_length_263_cov_1.126316_g1128_i0 PRJNA1022587 1130 263 1.126316 2.96221108 Phytophthora cactorum 29920 SAR_Eukaryotes SAR_Eukaryotes 175 5.95e-53   NR KAG2874946.1 29920 g1128 i0 95.4 8.93155893536122 87 4 99.2 0 1 261 62 148 KAG2874946.1 hypothetical protein PC117_g27512 [Phytophthora cactorum] diamond 2349 175 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cactorum
29813780 29813780 PRJNA1022587_S_NODE_1011_length_272_cov_1.160804_g1009_i0 PRJNA1022587 1011 272 1.160804 3.15738688 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 52 2.62e-5   NR KAJ8525862.1 4785 g1009 i0 45.3 0.705882352941177 64 35 70.6 0 255 64 2 65 KAJ8525862.1 hypothetical protein ON010_g15260 [Phytophthora cinnamomi] diamond 192 52 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
30571900 30571900 PRJNA1022587_S_NODE_1313_length_250_cov_0.779661_g1311_i0 PRJNA1022587 1313 250 0.779661 1.9491525 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 146 1.1999999999999996e-38   NR KAI9992435.1 4787 g1311 i0 88.9 1.944 81 9 97.2 0 3 245 593 673 KAI9992435.1 hypothetical protein PInf_017844 [Phytophthora infestans] diamond 486 146 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
30659024 30659024 PRJNA1022587_S_NODE_1393_length_247_cov_0.827586_g1391_i0 PRJNA1022587 1393 247 0.827586 2.04413742 Asteraceae 4210 Plants Plants 53.1 8.63e-6   NR PWA69540.1 35608 g1391 i0 95.5 0.801619433198381 22 1 26.7 0 148 213 334 355 PWA69540.1 Stress up-regulated Nod 19 [Artemisia annua] diamond 198 53.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Artemisia Artemisia annua
31678346 31678346 PRJNA1022587_S_NODE_1337_length_249_cov_0.812500_g1335_i0 PRJNA1022587 1337 249 0.8125 2.023125 Artemisia annua 35608 Plants Plants 104 6.269999999999999e-24   NR PWA85024.1 35608 g1335 i0 94 0.602409638554217 50 3 60.2 0 99 248 1035 1084 PWA85024.1 Integrase, catalytic region, Zinc finger, CCHC-type, Peptidase aspartic, catalytic [Artemisia annua] diamond 150 104 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Artemisia Artemisia annua
32145224 32145224 PRJNA1022587_S_NODE_1258_length_252_cov_0.927374_g1256_i0 PRJNA1022587 1258 252 0.927374 2.33698248 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 170 9.449999999999999e-48   NR KAE8902854.1 53985 g1256 i0 98.8 5.92857142857143 83 1 98.8 0 251 3 292 374 KAE8902854.1 hypothetical protein PF003_g13543 [Phytophthora fragariae] diamond 1494 170 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora fragariae
32343144 32343144 PRJNA1022587_S_NODE_799_length_295_cov_3.824324_g797_i0 PRJNA1022587 799 295 3.824324 11.281755799999999 Salmonella enterica 28901 Bacteria Bacteria 174 8.779999999999999e-55   NR WP_254486001.1 28901 g797 i0 96.5 7.84067796610169 85 3 86.4 0 256 2 1 85 WP_254486001.1 transposase family protein, partial [Salmonella enterica] diamond 2313 174 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
32784676 32784676 PRJNA1022587_S_NODE_920_length_282_cov_0.832536_g918_i0 PRJNA1022587 920 282 0.832536 2.34775152 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 167 6.409999999999998e-47   NR KAF4147955.1 4787 g918 i0 81.5 0.978723404255319 92 17 97.9 0 281 6 445 536 KAF4147955.1 hypothetical protein GN958_ATG02854 [Phytophthora infestans] diamond 276 167 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans

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