RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA694770" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA694770 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
7558073 7558073 PRJNA694770_P_NODE_26506_length_380_cov_1.293160_g26212_i0 PRJNA694770 26506 380 1.29316 4.914008 root 1 Root_unresolved Root_unresolved 686 0   NTclustered gi|166044642|emb|CU367551.1| 100861 g26212 i0 99.211 100.097368421053 380 3 100 0 1 380 317 696 Aphanomyces euteiches cDNA blastn 38037 691 0.992764109985528 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
15978496 15978496 PRJNA694770_P_NODE_89313_length_246_cov_0.890173_g89019_i0 PRJNA694770 89313 246 0.890173 2.18982558 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 392 1.15e-104   NTclustered gi|325194231|emb|FR825088.1| 890382 g89019 i0 95.528 1.49186991869919 246 10 100 1 1 246 1289 1045 Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 blastn 367 392 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
20306980 20306980 PRJNA694770_P_NODE_44036_length_314_cov_1.278008_g43742_i0 PRJNA694770 44036 314 1.278008 4.01294512 root 1 Root_unresolved Root_unresolved 508 1.45e-139   NTclustered gi|166044588|emb|CU367497.1| 100861 g43742 i0 95.86 73.5700636942675 314 13 100 0 1 314 32 345 Aphanomyces euteiches cDNA blastn 23101 508 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
21582933 21582933 PRJNA694770_P_NODE_50917_length_294_cov_2.248869_g50623_i0 PRJNA694770 50917 294 2.248869 6.61167486 root 1 Root_unresolved Root_unresolved 544 3.69e-150   NTclustered gi|166046790|emb|CU367365.1| 100861 g50623 i0 100 14.9795918367347 294 0 100 0 1 294 798 505 Aphanomyces euteiches cDNA blastn 4404 544 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
22858277 22858277 PRJNA694770_P_NODE_60618_length_279_cov_1.092233_g60324_i0 PRJNA694770 60618 279 1.092233 3.04733007 root 1 Root_unresolved Root_unresolved 468 2.15e-127   NTclustered gi|166044639|emb|CU367548.1| 100861 g60324 i0 97.445 69.8530465949821 274 7 98 0 1 274 391 118 Aphanomyces euteiches cDNA blastn 19489 468 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches

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