RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA667863" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 17 ✖

tax_clade 1

bioproject 1

  • PRJNA667863 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
4461918 4461918 PRJNA667863_P_NODE_2204_length_383_cov_4.245161_g2170_i0 PRJNA667863 2204 383 4.245161 16.25896663 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 143 8.69e-39   NR KAI2491131.1 210448 g2170 i0 54.8 2.96083550913838 126 51 98.7 2 379 2 180 299 KAI2491131.1 spermidine-spermine synthase [Fragilaria crotonensis] diamond 1134 143 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
8287248 8287248 PRJNA667863_P_NODE_18607_length_226_cov_3.562092_g18573_i0 PRJNA667863 18607 226 3.562092 8.05032792 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 113 3.7900000000000005e-27   NR GKY96242.1 2872254 g18573 i0 68.8 1.02212389380531 77 22 99.6 1 2 226 223 299 GKY96242.1 hypothetical protein MPSEU_000584000 [Mayamaea pseudoterrestris] diamond 231 113 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
9562492 9562492 PRJNA667863_P_NODE_3388_length_338_cov_1.162264_g3354_i0 PRJNA667863 3388 338 1.162264 3.92845232 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 129 6.059999999999999e-35   NR KAI2493554.1 210448 g3354 i0 58.9 4.45562130177515 95 39 84.3 0 54 338 23 117 KAI2493554.1 hypothetical protein MHU86_20983 [Fragilaria crotonensis] diamond 1506 130 0.992307692307692 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
24860154 24860154 PRJNA667863_P_NODE_15620_length_243_cov_1.388235_g15586_i0 PRJNA667863 15620 243 1.388235 3.37341105 root 1 Root_unresolved Root_unresolved 132 8.289999999999999e-38   NR AID23573.1 2850 g15586 i0 75 3.95061728395062 80 20 98.8 0 2 241 8 87 AID23573.1 ribosomal protein, partial [Phaeodactylum tricornutum] diamond 960 132 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
28723805 28723805 PRJNA667863_P_NODE_18267_length_229_cov_11.916667_g18233_i0 PRJNA667863 18267 229 11.916667 27.28916743 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 76.3 1.31e-15   NR XP_002186290.1 556484 g18233 i0 61.7 0.786026200873362 60 23 78.6 0 180 1 4 63 XP_002186290.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 180 76.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29083228 29083228 PRJNA667863_P_NODE_18388_length_228_cov_4.606452_g18354_i0 PRJNA667863 18388 228 4.606452 10.50271056 root 1 Root_unresolved Root_unresolved 108 7.040000000000001e-27   NR KAI2504277.1 210448 g18354 i0 69.3 6.78947368421053 75 21 97.4 2 224 3 134 207 KAI2504277.1 Cytochrome C1 family [Fragilaria crotonensis] diamond 1548 109 0.990825688073395 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29576022 29576022 PRJNA667863_P_NODE_14130_length_246_cov_0.890173_g14096_i0 PRJNA667863 14130 246 0.890173 2.18982558 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 71.2 2.62e-12   NR CAB9510371.1 568900 g14096 i0 45.7 2.03658536585366 81 42 97.6 2 6 245 118 197 CAB9510371.1 transferase activity [Seminavis robusta] diamond 501 71.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29872546 29872546 PRJNA667863_P_NODE_15991_length_243_cov_0.905882_g15957_i0 PRJNA667863 15991 243 0.905882 2.20129326 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 64.3 8.98e-10   NR KAL3823330.1 382380 g15957 i0 71.1 4.48148148148148 38 11 46.9 0 2 115 463 500 KAL3823330.1 hypothetical protein ACHAXA_010465 [Cyclostephanos tholiformis] diamond 1089 64.7 0.993817619783617 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
30283618 30283618 PRJNA667863_P_NODE_11952_length_250_cov_0.870056_g11918_i0 PRJNA667863 11952 250 0.870056 2.17514 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 130 1.57e-33   NR KAL3816553.1 382380 g11918 i0 72.3 5.976 83 23 99.6 0 1 249 60 142 KAL3816553.1 hypothetical protein ACHAXA_011852 [Cyclostephanos tholiformis] diamond 1494 130 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
30650094 30650094 PRJNA667863_P_NODE_12593_length_249_cov_0.869318_g12559_i0 PRJNA667863 12593 249 0.869318 2.16460182 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 93.6 5.6300000000000005e-21   NR KAL3773943.1 382360 g12559 i0 68.3 4.69879518072289 63 20 75.9 0 2 190 160 222 KAL3773943.1 hypothetical protein ACHAWO_004551 [Cyclotella atomus] diamond 1170 93.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
31123892 31123892 PRJNA667863_P_NODE_12935_length_248_cov_0.880000_g12901_i0 PRJNA667863 12935 248 0.88 2.1824 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 129 2e-34   NR GKY94818.1 2872254 g12901 i0 71.6 0.979838709677419 81 23 98 0 4 246 70 150 GKY94818.1 hypothetical protein MPSEU_000447000 [Mayamaea pseudoterrestris] diamond 243 129 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
31420857 31420857 PRJNA667863_P_NODE_7736_length_272_cov_2.462312_g7702_i0 PRJNA667863 7736 272 2.462312 6.69748864 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 143 7.86e-41   NR KAL3758056.1 259834 g7702 i0 66.7 2.87867647058824 93 28 99.3 1 2 271 3 95 KAL3758056.1 hypothetical protein ACHAWU_002989 [Discostella pseudostelligera] diamond 783 143 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
31756719 31756719 PRJNA667863_P_NODE_10337_length_256_cov_1.251366_g10303_i0 PRJNA667863 10337 256 1.251366 3.20349696 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 61.2 1.14e-8   NR GAX28933.1 1519565 g10303 i0 40.3 1.828125 77 43 90.2 1 233 3 243 316 GAX28933.1 hypothetical protein FisN_20Lh254 [Fistulifera solaris] diamond 468 61.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
31926927 31926927 PRJNA667863_P_NODE_12757_length_248_cov_1.594286_g12723_i0 PRJNA667863 12757 248 1.594286 3.95382928 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 53.1 4.24e-7   NR KAK1737895.1 267567 g12723 i0 52.3 2.91532258064516 44 21 53.2 0 235 104 7 50 KAK1737895.1 hypothetical protein QTG54_011189 [Skeletonema marinoi] diamond 723 53.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
32465010 32465010 PRJNA667863_P_NODE_8359_length_268_cov_1.574359_g8325_i0 PRJNA667863 8359 268 1.574359 4.21928212 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 144 5.9099999999999996e-40   NR CAJ1937478.1 2856 g8325 i0 76.1 2.96641791044776 88 21 98.5 0 2 265 207 294 CAJ1937478.1 unnamed protein product [Cylindrotheca closterium] diamond 795 144 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32610786 32610786 PRJNA667863_P_NODE_19460_length_201_cov_4.742188_g19426_i0 PRJNA667863 19460 201 4.742188 9.53179788 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 53.5 3.1e-6   NR OEU20742.1 635003 g19426 i0 52.5 0.597014925373134 40 19 59.7 0 80 199 7 46 OEU20742.1 MC family transporter: phosphate [Fragilariopsis cylindrus CCMP1102] diamond 120 53.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
32736906 32736906 PRJNA667863_P_NODE_10840_length_253_cov_1.461111_g10806_i0 PRJNA667863 10840 253 1.461111 3.69661083 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 56.2 7.3e-7   NR CAB9519765.1 568900 g10806 i0 32.1 1.93280632411067 81 55 96 0 249 7 330 410 CAB9519765.1 KH domain [Seminavis robusta] diamond 489 56.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta

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