RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

bioproject 1

  • PRJNA849172 · 8 ✖

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
7214446 7214446 PRJNA849172_P_NODE_42606_length_317_cov_15.102459_g42246_i0 PRJNA849172 42606 317 15.102459 47.87479503 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 134 1.18e-37   NR KAI2488933.1 210448 g42246 i0 69.4 6.1608832807571 85 26 80.4 0 257 3 16 100 KAI2488933.1 putative GTP-ase activating proteins for the small GTPase [Fragilaria crotonensis] diamond 1953 134 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
11038917 11038917 PRJNA849172_P_NODE_14089_length_559_cov_68.366255_g13730_i0 PRJNA849172 14089 559 68.366255 382.16736545 Entomoneis sp. 186043 SAR_Eukaryotes SAR_Eukaryotes 193 3.11e-44   NTclustered gi|1372147530|gb|MF997419.1| 186043 g13730 i0 75 12.8890876565295 448 96 79 14 18 460 21256 21692 Entomoneis sp. mitochondrion, complete genome blastn 7205 193 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis sp.
22512115 22512115 PRJNA849172_P_NODE_144958_length_202_cov_4.829457_g144598_i0 PRJNA849172 144958 202 4.829457 9.75550314 Lineaperpetua lacustris 2923095 SAR_Eukaryotes SAR_Eukaryotes 108 3.7e-19   NTclustered gi|2728413486|gb|OR666654.1| 2923095 g144598 i0 95.522 3.96534653465347 67 3 33 0 3 69 24135 24069 Thalassiosira lacustris strain SXU-149 chloroplast, complete genome blastn 801 108 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Lineaperpetua Lineaperpetua lacustris
24183621 24183621 PRJNA849172_P_NODE_128559_length_223_cov_16.140000_g128199_i0 PRJNA849172 128559 223 16.14 35.9922 Skeletonema 2842 SAR_Eukaryotes SAR_Eukaryotes 75 4.23e-9   NTclustered gi|2739942906|dbj|LC814766.1| 2843 g128199 i0 93.878 5.91031390134529 49 3 22 0 113 161 36553 36505 Skeletonema costatum SCHP35 mitochondrial DNA, complete genome blastn 1318 75 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema costatum
25060809 25060809 PRJNA849172_P_NODE_118980_length_232_cov_17.339623_g118620_i0 PRJNA849172 118980 232 17.339623 40.22792536 Nitzschia sp. pyKryTriq1 3034176 SAR_Eukaryotes SAR_Eukaryotes 178 3.2799999999999993e-40   NTclustered gi|2524387093|emb|OY101132.1| 3034176 g118620 i0 82.927 6.81034482758621 205 27 87 8 1 201 6187 6387 Nitzschia sp. pyKryTriq1 genome assembly, organelle: mitochondrion blastn 1580 178 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. pyKryTriq1
29423028 29423028 PRJNA849172_P_NODE_18649_length_479_cov_16.071429_g18290_i0 PRJNA849172 18649 479 16.071429 76.98214491 Stephanopyxis turris 515487 SAR_Eukaryotes SAR_Eukaryotes 73.2 1.07e-11   NR QYC61879.1 515487 g18290 i0 43.8 0.81419624217119 130 67 79.5 3 6 386 284 410 QYC61879.1 NADH dehydrogenase subunit 2 [Stephanopyxis turris] diamond 390 73.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Melosirales Stephanopyxidaceae Stephanopyxis Stephanopyxis turris
32267975 32267975 PRJNA849172_P_NODE_16498_length_512_cov_13.646925_g16139_i0 PRJNA849172 16498 512 13.646925 69.872256 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 187 3.84e-58   NR AID23596.1 2850 g16139 i0 76.9 0.685546875 117 27 68.6 0 4 354 1 117 AID23596.1 putative voltage-dependent anion-selective channel protein, partial [Phaeodactylum tricornutum] diamond 351 187 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32718434 32718434 PRJNA849172_P_NODE_42600_length_317_cov_23.405738_g42240_i0 PRJNA849172 42600 317 23.405738 74.19618946 Cymbellales 97224 SAR_Eukaryotes SAR_Eukaryotes 108 4.97e-25   NR AVR57504.1 186043 g42240 i0 52.9 6.78548895899054 102 45 93.7 1 300 4 54 155 AVR57504.1 NADH dehydrogenase subunit 5 [Entomoneis sp.] diamond 2151 109 0.990825688073395 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis sp.

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