RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA975724" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA975724 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
3496672 3496672 PRJNA975724_S_NODE_37583_length_326_cov_1.217391_g37402_i0 PRJNA975724 37583 326 1.217391 3.96869466 Lithodesmioides sp. mgcode 4 2914905 SAR_Eukaryotes SAR_Eukaryotes 148 3.8e-31   NTclustered gi|2073953334|gb|MW849271.1| 2914905 g37402 i0 77.037 51.239263803681 270 55 82 7 10 275 13837 14103 Lithodesmioides sp. mgcode 4 isolate Qingdao in China mitochondrion, complete genome blastn 16704 148 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Lithodesmioides Lithodesmioides sp. mgcode 4
8919658 8919658 PRJNA975724_S_NODE_467_length_1010_cov_77.302028_g385_i0 PRJNA975724 467 1010 77.302028 780.7504828 Skeletonema 2842 SAR_Eukaryotes SAR_Eukaryotes 137 2.75e-27   NTclustered gi|1179910904|dbj|LC258386.1| 371681 g385 i0 88.696 11.3792079207921 115 10 11 3 642 755 2612 2724 Skeletonema grevillei genes for 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence, strain: F35#9 blastn 11493 137 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema grevillei
9873898 9873898 PRJNA975724_S_NODE_24688_length_367_cov_1.343537_g24507_i0 PRJNA975724 24688 367 1.343537 4.93078079 Navicula incertata 2014769 SAR_Eukaryotes SAR_Eukaryotes 137 9.35e-28   NTclustered gi|2866543349|gb|PQ722532.1| 2014769 g24507 i0 84.783 41.1471389645777 138 19 37 2 26 162 45557 45421 Navicula incertata mitochondrion, complete genome blastn 15101 137 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula incertata
16249838 16249838 PRJNA975724_S_NODE_71833_length_260_cov_1.235294_g71652_i0 PRJNA975724 71833 260 1.235294 3.2117644 Epithemia pelagica 2809013 SAR_Eukaryotes SAR_Eukaryotes 99 3e-16   NTclustered gi|2307964125|emb|OX337243.1| 2809013 g71652 i0 79.333 30.4961538461538 150 23 56 6 37 182 19431 19576 Epithemia pelagica genome assembly, organelle: mitochondrion blastn 7929 99 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Rhopalodiales Rhopalodiaceae Epithemia Epithemia pelagica
18797938 18797938 PRJNA975724_S_NODE_39495_length_321_cov_1.379032_g39314_i0 PRJNA975724 39495 321 1.379032 4.42669272 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 141 6.25e-29   NTclustered gi|2074156200|gb|MW413905.1| 216802 g39314 i0 75.394 44.9844236760125 317 65 97 13 8 318 24296 24605 Guinardia delicatula mitochondrion, complete genome blastn 14440 141 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
20393076 20393076 PRJNA975724_S_NODE_2456_length_628_cov_2.317117_g2285_i0 PRJNA975724 2456 628 2.317117 14.55149476 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 119 6.06e-22   NTclustered gi|1819718724|gb|MN956530.1| 2850 g2285 i0 78.857 1.90127388535032 175 37 28 0 211 385 3575 3401 Phaeodactylum tricornutum strain ICE-H mitochondrion, complete genome blastn 1194 119 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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