RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA453567" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA453567 · 5 ✖

analysis 1

  • diamond · 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
2368795 2368795 PRJNA453567_P_NODE_1882_length_845_cov_2.440594_g1732_i0 PRJNA453567 1882 845 2.440594 20.6230193 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 300 5.889999999999998e-99   NR MES1912193.1 1215613 g1732 i0 66.8 2.51715976331361 238 79 84.5 0 27 740 2 239 MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM] diamond 2127 300 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28008492 28008492 PRJNA453567_P_NODE_6105_length_406_cov_1.373984_g5869_i0 PRJNA453567 6105 406 1.373984 5.57837504 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 91.7 1.91e-18   NR MES1910123.1 1215613 g5869 i0 43.3 2.80788177339901 127 63 90.1 2 6 371 3045 3167 MES1910123.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1140 91.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28355529 28355529 PRJNA453567_P_NODE_1086_length_1128_cov_3.575619_g996_i0 PRJNA453567 1086 1128 3.575619 40.33298232 Hondaea 2315209 SAR_Eukaryotes SAR_Eukaryotes 119 7.999999999999999e-26   NR MES1909711.1 1215613 g996 i0 38.6 1.13829787234043 202 107 52.4 5 1126 536 267 456 MES1909711.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1284 120 0.991666666666667 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30518447 30518447 PRJNA453567_P_NODE_24173_length_178_cov_2.482270_g23936_i0 PRJNA453567 24173 178 2.48227 4.4184406 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 40.8 0.0193   NR AAT09062.1 227086 g23936 i0 52.9 0.573033707865168 34 16 57.3 0 147 46 47 80 AAT09062.1 selenoprotein W 1 [Bigelowiella natans] diamond 102 40.8 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
31308362 31308362 PRJNA453567_P_NODE_2315_length_748_cov_2.789030_g2143_i0 PRJNA453567 2315 748 2.78903 20.8619444 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 87 1.6e-15   NR MES1908555.1 1215613 g2143 i0 44.8 2.31417112299465 96 52 38.5 1 79 366 4 98 MES1908555.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1731 87 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM

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