RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA763243 · 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
743307 743307 PRJNA763243_P_NODE_40621_length_275_cov_2.856436_g40275_i0 PRJNA763243 40621 275 2.856436 7.855199 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 488 1.6299999999999995e-133   NTclustered gi|586947715|gb|KF913343.1| 303400 g40275 i0 99.262 3.76727272727273 271 0 99 2 2 272 781 513 Nitzschia palea strain M2 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 1036 488 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
743342 743342 PRJNA763243_P_NODE_421_length_1684_cov_5.083799_g338_i0 PRJNA763243 421 1684 5.083799 85.61117516 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 316 5.5699999999999985e-81   NTclustered gi|2074156200|gb|MW413905.1| 216802 g338 i0 75.066 28.0290973871734 754 151 44 30 160 892 23865 24602 Guinardia delicatula mitochondrion, complete genome blastn 47201 316 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
1205246 1205246 PRJNA763243_P_NODE_70041_length_220_cov_6.619048_g69695_i0 PRJNA763243 70041 220 6.619048 14.5619056 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 121 5.2699999999999997e-23   NTclustered gi|146762526|gb|EF553458.1| 2850 g69695 i0 81.935 34.5 155 17 70 6 66 220 4229 4086 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 7590 121 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
10946867 10946867 PRJNA763243_P_NODE_18449_length_365_cov_30.123288_g18104_i0 PRJNA763243 18449 365 30.123288 109.9500012 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 669 0   NTclustered gi|586947715|gb|KF913343.1| 303400 g18104 i0 100 7.9013698630137 362 0 99 0 4 365 110 471 Nitzschia palea strain M2 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 2884 669 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
13497466 13497466 PRJNA763243_P_NODE_59231_length_244_cov_4.187135_g58885_i0 PRJNA763243 59231 244 4.187135 10.2166094 Fragilariopsis cylindrus 186039 SAR_Eukaryotes SAR_Eukaryotes 211 3.43e-50   NTclustered gi|1783488149|ref|NC_045244.1| 186039 g58885 i0 83.929 69.5983606557377 224 32 91 4 7 228 33784 34005 Fragilariopsis cylindrus chloroplast, complete genome blastn 16982 211 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
17321730 17321730 PRJNA763243_P_NODE_45634_length_263_cov_4.394737_g45288_i0 PRJNA763243 45634 263 4.394737 11.55815831 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 220 6.22e-53   NTclustered gi|657012566|gb|KF302620.1| 2850 g45288 i0 85.088 69.6882129277567 228 21 84 10 42 263 759 539 Phaeodactylum tricornutum clone C821 hypothetical protein mRNA, complete cds blastn 18328 220 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);;