RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA839281" 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

  • PRJNA839281 · 6 ✖

analysis 1

  • diamond · 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
7207702 7207702 PRJNA839281_S_NODE_10866_length_241_cov_1.062500_g10597_i0 PRJNA839281 10866 241 1.0625 2.560625 Globisporangium splendens 82926 SAR_Eukaryotes SAR_Eukaryotes 62.8 2.84e-9   NR KAF1324749.1 82926 g10597 i0 50 2.83817427385892 84 30 92.1 3 14 235 182 263 KAF1324749.1 Nucleosome assembly protein 1, partial [Globisporangium splendens] diamond 684 62.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium Globisporangium splendens
27939209 27939209 PRJNA839281_S_NODE_26205_length_167_cov_1.728814_g25936_i0 PRJNA839281 26205 167 1.728814 2.88711938 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 49.3 6.46e-5   NR RHY33897.1 157072 g25936 i0 78.6 1.02395209580838 28 6 50.3 0 165 82 530 557 RHY33897.1 hypothetical protein DYB32_003863, partial [Aphanomyces invadans] diamond 171 49.3 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
30117750 30117750 PRJNA839281_S_NODE_7392_length_297_cov_1.153226_g7123_i0 PRJNA839281 7392 297 1.153226 3.42508122 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 120 8.539999999999998e-30   NR GLD94132.1 114742 g7123 i0 56.1 4.94949494949495 98 43 99 0 3 296 247 344 GLD94132.1 hypothetical protein PINS_up002743 [Pythium insidiosum] diamond 1470 120 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
30157702 30157702 PRJNA839281_S_NODE_32372_length_164_cov_0.886957_g32103_i0 PRJNA839281 32372 164 0.886957 1.45460948 root 1 Root_unresolved Root_unresolved 41.6 0.0332   NR DBA01564.1 4803 g32103 i0 41.9 4.24390243902439 43 25 78.7 0 130 2 48 90 DBA01564.1 TPA: hypothetical protein N0F65_011535 [Lagenidium giganteum] diamond 696 41.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
30402676 30402676 PRJNA839281_S_NODE_18693_length_191_cov_1.274648_g18424_i0 PRJNA839281 18693 191 1.274648 2.43457768 Aphanomyces cochlioides 112091 SAR_Eukaryotes SAR_Eukaryotes 53.9 1.42e-6   NR KAG9399183.1 112091 g18424 i0 50 0.722513089005236 46 23 72.3 0 154 17 26 71 KAG9399183.1 hypothetical protein AC1031_012144 [Aphanomyces cochlioides] diamond 138 53.9 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cochlioides
30465722 30465722 PRJNA839281_S_NODE_32153_length_164_cov_0.886957_g31884_i0 PRJNA839281 32153 164 0.886957 1.45460948 Thraustotheca clavata 74557 SAR_Eukaryotes SAR_Eukaryotes 42 0.0234   NR AIG55696.1 74557 g31884 i0 50 0.841463414634146 46 21 84.1 1 157 20 115 158 AIG55696.1 secreted protein, partial [Thraustotheca clavata] diamond 138 42 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata

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