RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJEB28062" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 9 ✖

tax_clade 1

bioproject 1

  • PRJEB28062 · 9 ✖

analysis 1

  • blastn · 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
25714 25714 PRJEB28062_P_NODE_91401_length_340_cov_71.078652_g89039_i0 PRJEB28062 91401 340 71.078652 241.6674168 Ulnaria acus 1436140 SAR_Eukaryotes SAR_Eukaryotes 558 1.55e-154   NTclustered gi|378824466|ref|NC_016731.1| 1436140 g89039 i0 98.423 8.47352941176471 317 5 93 0 2 318 82001 82317 Synedra acus chloroplast, complete genome blastn 2881 558 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria acus
9916006 9916006 PRJEB28062_P_NODE_79568_length_378_cov_11.344262_g77206_i0 PRJEB28062 79568 378 11.344262 42.88131036 Pseudo-nitzschia 41953 SAR_Eukaryotes SAR_Eukaryotes 78.7 5.94e-10   NTclustered gi|2852238308|gb|PQ498360.1| 189737 g77206 i0 94.118 2.11375661375661 51 3 13 0 231 281 33841 33791 Pseudo-nitzschia galaxiae isolate CNS01103 mitochondrion, complete genome blastn 799 78.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia galaxiae
10228571 10228571 PRJEB28062_P_NODE_94429_length_331_cov_8.279070_g92067_i0 PRJEB28062 94429 331 8.27907 27.4037217 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 374 5.859999999999998e-99   NTclustered gi|2620230846|gb|OR797295.1| 2126271 g92067 i0 88.365 81.8066465256798 318 27 93 8 23 331 4524 4840 Naviculales sp. strain SZCZO2114 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 27078 374 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
12777997 12777997 PRJEB28062_P_NODE_27071_length_713_cov_38.162500_g24816_i0 PRJEB28062 27071 713 38.1625 272.098625 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 935 0   NTclustered gi|2620230846|gb|OR797295.1| 2126271 g24816 i0 91.185 97.9565217391304 692 56 97 5 2 692 4918 4231 Naviculales sp. strain SZCZO2114 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 69843 935 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
12778908 12778908 PRJEB28062_P_NODE_71431_length_406_cov_5.699700_g69070_i0 PRJEB28062 71431 406 5.6997 23.140782 Tabularia sp. 2508070 SAR_Eukaryotes SAR_Eukaryotes 510 5.3499999999999995e-140   NTclustered gi|2862228887|gb|PQ645521.1| 2508070 g69070 i0 90.746 90.5394088669951 389 26 95 7 1 387 4342 3962 Tabularia sp. isolate AGSB0382 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 36759 510 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Tabularia Tabularia sp.
17565469 17565469 PRJEB28062_P_NODE_5454_length_1709_cov_70.490220_g4332_i0 PRJEB28062 5454 1709 70.49022 1204.6778598 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 645 6.349999999999999e-180   NTclustered gi|2632235335|gb|OR922717.1| 2856 g4332 i0 85.913 56.7753071971913 646 43 45 18 86 725 2703 3306 Cylindrotheca closterium strain AGSB0133 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 97029 649 0.993836671802773 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
17875281 17875281 PRJEB28062_P_NODE_111015_length_283_cov_39.138095_g108652_i0 PRJEB28062 111015 283 39.138095 110.76080885 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 89.8 1.99e-13   NTclustered gi|219124223|ref|XM_002182373.1| 556484 g108652 i0 76.023 0.604240282685512 171 41 60 0 90 260 1364 1194 Phaeodactylum tricornutum CCAP 1055/1 predicted protein mRNA blastn 171 89.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
18838863 18838863 PRJEB28062_P_NODE_133095_length_232_cov_8.584906_g130731_i0 PRJEB28062 133095 232 8.584906 19.91698192 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 132 2.59e-26   NTclustered gi|2168682389|gb|MW561352.1| 67476 g130731 i0 89.524 42.6853448275862 105 9 44 2 130 232 6373 6477 Haslea ostrearia strain SZCZP1883 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 9903 132 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea ostrearia
18839141 18839141 PRJEB28062_P_NODE_32635_length_643_cov_6.473684_g30330_i0 PRJEB28062 32635 643 6.473684 41.62578812 Gomphonemataceae 97225 SAR_Eukaryotes SAR_Eukaryotes 1074 0   NTclustered gi|2328365172|ref|NC_067848.1| 97227 g30330 i0 98.682 185.968895800933 607 5 94 3 23 626 72486 73092 Gomphonema parvulum voucher personal collection:A.Bruce Cahoon:diatom-2021-A chloroplast, complete genome blastn 119578 1074 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum

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