RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA473641" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA473641 · 6 ✖

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
2995870 2995870 PRJNA473641_P_NODE_483_length_1037_cov_2.057054_g428_i0 PRJNA473641 483 1037 2.057054 21.33164998 Pseudo-nitzschia sabit 1664502 SAR_Eukaryotes SAR_Eukaryotes 95.3 1.72e-14   NTclustered gi|2852238230|gb|PQ498358.1| 1664502 g428 i0 82.883 32.4146576663452 111 13 10 6 169 276 33333 33440 Pseudo-nitzschia sabit isolate CNS00609 mitochondrion, complete genome blastn 33614 95.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia sabit
27802866 27802866 PRJNA473641_P_NODE_17884_length_250_cov_0.870056_g17801_i0 PRJNA473641 17884 250 0.870056 2.17514 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 63.9 1.36e-9   NR KAG7349683.1 303405 g17801 i0 52.3 1.056 88 35 97.2 2 1 243 234 321 KAG7349683.1 von Willebrand factor type A domain containing protein [Nitzschia inconspicua] diamond 264 63.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28339493 28339493 PRJNA473641_P_NODE_20306_length_247_cov_1.436782_g20223_i0 PRJNA473641 20306 247 1.436782 3.54885154 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 87 7.33e-20   NR CAB9516179.1 568900 g20223 i0 54.3 0.850202429149798 70 32 85 0 12 221 54 123 CAB9516179.1 expressed unknown protein [Seminavis robusta] diamond 210 87 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28418990 28418990 PRJNA473641_P_NODE_4926_length_408_cov_3.020896_g4843_i0 PRJNA473641 4926 408 3.020896 12.32525568 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 124 1.4999999999999999e-33   NR CAJ1940348.1 2856 g4843 i0 60.4 9.25735294117647 91 36 66.9 0 46 318 3 93 CAJ1940348.1 unnamed protein product [Cylindrotheca closterium] diamond 3777 124 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
28640033 28640033 PRJNA473641_P_NODE_20407_length_247_cov_0.885057_g20324_i0 PRJNA473641 20407 247 0.885057 2.18609079 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 89.7 2.37e-19   NR KAI2488791.1 210448 g20324 i0 46.3 2.91497975708502 80 43 97.2 0 6 245 199 278 KAI2488791.1 Diacylglycerol acyltransferase [Fragilaria crotonensis] diamond 720 89.7 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32067587 32067587 PRJNA473641_P_NODE_19958_length_248_cov_0.880000_g19875_i0 PRJNA473641 19958 248 0.88 2.1824 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 47 0.00129   NR KAL3769464.1 259834 g19875 i0 39.7 2.47983870967742 58 33 67.7 2 235 68 1024 1081 KAL3769464.1 hypothetical protein ACHAWU_008873 [Discostella pseudostelligera] diamond 615 47 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);;