RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA827593" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA827593 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
7199946 7199946 PRJNA827593_P_NODE_7306_length_828_cov_3.249007_g7037_i0 PRJNA827593 7306 828 3.249007 26.90177796 Eucampia zodiacus 444606 SAR_Eukaryotes SAR_Eukaryotes 230 3.5799999999999995e-55   NTclustered gi|2026158947|ref|NC_054334.1| 444606 g7037 i0 78.329 50.1630434782609 383 64 45 16 454 824 30221 29846 Eucampia zodiacus strain CNS00060 mitochondrion, complete genome blastn 41535 230 1 Eukaryota Sar   Bacillariophyta Mediophyceae Hemiaulales Hemiaulaceae Eucampia Eucampia zodiacus
9749456 9749456 PRJNA827593_P_NODE_50488_length_281_cov_2.216346_g50189_i0 PRJNA827593 50488 281 2.216346 6.22793226 Trieres regia 1335017 SAR_Eukaryotes SAR_Eukaryotes 122 1.9499999999999994e-23   NTclustered gi|2055417059|ref|NC_056371.1| 1335017 g50189 i0 87.619 5.02491103202847 105 13 37 0 111 215 4369 4473 Odontella regia mitochondrion, complete genome blastn 1412 122 1 Eukaryota Sar   Bacillariophyta Mediophyceae Eupodiscales Parodontellaceae Trieres Trieres regia
14849068 14849068 PRJNA827593_P_NODE_2912_length_1370_cov_5.294526_g2712_i0 PRJNA827593 2912 1370 5.294526 72.5350062 Lithodesmium undulatum 59812 SAR_Eukaryotes SAR_Eukaryotes 641 6.549999999999999e-179   NTclustered gi|2088237800|ref|NC_056903.1| 59812 g2712 i0 78.178 79.7496350364963 1054 196 76 28 24 1060 2034 3070 Lithodesmium undulatum mitochondrion, complete genome blastn 109257 641 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Lithodesmium Lithodesmium undulatum
17805898 17805898 PRJNA827593_P_NODE_34814_length_347_cov_2.032847_g34515_i0 PRJNA827593 34814 347 2.032847 7.05397909 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 178 5.2e-40   NTclustered gi|699008555|ref|NC_024928.1| 1458866 g34515 i0 86.792 43.2881844380403 159 21 46 0 165 323 67547 67705 Eunotia naegelii chloroplast, complete genome blastn 15021 178 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Eunotiales Eunotiaceae Eunotia Eunotia naegelii

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