RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA550047 · 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
1793886 1793886 PRJNA550047_P_NODE_590242_length_201_cov_5.710938_g588269_i0 PRJNA550047 590242 201 5.710938 11.47898538 Trieres regia 1335017 SAR_Eukaryotes SAR_Eukaryotes 102 1.71e-17   NTclustered gi|2055417059|ref|NC_056371.1| 1335017 g588269 i0 80.714 49.0597014925373 140 20 68 6 54 189 12594 12458 Odontella regia mitochondrion, complete genome blastn 9861 102 1 Eukaryota Sar   Bacillariophyta Mediophyceae Eupodiscales Parodontellaceae Trieres Trieres regia
4344171 4344171 PRJNA550047_P_NODE_489264_length_234_cov_6.012422_g487291_i0 PRJNA550047 489264 234 6.012422 14.06906748 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 392 1.0899999999999999e-104   NTclustered gi|74325165|ref|NC_007405.1| 35128 g487291 i0 96.996 105.034188034188 233 7 99 0 2 234 12579 12347 Thalassiosira pseudonana mitochondrion, complete genome blastn 24578 392 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
11323641 11323641 PRJNA550047_P_NODE_241749_length_300_cov_15.096916_g239780_i0 PRJNA550047 241749 300 15.096916 45.290748 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 435 2.3700000000000003e-117   NTclustered gi|27262897|emb|Y10566.2| 92081 g239780 i0 92.025 108.676666666667 326 0 100 1 1 300 1285 1610 Peridinium balticum endosymbiont partial 18S rRNA gene blastn 32603 435 1 Eukaryota Sar   Bacillariophyta         Peridinium balticum endosymbiont
11994532 11994532 PRJNA550047_P_NODE_373390_length_275_cov_12.891089_g371418_i0 PRJNA550047 373390 275 12.891089 35.45049475 Acanthoceras zachariasii 451788 SAR_Eukaryotes SAR_Eukaryotes 187 6.639999999999998e-43   NTclustered gi|1418588907|ref|NC_038009.1| 451788 g371418 i0 84.375 21.6690909090909 192 29 69 1 31 221 88120 88311 Acanthoceras zachariasii chloroplast, complete genome blastn 5959 187 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Acanthocerataceae Acanthoceras Acanthoceras zachariasii
22193579 22193579 PRJNA550047_P_NODE_465658_length_242_cov_5.307692_g463685_i0 PRJNA550047 465658 242 5.307692 12.84461464 Nitzschia reversa 2675857 SAR_Eukaryotes SAR_Eukaryotes 167 7.46e-37   NTclustered gi|2721953992|gb|OR464345.1| 2675857 g463685 i0 92.373 56.3636363636364 118 8 49 1 21 138 55552 55436 Nitzschia reversa mitochondrion, complete genome blastn 13640 167 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
22797586 22797586 PRJNA550047_P_NODE_206838_length_323_cov_10.828000_g204870_i0 PRJNA550047 206838 323 10.828 34.97444 Pleurosigma 197752 SAR_Eukaryotes SAR_Eukaryotes 579 1.1299999999999997e-160   NTclustered gi|2301269116|ref|NC_066077.1| 197753 g204870 i0 99.068 195.613003095975 322 3 99 0 1 322 76421 76742 Pleurosigma intermedium isolate Jiaozhou Bay in China chloroplast, complete genome blastn 63183 579 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pleurosigmataceae Pleurosigma Pleurosigma intermedium

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