RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA1197996" 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

  • PRJNA1197996 · 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
10527537 10527537 PRJNA1197996_S_NODE_1089_length_693_cov_5.490323_g1046_i0 PRJNA1197996 1089 693 5.490323 38.04793839 Berkeleya fennica 1577906 SAR_Eukaryotes SAR_Eukaryotes 86.1 6.82e-12   NTclustered gi|746001744|ref|NC_026126.1| 1577906 g1046 i0 86.842 3.16017316017316 76 10 11 0 557 632 34837 34762 Berkeleya fennica mitochondrion, complete genome blastn 2190 86.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Berkeleyaceae Berkeleya Berkeleya fennica
10528022 10528022 PRJNA1197996_S_NODE_3389_length_469_cov_7.752525_g3335_i0 PRJNA1197996 3389 469 7.752525 36.35934225 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 265 5.38e-66   NTclustered gi|657012511|gb|KF302595.1| 2850 g3335 i0 88.889 4.27078891257996 216 22 46 2 255 469 298 84 Phaeodactylum tricornutum clone C854 ubiquitin-ribosomal protein fusion S27a mRNA, partial cds blastn 2003 265 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
16900949 16900949 PRJNA1197996_S_NODE_1254_length_659_cov_4.068259_g1209_i0 PRJNA1197996 1254 659 4.068259 26.80982681 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 604 4.019999999999999e-168   NTclustered gi|657012562|gb|KF302618.1| 2850 g1209 i0 88.956 51.2352048558422 498 44 75 7 166 656 21 514 Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds blastn 33764 604 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
22000593 22000593 PRJNA1197996_S_NODE_1378_length_636_cov_10.371226_g1332_i0 PRJNA1197996 1378 636 10.371226 65.96099736 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 403 1.5099999999999994e-107   NTclustered gi|657012465|gb|KF302574.1| 2850 g1332 i0 87.791 36.187106918239 344 42 54 0 122 465 344 1 Phaeodactylum tricornutum clone C567 ribosomal protein mRNA, partial cds blastn 23015 403 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27357153 27357153 PRJNA1197996_S_NODE_21183_length_261_cov_1.547872_g21129_i0 PRJNA1197996 21183 261 1.547872 4.03994592 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 139 2.17e-40   NR AID23596.1 2850 g21129 i0 79.8 0.96551724137931 84 17 96.6 0 260 9 34 117 AID23596.1 putative voltage-dependent anion-selective channel protein, partial [Phaeodactylum tricornutum] diamond 252 139 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
28525431 28525431 PRJNA1197996_S_NODE_8227_length_355_cov_2.911348_g8173_i0 PRJNA1197996 8227 355 2.911348 10.3352854 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 67.4 3.04e-10   NR KAI2512956.1 210448 g8173 i0 57.7 0.87887323943662 52 22 43.9 0 353 198 842 893 KAI2512956.1 Aconitate B N-terminal domain [Fragilaria crotonensis] diamond 312 67.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30103988 30103988 PRJNA1197996_S_NODE_8792_length_348_cov_2.301818_g8738_i0 PRJNA1197996 8792 348 2.301818 8.01032664 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 48.5 0.0012   NR GKY95951.1 2872254 g8738 i0 37.3 1.68103448275862 83 44 64.7 1 26 250 854 936 GKY95951.1 hypothetical protein MPSEU_000555600 [Mayamaea pseudoterrestris] diamond 585 48.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32190672 32190672 PRJNA1197996_S_NODE_12918_length_308_cov_1.638298_g12864_i0 PRJNA1197996 12918 308 1.638298 5.04595784 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 52 4.56e-5   NR KAL3801383.1 29204 g12864 i0 56.1 0.399350649350649 41 18 39.9 0 307 185 843 883 KAL3801383.1 hypothetical protein HJC23_006993 [Cyclotella cryptica] diamond 123 52 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica

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