RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

bioproject 1

  • PRJNA429937 · 9 ✖

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
2976725 2976725 PRJNA429937_P_NODE_155463_length_161_cov_7.204545_g132836_i0 PRJNA429937 155463 161 7.204545 11.59931745 Paralia sulcata 216927 SAR_Eukaryotes SAR_Eukaryotes 152 1.28e-32   NTclustered gi|2202538979|gb|OM891885.1| 216927 g132836 i0 83.851 100.813664596273 161 24 100 2 1 161 3791 3949 Paralia sulcata 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 16231 152 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Paraliales Paraliaceae Paralia Paralia sulcata
8079214 8079214 PRJNA429937_P_NODE_138127_length_208_cov_988.960894_g115500_i0 PRJNA429937 138127 208 988.960894 2057.03865952 Craticula sp. RGastineau-2025a 3393937 SAR_Eukaryotes SAR_Eukaryotes 231 2.18e-56   NTclustered gi|2889644843|gb|PQ892177.1| 3393937 g115500 i0 86.792 62.3173076923077 212 23 100 5 1 208 4668 4878 Craticula sp. RGastineau-2025a isolate SZCZEY2171 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 12962 231 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Craticula Craticula sp. RGastineau-2025a
17003294 17003294 PRJNA429937_P_NODE_150674_length_179_cov_4.300000_g128047_i0 PRJNA429937 150674 179 4.3 7.697 Gomphonema parvulum 97227 SAR_Eukaryotes SAR_Eukaryotes 211 2.36e-50   NTclustered gi|2162236494|gb|OL780349.1| 97227 g128047 i0 98.347 81.2793296089386 121 0 100 1 1 119 596 476 Gomphonema parvulum strain CBac2019033 large subunit ribosomal RNA gene, partial sequence blastn 14549 211 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
19551857 19551857 PRJNA429937_P_NODE_147216_length_192_cov_3.625767_g124589_i0 PRJNA429937 147216 192 3.625767 6.96147264 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 267 5.4199999999999996e-67   NTclustered gi|146762526|gb|EF553458.1| 2850 g124589 i0 91.667 14.640625 192 16 100 0 1 192 4210 4401 Phaeodactylum tricornutum strain CCAP 1055/1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 2811 267 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27581162 27581162 PRJNA429937_P_NODE_36904_length_595_cov_3.892226_g22977_i2 PRJNA429937 36904 595 3.892226 23.1587447 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 166 1.1e-43   NR KAI2497837.1 210448 g22977 i2 54.7 1.40168067226891 139 63 70.1 0 78 494 596 734 KAI2497837.1 hypothetical protein MHU86_16671 [Fragilaria crotonensis] diamond 834 166 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27960074 27960074 PRJNA429937_P_NODE_36785_length_596_cov_3.996473_g22977_i0 PRJNA429937 36785 596 3.996473 23.81897908 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 191 1.23e-52   NR KAI2497837.1 210448 g22977 i0 54.9 4.11744966442953 164 73 82 1 590 102 571 734 KAI2497837.1 hypothetical protein MHU86_16671 [Fragilaria crotonensis] diamond 2454 191 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28370529 28370529 PRJNA429937_P_NODE_36786_length_596_cov_3.948854_g22977_i1 PRJNA429937 36786 596 3.948854 23.53516984 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 191 1.23e-52   NR KAI2497837.1 210448 g22977 i1 54.9 4.11744966442953 164 73 82 1 590 102 571 734 KAI2497837.1 hypothetical protein MHU86_16671 [Fragilaria crotonensis] diamond 2454 191 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32035560 32035560 PRJNA429937_P_NODE_157638_length_154_cov_2.944000_g135011_i0 PRJNA429937 157638 154 2.944 4.53376 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 60.5 6.19e-9   NR GKY99417.1 2872254 g135011 i0 77.4 0.603896103896104 31 7 60.4 0 153 61 620 650 GKY99417.1 hypothetical protein MPSEU_000896400 [Mayamaea pseudoterrestris] diamond 93 60.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32383638 32383638 PRJNA429937_P_NODE_151079_length_178_cov_2.006711_g128452_i0 PRJNA429937 151079 178 2.006711 3.57194558 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 56.2 2.75e-7   NR KAL3808545.1 382380 g128452 i0 62.2 1.24719101123595 37 14 62.4 0 112 2 256 292 KAL3808545.1 hypothetical protein ACHAXA_011800 [Cyclostephanos tholiformis] diamond 222 56.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis

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