RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA682370" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA682370 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
664325 664325 PRJNA682370_S_NODE_21721_length_157_cov_0.983607_g21109_i0 PRJNA682370 21721 157 0.983607 1.54426299 Micromonas pusilla 38833 Plants Plants 165 1.59e-36   NTclustered gi|65428036|gb|AY955013.1| 38833 g21109 i0 85.806 31.0700636942675 155 22 99 0 3 157 1297 1143 Micromonas pusilla strain CCMP1195 beta-tubulin gene, partial cds blastn 4878 165 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas pusilla
664327 664327 PRJNA682370_S_NODE_21981_length_156_cov_1.264463_g21369_i0 PRJNA682370 21981 156 1.264463 1.97256228 Tetraselmis suecica 270643 Plants Plants 134 4.4600000000000006e-27   NTclustered gi|1486933343|gb|MF957257.1| 270643 g21369 i0 82.468 40.5448717948718 154 25 98 2 4 156 999 847 Tetraselmis suecica heat shock protein 70 mRNA, complete cds blastn 6325 134 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorodendrophyceae Chlorodendrales Chlorodendraceae Tetraselmis Tetraselmis suecica
664537 664537 PRJNA682370_S_NODE_7061_length_287_cov_2.134921_g6449_i0 PRJNA682370 7061 287 2.134921 6.12722327 Dicloster acuatus 91190 Plants Plants 134 9.21e-27   NTclustered gi|2724824305|gb|PP746556.1| 91190 g6449 i0 80.925 76.0313588850174 173 30 60 3 43 214 1587 1417 Dicloster acuatus culture SAG:41.98 mitochondrion, complete genome blastn 21821 134 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Dicloster Dicloster acuatus
5003002 5003002 PRJNA682370_S_NODE_15064_length_184_cov_2.120805_g14452_i0 PRJNA682370 15064 184 2.120805 3.9022812 Trebouxiaceae 2507902 Plants Plants 126 9.12e-25   NTclustered gi|1750939486|gb|MH917293.1| 1825957 g14452 i0 91.304 98.8315217391304 92 8 50 0 47 138 15464 15373 Trebouxia sp. TR9 mitochondrion, complete genome blastn 18185 126 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia lynnae
12143624 12143624 PRJNA682370_S_NODE_17430_length_172_cov_1.087591_g16818_i0 PRJNA682370 17430 172 1.087591 1.87065652 Mantoniella tinhauana 3097027 Plants Plants 135 1.39e-27   NTclustered gi|2735153279|gb|CP140064.1| 3097027 g16818 i0 81.034 14.843023255814 174 29 100 4 1 172 1560564 1560735 Mantoniella tinhauana isolate LFS chromosome 3 blastn 2553 135 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Mantoniella Mantoniella tinhauana
19791437 19791437 PRJNA682370_S_NODE_6056_length_318_cov_2.106007_g5444_i0 PRJNA682370 6056 318 2.106007 6.69710226 Mantoniella tinhauana 3097027 Plants Plants 252 2.7399999999999998e-62   NTclustered gi|2735153278|gb|CP140063.1| 3097027 g5444 i0 82.155 82.2075471698113 297 49 93 4 24 318 631489 631783 Mantoniella tinhauana isolate LFS chromosome 2 blastn 26142 252 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Mantoniella Mantoniella tinhauana

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