RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJEB58983", 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

  • PRJEB58983 · 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
2674788 2674788 PRJEB58983_P_NODE_15763_length_322_cov_2.983936_g15348_i0 PRJEB58983 15763 322 2.983936 9.60827392 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 584 2.41e-162   NTclustered gi|1803023461|gb|MN937452.1| 2850 g15348 i0 99.379 197.931677018634 322 2 100 0 1 322 68178 67857 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 63734 584 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
2674957 2674957 PRJEB58983_P_NODE_23883_length_270_cov_1.969543_g23468_i0 PRJEB58983 23883 270 1.969543 5.3177661 Coscinodiscus wailesii 671091 SAR_Eukaryotes SAR_Eukaryotes 189 1.8099999999999993e-43   NTclustered gi|2088246177|ref|NC_057078.1| 671091 g23468 i0 82.222 78.1148148148148 225 35 82 5 1 222 27867 27645 Coscinodiscus wailesii mitochondrion, complete genome blastn 21091 189 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus wailesii
4820119 4820119 PRJEB58983_P_NODE_35184_length_211_cov_5.355072_g34769_i0 PRJEB58983 35184 211 5.355072 11.29920192 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 379 7.489999999999999e-101   NTclustered gi|98978944|gb|DQ512463.1| 29208 g34769 i0 99.052 100.009478672986 211 2 100 0 1 211 84 294 Stephanodiscus niagarae strain J95-16 large subunit ribosomal RNA gene, partial sequence blastn 21102 379 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus niagarae
5227571 5227571 PRJEB58983_P_NODE_28845_length_250_cov_1.960452_g28430_i0 PRJEB58983 28845 250 1.960452 4.90113 Navicula avium 2018708 SAR_Eukaryotes SAR_Eukaryotes 451 1.91e-122   NTclustered gi|2301268781|ref|NC_066074.1| 2018708 g28430 i0 99.2 197.388 250 2 100 0 1 250 69056 69305 Haslea avium isolate Jiaozhou Bay in China chloroplast, complete genome blastn 49347 451 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula avium
6502998 6502998 PRJEB58983_P_NODE_17706_length_306_cov_1.570815_g17291_i0 PRJEB58983 17706 306 1.570815 4.8066939 Navicula ramosissima 265559 SAR_Eukaryotes SAR_Eukaryotes 418 2.44e-112   NTclustered gi|1102548834|ref|NC_031848.1| 265559 g17291 i0 91.586 99.0359477124183 309 17 100 6 1 306 22623 22925 Navicula ramosissima voucher 10.TA439.Nram.mt mitochondrion, complete genome blastn 30305 418 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula ramosissima
7369558 7369558 PRJEB58983_P_NODE_16066_length_319_cov_3.772358_g15651_i0 PRJEB58983 16066 319 3.772358 12.03382202 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 412 1.1899999999999997e-110   NTclustered gi|2202538977|gb|OM891883.1| 1960768 g15651 i0 90.221 99.6332288401254 317 29 99 2 2 317 3951 4266 Pleurosigma sp. small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 31783 412 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pleurosigmataceae Pleurosigma Pleurosigma sp.
7777333 7777333 PRJEB58983_P_NODE_22647_length_276_cov_1.536946_g22232_i0 PRJEB58983 22647 276 1.536946 4.24197096 Navicula ramosissima 265559 SAR_Eukaryotes SAR_Eukaryotes 411 3.629999999999999e-110   NTclustered gi|1102548834|ref|NC_031848.1| 265559 g22232 i0 93.478 37.25 276 18 100 0 1 276 22360 22635 Navicula ramosissima voucher 10.TA439.Nram.mt mitochondrion, complete genome blastn 10281 411 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula ramosissima
9052416 9052416 PRJEB58983_P_NODE_6188_length_494_cov_6.788599_g5774_i0 PRJEB58983 6188 494 6.788599 33.53567906 Navicula tripunctata 431568 SAR_Eukaryotes SAR_Eukaryotes 896 0   NTclustered gi|168145932|emb|AM710584.1| 431568 g5774 i0 99.393 100.03036437247 494 3 100 0 1 494 39 532 Navicula tripunctata partial 28S rRNA gene, strain AT-202.01 blastn 49415 896 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula tripunctata
9920330 9920330 PRJEB58983_P_NODE_24468_length_267_cov_3.041237_g24053_i0 PRJEB58983 24468 267 3.041237 8.12010279 Gomphonemataceae 97225 SAR_Eukaryotes SAR_Eukaryotes 152 2.34e-32   NTclustered gi|2444483253|gb|OP718170.1| 97227 g24053 i0 89.831 22.2584269662921 118 12 44 0 13 130 4467 4584 Gomphonema parvulum mitochondrion, complete genome blastn 5943 152 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
10327672 10327672 PRJEB58983_P_NODE_11329_length_374_cov_1.485050_g10914_i0 PRJEB58983 11329 374 1.48505 5.554087 Navicula lanceolata 265549 SAR_Eukaryotes SAR_Eukaryotes 686 0   NTclustered gi|217331187|gb|FJ002148.1| 265549 g10914 i0 99.733 99.1791443850267 374 1 100 0 1 374 978 605 Navicula lanceolata isolate C86 ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit gene, partial cds; chloroplast blastn 37093 686 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula lanceolata
14153138 14153138 PRJEB58983_P_NODE_16012_length_320_cov_1.850202_g15597_i0 PRJEB58983 16012 320 1.850202 5.9206464 Navicula lanceolata 265549 SAR_Eukaryotes SAR_Eukaryotes 592 1.4299999999999996e-164   NTclustered gi|2395622456|emb|OX384916.1| 265549 g15597 i0 100 100.9375 320 0 100 0 1 320 107 426 Navicula lanceolata psbA_gene__partial_sequence, isolate Brb14_Nav2_T2_a blastn 32300 592 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula lanceolata
14153491 14153491 PRJEB58983_P_NODE_33292_length_236_cov_3.785276_g32877_i0 PRJEB58983 33292 236 3.785276 8.93325136 Thalassiosira bioculata 1048533 SAR_Eukaryotes SAR_Eukaryotes 414 2.34e-111   NTclustered gi|2862228846|gb|PQ645480.1| 1048533 g32877 i0 98.305 100.03813559322 236 4 100 0 1 236 3555 3790 Thalassiosira bioculata isolate AGSB0307 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 23609 414 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira bioculata
15427510 15427510 PRJEB58983_P_NODE_34253_length_230_cov_2.229299_g33838_i0 PRJEB58983 34253 230 2.229299 5.1273877 Navicula veneta 138539 SAR_Eukaryotes SAR_Eukaryotes 241 4.08e-59   NTclustered gi|2088232805|ref|NC_056793.1| 138539 g33838 i0 88.119 85.4086956521739 202 24 88 0 3 204 1023 822 Navicula veneta isolate SZCZR1826 mitochondrion, complete genome blastn 19644 241 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula veneta
15427598 15427598 PRJEB58983_P_NODE_7293_length_458_cov_2.724675_g6879_i0 PRJEB58983 7293 458 2.724675 12.4790115 Fistulifera saprophila 880757 SAR_Eukaryotes SAR_Eukaryotes 115 5.59e-21   NTclustered gi|2088232451|ref|NC_056789.1| 880757 g6879 i0 85.714 18.8384279475983 112 12 24 4 340 450 7369 7261 Fistulifera saprophila isolate SZCZR1829 mitochondrion, complete genome blastn 8628 115 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera saprophila
16701581 16701581 PRJEB58983_P_NODE_23014_length_274_cov_2.238806_g22599_i0 PRJEB58983 23014 274 2.238806 6.13432844 Pseudictyota sp. 2850690 SAR_Eukaryotes SAR_Eukaryotes 339 1.73e-88   NTclustered gi|2059554263|gb|MZ469804.1| 2850690 g22599 i0 89.247 107.919708029197 279 19 100 8 1 274 377 105 Pseudictyota sp. strain DAD-ALGEUK-76 large subunit ribosomal RNA gene, partial sequence; chloroplast blastn 29570 339 1 Eukaryota Sar   Bacillariophyta Mediophyceae Eupodiscales Odontellaceae Pseudictyota Pseudictyota sp.
20526172 20526172 PRJEB58983_P_NODE_8097_length_435_cov_3.102210_g7683_i0 PRJEB58983 8097 435 3.10221 13.4946135 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 267 1.38e-66   NTclustered gi|657012562|gb|KF302618.1| 2850 g7683 i0 80.682 87.2413793103448 352 60 80 7 11 357 411 759 Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds blastn 37950 267 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
23944513 23944513 PRJEB58983_P_NODE_7719_length_445_cov_4.016129_g7305_i0 PRJEB58983 7719 445 4.016129 17.87177405 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 811 0   NTclustered gi|2728413771|gb|OR666656.1| 386076 g7305 i0 99.551 198.487640449438 445 2 100 0 1 445 69132 69576 Discostella stelligera strain SXU-YN191 chloroplast, complete genome blastn 88327 817 0.99265605875153 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella stelligera
24350648 24350648 PRJEB58983_P_NODE_20060_length_289_cov_4.796296_g19645_i0 PRJEB58983 20060 289 4.796296 13.86129544 Amicula sp. isolate GU52X-4 cfCalB7 3003489 SAR_Eukaryotes SAR_Eukaryotes 135 2.5800000000000004e-27   NTclustered gi|2396590850|gb|ON390794.1| 3003489 g19645 i0 77.311 10.4671280276817 238 49 82 5 54 289 111607 111373 Amicula sp. isolate GU52X-4 cfCalB7 voucher Theriot Lab HK478 mitochondrion, complete genome blastn 3025 135 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Amicula Amicula sp. isolate GU52X-4 cfCalB7
25218212 25218212 PRJEB58983_P_NODE_28420_length_251_cov_2.550562_g28005_i0 PRJEB58983 28420 251 2.550562 6.40191062 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 448 2.48e-121   NTclustered gi|2444483125|gb|OP718169.1| 97227 g28005 i0 98.81 198.358565737052 252 2 100 1 1 251 72513 72764 Gomphonema parvulum chloroplast, complete genome blastn 49788 448 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
27026755 27026755 PRJEB58983_P_NODE_24942_length_265_cov_2.255208_g24527_i0 PRJEB58983 24942 265 2.255208 5.9763012 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 152 3.6e-45   NR KAG7353658.1 303405 g24527 i0 82.1 7.65283018867925 84 15 95.1 0 1 252 82 165 KAG7353658.1 ubiquitin-conjugating enzyme [Nitzschia inconspicua] diamond 2028 153 0.993464052287582 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28574259 28574259 PRJEB58983_P_NODE_26387_length_259_cov_1.392473_g25972_i0 PRJEB58983 26387 259 1.392473 3.60650507 Cylindrotheca 2852 SAR_Eukaryotes SAR_Eukaryotes 105 2.59e-24   NR CAJ1950724.1 2856 g25972 i0 59.7 2.71042471042471 77 31 89.2 0 18 248 549 625 CAJ1950724.1 unnamed protein product [Cylindrotheca closterium] diamond 702 106 0.990566037735849 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31297478 31297478 PRJEB58983_P_NODE_26875_length_257_cov_1.211957_g26460_i0 PRJEB58983 26875 257 1.211957 3.11472949 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 100 1.46e-25   NR AID23594.1 2850 g26460 i0 93.6 0.54863813229572 47 3 54.9 0 257 117 53 99 AID23594.1 ubiquitin-ribosomal protein fusion S27a, partial [Phaeodactylum tricornutum] diamond 141 100 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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