RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA784979" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA784979 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
8418662 8418662 PRJNA784979_S_NODE_1987_length_330_cov_1.516014_g1945_i0 PRJNA784979 1987 330 1.516014 5.0028462 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 129 7.87e-33   NR YP_009029080.1 2856 g1945 i0 57.3 1.87272727272727 103 44 93.6 0 2 310 47 149 YP_009029080.1 hypothetical protein [Cylindrotheca closterium] diamond 618 129 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
26832176 26832176 PRJNA784979_S_NODE_5821_length_204_cov_1.077419_g5779_i0 PRJNA784979 5821 204 1.077419 2.19793476 Phytophthora lilii 2077276 SAR_Eukaryotes SAR_Eukaryotes 69.7 6.71e-12   NR GMF31033.1 2077276 g5779 i0 56.1 0.838235294117647 57 25 83.8 0 199 29 113 169 GMF31033.1 unnamed protein product [Phytophthora lilii] diamond 171 69.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora lilii
27116641 27116641 PRJNA784979_S_NODE_9382_length_172_cov_1.130081_g9340_i0 PRJNA784979 9382 172 1.130081 1.94373932 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 73.9 6.12e-14   NR KAF4128241.1 4787 g9340 i0 60.7 0.976744186046512 56 21 97.7 1 170 3 27 81 KAF4128241.1 hypothetical protein GN958_ATG22563 [Phytophthora infestans] diamond 168 73.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
27464609 27464609 PRJNA784979_S_NODE_8223_length_180_cov_1.877863_g8181_i0 PRJNA784979 8223 180 1.877863 3.3801534 Phytophthora fragariae 53985 SAR_Eukaryotes SAR_Eukaryotes 58.5 4.14e-8   NR KAE9302619.1 53985 g8181 i0 77.1 0.8 48 10 78.3 1 148 8 34 81 KAE9302619.1 hypothetical protein PF008_g22450 [Phytophthora fragariae] diamond 144 58.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora fragariae
30189257 30189257 PRJNA784979_S_NODE_10592_length_166_cov_1.811966_g10550_i0 PRJNA784979 10592 166 1.811966 3.00786356 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 63.9 4.1e-10   NR KAF4128246.1 4787 g10550 i0 60.7 6.05421686746988 56 19 97.6 2 3 164 67 121 KAF4128246.1 hypothetical protein GN958_ATG22568 [Phytophthora infestans] diamond 1005 63.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
30852784 30852784 PRJNA784979_S_NODE_6494_length_196_cov_1.034014_g6452_i0 PRJNA784979 6494 196 1.034014 2.02666744 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 63.5 7.12e-11   NR KAF4128243.1 4787 g6452 i0 40.3 2.05102040816327 67 38 99.5 1 195 1 57 123 KAF4128243.1 hypothetical protein GN958_ATG22565 [Phytophthora infestans] diamond 402 63.9 0.993740219092332 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
31064965 31064965 PRJNA784979_S_NODE_5335_length_210_cov_1.136646_g5293_i0 PRJNA784979 5335 210 1.136646 2.3869566 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 76.6 2.02e-14   NR KAF0714686.1 120398 g5293 i0 53.8 0.928571428571429 65 28 90 1 199 11 283 347 KAF0714686.1 hypothetical protein As57867_003739 [Aphanomyces stellatus] diamond 195 76.6 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
32424874 32424874 PRJNA784979_S_NODE_5059_length_214_cov_1.539394_g5017_i0 PRJNA784979 5059 214 1.539394 3.29430316 Phytophthora fragariaefolia 1490495 SAR_Eukaryotes SAR_Eukaryotes 49.7 8.93e-5   NR GMF22350.1 1490495 g5017 i0 56.9 0.714953271028037 51 21 70.1 1 152 3 184 234 GMF22350.1 unnamed protein product [Phytophthora fragariaefolia] diamond 153 49.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora fragariaefolia

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