RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1111448" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA1111448 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
6596212 6596212 PRJNA1111448_S_NODE_55986_length_335_cov_2.114504_g55163_i0 PRJNA1111448 55986 335 2.114504 7.0835884 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 272 2.2299999999999997e-68   NTclustered gi|325194347|emb|FR825188.1| 890382 g55163 i0 83 71.3014925373134 300 51 90 0 1 300 978 1277 Albugo laibachii Nc14, genomic contig CONTIG_1829_NC14_v4_1468_6528 blastn 23886 272 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
8676202 8676202 PRJNA1111448_S_NODE_72327_length_307_cov_1.243590_g71504_i0 PRJNA1111448 72327 307 1.24359 3.8178213 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 531 3.0199999999999998e-146   NTclustered gi|50261276|ref|NC_005984.1| 4770 g71504 i0 97.735 106.260586319218 309 5 100 2 1 307 9177 9485 Saprolegnia ferax mitochondrion, complete genome blastn 32622 531 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia ferax
15050267 15050267 PRJNA1111448_S_NODE_144412_length_200_cov_4.850394_g143589_i0 PRJNA1111448 144412 200 4.850394 9.700788 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 359 9.14e-95   NTclustered gi|166051677|emb|CU353805.1| 100861 g143589 i0 99 94.985 200 2 100 0 1 200 85 284 Aphanomyces euteiches cDNA blastn 18997 359 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
18069411 18069411 PRJNA1111448_S_NODE_23755_length_441_cov_5.437500_g22933_i0 PRJNA1111448 23755 441 5.4375 23.979375 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 809 0   NTclustered gi|698793876|ref|XR_717098.1| 112090 g22933 i0 99.773 101.24716553288 441 1 100 0 1 441 2124 2564 Aphanomyces astaci 28S ribosomal RNA rRNA blastn 44650 809 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
21895147 21895147 PRJNA1111448_S_NODE_83158_length_291_cov_13.646789_g82335_i0 PRJNA1111448 83158 291 13.646789 39.71215599 Geolegnia helicoides 1432543 SAR_Eukaryotes SAR_Eukaryotes 496 1.04e-135   NTclustered gi|563440377|gb|KF656776.1| 1432543 g82335 i0 97.27 100.216494845361 293 6 100 1 1 291 905 613 Geolegnia helicoides internal transcribed spacer 2 and 28S ribosomal RNA gene, partial sequence blastn 29163 496 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Geolegnia Geolegnia helicoides
23975012 23975012 PRJNA1111448_S_NODE_33039_length_397_cov_26.990741_g32216_i0 PRJNA1111448 33039 397 26.990741 107.15324177 Verrucalvaceae 120409 SAR_Eukaryotes SAR_Eukaryotes 701 0   NTclustered gi|698793877|ref|XR_717099.1| 112090 g32216 i0 98.492 99.8463476070529 398 5 100 1 1 397 598 995 Aphanomyces astaci 18S ribosomal RNA rRNA blastn 39639 701 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci

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