RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJNA640143" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 20 ✖

tax_clade 1

bioproject 1

  • PRJNA640143 · 20 ✖

analysis 1

  • blastn · 20 ✖

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
609585 609585 PRJNA640143_S_NODE_10861_length_262_cov_1.840000_g10651_i0 PRJNA640143 10861 262 1.84 4.8208 Eunotia naegelii 1458866 SAR_Eukaryotes SAR_Eukaryotes 219 2.2299999999999994e-52   NTclustered gi|699008555|ref|NC_024928.1| 1458866 g10651 i0 83.197 3.79389312977099 244 36 92 3 3 242 98953 99195 Eunotia naegelii chloroplast, complete genome blastn 994 219 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Eunotiales Eunotiaceae Eunotia Eunotia naegelii
2430681 2430681 PRJNA640143_S_NODE_3702_length_419_cov_24.785340_g3503_i0 PRJNA640143 3702 419 24.78534 103.8505746 Phaeodactylum 2849 SAR_Eukaryotes SAR_Eukaryotes 183 1.37e-41   NTclustered gi|395362|emb|Z24768.1| 2850 g3503 i0 85 4.10262529832936 180 27 43 0 231 410 2145 1966 P.tricornutum fcpA, fcpB, fcpC, and fcpD genes, complete CDS blastn 1719 183 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
3707156 3707156 PRJNA640143_S_NODE_63_length_1669_cov_22.532475_g56_i0 PRJNA640143 63 1669 22.532475 376.06700775 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 1995 0   NTclustered gi|2065945752|gb|MW845780.1| 230516 g56 i0 89.103 95.9496704613541 1606 173 96 2 37 1640 111142 109537 Chaetoceros curvisetus chloroplast, complete genome blastn 160140 2010 0.992537313432836 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros curvisetus
4437574 4437574 PRJNA640143_S_NODE_2024_length_536_cov_18.567134_g1876_i0 PRJNA640143 2024 536 18.567134 99.51983824 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 366 1.6599999999999993e-96   NTclustered gi|219112234|ref|XM_002177833.1| 556484 g1876 i0 80.282 18.634328358209 497 89 92 7 4 494 628 135 Phaeodactylum tricornutum CCAP 1055/1 protein fucoxanthin chlorophyl a/c protein (Lhcf3), mRNA blastn 9988 366 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
4983744 4983744 PRJNA640143_S_NODE_3764_length_416_cov_30.245383_g3565_i0 PRJNA640143 3764 416 30.245383 125.82079328 Phaeodactylum 2849 SAR_Eukaryotes SAR_Eukaryotes 183 1.36e-41   NTclustered gi|395362|emb|Z24768.1| 2850 g3565 i0 85 4.13221153846154 180 27 43 0 228 407 2145 1966 P.tricornutum fcpA, fcpB, fcpC, and fcpD genes, complete CDS blastn 1719 183 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
6988326 6988326 PRJNA640143_S_NODE_18906_length_201_cov_315.500000_g18696_i0 PRJNA640143 18906 201 315.5 634.155 Halamphora coffeiformis 1487565 SAR_Eukaryotes SAR_Eukaryotes 287 4.399999999999999e-73   NTclustered gi|1735236684|ref|NC_044465.1| 1487565 g18696 i0 99.371 149.437810945274 159 0 79 1 41 199 69148 69305 Halamphora coffeaeformis chloroplast, complete genome blastn 30037 287 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora coffeiformis
7533324 7533324 PRJNA640143_S_NODE_32386_length_151_cov_1.710526_g32176_i0 PRJNA640143 32386 151 1.710526 2.58289426 Thalassiosira 35127 SAR_Eukaryotes SAR_Eukaryotes 182 1.51e-41   NTclustered gi|2127884451|ref|NC_058876.1| 49265 g32176 i0 89.51 114.596026490066 143 15 95 0 9 151 27566 27708 Thalassiosira rotula isolate CNS00051 chloroplast, complete genome blastn 17304 182 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira rotula
9538770 9538770 PRJNA640143_S_NODE_7068_length_316_cov_9.544803_g6858_i0 PRJNA640143 7068 316 9.544803 30.16157748 Cylindrotheca fusiformis 2853 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.008   NTclustered gi|23168421|gb|AY125587.1| 2853 g6858 i0 96.875 0.10126582278481 32 1 10 0 252 283 447 416 Cylindrotheca fusiformis fucoxanthin chlorophyll a/c-binding protein precursor (cffcpA-7) mRNA, partial cds blastn 32 54.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca fusiformis
10814174 10814174 PRJNA640143_S_NODE_25569_length_174_cov_6.576642_g25359_i0 PRJNA640143 25569 174 6.576642 11.44335708 Bacillaria paxillifer 3003 SAR_Eukaryotes SAR_Eukaryotes 211 2.28e-50   NTclustered gi|2199203925|ref|NC_061049.1| 3003 g25359 i0 89.881 49.4367816091954 168 12 95 4 9 174 98908 99072 Bacillaria paxillifer chloroplast, complete genome blastn 8602 211 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Bacillaria Bacillaria paxillifer
10814494 10814494 PRJNA640143_S_NODE_8749_length_288_cov_2.115538_g8539_i0 PRJNA640143 8749 288 2.115538 6.09274944 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 510 3.66e-140   NTclustered gi|1418586581|ref|NC_037986.1| 2856 g8539 i0 98.611 38.9097222222222 288 4 100 0 1 288 2881 2594 Cylindrotheca closterium strain CCMP1855 mitochondrion, complete genome blastn 11206 510 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
13364232 13364232 PRJNA640143_S_NODE_29691_length_159_cov_2.155738_g29481_i0 PRJNA640143 29691 159 2.155738 3.42762342 Haslea pseudostrearia 197756 SAR_Eukaryotes SAR_Eukaryotes 176 7.49e-40   NTclustered gi|2328348073|ref|NC_067581.1| 197756 g29481 i0 87.179 13.874213836478 156 18 97 2 3 157 105390 105236 Haslea pseudostrearia strain SCCAP K-1594 chloroplast, complete genome blastn 2206 176 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea pseudostrearia
15913030 15913030 PRJNA640143_S_NODE_4273_length_394_cov_2.140056_g4070_i0 PRJNA640143 4273 394 2.140056 8.43182064 Navicula tsukamotoi 2018706 SAR_Eukaryotes SAR_Eukaryotes 296 1.58e-75   NTclustered gi|2310599052|gb|OK729588.1| 2018706 g4070 i0 80.729 19.8807106598985 384 70 97 4 10 391 114219 114600 Navicula tsukamotoi strain SZCZR1831 chloroplast, complete genome blastn 7833 296 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula tsukamotoi
17733289 17733289 PRJNA640143_S_NODE_23794_length_181_cov_1.277778_g23584_i0 PRJNA640143 23794 181 1.277778 2.31277818 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 283 5.01e-72   NTclustered gi|220980838|emb|AM183249.1| 303400 g23584 i0 97.59 88.7734806629834 166 2 92 1 1 166 266 103 Nitzschia palea partial 28S rRNA gene, clone Victor 02-9F blastn 16068 283 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
17733341 17733341 PRJNA640143_S_NODE_3294_length_439_cov_39.191542_g3099_i0 PRJNA640143 3294 439 39.191542 172.05086938 Phaeodactylum 2849 SAR_Eukaryotes SAR_Eukaryotes 183 1.44e-41   NTclustered gi|395362|emb|Z24768.1| 2850 g3099 i0 85 3.91571753986333 180 27 41 0 251 430 2145 1966 P.tricornutum fcpA, fcpB, fcpC, and fcpD genes, complete CDS blastn 1719 183 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
19736667 19736667 PRJNA640143_S_NODE_23016_length_183_cov_363.726027_g22806_i0 PRJNA640143 23016 183 363.726027 665.61862941 Pinnularia borealis complex sp. 2725370 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.001   NTclustered gi|1829658850|gb|MN940791.1| 2725370 g22806 i0 96.97 1.62295081967213 33 1 18 0 1 33 146 114 Pinnularia borealis complex sp. voucher ICE16_03_08 28S ribosomal RNA gene, partial sequence blastn 297 56.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pinnulariaceae Pinnularia Pinnularia borealis complex sp.
21557422 21557422 PRJNA640143_S_NODE_997_length_702_cov_3.715789_g905_i0 PRJNA640143 997 702 3.715789 26.08483878 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 784 0   NTclustered gi|2199203925|ref|NC_061049.1| 3003 g905 i0 87.856 95.8290598290598 667 81 95 0 36 702 116847 116181 Bacillaria paxillifer chloroplast, complete genome blastn 67272 789 0.993662864385298 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Bacillaria Bacillaria paxillifer
22286699 22286699 PRJNA640143_S_NODE_1078_length_681_cov_88.928571_g976_i0 PRJNA640143 1078 681 88.928571 605.60356851 Nitzschia sp. pyKryTriq1 3034176 SAR_Eukaryotes SAR_Eukaryotes 337 1.6699999999999995e-87   NTclustered gi|2524387093|emb|OY101132.1| 3034176 g976 i0 78.958 42.776798825257 499 101 73 4 131 627 16177 16673 Nitzschia sp. pyKryTriq1 genome assembly, organelle: mitochondrion blastn 29131 337 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. pyKryTriq1
23562272 23562272 PRJNA640143_S_NODE_1259_length_639_cov_5.531561_g1149_i0 PRJNA640143 1259 639 5.531561 35.34667479 Paralia sulcata 216927 SAR_Eukaryotes SAR_Eukaryotes 100 2.24e-16   NTclustered gi|2074156086|gb|MW413901.1| 216927 g1149 i0 75.502 1.79186228482003 249 38 37 14 1 237 21346 21583 Paralia sulcata mitochondrion, complete genome blastn 1145 100 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Paraliales Paraliaceae Paralia Paralia sulcata
24107289 24107289 PRJNA640143_S_NODE_12579_length_244_cov_289.077295_g12369_i0 PRJNA640143 12579 244 289.077295 705.3485998 Phaeodactylum 2849 SAR_Eukaryotes SAR_Eukaryotes 183 7.479999999999997e-42   NTclustered gi|395362|emb|Z24768.1| 2850 g12369 i0 85 7.04508196721311 180 27 74 0 51 230 1966 2145 P.tricornutum fcpA, fcpB, fcpC, and fcpD genes, complete CDS blastn 1719 183 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
24107423 24107423 PRJNA640143_S_NODE_5899_length_342_cov_2.029508_g5689_i0 PRJNA640143 5899 342 2.029508 6.94091736 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 440 5.909999999999997e-119   NTclustered gi|2199203925|ref|NC_061049.1| 3003 g5689 i0 90.058 100.880116959064 342 31 99 2 1 339 115834 116175 Bacillaria paxillifer chloroplast, complete genome blastn 34501 440 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Bacillaria Bacillaria paxillifer

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