RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA577580" 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

  • PRJNA577580 · 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
1839528 1839528 PRJNA577580_P_NODE_42_length_2488_cov_18.895652_g32_i0 PRJNA577580 42 2488 18.895652 470.12382176 Leptocylindrus minimus 216767 SAR_Eukaryotes SAR_Eukaryotes 300 8.34e-76   NTclustered gi|2632235311|gb|OR922693.1| 216767 g32 i0 74.531 8.69172025723473 746 163 33 26 676 1405 3688 2954 Leptocylindrus minimus strain AGSB0065 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 21625 300 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Leptocylindrales Leptocylindraceae Leptocylindrus Leptocylindrus minimus
3689518 3689518 PRJNA577580_P_NODE_17243_length_214_cov_4.560284_g17165_i0 PRJNA577580 17243 214 4.560284 9.75900776 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 100 6.64e-17   NTclustered gi|2862228911|gb|PQ645545.1| 426632 g17165 i0 86.17 1.29439252336449 94 11 44 2 40 133 2368 2277 Chaetoceros diadema isolate AGSB0427 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 277 100 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros diadema
7515980 7515980 PRJNA577580_P_NODE_1586_length_719_cov_17.910217_g1512_i0 PRJNA577580 1586 719 17.910217 128.77446023 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 207 1.4499999999999998e-48   NTclustered gi|1169296927|gb|KY364697.1| 29204 g1512 i0 95.385 23.2559109874826 130 6 25 0 325 454 4471 4342 Cyclotella cryptica 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 16721 207 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
12043100 12043100 PRJNA577580_P_NODE_15610_length_245_cov_0.906977_g15532_i0 PRJNA577580 15610 245 0.906977 2.22209365 Cocconeiopsis kantsiensis 3082010 SAR_Eukaryotes SAR_Eukaryotes 178 3.5e-40   NTclustered gi|2692958369|ref|NC_086887.1| 3082010 g15532 i0 83.42 42.6489795918367 193 30 78 2 11 202 7207 7398 Cocconeiopsis kantsiensis isolate Huiquan Bay in China mitochondrion, complete genome blastn 10449 178 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cocconeidales Cocconeidaceae Cocconeiopsis Cocconeiopsis kantsiensis
16440829 16440829 PRJNA577580_P_NODE_8993_length_303_cov_2.360870_g8915_i0 PRJNA577580 8993 303 2.36087 7.1534361 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.008   NTclustered gi|2073953076|gb|MW849265.1| 2856 g8915 i0 92.308 0.712871287128713 39 2 13 1 186 224 34622 34659 Cylindrotheca closterium isolate Qingdao in China mitochondrion, complete genome blastn 216 54.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
23516432 23516432 PRJNA577580_P_NODE_1519_length_737_cov_8.625000_g1445_i0 PRJNA577580 1519 737 8.625 63.56625 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 167 2.53e-36   NTclustered gi|2074156200|gb|MW413905.1| 216802 g1445 i0 77.931 25.8561736770692 290 49 39 9 454 737 24229 24509 Guinardia delicatula mitochondrion, complete genome blastn 19056 167 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
24790199 24790199 PRJNA577580_P_NODE_480_length_1188_cov_96.262780_g440_i0 PRJNA577580 480 1188 96.26278 1143.6018264 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 165 1.49e-35   NTclustered gi|2074156200|gb|MW413905.1| 216802 g440 i0 75.128 12.9873737373737 390 77 32 16 373 752 24605 24226 Guinardia delicatula mitochondrion, complete genome blastn 15429 165 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula

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