RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA814235" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 10 ✖

tax_clade 1

bioproject 1

  • PRJNA814235 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
2502260 2502260 PRJNA814235_P_NODE_24322_length_387_cov_5.380000_g22954_i0 PRJNA814235 24322 387 5.38 20.8206 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 669 0   NTclustered gi|1891520246|gb|MN696750.1| 303402 g22954 i0 98.177 96.5297157622739 384 5 99 2 1 383 26 408 Nitzschia dissipata culture TCC:632 large subunit ribosomal RNA gene, partial sequence blastn 37357 669 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia dissipata
3369684 3369684 PRJNA814235_P_NODE_92003_length_203_cov_3.072289_g90608_i0 PRJNA814235 92003 203 3.072289 6.23674667 Discostella guiyangensis 3145224 SAR_Eukaryotes SAR_Eukaryotes 97.1 8.06e-16   NTclustered gi|2728413627|gb|OR666655.1| 3145224 g90608 i0 89.474 28.320197044335 76 8 37 0 128 203 51859 51784 Discostella guiyangensis strain GY168 chloroplast, complete genome blastn 5749 97.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella guiyangensis
3778783 3778783 PRJNA814235_P_NODE_37183_length_313_cov_7.336957_g35793_i0 PRJNA814235 37183 313 7.336957 22.96467541 Fragilariophyceae 33853 SAR_Eukaryotes SAR_Eukaryotes 564 3.039999999999999e-156   NTclustered gi|417075293|gb|JX645086.1| 137771 g35793 i0 99.357 99.297124600639 311 2 99 0 3 313 329 19 Uncultured diatom clone Es109 18S ribosomal RNA gene, partial sequence blastn 31080 569 0.991212653778559 Eukaryota Sar   Bacillariophyta         uncultured diatom
7193348 7193348 PRJNA814235_P_NODE_10386_length_586_cov_4.391621_g9228_i0 PRJNA814235 10386 586 4.391621 25.73489906 Asterionella formosa 210441 SAR_Eukaryotes SAR_Eukaryotes 833 0   NTclustered gi|2497507841|gb|OQ694381.1| 210441 g9228 i0 98.721 168.453924914676 469 6 93 0 118 586 68452 68920 Asterionella formosa chloroplast, complete genome blastn 98714 833 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionella Asterionella formosa
11021709 11021709 PRJNA814235_P_NODE_52069_length_264_cov_2.546256_g50675_i0 PRJNA814235 52069 264 2.546256 6.72211584 Bacillaria paxillifer 3003 SAR_Eukaryotes SAR_Eukaryotes 368 2.11e-97   NTclustered gi|2202538966|gb|OM891872.1| 3003 g50675 i0 91.76 73.9280303030303 267 19 100 2 1 264 5855 5589 Bacillaria paxillifer 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 19517 368 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Bacillaria Bacillaria paxillifer
12706491 12706491 PRJNA814235_P_NODE_39330_length_304_cov_14.123596_g37939_i0 PRJNA814235 39330 304 14.123596 42.93573184 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 392 1.4699999999999995e-104   NTclustered gi|1826601749|gb|MT259197.1| 517777 g37939 i0 90.132 100.075657894737 304 26 100 4 1 304 1284 1583 Psammoneis senegalensis voucher AQ7 small subunit ribosomal RNA gene, partial sequence blastn 30423 394 0.99492385786802 Eukaryota Sar   Bacillariophyta Mediophyceae Triceratiales Plagiogrammaceae Psammoneis Psammoneis senegalensis
13980986 13980986 PRJNA814235_P_NODE_48671_length_273_cov_3.614407_g47277_i0 PRJNA814235 48671 273 3.614407 9.86733111 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 472 1.62e-128   NTclustered gi|146762526|gb|EF553458.1| 2850 g47277 i0 97.802 98.7619047619048 273 6 100 0 1 273 3852 3580 Phaeodactylum tricornutum strain CCAP 1055/1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 26962 472 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
16120819 16120819 PRJNA814235_P_NODE_64393_length_237_cov_2.740000_g62998_i0 PRJNA814235 64393 237 2.74 6.4938 Nitzschia reversa 2675857 SAR_Eukaryotes SAR_Eukaryotes 294 3.2e-75   NTclustered gi|2862228864|gb|PQ645498.1| 2675857 g62998 i0 88.889 101.666666666667 243 21 100 4 1 237 3678 3920 Nitzschia reversa isolate AGSB0348 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 24095 294 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
21628612 21628612 PRJNA814235_P_NODE_195657_length_151_cov_1.298246_g194262_i0 PRJNA814235 195657 151 1.298246 1.96035146 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 65.8 1.58e-6   NTclustered gi|1169296928|gb|KY364698.1| 2843 g194262 i0 100 23.3841059602649 35 0 23 0 96 130 4033 4067 Skeletonema costatum 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 3531 65.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema costatum
22492900 22492900 PRJNA814235_P_NODE_150378_length_174_cov_2.270073_g148983_i0 PRJNA814235 150378 174 2.270073 3.94992702 Bacillaria paxillifer 3003 SAR_Eukaryotes SAR_Eukaryotes 292 7.92e-75   NTclustered gi|2202538966|gb|OM891872.1| 3003 g148983 i0 97.126 57.0057471264368 174 4 100 1 1 174 5855 5683 Bacillaria paxillifer 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 9919 292 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);;