RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA661142" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

bioproject 1

  • PRJNA661142 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
19755098 19755098 PRJNA661142_P_NODE_5676_length_324_cov_7.269091_g5611_i0 PRJNA661142 5676 324 7.269091 23.55185484 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 62.8 9.2e-9   NR CAI2384204.1 5936 g5611 i0 50 0.537037037037037 58 29 53.7 0 249 76 1 58 CAI2384204.1 unnamed protein product [Moneuplotes crassus] diamond 174 62.8 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
26669603 26669603 PRJNA661142_P_NODE_6841_length_292_cov_2.518519_g6776_i0 PRJNA661142 6841 292 2.518519 7.35407548 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 53.9 7.48e-6   NR CAI2371209.1 5936 g6776 i0 45.6 0.924657534246575 90 38 82.2 2 241 2 1 89 CAI2371209.1 unnamed protein product [Moneuplotes crassus] diamond 270 53.9 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
29714192 29714192 PRJNA661142_P_NODE_9570_length_226_cov_1.728814_g9505_i0 PRJNA661142 9570 226 1.728814 3.90711964 Heterotrichida 5957 SAR_Eukaryotes SAR_Eukaryotes 113 5.0100000000000005e-27   NR OMJ96253.1 5963 g9505 i0 70.7 1.99115044247788 75 22 99.6 0 225 1 3532 3606 OMJ96253.1 hypothetical protein SteCoe_217 [Stentor coeruleus] diamond 450 113 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
30334596 30334596 PRJNA661142_P_NODE_8632_length_251_cov_1.009901_g8567_i0 PRJNA661142 8632 251 1.009901 2.53485151 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 139 6.07e-40   NR CAI2382728.1 5936 g8567 i0 86.7 0.99203187250996006 83 11 99.2 0 2 250 54 136 CAI2382728.1 unnamed protein product [Moneuplotes crassus] diamond 249 139 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus

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