RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA395690" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 14 ✖

tax_clade 1

bioproject 1

  • PRJNA395690 · 14 ✖

analysis 1

  • blastn · 14 ✖

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
1078958 1078958 PRJNA395690_P_NODE_1321_length_680_cov_2.270998_g1183_i0 PRJNA395690 1321 680 2.270998 15.4427864 Sellaphora 216740 SAR_Eukaryotes SAR_Eukaryotes 1157 0   NTclustered gi|570348533|gb|KF959642.1| 1436139 g1183 i0 97.353 99.7735294117647 680 18 100 0 1 680 579 1258 Sellaphora minima isolate TCC524 ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit (rbcL) gene, partial cds; chloroplast blastn 67846 1162 0.995697074010327 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Sellaphoraceae Sellaphora Sellaphora minima
1686574 1686574 PRJNA395690_P_NODE_34002_length_162_cov_2.415929_g33850_i0 PRJNA395690 34002 162 2.415929 3.91380498 Coscinodiscus wailesii 671091 SAR_Eukaryotes SAR_Eukaryotes 73.1 1.03e-8   NTclustered gi|1377545679|gb|MG835777.1| 671091 g33850 i0 97.619 22.7839506172839 42 1 26 0 121 162 523 482 Coscinodiscus wailesii isolate SKLMP_J006 28S ribosomal RNA gene, partial sequence blastn 3691 73.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus wailesii
8064800 8064800 PRJNA395690_P_NODE_13447_length_222_cov_1.190751_g13295_i0 PRJNA395690 13447 222 1.190751 2.64346722 Navicula incertata 2014769 SAR_Eukaryotes SAR_Eukaryotes 111 3.2e-20   NTclustered gi|2866543349|gb|PQ722532.1| 2014769 g13295 i0 78.889 1.83333333333333 180 26 79 10 47 222 49586 49415 Navicula incertata mitochondrion, complete genome blastn 407 111 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula incertata
8064825 8064825 PRJNA395690_P_NODE_14827_length_211_cov_1.549383_g14675_i0 PRJNA395690 14827 211 1.549383 3.26919813 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 141 3.85e-29   NTclustered gi|224004979|ref|XM_002296105.1| 296543 g14675 i0 83.444 44.3554502369668 151 25 72 0 3 153 734 884 Thalassiosira pseudonana CCMP1335 RL3, ribosomal protein 3, 60S large ribosomal subunit (RL3), mRNA blastn 9359 141 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
11890324 11890324 PRJNA395690_P_NODE_1270_length_697_cov_2.274691_g1138_i0 PRJNA395690 1270 697 2.274691 15.85459627 Haslea nusantara 2600302 SAR_Eukaryotes SAR_Eukaryotes 1112 0   NTclustered gi|1735238235|ref|NC_044491.1| 2600302 g1138 i0 95.422 95.1994261119082 699 30 100 2 1 697 54970 55668 Haslea nusantara chloroplast, complete genome blastn 66354 1112 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea nusantara
17656706 17656706 PRJNA395690_P_NODE_494_length_1095_cov_2.879541_g413_i0 PRJNA395690 494 1095 2.879541 31.53097395 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 1700 0   NTclustered gi|699008555|ref|NC_024928.1| 1458866 g413 i0 94.698 118.119634703196 1094 58 99 0 2 1095 89444 90537 Eunotia naegelii chloroplast, complete genome blastn 129341 1705 0.997067448680352 Eukaryota Sar   Bacillariophyta Bacillariophyceae Eunotiales Eunotiaceae Eunotia Eunotia naegelii
19537762 19537762 PRJNA395690_P_NODE_8616_length_275_cov_3.066372_g8464_i0 PRJNA395690 8616 275 3.066372 8.432523 Schizostauron trachyderma 2770866 SAR_Eukaryotes SAR_Eukaryotes 481 2.72e-131   NTclustered gi|2125740378|gb|MZ520768.1| 2770866 g8464 i0 98.182 198.465454545455 275 5 100 0 1 275 107230 106956 Schizostauron trachyderma strain SZCZE1420 plastid, complete genome blastn 54578 481 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Schizostauron Schizostauron trachyderma
22088249 22088249 PRJNA395690_P_NODE_33498_length_163_cov_0.894737_g33346_i0 PRJNA395690 33498 163 0.894737 1.45842131 Navicula avium 2018708 SAR_Eukaryotes SAR_Eukaryotes 193 7.669999999999999e-45   NTclustered gi|2721954134|gb|OR464347.1| 2018708 g33346 i0 88.199 5.89570552147239 161 19 99 0 2 162 12729 12569 Haslea avium plastid, complete genome blastn 961 193 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula avium
23363622 23363622 PRJNA395690_P_NODE_16459_length_200_cov_1.350993_g16307_i0 PRJNA395690 16459 200 1.350993 2.701986 Sundstroemia setigera 3005 SAR_Eukaryotes SAR_Eukaryotes 191 3.53e-44   NTclustered gi|2413964251|gb|ON646002.1| 3005 g16307 i0 85.484 46.22 186 23 92 4 17 200 22000 22183 Rhizosolenia setigera isolate CNS00571 mitochondrion, complete genome blastn 9244 191 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Sundstroemia Sundstroemia setigera
24637941 24637941 PRJNA395690_P_NODE_18980_length_189_cov_1.407143_g18828_i0 PRJNA395690 18980 189 1.407143 2.65950027 Navicula arenaria 355634 SAR_Eukaryotes SAR_Eukaryotes 250 5.36e-62   NTclustered gi|2301268953|ref|NC_066075.1| 355634 g18828 i0 90.476 61.6613756613757 189 18 100 0 1 189 143952 143764 Navicula arenaria isolate Jiaozhou Bay in China chloroplast, complete genome blastn 11654 250 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula arenaria
24637948 24637948 PRJNA395690_P_NODE_19580_length_187_cov_2.927536_g19428_i0 PRJNA395690 19580 187 2.927536 5.47449232 Entomoneis umbratica 2086363 SAR_Eukaryotes SAR_Eukaryotes 257 3.1600000000000004e-64   NTclustered gi|2721954796|gb|OR464352.1| 2086363 g19428 i0 91.848 89.0588235294118 184 15 98 0 4 187 50025 49842 Entomoneis umbratica plastid, complete genome blastn 16654 257 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis umbratica
25305213 25305213 PRJNA395690_P_NODE_34240_length_162_cov_1.424779_g34088_i0 PRJNA395690 34240 162 1.424779 2.30814198 Luticola 431369 SAR_Eukaryotes SAR_Eukaryotes 198 1.64e-46   NTclustered gi|694880115|gb|KM116124.1| 1561720 g34088 i0 88.957 70.3703703703704 163 15 99 1 3 162 672 834 Luticola permuticopsis clone A01 18S ribosomal RNA gene, partial sequence blastn 11400 198 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Diadesmidaceae Luticola Luticola permuticopsis
25305242 25305242 PRJNA395690_P_NODE_36920_length_155_cov_2.933962_g36767_i0 PRJNA395690 36920 155 2.933962 4.5476411 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 206 9.24e-49   NTclustered gi|662012825|ref|NC_024083.1| 1115533 g36767 i0 91.837 92.0387096774193 147 12 95 0 1 147 49565 49711 Didymosphenia geminata chloroplast, complete genome blastn 14266 206 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Didymosphenia Didymosphenia geminata
25305290 25305290 PRJNA395690_P_NODE_9040_length_270_cov_4.615385_g8888_i0 PRJNA395690 9040 270 4.615385 12.4615395 Rhopalodiales 245176 SAR_Eukaryotes SAR_Eukaryotes 420 5.89e-113   NTclustered gi|2325195844|gb|OM494341.1| 186043 g8888 i0 98.734 176.874074074074 237 2 88 1 16 252 89290 89055 Entomoneis sp. isolate C2 plastid, complete genome blastn 47756 422 0.995260663507109 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis sp.

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