RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "blastn", bioproject = "PRJNA662254" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 18 ✖

tax_clade 1

bioproject 1

  • PRJNA662254 · 18 ✖

analysis 1

  • blastn · 18 ✖

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
2437105 2437105 PRJNA662254_P_NODE_21142_length_357_cov_1.528169_g20491_i0 PRJNA662254 21142 357 1.5281690000000001 5.45556333 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 654 0   NTclustered gi|496737171|gb|KC923296.1| 304200 g20491 i0 99.72 97.1792717086835 357 1 100 0 1 357 61 417 Nitzschia amphibia strain FDCC L602 18S ribosomal RNA gene, partial sequence blastn 34693 654 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia amphibia
3179132 3179132 PRJNA662254_P_NODE_27303_length_317_cov_1.188525_g26652_i0 PRJNA662254 27303 317 1.188525 3.76762425 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 453 6.970000000000001e-123   NTclustered gi|2620230846|gb|OR797295.1| 2126271 g26652 i0 93.464 95 306 19 97 1 4 309 4419 4723 Naviculales sp. strain SZCZO2114 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 30115 453 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
3179138 3179138 PRJNA662254_P_NODE_30523_length_300_cov_1.740088_g29872_i0 PRJNA662254 30523 300 1.740088 5.220264 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 501 2.31e-137   NTclustered gi|2059418577|gb|MW971520.1| 303405 g29872 i0 96.99 107.656666666667 299 8 99 1 3 300 127392 127690 Nitzschia inconspicua strain hildebrandi plastid, complete genome blastn 32297 501 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
4456124 4456124 PRJNA662254_P_NODE_17244_length_394_cov_2.336449_g16593_i0 PRJNA662254 17244 394 2.336449 9.20560906 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 689 0   NTclustered gi|2059418577|gb|MW971520.1| 303405 g16593 i0 98.223 136.832487309645 394 7 100 0 1 394 39142 39535 Nitzschia inconspicua strain hildebrandi plastid, complete genome blastn 53912 689 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
7006891 7006891 PRJNA662254_P_NODE_34066_length_286_cov_1.112676_g33415_i0 PRJNA662254 34066 286 1.112676 3.18225336 Nitzschia amphibia 304200 SAR_Eukaryotes SAR_Eukaryotes 518 2.17e-142   NTclustered gi|1779750587|gb|MN750495.1| 304200 g33415 i0 99.301 100.192307692308 286 2 100 0 1 286 1504 1219 Nitzschia amphibia strain RT5 [Nit239] small subunit ribosomal RNA gene, partial sequence blastn 28655 518 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia amphibia
7007025 7007025 PRJNA662254_P_NODE_59466_length_244_cov_0.900585_g58815_i0 PRJNA662254 59466 244 0.900585 2.1974274 Coscinodiscus granii 265552 SAR_Eukaryotes SAR_Eukaryotes 117 7.6900000000000005e-22   NTclustered gi|2192941198|ref|NC_060315.1| 265552 g58815 i0 91.765 29.8360655737705 85 5 34 1 44 126 5777 5861 Coscinodiscus granii mitochondrion, complete sequence blastn 7280 117 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus granii
9556763 9556763 PRJNA662254_P_NODE_29248_length_307_cov_0.957265_g28597_i0 PRJNA662254 29248 307 0.957265 2.93880355 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 440 5.229999999999999e-119   NTclustered gi|2059418577|gb|MW971520.1| 303405 g28597 i0 92.508 102.954397394137 307 23 100 0 1 307 129426 129732 Nitzschia inconspicua strain hildebrandi plastid, complete genome blastn 31607 440 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
12107585 12107585 PRJNA662254_P_NODE_14470_length_431_cov_4.882682_g13819_i0 PRJNA662254 14470 431 4.882682 21.04435942 Nitzschia amphibia 304200 SAR_Eukaryotes SAR_Eukaryotes 791 0   NTclustered gi|2209416101|gb|ON015000.1| 304200 g13819 i0 99.767 100.60788863109 430 1 99 0 2 431 514 85 Nitzschia amphibia clone CBac2019021 large subunit ribosomal RNA gene, partial sequence blastn 43362 791 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia amphibia
13382434 13382434 PRJNA662254_P_NODE_55271_length_246_cov_0.890173_g54620_i0 PRJNA662254 55271 246 0.890173 2.18982558 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 126 1.29e-24   NTclustered gi|219121659|ref|XM_002181144.1| 556484 g54620 i0 82 2.80081300813008 150 25 61 2 96 244 190 338 Phaeodactylum tricornutum CCAP 1055/1 predicted protein partial mRNA blastn 689 126 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
15190443 15190443 PRJNA662254_P_NODE_16832_length_399_cov_4.131902_g16181_i0 PRJNA662254 16832 399 4.131902 16.48628898 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 736 0   NTclustered gi|1779750555|gb|MN750463.1| 303405 g16181 i0 100 98.7318295739348 398 0 99 0 2 399 4 401 Nitzschia inconspicua strain G3_3 [L61] small subunit ribosomal RNA gene, partial sequence blastn 39394 736 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
15190480 15190480 PRJNA662254_P_NODE_38572_length_270_cov_1.492386_g37921_i0 PRJNA662254 38572 270 1.492386 4.0294422 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 122 1.86e-23   NTclustered gi|1179910904|dbj|LC258386.1| 371681 g37921 i0 86.842 42.162962962963 114 10 41 5 1 112 2721 2611 Skeletonema grevillei genes for 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence, strain: F35#9 blastn 11384 122 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema grevillei
15931151 15931151 PRJNA662254_P_NODE_35913_length_279_cov_1.495146_g35262_i0 PRJNA662254 35913 279 1.495146 4.17145734 Denticula kuetzingii 1003042 SAR_Eukaryotes SAR_Eukaryotes 481 2.77e-131   NTclustered gi|329342917|gb|HQ912303.1| 1003042 g35262 i0 98.182 98.7347670250896 275 5 99 0 1 275 372 646 Denticula kuetzingii strain UTEX FD135 PsbC (psbC) gene, partial cds; chloroplast blastn 27547 481 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Denticula Denticula kuetzingii
17206458 17206458 PRJNA662254_P_NODE_6674_length_660_cov_5.425894_g6058_i0 PRJNA662254 6674 660 5.425894 35.8109004 Cylindrotheca fusiformis 2853 SAR_Eukaryotes SAR_Eukaryotes 507 1.17e-138   NTclustered gi|66968231|gb|DQ060240.1| 2853 g6058 i0 81.464 8.72575757575758 642 98 95 16 30 659 1625 2257 Cylindrotheca fusiformis chloroplast fucoxanthin chlorophyll a/c-binding protein precursor (cffcpA-1A) gene, complete cds; nuclear gene for chloroplast product blastn 5759 507 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca fusiformis
17739880 17739880 PRJNA662254_P_NODE_7134_length_636_cov_5.143872_g6510_i0 PRJNA662254 7134 636 5.143872 32.71502592 Pseudo-nitzschia 41953 SAR_Eukaryotes SAR_Eukaryotes 920 0   NTclustered gi|2862228894|gb|PQ645528.1| 44447 g6510 i0 92.79 98.0487421383648 638 42 100 3 1 636 4111 3476 Pseudo-nitzschia delicatissima isolate AGSB0398 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 62359 920 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia delicatissima
20288275 20288275 PRJNA662254_P_NODE_40616_length_263_cov_1.621053_g39965_i0 PRJNA662254 40616 263 1.621053 4.26336939 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 451 2.03e-122   NTclustered gi|2866543221|gb|PQ722531.1| 2014769 g39965 i0 97.71 198.197718631179 262 6 99 0 1 262 73091 72830 Navicula incertata chloroplast, complete genome blastn 52126 453 0.995584988962472 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula incertata
21030829 21030829 PRJNA662254_P_NODE_40957_length_262_cov_1.613757_g40306_i0 PRJNA662254 40957 262 1.613757 4.22804334 Denticula kuetzingii 1003042 SAR_Eukaryotes SAR_Eukaryotes 435 2.0300000000000003e-117   NTclustered gi|817090831|gb|KM009475.1| 1003042 g40306 i0 96.578 104.225190839695 263 8 100 1 1 262 307 569 Denticula kuetzingii isolate FD135 PSII protein D1 (psbA) gene, partial cds; chloroplast blastn 27307 435 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Denticula Denticula kuetzingii
21030854 21030854 PRJNA662254_P_NODE_46777_length_250_cov_0.870056_g46126_i0 PRJNA662254 46777 250 0.870056 2.17514 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 291 4.41e-74   NTclustered gi|2059418577|gb|MW971520.1| 303405 g46126 i0 90.541 4.932 222 18 89 3 3 224 99891 100109 Nitzschia inconspicua strain hildebrandi plastid, complete genome blastn 1233 291 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
23581087 23581087 PRJNA662254_P_NODE_62879_length_242_cov_0.911243_g62228_i0 PRJNA662254 62879 242 0.911243 2.20520806 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 204 5.69e-48   NTclustered gi|223996330|ref|XM_002287803.1| 296543 g62228 i0 84.804 0.84297520661157 204 29 84 2 1 203 1642 1844 Thalassiosira pseudonana CCMP1335 predicted protein partial mRNA blastn 204 204 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);;