RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA672101", tax_clade = "Sar" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Eukaryota · 20 ✖

tax_clade 1

  • Sar · 20 ✖

bioproject 1

  • PRJNA672101 · 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
641758 641758 PRJNA672101_S_NODE_15601_length_308_cov_3.668085_g15570_i0 PRJNA672101 15601 308 3.668085 11.2977018 Polarella glacialis 89957 SAR_Eukaryotes SAR_Eukaryotes 77.4 5.3e-14   NR CAE8601232.1 89957 g15570 i0 60.4 0.516233766233766 53 21 51.6 0 211 53 615 667 CAE8601232.1 unnamed protein product [Polarella glacialis] diamond 159 77.4 1 Eukaryota Sar     Dinophyceae Suessiales Suessiaceae Polarella Polarella glacialis
1917985 1917985 PRJNA672101_S_NODE_16742_length_301_cov_4.407895_g16711_i0 PRJNA672101 16742 301 4.407895 13.26776395 Phytophthora cactorum 29920 SAR_Eukaryotes SAR_Eukaryotes 69.4 2.78e-7   NTclustered gi|2308292329|gb|OK574294.1| 29920 g16711 i0 83.117 1.49833887043189 77 11 25 2 61 135 24581 24505 Phytophthora cactorum voucher CH98LOQ1 mitochondrion, complete genome blastn 451 69.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cactorum
5745285 5745285 PRJNA672101_S_NODE_16245_length_304_cov_3.463203_g16214_i0 PRJNA672101 16245 304 3.463203 10.52813712 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 145 4.54e-30   NTclustered gi|2074156200|gb|MW413905.1| 216802 g16214 i0 79.439 43.4703947368421 214 36 69 6 77 285 24392 24602 Guinardia delicatula mitochondrion, complete genome blastn 13215 145 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
6269376 6269376 PRJNA672101_S_NODE_205_length_875_cov_6.735661_g188_i0 PRJNA672101 205 875 6.735661 58.93703375 Pseudo-nitzschia 41953 SAR_Eukaryotes SAR_Eukaryotes 86.1 8.7e-12   NTclustered gi|2852238308|gb|PQ498360.1| 189737 g188 i0 97.959 4.06514285714286 49 1 6 0 415 463 33790 33838 Pseudo-nitzschia galaxiae isolate CNS01103 mitochondrion, complete genome blastn 3557 86.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia galaxiae
18494194 18494194 PRJNA672101_S_NODE_14875_length_313_cov_1.604167_g14844_i0 PRJNA672101 14875 313 1.604167 5.02104271 Blastocystis sp. NMH 3128537 SAR_Eukaryotes SAR_Eukaryotes 91.3 4.05e-19   NR KAK8801005.1 3128537 g14844 i0 80 1.13099041533546 55 11 52.7 0 307 143 193 247 KAK8801005.1 hypothetical protein WA588_001833 [Blastocystis sp. NMH] diamond 354 91.3 1 Eukaryota Sar     Bigyra Opalinata Blastocystidae Blastocystis Blastocystis sp. NMH
19768931 19768931 PRJNA672101_S_NODE_34656_length_227_cov_2.915584_g34625_i0 PRJNA672101 34656 227 2.915584 6.61837568 Stramenopiles sp. MAST-7B-sp1 2805729 SAR_Eukaryotes SAR_Eukaryotes 76.8 1.2e-9   NTclustered gi|1960721541|gb|MW521835.1| 2805729 g34625 i0 94 17.0132158590308 50 3 22 0 178 227 5595 5546 Stramenopiles sp. MAST-7B-sp1 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 3862 76.8 1 Eukaryota Sar             Stramenopiles sp. MAST-7B-sp1
27934631 27934631 PRJNA672101_S_NODE_16565_length_302_cov_4.371179_g16534_i0 PRJNA672101 16565 302 4.371179 13.20096058 Amoebophrya sp. A12 88552 SAR_Eukaryotes SAR_Eukaryotes 50.8 1.11e-4   NR CAD7950604.1 2202890 g16534 i0 42.6 2.02649006622517 108 53 98.3 2 297 1 802 909 CAD7950604.1 unnamed protein product [Amoebophrya sp. A120] diamond 612 50.8 1 Eukaryota Sar     Dinophyceae Syndiniales Amoebophryaceae Amoebophrya Amoebophrya sp. A120
28092417 28092417 PRJNA672101_S_NODE_3205_length_450_cov_7.058355_g3174_i0 PRJNA672101 3205 450 7.058355 31.7625975 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 70.1 7.43e-11   NR KAL4429461.1 5901 g3174 i0 43.4 2.14 83 40 50.7 2 235 8 277 359 KAL4429461.1 hypothetical protein ABPG74_001306 [Tetrahymena malaccensis] diamond 963 70.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
29323738 29323738 PRJNA672101_S_NODE_7429_length_373_cov_5.830000_g7398_i0 PRJNA672101 7429 373 5.83 21.7459 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.0174   NR KAK1739094.1 267567 g7398 i0 30.8 0.522788203753351 65 44 52.3 1 261 67 525 588 KAK1739094.1 hypothetical protein QTG54_010410 [Skeletonema marinoi] diamond 195 45.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
29398845 29398845 PRJNA672101_S_NODE_5949_length_392_cov_2.896552_g5918_i0 PRJNA672101 5949 392 2.896552 11.35448384 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 48.9 0.00126   NR XP_004037229.1 5932 g5918 i0 67.6 0.818877551020408 37 12 28.3 0 297 187 419 455 XP_004037229.1 hypothetical protein IMG5_057980 [Ichthyophthirius multifiliis] diamond 321 49.3 0.991886409736308 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
29449877 29449877 PRJNA672101_S_NODE_6670_length_382_cov_5.482201_g6639_i0 PRJNA672101 6670 382 5.482201 20.94200782 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 56.6 1.94e-6   NR GKY93150.1 2872254 g6639 i0 52 0.392670157068063 50 21 36.9 2 207 67 224 273 GKY93150.1 hypothetical protein MPSEU_000283000 [Mayamaea pseudoterrestris] diamond 150 56.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29734004 29734004 PRJNA672101_S_NODE_26470_length_258_cov_3.324324_g26439_i0 PRJNA672101 26470 258 3.324324 8.57675592 Polarella glacialis 89957 SAR_Eukaryotes SAR_Eukaryotes 90.9 5.07e-19   NR CAE8601232.1 89957 g26439 i0 50 0.883720930232558 76 38 88.4 0 27 254 588 663 CAE8601232.1 unnamed protein product [Polarella glacialis] diamond 228 90.9 1 Eukaryota Sar     Dinophyceae Suessiales Suessiaceae Polarella Polarella glacialis
29860576 29860576 PRJNA672101_S_NODE_18551_length_292_cov_2.109589_g18520_i0 PRJNA672101 18551 292 2.109589 6.15999988 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00742   NR ETO08579.1 46433 g18520 i0 32.8 0.626712328767123 61 37 58.6 1 265 95 294 354 ETO08579.1 hypothetical protein RFI_28808 [Reticulomyxa filosa] diamond 183 45.4 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
30271592 30271592 PRJNA672101_S_NODE_25512_length_262_cov_2.037037_g25481_i0 PRJNA672101 25512 262 2.037037 5.33703694 Amoebophrya sp. A25 1410381 SAR_Eukaryotes SAR_Eukaryotes 58.2 1.69e-7   NR CAD7956188.1 1410381 g25481 i0 40.2 8.90839694656488 82 43 93.9 1 251 6 148 223 CAD7956188.1 unnamed protein product [Amoebophrya sp. A25] diamond 2334 58.2 1 Eukaryota Sar     Dinophyceae Syndiniales Amoebophryaceae Amoebophrya Amoebophrya sp. A25
30524048 30524048 PRJNA672101_S_NODE_25733_length_261_cov_2.047872_g25702_i0 PRJNA672101 25733 261 2.047872 5.34494592 Pelagophyceae sp. CCMP2 1982007 SAR_Eukaryotes SAR_Eukaryotes 90.9 1.53e-20   NR KAJ1461734.1 483370 g25702 i0 56.6 7.63218390804598 83 36 95.4 0 2 250 11 93 KAJ1461734.1 P-loop containing nucleoside triphosphate hydrolase protein [Pelagophyceae sp. CCMP2097] diamond 1992 90.9 1 Eukaryota Sar     Pelagophyceae       Pelagophyceae sp. CCMP2097
31041881 31041881 PRJNA672101_S_NODE_5515_length_399_cov_2.880368_g5484_i0 PRJNA672101 5515 399 2.880368 11.49266832 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 93.6 1.1e-20   NR KRX10339.1 266149 g5484 i0 43.6 37.390977443609 101 50 72.2 2 105 392 10 108 KRX10339.1 P-loop containing nucleoside triphosphate hydrolase [Pseudocohnilembus persalinus] diamond 14919 94.4 0.991525423728813 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
31535706 31535706 PRJNA672101_S_NODE_16556_length_302_cov_5.689956_g16525_i0 PRJNA672101 16556 302 5.689956 17.18366712 Nannochloropsis gaditana 72520 SAR_Eukaryotes SAR_Eukaryotes 61.2 2.46e-8   NR EWM29398.1 72520 g16525 i0 40.3 0.764900662251656 77 42 72.5 1 58 276 1469 1545 EWM29398.1 cad protein [Nannochloropsis gaditana] diamond 231 61.2 1 Eukaryota Sar     Eustigmatophyceae Eustigmatales Monodopsidaceae Nannochloropsis Nannochloropsis gaditana
31567332 31567332 PRJNA672101_S_NODE_22476_length_274_cov_2.512438_g22445_i0 PRJNA672101 22476 274 2.512438 6.88408012 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 62.8 4.92e-9   NR KAL3791744.1 29204 g22445 i0 35.2 0.996350364963504 91 58 98.5 1 1 270 767 857 KAL3791744.1 hypothetical protein HJC23_007511 [Cyclotella cryptica] diamond 273 62.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32326782 32326782 PRJNA672101_S_NODE_21299_length_279_cov_4.407767_g21268_i0 PRJNA672101 21299 279 4.407767 12.29766993 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 82 8.92e-16   NR KRX00755.1 266149 g21268 i0 58.9 4.76344086021505 56 23 60.2 0 1 168 494 549 KRX00755.1 Ubiquitin-conjugating enzyme/RWD-like protein [Pseudocohnilembus persalinus] diamond 1329 82 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
32673740 32673740 PRJNA672101_S_NODE_35020_length_217_cov_6.465278_g34989_i0 PRJNA672101 35020 217 6.465278 14.02965326 Tribonema minus 303371 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00164   NR KAG5183659.1 303371 g34989 i0 40.8 1.99078341013825 71 32 96.8 2 4 213 139 200 KAG5183659.1 ribosomal protein L18 [Tribonema minus] diamond 432 45.8 1 Eukaryota Sar     Xanthophyceae Tribonematales Tribonemataceae Tribonema Tribonema minus

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