RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA492406" 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

bioproject 1

  • PRJNA492406 · 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
1099291 1099291 PRJNA492406_P_NODE_281_length_2055_cov_13.672553_g204_i0 PRJNA492406 281 2055 13.672553 280.97096415 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 241 4.22e-58   NTclustered gi|2088237800|ref|NC_056903.1| 59812 g204 i0 72.234 23.3172749391727 922 209 44 39 931 1840 5973 6859 Lithodesmium undulatum mitochondrion, complete genome blastn 47917 241 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Lithodesmium Lithodesmium undulatum
5555947 5555947 PRJNA492406_P_NODE_17865_length_295_cov_1.387387_g17566_i0 PRJNA492406 17865 295 1.387387 4.09279165 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 178 4.33e-40   NTclustered gi|2059418728|gb|MW971521.1| 303405 g17566 i0 79.104 67.7254237288136 268 48 90 8 1 265 20977 20715 Nitzschia inconspicua strain hildebrandi mitochondrion, complete genome blastn 19979 178 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
8105753 8105753 PRJNA492406_P_NODE_28827_length_247_cov_0.885057_g28528_i0 PRJNA492406 28827 247 0.885057 2.18609079 Haslea ostrearia 67476 SAR_Eukaryotes SAR_Eukaryotes 143 1.29e-29   NTclustered gi|2175666594|gb|MW595180.1| 67476 g28528 i0 82.822 58.17004048583 163 24 65 4 1 161 606 446 Haslea ostrearia strain OZ-1 cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial blastn 14368 143 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea ostrearia
10656430 10656430 PRJNA492406_P_NODE_3569_length_634_cov_11.021390_g3277_i0 PRJNA492406 3569 634 11.02139 69.8756126 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 158 1.3e-33   NTclustered gi|2839792214|gb|PQ512812.1| 183589 g3277 i0 77.985 40.2255520504732 268 47 41 11 375 634 4045 3782 Pseudo-nitzschia multistriata isolate CNS00142 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 25503 158 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
11931069 11931069 PRJNA492406_P_NODE_21450_length_276_cov_2.354680_g21151_i0 PRJNA492406 21450 276 2.35468 6.4989168 Eunotia naegelii 1458866 SAR_Eukaryotes SAR_Eukaryotes 117 8.87e-22   NTclustered gi|1418586621|ref|NC_037987.1| 1458866 g21151 i0 78.736 2.91304347826087 174 37 63 0 1 174 5741 5914 Eunotia naegelii strain UTEX FD354 mitochondrion, complete genome blastn 804 117 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Eunotiales Eunotiaceae Eunotia Eunotia naegelii
17029522 17029522 PRJNA492406_P_NODE_12694_length_351_cov_1.107914_g12395_i0 PRJNA492406 12694 351 1.107914 3.88877814 Schizostauron trachyderma 2770866 SAR_Eukaryotes SAR_Eukaryotes 93.5 1.95e-14   NTclustered gi|2125739626|gb|MZ520767.1| 2770866 g12395 i0 75 0.86039886039886 216 47 60 7 134 345 17026 16814 Schizostauron trachyderma strain SZCZE1420 mitochondrion, complete genome blastn 302 93.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Schizostauron Schizostauron trachyderma
23404733 23404733 PRJNA492406_P_NODE_19519_length_286_cov_1.075117_g19220_i0 PRJNA492406 19519 286 1.075117 3.07483462 Nitzschia reversa 2675857 SAR_Eukaryotes SAR_Eukaryotes 156 1.96e-33   NTclustered gi|2721953992|gb|OR464345.1| 2675857 g19220 i0 90.598 38.3076923076923 117 11 41 0 155 271 55547 55431 Nitzschia reversa mitochondrion, complete genome blastn 10956 156 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
24678886 24678886 PRJNA492406_P_NODE_9380_length_400_cov_4.712538_g9081_i0 PRJNA492406 9380 400 4.712538 18.850152 Haslea pseudostrearia 197756 SAR_Eukaryotes SAR_Eukaryotes 158 7.9e-34   NTclustered gi|2328347954|ref|NC_067578.1| 197756 g9081 i0 76.106 14.69 339 59 83 17 54 385 27910 27587 Haslea pseudostrearia strain SCCAP K-1594 mitochondrion, complete genome blastn 5876 158 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea pseudostrearia
25325392 25325392 PRJNA492406_P_NODE_16620_length_307_cov_1.876068_g16321_i0 PRJNA492406 16620 307 1.876068 5.75952876 Thalassiosirales 33847 SAR_Eukaryotes SAR_Eukaryotes 178 4.53e-40   NTclustered gi|2728403597|gb|PP777232.1| 41457 g16321 i0 90.441 38.2833876221498 136 12 44 1 157 291 4288 4423 Skeletonema pseudocostatum strain CNS00493 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 11753 178 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema pseudocostatum
28308231 28308231 PRJNA492406_P_NODE_24786_length_260_cov_0.914439_g24487_i0 PRJNA492406 24786 260 0.914439 2.3775414 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 127 1.09e-31   NR KAG7364831.1 303405 g24487 i0 73.5 11.5038461538462 83 22 95.8 0 2 250 2029 2111 KAG7364831.1 methionine synthase [Nitzschia inconspicua] diamond 2991 127 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28876403 28876403 PRJNA492406_P_NODE_16308_length_310_cov_1.696203_g16009_i0 PRJNA492406 16308 310 1.696203 5.2582293 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 50.1 2.32e-4   NR KAL3772705.1 2934178 g16009 i0 60.6 0.319354838709677 33 13 31.9 0 306 208 1404 1436 KAL3772705.1 hypothetical protein ACHAW5_002680 [Stephanodiscus triporus] diamond 99 50.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus

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