RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA379145 · 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
3624750 3624750 PRJNA379145_P_NODE_35163_length_350_cov_38.829653_g33017_i0 PRJNA379145 35163 350 38.829653 135.9037855 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 427 4.7e-115   NTclustered gi|2202538965|gb|OM891871.1| 515483 g33017 i0 90.244 81.7542857142857 328 30 93 2 1 327 4519 4193 Psammodictyon constrictum 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 28614 427 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Psammodictyon Psammodictyon constrictum
16978383 16978383 PRJNA379145_P_NODE_54454_length_211_cov_1.803371_g52300_i0 PRJNA379145 54454 211 1.803371 3.80511281 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 119 1.8000000000000001e-22   NTclustered gi|223994226|ref|XM_002286761.1| 296543 g52300 i0 93.671 2.49763033175355 79 5 37 0 114 192 79 1 Thalassiosira pseudonana CCMP1335 RS30, ribosomal protein 30 40S small ribosomal subunit (RS30), partial mRNA blastn 527 119 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
16978540 16978540 PRJNA379145_P_NODE_8894_length_1017_cov_29.572154_g7856_i0 PRJNA379145 8894 1017 29.572154 300.74880618 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 425 5.28e-114   NTclustered gi|657012367|gb|KF302531.1| 2850 g7856 i0 88.235 53.2055063913471 357 40 35 2 367 722 393 38 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 54110 425 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
20200184 20200184 PRJNA379145_P_NODE_74116_length_150_cov_1.683761_g71961_i0 PRJNA379145 74116 150 1.683761 2.5256415 Hantzschia 186033 SAR_Eukaryotes SAR_Eukaryotes 244 1.88e-60   NTclustered gi|1949467028|gb|MW396828.1| 2798590 g71961 i0 96.599 23.6933333333333 147 5 98 0 4 150 385 531 Hantzschia abundans strain MZ-BH2 large subunit ribosomal RNA gene, partial sequence blastn 3554 244 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Hantzschia Hantzschia abundans
22750831 22750831 PRJNA379145_P_NODE_33758_length_366_cov_132.075075_g31614_i0 PRJNA379145 33758 366 132.075075 483.3947745 Hantzschia 186033 SAR_Eukaryotes SAR_Eukaryotes 484 2.89e-132   NTclustered gi|694880079|gb|KM116088.1| 186034 g31614 i0 90.515 100.784153005464 369 31 100 3 1 366 911 544 Hantzschia amphioxys clone E01 18S ribosomal RNA gene, partial sequence blastn 36887 486 0.995884773662551 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Hantzschia Hantzschia amphioxys
24627308 24627308 PRJNA379145_P_NODE_56480_length_202_cov_2.568047_g54326_i0 PRJNA379145 56480 202 2.568047 5.18745494 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 215 2.12e-51   NTclustered gi|224006553|ref|XM_002292201.1| 296543 g54326 i0 92.105 79.3861386138614 152 12 75 0 12 163 1186 1337 Thalassiosira pseudonana CCMP1335 tubulin alpha (TUB1), mRNA blastn 16036 215 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana

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