RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA951810", 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 · 12 ✖

tax_clade 1

  • Sar · 12 ✖

bioproject 1

  • PRJNA951810 · 12 ✖

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
4766643 4766643 PRJNA951810_P_NODE_97064_length_294_cov_4.828054_g96720_i0 PRJNA951810 97064 294 4.828054 14.19447876 Lithodesmium undulatum 59812 SAR_Eukaryotes SAR_Eukaryotes 202 2.56e-47   NTclustered gi|2088237800|ref|NC_056903.1| 59812 g96720 i0 83.482 73.8367346938775 224 29 74 5 17 233 2717 2939 Lithodesmium undulatum mitochondrion, complete genome blastn 21708 202 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Lithodesmium Lithodesmium undulatum
23889371 23889371 PRJNA951810_P_NODE_20719_length_440_cov_2.678474_g20381_i0 PRJNA951810 20719 440 2.678474 11.7852856 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 281 4.98e-71   NTclustered gi|657012367|gb|KF302531.1| 2850 g20381 i0 83.121 31.4454545454545 314 47 71 6 1 311 326 16 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 13836 281 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
28194098 28194098 PRJNA951810_P_NODE_181106_length_230_cov_12.700637_g180761_i0 PRJNA951810 181106 230 12.700637 29.2114651 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 68.6 3.34e-12   NR KAL3945167.1 3061772 g180761 i0 45.3 0.978260869565217 75 41 97.8 0 225 1 8 82 KAL3945167.1 MAG: hypothetical protein SGBAC_000770 [Bacillariaceae sp.] diamond 225 68.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
28288820 28288820 PRJNA951810_P_NODE_156786_length_252_cov_5.452514_g156441_i0 PRJNA951810 156786 252 5.452514 13.74033528 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 87.8 2.61e-18   NR CAB9516079.1 568900 g156441 i0 63.9 2.17857142857143 61 22 72.6 0 18 200 217 277 CAB9516079.1 Trifunctional UDP-glucose 4,6-dehydratase/UDP-4-keto-6 [Seminavis robusta] diamond 549 87.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29078480 29078480 PRJNA951810_P_NODE_134448_length_270_cov_1.406091_g134103_i0 PRJNA951810 134448 270 1.406091 3.7964457 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 56.2 8.04e-7   NR KAG7348448.1 303405 g134103 i0 37.5 0.8 72 45 80 0 256 41 96 167 KAG7348448.1 globin-like protein [Nitzschia inconspicua] diamond 216 56.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
30151858 30151858 PRJNA951810_P_NODE_34772_length_336_cov_2.376426_g34429_i0 PRJNA951810 34772 336 2.376426 7.98479136 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 68.6 9.16e-11   NR CAJ1932703.1 2856 g34429 i0 39.4 0.883928571428571 99 53 85.7 3 1 288 343 437 CAJ1932703.1 unnamed protein product [Cylindrotheca closterium] diamond 297 68.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
30215066 30215066 PRJNA951810_P_NODE_158532_length_251_cov_2.443820_g158187_i0 PRJNA951810 158532 251 2.44382 6.1339882 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 76.3 5.41e-16   NR KAK1743969.1 267567 g158187 i0 62.3 1.45816733067729 61 23 72.9 0 251 69 28 88 KAK1743969.1 60S ribosomal protein L38 [Skeletonema marinoi] diamond 366 76.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
30253585 30253585 PRJNA951810_P_NODE_108892_length_287_cov_6.289720_g108548_i0 PRJNA951810 108892 287 6.28972 18.0514964 root 1 Root_unresolved Root_unresolved 43.1 0.0406   NR CAJ1960857.1 2856 g108548 i0 41.5 1.4006968641115 41 22 40.8 1 164 48 190 230 CAJ1960857.1 unnamed protein product [Cylindrotheca closterium] diamond 402 43.5 0.990804597701149 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
30348665 30348665 PRJNA951810_P_NODE_158632_length_251_cov_2.000000_g158287_i0 PRJNA951810 158632 251 2 5.02 root 1 Root_unresolved Root_unresolved 49.7 1.5e-4   NR CAJ1951186.1 2856 g158287 i0 41.7 3.14342629482072 72 38 81.3 1 3 206 1071 1142 CAJ1951186.1 unnamed protein product [Cylindrotheca closterium] diamond 789 49.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
30695622 30695622 PRJNA951810_P_NODE_166833_length_245_cov_0.895349_g166488_i0 PRJNA951810 166833 245 0.895349 2.19360505 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 68.6 3.08e-11   NR KAG7341150.1 303405 g166488 i0 41.2 4.17551020408163 85 44 99.2 2 243 1 673 755 KAG7341150.1 methyltransferase type 11 domain containing protein [Nitzschia inconspicua] diamond 1023 68.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
32308699 32308699 PRJNA951810_P_NODE_120199_length_280_cov_2.028986_g119854_i0 PRJNA951810 120199 280 2.028986 5.6811608 Cylindrotheca 2852 SAR_Eukaryotes SAR_Eukaryotes 63.2 3.81e-9   NR CAJ1939047.1 2856 g119854 i0 44.9 1.47857142857143 69 34 69.6 1 207 13 386 454 CAJ1939047.1 unnamed protein product [Cylindrotheca closterium] diamond 414 63.5 0.995275590551181 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32618026 32618026 PRJNA951810_P_NODE_169820_length_242_cov_5.733728_g169475_i0 PRJNA951810 169820 242 5.733728 13.87562176 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0203   NR EJK57826.1 159749 g169475 i0 42 0.855371900826446 69 35 79.3 2 233 42 1147 1215 EJK57826.1 hypothetical protein THAOC_22097 [Thalassiosira oceanica] diamond 207 43.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica

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