RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA700095 · 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
1959119 1959119 PRJNA700095_P_NODE_19522_length_401_cov_2.359756_g18259_i0 PRJNA700095 19522 401 2.359756 9.46262156 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 115 4.83e-21   NTclustered gi|224003048|ref|XM_002291160.1| 296543 g18259 i0 89.247 0.231920199501247 93 8 23 2 172 263 98 7 Thalassiosira pseudonana CCMP1335 Cdc37 protein (Cdc37), partial mRNA blastn 93 115 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
1959165 1959165 PRJNA700095_P_NODE_28542_length_318_cov_4.232653_g27278_i0 PRJNA700095 28542 318 4.232653 13.45983654 Hemiaulus sinensis 1003062 SAR_Eukaryotes SAR_Eukaryotes 231 3.57e-56   NTclustered gi|2248495916|ref|NC_063458.1| 1003062 g27278 i0 80.731 45.3962264150943 301 54 94 4 5 303 22169 21871 Hemiaulus sinensis isolate Qingdao in China mitochondrion, complete genome blastn 14436 231 1 Eukaryota Sar   Bacillariophyta Mediophyceae Hemiaulales Hemiaulaceae Hemiaulus Hemiaulus sinensis
17261180 17261180 PRJNA700095_P_NODE_51274_length_251_cov_1.286517_g50010_i0 PRJNA700095 51274 251 1.286517 3.22915767 Nitzschia laevis 186029 SAR_Eukaryotes SAR_Eukaryotes 195 3.57e-45   NTclustered gi|1581445387|gb|MH017309.1| 186029 g50010 i0 87.952 53.6294820717131 166 19 66 1 81 245 436 601 Nitzschia laevis isolate ccmp1092 NADH dehydrogenase subunit 1 (nad1) gene, partial cds; mitochondrial blastn 13461 195 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia laevis
22360327 22360327 PRJNA700095_P_NODE_26478_length_333_cov_1.076923_g25214_i0 PRJNA700095 26478 333 1.076923 3.58615359 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 226 1.75e-54   NTclustered gi|224003920|ref|XM_002291596.1| 296543 g25214 i0 79.439 0.963963963963964 321 64 96 2 12 331 1000 681 Thalassiosira pseudonana CCMP1335 predicted protein mRNA blastn 321 226 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);;