RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA395690", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 22 ✖

tax_clade 1

  • Sar · 22 ✖

bioproject 1

  • PRJNA395690 · 22 ✖

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
13832545 13832545 PRJNA395690_P_NODE_34971_length_162_cov_0.902655_g34819_i0 PRJNA395690 34971 162 0.902655 1.4623011 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 95.9 7.76e-23   NR CAJ1953473.1 2856 g34819 i0 87 6 54 7 100 0 1 162 155 208 CAJ1953473.1 unnamed protein product [Cylindrotheca closterium] diamond 972 95.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
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.
26600226 26600226 PRJNA395690_P_NODE_28761_length_167_cov_0.864407_g28609_i0 PRJNA395690 28761 167 0.864407 1.44355969 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 62 8.3e-10   NR KAI2511482.1 210448 g28609 i0 72.1 0.772455089820359 43 10 77.2 1 131 3 8 48 KAI2511482.1 PPPDE putative peptidase domain-containing protein [Fragilaria crotonensis] diamond 129 62 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27012023 27012023 PRJNA395690_P_NODE_33882_length_163_cov_0.894737_g33730_i0 PRJNA395690 33882 163 0.894737 1.45842131 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 89.4 1.69e-20   NR XP_002186010.1 556484 g33730 i0 86.8 2.92638036809816 53 7 97.5 0 161 3 124 176 XP_002186010.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 477 89.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27565897 27565897 PRJNA395690_P_NODE_13264_length_224_cov_0.868571_g13112_i0 PRJNA395690 13264 224 0.868571 1.94559904 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 55.5 6.12e-8   NR KAI2513692.1 210448 g13112 i0 62.5 1.125 40 15 53.6 0 4 123 46 85 KAI2513692.1 hypothetical protein MHU86_832 [Fragilaria crotonensis] diamond 252 55.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28212116 28212116 PRJNA395690_P_NODE_33746_length_163_cov_0.894737_g33594_i0 PRJNA395690 33746 163 0.894737 1.45842131 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0127   NR KAL3919812.1 3061772 g33594 i0 40.7 0.993865030674847 54 30 95.7 1 4 159 154 207 KAL3919812.1 MAG: hypothetical protein SGILL_003567 [Bacillariaceae sp.] diamond 162 42.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
29096529 29096529 PRJNA395690_P_NODE_23168_length_179_cov_1.453846_g23016_i0 PRJNA395690 23168 179 1.453846 2.60238434 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 48.1 1.99e-4   NR KAI2507915.1 210448 g23016 i0 48.4 1.07262569832402 64 24 98.9 3 1 177 71 130 KAI2507915.1 peptidase [Fragilaria crotonensis] diamond 192 48.1 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30675505 30675505 PRJNA395690_P_NODE_18453_length_190_cov_1.425532_g18301_i0 PRJNA395690 18453 190 1.425532 2.7085108 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 101 2.5e-24   NR XP_002184230.1 556484 g18301 i0 69.6 1.08947368421053 69 15 99.5 1 190 2 172 240 XP_002184230.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 207 101 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
30801963 30801963 PRJNA395690_P_NODE_21934_length_182_cov_1.488722_g21782_i0 PRJNA395690 21934 182 1.488722 2.70947404 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0165   NR GAX13776.1 1519565 g21782 i0 43.6 1.31868131868132 39 22 64.3 0 119 3 51 89 GAX13776.1 hypothetical protein FisN_30Lh067 [Fistulifera solaris] diamond 240 42.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris

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