RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJDB9741", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 11 ✖

tax_clade 1

  • Sar · 11 ✖

bioproject 1

  • PRJDB9741 · 11 ✖

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
10213790 10213790 PRJDB9741_P_NODE_39389_length_161_cov_1.410714_g39072_i0 PRJDB9741 39389 161 1.410714 2.27124954 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 124 2.7899999999999998e-24   NTclustered gi|657012562|gb|KF302618.1| 2850 g39072 i0 82 3.6583850931677 150 23 92 4 2 149 426 279 Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds blastn 589 124 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27506703 27506703 PRJDB9741_P_NODE_20043_length_178_cov_1.263566_g19726_i0 PRJDB9741 20043 178 1.263566 2.24914748 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 66.6 5.67e-11   NR KAG7365068.1 303405 g19726 i0 52.7 0.926966292134832 55 26 92.7 0 167 3 635 689 KAG7365068.1 two-component system-sensor histidine kinase [Nitzschia inconspicua] diamond 165 66.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27885370 27885370 PRJDB9741_P_NODE_27285_length_167_cov_1.432203_g26968_i0 PRJDB9741 27285 167 1.432203 2.39177901 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 61.6 2.88e-9   NR KAG7355016.1 303405 g26968 i0 50 0.790419161676647 44 22 79 0 1 132 570 613 KAG7355016.1 hypothetical protein IV203_004372 [Nitzschia inconspicua] diamond 132 61.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28200922 28200922 PRJDB9741_P_NODE_19446_length_179_cov_1.276923_g19129_i0 PRJDB9741 19446 179 1.276923 2.28569217 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 55.1 7.06e-7   NR KAK1740537.1 267567 g19129 i0 55.3 1.49162011173184 47 21 78.8 0 145 5 119 165 KAK1740537.1 cAMP-dependent protein kinase regulatory chain-related protein [Skeletonema marinoi] diamond 267 55.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
28390568 28390568 PRJDB9741_P_NODE_7686_length_226_cov_3.785311_g7369_i0 PRJDB9741 7686 226 3.785311 8.55480286 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 81.3 1.36e-17   NR XP_002186290.1 556484 g7369 i0 58.7 1.64601769911504 63 26 83.6 0 193 5 4 66 XP_002186290.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 372 81.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
28674844 28674844 PRJDB9741_P_NODE_5307_length_274_cov_2.182222_g4991_i0 PRJDB9741 5307 274 2.182222 5.97928828 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 89.7 6.4400000000000006e-21   NR GKY97253.1 2872254 g4991 i0 63.8 0.755474452554745 69 25 75.5 0 274 68 40 108 GKY97253.1 60S ribosomal protein L38 [Mayamaea pseudoterrestris] diamond 207 89.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
30001095 30001095 PRJDB9741_P_NODE_32651_length_165_cov_0.879310_g32334_i0 PRJDB9741 32651 165 0.87931 1.4508615 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 46.6 5.36e-4   NR KAI2495870.1 210448 g32334 i0 46.3 0.745454545454545 41 22 74.5 0 35 157 239 279 KAI2495870.1 methyltransferase domain-containing protein [Fragilaria crotonensis] diamond 123 46.6 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30506525 30506525 PRJDB9741_P_NODE_40713_length_161_cov_0.910714_g40396_i0 PRJDB9741 40713 161 0.910714 1.46624954 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 60.5 2.41e-9   NR KAG7356920.1 303405 g40396 i0 93.3 0.559006211180124 30 2 55.9 0 161 72 170 199 KAG7356920.1 chlorophyll A-B binding protein [Nitzschia inconspicua] diamond 90 60.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
32055561 32055561 PRJDB9741_P_NODE_33258_length_164_cov_1.504348_g32941_i0 PRJDB9741 33258 164 1.504348 2.46713072 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 85.5 9.54e-19   NR KAI2498985.1 210448 g32941 i0 72.2 4.79268292682927 54 15 98.8 0 2 163 143 196 KAI2498985.1 hypothetical protein MHU86_15489 [Fragilaria crotonensis] diamond 786 85.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32176458 32176458 PRJDB9741_P_NODE_28058_length_167_cov_0.864407_g27741_i0 PRJDB9741 28058 167 0.864407 1.44355969 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 105 1.59e-27   NR KAL3760540.1 259834 g27741 i0 96.4 1.97604790419162 55 2 98.8 0 1 165 90 144 KAL3760540.1 hypothetical protein ACHAWU_009501 [Discostella pseudostelligera] diamond 330 105 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
32277319 32277319 PRJDB9741_P_NODE_15419_length_186_cov_1.284672_g15102_i0 PRJDB9741 15419 186 1.284672 2.38948992 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 112 1.82e-30   NR KAL3770671.1 259834 g15102 i0 94.7 0.919354838709677 57 3 91.9 0 186 16 49 105 KAL3770671.1 hypothetical protein ACHAWU_004370 [Discostella pseudostelligera] diamond 171 112 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera

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