RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJEB6584" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 10 ✖

tax_clade 1

bioproject 1

  • PRJEB6584 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
25525581 25525581 PRJEB6584p_S_NODE_529_length_346_cov_4.623794_g498_i0 PRJEB6584 529 346 4.623794 15.99832724 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 176 1.86e-39   NTclustered gi|2074156200|gb|MW413905.1| 216802 g498 i0 76.638 77.3757225433526 351 62 98 16 8 346 24229 24571 Guinardia delicatula mitochondrion, complete genome blastn 26772 176 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
25796386 25796386 PRJEB6584o_S_NODE_14171_length_234_cov_4.889447_g14063_i0 PRJEB6584 14171 234 4.889447 11.44130598 Skeletonema menzelii 216823 SAR_Eukaryotes SAR_Eukaryotes 150 7.22e-32   NTclustered gi|2739942921|dbj|LC814781.1| 216823 g14063 i0 81.771 33.4188034188034 192 24 78 10 9 190 32240 32430 Skeletonema menzelii NIES-2842 mitochondrial DNA, complete genome blastn 7820 150 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema menzelii
25797114 25797114 PRJEB6584o_S_NODE_50771_length_166_cov_3.908397_g50663_i0 PRJEB6584 50771 166 3.908397 6.48793902 Pseudo-nitzschia sabit 1664502 SAR_Eukaryotes SAR_Eukaryotes 73.1 1.07e-8   NTclustered gi|2852238230|gb|PQ498358.1| 1664502 g50663 i0 100 12.9518072289157 39 0 23 0 128 166 19660 19698 Pseudo-nitzschia sabit isolate CNS00609 mitochondrion, complete genome blastn 2150 73.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia sabit
26024283 26024283 PRJEB6584m_S_NODE_228_length_333_cov_1.728188_g216_i0 PRJEB6584 228 333 1.728188 5.75486604 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 171 8.3e-38   NTclustered gi|2739942924|dbj|LC814784.1| 41457 g216 i0 77.399 78.8918918918919 323 49 93 18 23 333 33435 33745 Skeletonema pseudocostatum NIES-2843 mitochondrial DNA, complete genome blastn 26271 171 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema pseudocostatum
26067981 26067981 PRJEB6584e_S_NODE_5_length_1260_cov_257.115102_g4_i0 PRJEB6584 5 1260 257.115102 3239.6502852 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 235 1.19e-56   NTclustered gi|2074156200|gb|MW413905.1| 216802 g4 i0 78.534 34.6253968253968 382 65 30 14 117 489 24602 24229 Guinardia delicatula mitochondrion, complete genome blastn 43628 235 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
26067989 26067989 PRJEB6584f_S_NODE_37_length_1238_cov_53.682461_g36_i0 PRJEB6584 37 1238 53.682461000000004 664.58886718 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 235 1.17e-56   NTclustered gi|2074156200|gb|MW413905.1| 216802 g36 i0 78.534 35.2374798061389 382 64 30 15 188 559 24602 24229 Guinardia delicatula mitochondrion, complete genome blastn 43624 235 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
26068066 26068066 PRJEB6584h_S_NODE_653_length_441_cov_6.871921_g593_i0 PRJEB6584 653 441 6.871921 30.30517161 Didymosphenia geminata 1115533 SAR_Eukaryotes SAR_Eukaryotes 75 9.1e-9   NTclustered gi|1125788738|ref|NC_032171.1| 1115533 g593 i0 84.211 1.20861678004535 76 12 17 0 228 303 28713 28638 Didymosphenia geminata mitochondrion, complete genome blastn 533 75 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Didymosphenia Didymosphenia geminata
26340085 26340085 PRJEB6584f_S_NODE_6767_length_153_cov_1.016949_g6761_i0 PRJEB6584 6767 153 1.016949 1.55593197 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 104 3.41e-18   NTclustered gi|219123891|ref|XM_002182214.1| 556484 g6761 i0 85.714 0.993464052287582 98 14 64 0 1 98 328 425 Phaeodactylum tricornutum CCAP 1055/1 ubiquitin extension protein 1/2 (UBI1/2), mRNA blastn 152 104 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26476372 26476372 PRJEB6584f_S_NODE_40_length_949_cov_17.973742_g36_i1 PRJEB6584 40 949 17.973742 170.57081158 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 235 8.88e-57   NTclustered gi|2074156200|gb|MW413905.1| 216802 g36 i1 78.534 46.5384615384615 382 64 39 15 261 632 24229 24602 Guinardia delicatula mitochondrion, complete genome blastn 44165 235 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
26476699 26476699 PRJEB6584l_S_NODE_3464_length_298_cov_3.049430_g3312_i0 PRJEB6584 3464 298 3.04943 9.0873014 Eucampia zodiacus 444606 SAR_Eukaryotes SAR_Eukaryotes 137 7.43e-28   NTclustered gi|2026158947|ref|NC_054334.1| 444606 g3312 i0 76.596 77.3489932885906 282 47 92 15 25 297 29910 30181 Eucampia zodiacus strain CNS00060 mitochondrion, complete genome blastn 23050 137 1 Eukaryota Sar   Bacillariophyta Mediophyceae Hemiaulales Hemiaulaceae Eucampia Eucampia zodiacus

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