RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA1120060" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 12 ✖

tax_clade 1

bioproject 1

  • PRJNA1120060 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
2796025 2796025 PRJNA1120060_P_NODE_1983203_length_273_cov_3.000000_g1965175_i0 PRJNA1120060 1983203 273 3 8.19 Rhizosolenia imbricata 216768 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.025   NTclustered gi|725650481|ref|NC_025311.1| 216768 g1965175 i0 100 0.205128205128205 28 0 10 0 13 40 68684 68657 Rhizosolenia imbricata chloroplast, complete genome blastn 56 52.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Rhizosolenia Rhizosolenia imbricata
4058718 4058718 PRJNA1120060_P_NODE_1042824_length_311_cov_5.084034_g1024889_i0 PRJNA1120060 1042824 311 5.084034 15.81134574 Haslea nusantara 2600302 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.029   NTclustered gi|1735238366|ref|NC_044492.1| 2600302 g1024889 i0 100 0.090032154340836 28 0 9 0 227 254 1771 1744 Haslea nusantara mitochondrion, complete genome blastn 28 52.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea nusantara
11229572 11229572 PRJNA1120060_P_NODE_255329_length_438_cov_3.005479_g238475_i0 PRJNA1120060 255329 438 3.005479 13.16399802 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.042   NTclustered gi|2785082235|gb|PQ157946.1| 2126271 g238475 i0 100 0.127853881278539 28 0 6 0 324 351 68784 68811 Naviculales sp. strain SZCZO2114 mitochondrion, complete genome blastn 56 52.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
11735845 11735845 PRJNA1120060_P_NODE_2927530_length_243_cov_1.229412_g2909437_i0 PRJNA1120060 2927530 243 1.229412 2.98747116 Proschkinia sp. SZCZR1824 2588390 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.022   NTclustered gi|1681061561|gb|MH800316.1| 2588390 g2909437 i0 100 0.11522633744856 28 0 12 0 131 158 3674 3647 Proschkinia sp. SZCZR1824 mitochondrion, complete genome blastn 28 52.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Proschkiniaceae Proschkinia Proschkinia sp. SZCZR1824
12987164 12987164 PRJNA1120060_P_NODE_1134551_length_311_cov_2.605042_g1116616_i0 PRJNA1120060 1134551 311 2.605042 8.10168062 Thalassionema bacillare 426664 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.029   NTclustered gi|2192939962|ref|NC_060857.1| 426664 g1116616 i0 100 0.270096463022508 28 0 9 0 57 84 111419 111392 Thalassionema bacillare strain CNS00831 chloroplast, complete genome blastn 84 52.8 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Thalassionemales Thalassionemataceae Thalassionema Thalassionema bacillare
14264547 14264547 PRJNA1120060_P_NODE_1270672_length_308_cov_3.800000_g1252727_i0 PRJNA1120060 1270672 308 3.8 11.704 Nitzschia supralitorea 303403 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.029   NTclustered gi|2088232260|ref|NC_056787.1| 303403 g1252727 i0 100 0.0909090909090909 28 0 9 0 95 122 137041 137014 Nitzschia supralitorea isolate SZCZR1828 chloroplast, complete genome blastn 28 52.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia supralitorea
16838161 16838161 PRJNA1120060_P_NODE_3250954_length_229_cov_2.852564_g3232847_i0 PRJNA1120060 3250954 229 2.852564 6.53237156 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.02   NTclustered gi|2156401054|dbj|LC537471.1| 426638 g3232847 i0 100 0.244541484716157 28 0 12 0 191 218 98138 98111 Chaetoceros tenuissimus NIES-3715 chloroplast DNA, complete genome blastn 56 52.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
20636856 20636856 PRJNA1120060_P_NODE_1284077_length_308_cov_1.702128_g1266132_i0 PRJNA1120060 1284077 308 1.702128 5.24255424 Schizostauron trachyderma 2770866 SAR_Eukaryotes SAR_Eukaryotes 58.4 6.18e-4   NTclustered gi|2125739626|gb|MZ520767.1| 2770866 g1266132 i0 97.059 0.305194805194805 34 1 11 0 117 150 35307 35340 Schizostauron trachyderma strain SZCZE1420 mitochondrion, complete genome blastn 94 58.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Schizostauron Schizostauron trachyderma
21916741 21916741 PRJNA1120060_P_NODE_1578978_length_290_cov_1.488479_g1560986_i0 PRJNA1120060 1578978 290 1.488479 4.3165891 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.027   NTclustered gi|223997047|ref|XM_002288161.1| 296543 g1560986 i0 100 0.096551724137931 28 0 10 0 192 219 553 526 Thalassiosira pseudonana CCMP1335 predicted protein partial mRNA blastn 28 52.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
23188959 23188959 PRJNA1120060_P_NODE_135919_length_521_cov_5.040179_g120350_i0 PRJNA1120060 135919 521 5.040179 26.25933259 Cyclotella sp. WC03_2 1549164 SAR_Eukaryotes SAR_Eukaryotes 62.1 8.49e-5   NTclustered gi|691190018|gb|KJ958481.1| 1549164 g120350 i0 90 0.0959692898272553 50 2 9 3 198 246 46576 46529 Cyclotella sp. WC03_2 chloroplast, complete genome blastn 50 62.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella sp. WC03_2
23211975 23211975 PRJNA1120060_P_NODE_3127639_length_234_cov_9.720497_g3109535_i0 PRJNA1120060 3127639 234 9.720497 22.74596298 Plagiogrammopsis vanheurckii 1234821 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.006   NTclustered gi|1418587279|ref|NC_037997.1| 1234821 g3109535 i0 94.444 0.153846153846154 36 1 15 1 110 145 71445 71411 Plagiogrammopsis vanheurckii chloroplast, complete genome blastn 36 54.7 1 Eukaryota Sar   Bacillariophyta Mediophyceae Cymatosirales Cymatosiraceae Plagiogrammopsis Plagiogrammopsis vanheurckii
24457799 24457799 PRJNA1120060_P_NODE_1019680_length_312_cov_2.251046_g1001751_i0 PRJNA1120060 1019680 312 2.251046 7.02326352 Thalassiosira nordenskioeldii 83372 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.002   NTclustered gi|2127884593|ref|NC_058877.1| 83372 g1001751 i0 100 0.0961538461538462 30 0 10 0 79 108 4971 5000 Thalassiosira nordenskioeldii isolate CNS00052 chloroplast, complete genome blastn 30 56.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira nordenskioeldii

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