RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA760976" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA760976 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
3293679 3293679 PRJNA760976_P_NODE_4803_length_603_cov_2.413208_g4493_i0 PRJNA760976 4803 603 2.413208 14.55164424 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 1059 0   NTclustered gi|2633519340|gb|OR805654.1| 2126271 g4493 i0 98.342 198.169154228856 603 10 100 0 1 603 121521 120919 Naviculales sp. strain SZCZO2114 plastid, complete genome blastn 119496 1059 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
6309072 6309072 PRJNA760976_P_NODE_39925_length_271_cov_11.171717_g39604_i0 PRJNA760976 39925 271 11.171717 30.27535307 Entomoneis 186042 SAR_Eukaryotes SAR_Eukaryotes 464 2.6899999999999998e-126   NTclustered gi|2325195844|gb|OM494341.1| 186043 g39604 i0 97.778 192.033210332103 270 4 99 2 3 271 89043 89311 Entomoneis sp. isolate C2 plastid, complete genome blastn 52041 464 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis sp.
7121163 7121163 PRJNA760976_P_NODE_49706_length_248_cov_0.880000_g49385_i0 PRJNA760976 49706 248 0.88 2.1824 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 163 9.93e-36   NTclustered gi|223996056|ref|XM_002287666.1| 296543 g49385 i0 82.353 1.92338709677419 187 33 75 0 1 187 41 227 Thalassiosira pseudonana CCMP1335 vacuolar ATP synthase (VAT4), partial mRNA blastn 477 163 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
9670736 9670736 PRJNA760976_P_NODE_128_length_2726_cov_5.392009_g95_i0 PRJNA760976 128 2726 5.392009 146.98616534 Eucampia zodiacus 444606 SAR_Eukaryotes SAR_Eukaryotes 257 5.59e-63   NTclustered gi|2026158947|ref|NC_054334.1| 444606 g95 i0 72.025 13.0124724871607 1126 231 40 59 1627 2722 29385 28314 Eucampia zodiacus strain CNS00060 mitochondrion, complete genome blastn 35472 257 1 Eukaryota Sar   Bacillariophyta Mediophyceae Hemiaulales Hemiaulaceae Eucampia Eucampia zodiacus
9670771 9670771 PRJNA760976_P_NODE_26268_length_317_cov_1.364754_g25947_i0 PRJNA760976 26268 317 1.364754 4.32627018 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 459 1.5000000000000002e-124   NTclustered gi|146762526|gb|EF553458.1| 2850 g25947 i0 93.016 99.6908517350158 315 20 99 2 2 315 4373 4060 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 31602 459 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
10946421 10946421 PRJNA760976_P_NODE_1469_length_1027_cov_2.668763_g1247_i0 PRJNA760976 1469 1027 2.668763 27.40819601 Haslea pseudostrearia 197756 SAR_Eukaryotes SAR_Eukaryotes 185 9.849999999999998e-42   NTclustered gi|2328347954|ref|NC_067578.1| 197756 g1247 i0 75.223 24.3456669912366 448 81 42 24 592 1026 27910 27480 Haslea pseudostrearia strain SCCAP K-1594 mitochondrion, complete genome blastn 25003 185 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea pseudostrearia
13496085 13496085 PRJNA760976_P_NODE_17831_length_363_cov_1.017241_g17510_i0 PRJNA760976 17831 363 1.017241 3.69258483 Ralfsiella minima 1334967 SAR_Eukaryotes SAR_Eukaryotes 158 7.09e-34   NTclustered gi|2202538981|gb|OM891887.1| 1334967 g17510 i0 84.024 46.3443526170799 169 21 46 5 188 354 4715 4879 Odontella aurita var. minima 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 16823 158 1 Eukaryota Sar   Bacillariophyta       Ralfsiella Ralfsiella minima

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