RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA734348" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA734348 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
2472429 2472429 PRJNA734348_P_NODE_20322_length_445_cov_4.564516_g19631_i0 PRJNA734348 20322 445 4.564516 20.3120962 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 244 6.62e-60   NTclustered gi|725539117|gb|KM407590.1| 1574083 g19631 i0 91.111 40.1258426966292 180 16 40 0 66 245 248 427 Luticola muticopsis f. capitata isolate Ant003-G11 28S ribosomal RNA gene, partial sequence blastn 17856 244 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Diadesmidaceae Luticola Luticola muticopsis
12196833 12196833 PRJNA734348_P_NODE_143950_length_226_cov_5.581699_g143252_i0 PRJNA734348 143950 226 5.581699 12.61463974 Nitzschia dissipata 303402 SAR_Eukaryotes SAR_Eukaryotes 407 3.73e-109   NTclustered gi|1891520246|gb|MN696750.1| 303402 g143252 i0 99.115 97.0088495575221 226 2 100 0 1 226 85 310 Nitzschia dissipata culture TCC:632 large subunit ribosomal RNA gene, partial sequence blastn 21924 407 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia dissipata
12197688 12197688 PRJNA734348_P_NODE_47450_length_294_cov_1.040724_g46753_i0 PRJNA734348 47450 294 1.040724 3.05972856 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 327 4.05e-85   NTclustered gi|657012562|gb|KF302618.1| 2850 g46753 i0 87 2.96938775510204 300 27 99 6 2 294 48 342 Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds blastn 873 327 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
13472463 13472463 PRJNA734348_P_NODE_63411_length_276_cov_1.704433_g62714_i0 PRJNA734348 63411 276 1.704433 4.70423508 Gomphonema parvulum 97227 SAR_Eukaryotes SAR_Eukaryotes 351 2.23e-92   NTclustered gi|2328365145|ref|NC_067847.1| 97227 g62714 i0 94.69 81.8405797101449 226 12 82 0 7 232 4360 4585 Gomphonema parvulum voucher personal collection:A.Bruce Cahoon:diatom-2021-A mitochondrion, complete genome blastn 22588 351 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
21599707 21599707 PRJNA734348_P_NODE_81257_length_259_cov_2.913978_g80559_i0 PRJNA734348 81257 259 2.913978 7.54720302 Navicula 50949 SAR_Eukaryotes SAR_Eukaryotes 403 5.65e-108   NTclustered gi|2620230842|gb|OR797293.1| 1923966 g80559 i0 94.656 99.7915057915058 262 11 100 2 1 259 4094 3833 Navicula sp. strain SZCZEY2262 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 25846 403 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
23671162 23671162 PRJNA734348_P_NODE_36339_length_323_cov_4.812000_g35643_i0 PRJNA734348 36339 323 4.812 15.54276 Attheya septentrionalis 420275 SAR_Eukaryotes SAR_Eukaryotes 102 2.97e-17   NTclustered gi|2632235279|gb|OR922661.1| 420275 g35643 i0 91.781 22.6904024767802 73 6 23 0 251 323 3869 3797 Attheya septentrionalis strain AGSB0004 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 7329 102 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Attheyaceae Attheya Attheya septentrionalis
24944208 24944208 PRJNA734348_P_NODE_20160_length_448_cov_1.301333_g19469_i0 PRJNA734348 20160 448 1.301333 5.82997184 Eucampia zodiacus 444606 SAR_Eukaryotes SAR_Eukaryotes 99 5.49e-16   NTclustered gi|2026158947|ref|NC_054334.1| 444606 g19469 i0 76.098 13.6830357142857 205 39 44 8 32 227 30050 29847 Eucampia zodiacus strain CNS00060 mitochondrion, complete genome blastn 6130 99 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);;