RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA498309" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 16 ✖

bioproject 1

  • PRJNA498309 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
17058288 17058288 PRJNA498309_P_NODE_52714_length_362_cov_3.467692_g50566_i0 PRJNA498309 52714 362 3.467692 12.55304504 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 108 3.66e-27   NR CDW78764.1 5949 g50566 i0 81.3 2.13812154696133 64 12 53 0 19 210 93 156 CDW78764.1 40s ribosomal protein s18 [Stylonychia lemnae] diamond 774 108 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
27108434 27108434 PRJNA498309_P_NODE_9142_length_1008_cov_14.467559_g7763_i0 PRJNA498309 9142 1008 14.467559 145.83299472 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 68.6 1.55e-8   NR KAI2501302.1 210448 g7763 i0 48.5 0.982142857142857 66 34 19.6 0 907 710 923 988 KAI2501302.1 Reverse transcriptase (RNA-dependent DNA polymerase) [Fragilaria crotonensis] diamond 990 68.6 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27282268 27282268 PRJNA498309_P_NODE_113503_length_166_cov_1.496124_g111354_i0 PRJNA498309 113503 166 1.496124 2.48356584 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 89 6.61e-19   NR CAD8087091.1 5886 g111354 i0 73.1 3.75903614457831 52 14 94 0 3 158 1098 1149 CAD8087091.1 unnamed protein product [Paramecium primaurelia] diamond 624 89 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
27929888 27929888 PRJNA498309_P_NODE_96465_length_203_cov_1.144578_g94316_i0 PRJNA498309 96465 203 1.144578 2.32349334 Amoebophrya sp. A25 1410381 SAR_Eukaryotes SAR_Eukaryotes 40.4 0.0488   NR CAD7961644.1 1410381 g94316 i0 41.3 0.679802955665025 46 26 68 1 152 15 19 63 CAD7961644.1 unnamed protein product [Amoebophrya sp. A25] diamond 138 40.4 1 Eukaryota Sar     Dinophyceae Syndiniales Amoebophryaceae Amoebophrya Amoebophrya sp. A25
28024659 28024659 PRJNA498309_P_NODE_114145_length_165_cov_1.210938_g111996_i0 PRJNA498309 114145 165 1.210938 1.9980477 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 42 0.0243   NR KAL3805015.1 29204 g111996 i0 67.9 0.509090909090909 28 9 50.9 0 78 161 225 252 KAL3805015.1 hypothetical protein HJC23_003243 [Cyclotella cryptica] diamond 84 42 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29508494 29508494 PRJNA498309_P_NODE_36890_length_460_cov_3.685579_g34827_i0 PRJNA498309 36890 460 3.685579 16.9536634 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 73.2 1.58e-12   NR CAE7362164.1 2951 g34827 i0 66.7 0.332608695652174 51 16 32.6 1 75 224 63 113 CAE7362164.1 ybbA [Symbiodinium microadriaticum] diamond 153 73.2 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
29634487 29634487 PRJNA498309_S_NODE_21790_length_422_cov_3.485788_g19659_i0 PRJNA498309 21790 422 3.485788 14.71002536 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 102 8.43e-25   NR XP_004024378.1 5932 g19659 i0 50.5 1.58530805687204 111 52 78.2 2 414 85 11 119 XP_004024378.1 ribosomal protein, putative [Ichthyophthirius multifiliis] diamond 669 102 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
29982254 29982254 PRJNA498309_P_NODE_60851_length_324_cov_1.620209_g58703_i0 PRJNA498309 60851 324 1.620209 5.24947716 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00749   NR KAJ1428400.1 483371 g58703 i0 47.4 0.527777777777778 57 17 52.8 3 99 269 172 215 KAJ1428400.1 P-loop containing nucleoside triphosphate hydrolase protein [Ochromonadaceae sp. CCMP2298] diamond 171 45.4 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
30045294 30045294 PRJNA498309_P_NODE_36071_length_466_cov_4.505828_g34014_i0 PRJNA498309 36071 466 4.505828 20.99715848 Tribonema minus 303371 SAR_Eukaryotes SAR_Eukaryotes 91.3 1.56e-20   NR KAG5174960.1 303371 g34014 i0 63.9 0.463519313304721 72 26 46.4 0 441 226 39 110 KAG5174960.1 hypothetical protein JKP88DRAFT_351767 [Tribonema minus] diamond 216 91.3 1 Eukaryota Sar     Xanthophyceae Tribonematales Tribonemataceae Tribonema Tribonema minus
30139844 30139844 PRJNA498309_P_NODE_31312_length_506_cov_4.739872_g29301_i0 PRJNA498309 31312 506 4.739872 23.98375232 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 52.4 2.49e-4   NR KAJ1434138.1 483371 g29301 i0 41.1 0.432806324110672 73 36 39.7 2 489 289 2273 2344 KAJ1434138.1 REJ domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 219 52.4 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
30203148 30203148 PRJNA498309_P_NODE_65232_length_304_cov_10.677903_g63084_i0 PRJNA498309 65232 304 10.677903 32.46082512 Cryptosporidium bovis 310047 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0302   NR XP_067181760.1 310047 g63084 i0 47.1 0.503289473684211 51 25 48.4 1 178 32 370 420 XP_067181760.1 interaptin [Cryptosporidium bovis] diamond 153 43.9 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium bovis
30235003 30235003 PRJNA498309_P_NODE_94592_length_207_cov_3.064706_g92443_i0 PRJNA498309 94592 207 3.064706 6.34394142 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 80.5 1.08e-15   NR KAJ1430857.1 483371 g92443 i0 62.7 0.855072463768116 59 21 85.5 1 24 200 234 291 KAJ1430857.1 major facilitator superfamily domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 177 80.5 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
30266941 30266941 PRJNA498309_P_NODE_47132_length_392_cov_4.140845_g44996_i0 PRJNA498309 47132 392 4.140845 16.2321124 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 102 5.93e-25   NR XP_004024378.1 5932 g44996 i0 50.5 1.70663265306122 111 52 84.2 2 385 56 11 119 XP_004024378.1 ribosomal protein, putative [Ichthyophthirius multifiliis] diamond 669 102 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
31451511 31451511 PRJNA498309_P_NODE_37816_length_452_cov_22.154217_g35746_i0 PRJNA498309 37816 452 22.154217 100.13706084 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 86.7 1.67e-16   NR KAI2512534.1 210448 g35746 i0 87 0.915929203539823 46 6 30.5 0 264 127 617 662 KAI2512534.1 Transketolase [Fragilaria crotonensis] diamond 414 86.7 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32543358 32543358 PRJNA498309_P_NODE_42399_length_421_cov_3.130208_g40283_i0 PRJNA498309 42399 421 3.130208 13.17817568 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 140 7.18e-38   NR KAI2499454.1 210448 g40283 i0 53.8 0.94061757719715 132 60 93.3 1 21 413 101 232 KAI2499454.1 hypothetical protein MHU86_15038 [Fragilaria crotonensis] diamond 396 140 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32716149 32716149 PRJNA498309_P_NODE_63560_length_311_cov_10.386861_g61412_i0 PRJNA498309 63560 311 10.386861 32.30313771 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 116 3.9999999999999994e-28   NR XP_002186044.1 556484 g61412 i0 65.1 5.18971061093248 83 29 80.1 0 311 63 398 480 XP_002186044.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 1614 116 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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