RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA564013", 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 · 15 ✖

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJNA564013 · 15 ✖

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
10753225 10753225 PRJNA564013_P_NODE_20429_length_815_cov_11.888594_g18159_i0 PRJNA564013 20429 815 11.888594 96.8920411 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 989 0   NTclustered gi|2620230846|gb|OR797295.1| 2126271 g18159 i0 89.48 95.1128834355828 789 74 96 8 22 806 4135 4918 Naviculales sp. strain SZCZO2114 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 77517 989 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
24775376 24775376 PRJNA564013_P_NODE_218440_length_289_cov_2.258772_g215589_i0 PRJNA564013 218440 289 2.258772 6.52785108 Trieres regia 1335017 SAR_Eukaryotes SAR_Eukaryotes 122 2.0099999999999994e-23   NTclustered gi|2055417059|ref|NC_056371.1| 1335017 g215589 i0 88.889 12.4463667820069 99 11 34 0 2 100 12230 12328 Odontella regia mitochondrion, complete genome blastn 3597 122 1 Eukaryota Sar   Bacillariophyta Mediophyceae Eupodiscales Parodontellaceae Trieres Trieres regia
25358904 25358904 PRJNA564013_P_NODE_295060_length_228_cov_8.083832_g292208_i0 PRJNA564013 295060 228 8.083832 18.43113696 Phaeodactylum 2849 SAR_Eukaryotes SAR_Eukaryotes 139 1.52e-28   NTclustered gi|6979057|gb|AF063803.1|AF063803 2850 g292208 i0 87.5 4.73684210526316 120 15 53 0 101 220 1537 1418 Phaeodactylum tricornutum glyceraldehyde-3-phosphate dehydrogenase precursor (GapC1) gene, complete cds blastn 1080 139 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26762696 26762696 PRJNA564013_P_NODE_248721_length_262_cov_5.935323_g245869_i0 PRJNA564013 248721 262 5.935323 15.55054626 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 108 7.29e-27   NR GKY93450.1 2872254 g245869 i0 95.4 0.744274809160305 65 3 74.4 0 25 219 183 247 GKY93450.1 hypothetical protein MPSEU_000312500 [Mayamaea pseudoterrestris] diamond 195 108 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
27047637 27047637 PRJNA564013_P_NODE_135722_length_365_cov_7.562500_g132874_i0 PRJNA564013 135722 365 7.5625 27.603125 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 73.2 3.42e-12   NR ACA60907.1 2850 g132874 i0 49.4 0.649315068493151 79 40 64.9 0 343 107 696 774 ACA60907.1 gag-pol polyprotein [Phaeodactylum tricornutum] diamond 237 73.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27079221 27079221 PRJNA564013_P_NODE_100722_length_409_cov_2.698276_g97888_i0 PRJNA564013 100722 409 2.698276 11.03594884 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 137 2.29e-36   NR GKY94269.1 2872254 g97888 i0 72.7 0.726161369193154 99 25 71.1 1 119 409 20 118 GKY94269.1 hypothetical protein MPSEU_000392700 [Mayamaea pseudoterrestris] diamond 297 137 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
27079252 27079252 PRJNA564013_P_NODE_312362_length_218_cov_1.630573_g309510_i0 PRJNA564013 312362 218 1.630573 3.55464914 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 62 1.62e-9   NR KAG7374027.1 303405 g309510 i0 50.8 1.59633027522936 63 26 83.9 2 215 33 85 144 KAG7374027.1 MEKHLA domain containing protein [Nitzschia inconspicua] diamond 348 62 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27110710 27110710 PRJNA564013_P_NODE_44122_length_588_cov_17.893738_g41390_i0 PRJNA564013 44122 588 17.893738 105.21517944 Nitzschia sp. NIES-3576 2083273 SAR_Eukaryotes SAR_Eukaryotes 77.8 8.29e-14   NR BBC77682.1 2083273 g41390 i0 37.4 1.25510204081633 123 73 60.7 2 41 397 90 212 BBC77682.1 ribosomal protein S3 [Nitzschia sp. NIES-3576] diamond 738 77.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. NIES-3576
28153296 28153296 PRJNA564013_P_NODE_21505_length_797_cov_38.934783_g19192_i0 PRJNA564013 21505 797 38.934783 310.31022051 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 50.8 0.00316   NR CAJ1953015.1 2856 g19192 i0 23.7 1.85570890840652 241 142 85.8 7 705 22 19 230 CAJ1953015.1 unnamed protein product [Cylindrotheca closterium] diamond 1479 50.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
28514206 28514206 PRJNA564013_P_NODE_260447_length_253_cov_2.546875_g257595_i0 PRJNA564013 260447 253 2.546875 6.44359375 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 67.8 6.33e-11   NR KAI2500093.1 210448 g257595 i0 43 6.45059288537549 79 44 92.5 1 9 242 669 747 KAI2500093.1 zinc ion binding protein [Fragilaria crotonensis] diamond 1632 67.8 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28861406 28861406 PRJNA564013_P_NODE_283428_length_236_cov_3.211429_g280576_i0 PRJNA564013 283428 236 3.211429 7.57897244 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 52.8 2.26e-6   NR KAI2494791.1 210448 g280576 i0 39.6 1.23305084745763 53 32 67.4 0 234 76 83 135 KAI2494791.1 MEKHLA domain protein [Fragilaria crotonensis] diamond 291 52.8 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30079128 30079128 PRJNA564013_P_NODE_316112_length_215_cov_16.344156_g313260_i0 PRJNA564013 316112 215 16.344156 35.1399354 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0321   NR CAB9505017.1 568900 g313260 i0 63 0.376744186046512 27 10 37.7 0 8 88 18 44 CAB9505017.1 ankyrin repeat protein [Seminavis robusta] diamond 81 42.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31515418 31515418 PRJNA564013_P_NODE_294536_length_229_cov_1.714286_g291684_i0 PRJNA564013 294536 229 1.714286 3.92571494 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 97.1 2.44e-21   NR CAJ1969144.1 2856 g291684 i0 55.3 9.22270742358079 76 34 99.6 0 228 1 815 890 CAJ1969144.1 unnamed protein product [Cylindrotheca closterium] diamond 2112 97.8 0.992842535787321 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31564882 31564882 PRJNA564013_P_NODE_322056_length_212_cov_3.483444_g319204_i0 PRJNA564013 322056 212 3.483444 7.38490128 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 96.7 7.73e-22   NR GKY96926.1 2872254 g319204 i0 97.7 0.622641509433962 44 1 62.3 0 2 133 311 354 GKY96926.1 hypothetical protein MPSEU_000651500 [Mayamaea pseudoterrestris] diamond 132 96.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
31768118 31768118 PRJNA564013_P_NODE_74757_length_468_cov_1.427518_g71938_i0 PRJNA564013 74757 468 1.427518 6.68078424 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 74.3 3.77e-12   NR VEU43687.1 183589 g71938 i0 38.3 2.48076923076923 94 53 60.3 2 322 41 303 391 VEU43687.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 1161 74.7 0.994645247657296 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata

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