RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA556992 · 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
10727834 10727834 PRJNA556992_P_NODE_1148849_length_201_cov_16.546875_g1146658_i0 PRJNA556992 1148849 201 16.546875 33.25921875 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 76.8 1.04e-9   NTclustered gi|2073953076|gb|MW849265.1| 2856 g1146658 i0 86.486 1.87064676616915 74 4 35 6 42 112 34163 34093 Cylindrotheca closterium isolate Qingdao in China mitochondrion, complete genome blastn 376 76.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
10731039 10731039 PRJNA556992_P_NODE_296949_length_289_cov_2.148148_g294760_i0 PRJNA556992 296949 289 2.148148 6.20814772 Schizostauron trachyderma 2770866 SAR_Eukaryotes SAR_Eukaryotes 318 2.39e-82   NTclustered gi|2125740378|gb|MZ520768.1| 2770866 g294760 i0 87.063 84.0207612456747 286 31 98 6 7 289 48986 49268 Schizostauron trachyderma strain SZCZE1420 plastid, complete genome blastn 24282 318 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Schizostauron Schizostauron trachyderma
14552739 14552739 PRJNA556992_P_NODE_1153392_length_200_cov_17.858268_g1151201_i0 PRJNA556992 1153392 200 17.858268 35.716536 Sellaphora pupula 216741 SAR_Eukaryotes SAR_Eukaryotes 342 9.209999999999999e-90   NTclustered gi|139527392|gb|EF143266.1| 216741 g1151201 i0 97.97 98.47 197 4 99 0 3 199 1203 1399 Sellaphora pupula clone BEL2 ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit (rbcL) gene, partial cds; chloroplast blastn 19694 342 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Sellaphoraceae Sellaphora Sellaphora pupula
14555219 14555219 PRJNA556992_P_NODE_257412_length_301_cov_11.328947_g255223_i0 PRJNA556992 257412 301 11.328947 34.10013047 Sellaphora seminulum 1302831 SAR_Eukaryotes SAR_Eukaryotes 518 2.3e-142   NTclustered gi|459936748|gb|KC736613.1| 1302831 g255223 i0 97.674 99.9435215946844 301 7 100 0 1 301 1009 709 Sellaphora seminulum clone TCC461 ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit (rbcL) gene, partial cds; chloroplast blastn 30083 518 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Sellaphoraceae Sellaphora Sellaphora seminulum
15153123 15153123 PRJNA556992_P_NODE_154952_length_354_cov_31.950178_g152764_i0 PRJNA556992 154952 354 31.950178 113.10363012 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 566 9.669999999999999e-157   NTclustered gi|2325195844|gb|OM494341.1| 186043 g152764 i0 95.493 131.19209039548 355 15 100 1 1 354 101444 101090 Entomoneis sp. isolate C2 plastid, complete genome blastn 46442 568 0.996478873239437 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis sp.
15826277 15826277 PRJNA556992_P_NODE_1135593_length_204_cov_10.977099_g1133402_i0 PRJNA556992 1135593 204 10.977099 22.39328196 Didymosphenia geminata 1115533 SAR_Eukaryotes SAR_Eukaryotes 71.3 4.91e-8   NTclustered gi|1125788738|ref|NC_032171.1| 1115533 g1133402 i0 92.157 5.49509803921569 51 2 25 2 3 52 4974 5023 Didymosphenia geminata mitochondrion, complete genome blastn 1121 71.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Didymosphenia Didymosphenia geminata
15829877 15829877 PRJNA556992_P_NODE_313953_length_287_cov_1.224299_g311764_i0 PRJNA556992 313953 287 1.224299 3.51373813 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 119 2.58e-22   NTclustered gi|1819718724|gb|MN956530.1| 2850 g311764 i0 78.857 1.21951219512195 175 37 61 0 41 215 3401 3575 Phaeodactylum tricornutum strain ICE-H mitochondrion, complete genome blastn 350 119 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
16430655 16430655 PRJNA556992_P_NODE_904093_length_240_cov_3.988024_g901903_i0 PRJNA556992 904093 240 3.988024 9.5712576 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 272 1.52e-68   NTclustered gi|699008555|ref|NC_024928.1| 1458866 g901903 i0 87.137 78.4875 241 30 100 1 1 240 64438 64198 Eunotia naegelii chloroplast, complete genome blastn 18837 272 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Eunotiales Eunotiaceae Eunotia Eunotia naegelii
17100261 17100261 PRJNA556992_P_NODE_1071174_length_219_cov_7.815068_g1068983_i0 PRJNA556992 1071174 219 7.815068 17.11499892 Nitzschia schefterae 2794250 SAR_Eukaryotes SAR_Eukaryotes 357 3.67e-94   NTclustered gi|2071966764|gb|MW324658.1| 2794250 g1068983 i0 96.313 99.4520547945205 217 8 99 0 1 217 833 1049 Nitzschia schefterae isolate GU52X-1 NitzC28 photosystem II CP43 protein (psbC) gene, partial cds; chloroplast blastn 21780 357 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia schefterae
18976947 18976947 PRJNA556992_P_NODE_257395_length_301_cov_14.833333_g255206_i0 PRJNA556992 257395 301 14.833333 44.64833233 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 503 6.43e-138   NTclustered gi|817090803|gb|KM009461.1| 1003053 g255206 i0 96.99 100.624584717608 299 9 99 0 2 300 181 479 Fallacia monoculata isolate FD254 PSII protein D1 (psbA) gene, partial cds; chloroplast blastn 30288 505 0.996039603960396 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Sellaphoraceae Fallacia Fallacia monoculata
18978533 18978533 PRJNA556992_P_NODE_70155_length_453_cov_22.734211_g67982_i0 PRJNA556992 70155 453 22.734211 102.98597583 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 754 0   NTclustered gi|2127877134|ref|NC_058783.1| 37318 g67982 i0 96.689 101.631346578366 453 15 100 0 1 453 88853 89305 Pseudo-nitzschia pungens isolate CNS00141 chloroplast, complete genome blastn 46039 754 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia pungens
20931523 20931523 PRJNA556992_P_NODE_50317_length_511_cov_7.515982_g48157_i0 PRJNA556992 50317 511 7.515982 38.40666802 Cocconeiopsis kantsiensis 3082010 SAR_Eukaryotes SAR_Eukaryotes 689 0   NTclustered gi|2692958229|ref|NC_086886.1| 3082010 g48157 i0 91.016 101.146771037182 512 44 100 2 1 511 61842 62352 Cocconeiopsis kantsiensis chloroplast, complete genome blastn 51686 689 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cocconeidales Cocconeidaceae Cocconeiopsis Cocconeiopsis kantsiensis
24076392 24076392 PRJNA556992_P_NODE_1074579_length_218_cov_19.875862_g1072388_i0 PRJNA556992 1074579 218 19.875862 43.32937916 Rhopalodiales 245176 SAR_Eukaryotes SAR_Eukaryotes 398 2.1499999999999996e-106   NTclustered gi|1418587827|ref|NC_038001.1| 186043 g1072388 i0 99.541 196.256880733945 218 1 100 0 1 218 66106 66323 Entomoneis sp. chloroplast, complete genome blastn 42784 398 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis sp.
24080013 24080013 PRJNA556992_P_NODE_960499_length_234_cov_5.428571_g958309_i0 PRJNA556992 960499 234 5.428571 12.70285614 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 215 2.53e-51   NTclustered gi|2328348073|ref|NC_067581.1| 197756 g958309 i0 84.234 10.3376068376068 222 33 94 2 1 221 9003 9223 Haslea pseudostrearia strain SCCAP K-1594 chloroplast, complete genome blastn 2419 215 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea pseudostrearia

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