RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA846486", 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

  • PRJNA846486 · 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
4661702 4661702 PRJNA846486_P_NODE_49544_length_199_cov_1.020000_g49448_i0 PRJNA846486 49544 199 1.02 2.0298 Thalassiophysa hyalina 1953178 SAR_Eukaryotes SAR_Eukaryotes 58.4 3.71e-4   NTclustered gi|1143637949|gb|KX120343.1| 1953178 g49448 i0 100 0.155778894472362 31 0 16 0 164 194 199 229 Thalassiophysa hyalina isolate 4vi08.1cT 28S ribosomal RNA gene, partial sequence blastn 31 58.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Thalassiophysales Thalassiophysaceae Thalassiophysa Thalassiophysa hyalina
8486074 8486074 PRJNA846486_P_NODE_46127_length_204_cov_1.264516_g46031_i0 PRJNA846486 46127 204 1.264516 2.57961264 Leptocylindrus aporus 1398097 SAR_Eukaryotes SAR_Eukaryotes 86.1 1.75e-12   NTclustered gi|541134824|gb|KC814833.1| 1398097 g46031 i0 90.769 1.61274509803922 65 5 32 1 128 192 200 263 Leptocylindrus aporus strain SZN-B651 28S ribosomal RNA gene, partial sequence blastn 329 86.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Leptocylindrales Leptocylindraceae Leptocylindrus Leptocylindrus aporus
10159969 10159969 PRJNA846486_P_NODE_75368_length_169_cov_2.375000_g75272_i0 PRJNA846486 75368 169 2.375 4.01375 Entomoneis 186042 SAR_Eukaryotes SAR_Eukaryotes 226 7.859999999999997e-55   NTclustered gi|2202538958|gb|OM891864.1| 216750 g75272 i0 91.515 82.8402366863905 165 13 98 1 1 165 4062 4225 Entomoneis cf. alata 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 14000 228 0.991228070175439 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis cf. alata
12312367 12312367 PRJNA846486_P_NODE_17610_length_301_cov_9.404762_g17514_i0 PRJNA846486 17610 301 9.404762 28.30833362 Encyonema minutum 431330 SAR_Eukaryotes SAR_Eukaryotes 505 1.79e-138   NTclustered gi|168145881|emb|AM710515.1| 431330 g17514 i0 100 91.4551495016611 273 0 91 0 29 301 304 32 Encyonema minutum partial 28S rRNA gene, strain AT-137.13 blastn 27528 505 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Encyonema Encyonema minutum
21235315 21235315 PRJNA846486_P_NODE_35817_length_225_cov_1.375000_g35721_i0 PRJNA846486 35817 225 1.375 3.09375 Nitzschia sp. DOCU1 3041873 SAR_Eukaryotes SAR_Eukaryotes 350 6.34e-92   NTclustered gi|2504366779|emb|OX596002.1| 3041873 g35721 i0 97.561 96.8222222222222 205 3 91 2 1 204 28591 28794 Nitzschia sp. DOCU1 genome assembly, organelle: mitochondrion blastn 21785 350 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. DOCU1
21235341 21235341 PRJNA846486_P_NODE_45297_length_205_cov_2.282051_g45201_i0 PRJNA846486 45297 205 2.282051 4.67820455 Gomphonema parvulum 97227 SAR_Eukaryotes SAR_Eukaryotes 313 7.4399999999999995e-81   NTclustered gi|2444483253|gb|OP718170.1| 97227 g45201 i0 94.175 106.331707317073 206 11 100 1 1 205 4730 4525 Gomphonema parvulum mitochondrion, complete genome blastn 21798 313 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
25059449 25059449 PRJNA846486_P_NODE_40960_length_213_cov_2.786585_g40864_i0 PRJNA846486 40960 213 2.786585 5.93542605 Didymosphenia geminata 1115533 SAR_Eukaryotes SAR_Eukaryotes 268 1.7099999999999994e-67   NTclustered gi|1125788738|ref|NC_032171.1| 1115533 g40864 i0 91.795 46.6807511737089 195 12 91 4 1 193 32533 32341 Didymosphenia geminata mitochondrion, complete genome blastn 9943 268 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Didymosphenia Didymosphenia geminata
25059526 25059526 PRJNA846486_P_NODE_82320_length_166_cov_3.316239_g82224_i0 PRJNA846486 82320 166 3.316239 5.50495674 Attheya longicornis 451786 SAR_Eukaryotes SAR_Eukaryotes 102 1.36e-17   NTclustered gi|2046217437|gb|MW729336.1| 451786 g82224 i0 88.235 0.512048192771084 85 10 51 0 2 86 38991 39075 Attheya longicornis mitochondrion, complete genome blastn 85 102 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Attheyaceae Attheya Attheya longicornis
28475982 28475982 PRJNA846486_P_NODE_70206_length_174_cov_1.464000_g70110_i0 PRJNA846486 70206 174 1.464 2.54736 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 95.1 5.16e-21   NR CAB9504775.1 568900 g70110 i0 80.7 0.982758620689655 57 11 98.3 0 2 172 1289 1345 CAB9504775.1 Nitric oxide synthase [Seminavis robusta] diamond 171 95.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28539335 28539335 PRJNA846486_P_NODE_92367_length_162_cov_1.699115_g92271_i0 PRJNA846486 92367 162 1.699115 2.7525663 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 77 7.44e-15   NR GAX25881.1 1519565 g92271 i0 71.1 0.833333333333333 45 13 83.3 0 162 28 315 359 GAX25881.1 hypothetical protein FisN_6Hh081 [Fistulifera solaris] diamond 135 77 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28634060 28634060 PRJNA846486_P_NODE_59187_length_186_cov_1.138686_g59091_i0 PRJNA846486 59187 186 1.138686 2.11795596 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 72 1.75e-13   NR GKY94857.1 2872254 g59091 i0 59.1 1.06451612903226 66 23 100 1 1 186 130 195 GKY94857.1 fucoxanthin chlorophyll a c protein [Mayamaea pseudoterrestris] diamond 198 72 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28949783 28949783 PRJNA846486_P_NODE_78848_length_168_cov_0.873950_g78752_i0 PRJNA846486 78848 168 0.87395 1.468236 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 107 3.76e-27   NR KAI2494987.1 210448 g78752 i0 92.9 1 56 4 100 0 168 1 175 230 KAI2494987.1 Uracil phosphoribosyltransferase [Fragilaria crotonensis] diamond 168 107 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29770339 29770339 PRJNA846486_P_NODE_81111_length_167_cov_0.881356_g81015_i0 PRJNA846486 81111 167 0.881356 1.47186452 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 83.6 5.38e-17   NR XP_002178974.1 556484 g81015 i0 67.3 0.988023952095808 55 18 98.8 0 167 3 534 588 XP_002178974.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 165 83.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
31698280 31698280 PRJNA846486_P_NODE_88757_length_164_cov_0.904348_g88661_i0 PRJNA846486 88757 164 0.904348 1.48313072 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 61.2 3.48e-9   NR GFH48247.1 426638 g88661 i0 55.3 1.8109756097561 47 21 86 0 2 142 219 265 GFH48247.1 hypothetical protein CTEN210_04723 [Chaetoceros tenuissimus] diamond 297 61.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
32362903 32362903 PRJNA846486_P_NODE_20099_length_285_cov_2.211864_g20003_i0 PRJNA846486 20099 285 2.211864 6.3038124 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 67.8 9.72e-11   NR GKZ00473.1 2872254 g20003 i0 60.4 0.557894736842105 53 21 55.8 0 29 187 1163 1215 GKZ00473.1 hypothetical protein MPSEU_000999800 [Mayamaea pseudoterrestris] diamond 159 67.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris

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