RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA674050" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

  • Sar · 28 ✖

bioproject 1

  • PRJNA674050 · 28 ✖

analysis 1

  • diamond · 28 ✖

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
4471406 4471406 PRJNA674050_P_NODE_16924_length_269_cov_1.112245_g16721_i0 PRJNA674050 16924 269 1.112245 2.99193905 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 151 4.69e-45   NR KAJ1401815.1 483371 g16721 i0 88.9 2.00743494423792 90 9 99.3 1 269 3 47 136 KAJ1401815.1 ubiquitin-related domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 540 151 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
5748031 5748031 PRJNA674050_P_NODE_9945_length_301_cov_1.166667_g9742_i0 PRJNA674050 9945 301 1.166667 3.51166767 Nannochloropsis salina CCMP1776 1027361 SAR_Eukaryotes SAR_Eukaryotes 181 3.06e-53   NR TFJ84496.1 1027361 g9742 i0 92 2.62126245847176 88 7 87.7 0 36 299 263 350 TFJ84496.1 hypothetical protein NSK_004481 [Nannochloropsis salina CCMP1776] diamond 789 181 1 Eukaryota Sar     Eustigmatophyceae Eustigmatales Monodopsidaceae Microchloropsis Microchloropsis salina
17222424 17222424 PRJNA674050_P_NODE_41054_length_232_cov_2.289308_g40851_i0 PRJNA674050 41054 232 2.289308 5.31119456 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 98.6 4.3499999999999997e-23   NR KAJ1409391.1 483371 g40851 i0 68.8 1.99137931034483 77 24 99.6 0 232 2 82 158 KAJ1409391.1 50S ribosomal protein L30e-like protein [Ochromonadaceae sp. CCMP2298] diamond 462 98.6 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
26733215 26733215 PRJNA674050_P_NODE_28901_length_248_cov_0.885714_g28698_i0 PRJNA674050 28901 248 0.885714 2.19657072 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00333   NR CEP02182.1 37360 g28698 i0 49 0.616935483870968 51 26 61.7 0 3 155 419 469 CEP02182.1 hypothetical protein PBRA_002447 [Plasmodiophora brassicae] diamond 153 45.8 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26923630 26923630 PRJNA674050_P_NODE_35582_length_244_cov_0.912281_g35379_i0 PRJNA674050 35582 244 0.912281 2.22596564 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 62 6.02e-9   NR KAJ1443494.1 483371 g35379 i0 59.6 0.577868852459016 47 19 57.8 0 145 5 60 106 KAJ1443494.1 hypothetical protein B484DRAFT_441518 [Ochromonadaceae sp. CCMP2298] diamond 141 62 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
27018484 27018484 PRJNA674050_P_NODE_19402_length_260_cov_1.871658_g19199_i0 PRJNA674050 19402 260 1.871658 4.8663108 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 162 4.62e-45   NR XP_001031695.1 312017 g19199 i0 83.7 0.992307692307692 86 14 99.2 0 258 1 155 240 XP_001031695.1 hypothetical protein TTHERM_00760790 [Tetrahymena thermophila SB210] diamond 258 162 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27018488 27018488 PRJNA674050_P_NODE_7942_length_316_cov_1.201646_g7739_i0 PRJNA674050 7942 316 1.201646 3.79720136 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 155 1.0099999999999999e-46   NR 2XZN_Z 5911 g7739 i0 80.6 0.882911392405063 93 18 88.3 0 279 1 1 93 2XZN_Z Chain Z, Rps21e [Tetrahymena thermophila] diamond 279 155 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27461114 27461114 PRJNA674050_P_NODE_29483_length_248_cov_0.880000_g29280_i0 PRJNA674050 29483 248 0.88 2.1824 Ectocarpus sp. CCAP 131 74372 SAR_Eukaryotes SAR_Eukaryotes 76.6 4.59e-14   NR CAB1120496.1 867726 g29280 i0 48.8 11.9032258064516 82 41 99.2 1 2 247 421 501 CAB1120496.1 unnamed protein product [Ectocarpus sp. CCAP 1310/34] diamond 2952 76.6 1 Eukaryota Sar     Phaeophyceae Ectocarpales Ectocarpaceae Ectocarpus Ectocarpus sp. CCAP 1310/34
27599380 27599380 PRJNA674050_P_NODE_15884_length_272_cov_1.994975_g15681_i0 PRJNA674050 15884 272 1.994975 5.426332 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 160 2.71e-46   NR CAE7382485.1 2951 g15681 i0 82.2 1.98529411764706 90 16 99.3 0 3 272 195 284 CAE7382485.1 rpl3, partial [Symbiodinium microadriaticum] diamond 540 160 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
28198902 28198902 PRJNA674050_P_NODE_33126_length_245_cov_1.784884_g32923_i0 PRJNA674050 33126 245 1.784884 4.3729658 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 100 3.1999999999999997e-25   NR CAE7554797.1 2951 g32923 i0 69.2 6.06122448979592 78 22 93.1 2 228 1 1 78 CAE7554797.1 RPL31 [Symbiodinium microadriaticum] diamond 1485 100 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
28345020 28345020 PRJNA674050_P_NODE_36086_length_244_cov_0.906433_g35883_i0 PRJNA674050 36086 244 0.906433 2.21169652 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 82.8 2.86e-16   NR KAL4437891.1 5901 g35883 i0 70 1.35245901639344 50 15 61.5 0 242 93 244 293 KAL4437891.1 hypothetical protein ABPG74_001062 [Tetrahymena malaccensis] diamond 330 82.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
28439895 28439895 PRJNA674050_P_NODE_33746_length_245_cov_0.906977_g33543_i0 PRJNA674050 33746 245 0.906977 2.22209365 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 149 9.24e-40   NR XP_001008369.3 312017 g33543 i0 87.7 0.991836734693878 81 10 99.2 0 244 2 473 553 XP_001008369.3 glycosyl hydrolase family 31 protein [Tetrahymena thermophila SB210] diamond 243 149 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28534702 28534702 PRJNA674050_P_NODE_11187_length_292_cov_2.392694_g10984_i0 PRJNA674050 11187 292 2.392694 6.98666648 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 118 1.04e-31   NR CAE7469381.1 2951 g10984 i0 75.3 0.75 73 18 75 0 73 291 1 73 CAE7469381.1 RPS10 [Symbiodinium microadriaticum] diamond 219 118 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
28862021 28862021 PRJNA674050_P_NODE_21028_length_255_cov_2.296703_g20825_i0 PRJNA674050 21028 255 2.296703 5.85659265 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 67.4 2.13e-11   NR KAJ1438084.1 483371 g20825 i0 45.7 2.10588235294118 92 40 96.5 2 250 5 87 178 KAJ1438084.1 60S ribosomal protein L13 [Ochromonadaceae sp. CCMP2298] diamond 537 67.4 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
28881733 28881733 PRJNA674050_P_NODE_30528_length_247_cov_0.890805_g30325_i0 PRJNA674050 30528 247 0.890805 2.20028835 Ectocarpus sp. CCAP 131 74372 SAR_Eukaryotes SAR_Eukaryotes 63.5 6.99e-10   NR CAB1098052.1 867726 g30325 i0 69 0.510121457489879 42 13 51 0 92 217 12 53 CAB1098052.1 unnamed protein product [Ectocarpus sp. CCAP 1310/34] diamond 126 63.5 1 Eukaryota Sar     Phaeophyceae Ectocarpales Ectocarpaceae Ectocarpus Ectocarpus sp. CCAP 1310/34
28976677 28976677 PRJNA674050_P_NODE_24788_length_251_cov_0.870787_g24585_i0 PRJNA674050 24788 251 0.870787 2.18567537 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 144 1.0699999999999998e-37   NR KAJ1421191.1 483371 g24585 i0 86.6 0.9800796812749 82 11 98 0 251 6 169 250 KAJ1421191.1 P-loop containing nucleoside triphosphate hydrolase protein [Ochromonadaceae sp. CCMP2298] diamond 246 144 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
29134639 29134639 PRJNA674050_P_NODE_38189_length_243_cov_0.905882_g37986_i0 PRJNA674050 38189 243 0.905882 2.20129326 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 53.9 1.07e-6   NR KAJ1421402.1 483371 g37986 i0 55.3 0.580246913580247 47 21 58 0 161 21 14 60 KAJ1421402.1 hypothetical protein B484DRAFT_399474, partial [Ochromonadaceae sp. CCMP2298] diamond 141 53.9 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
29260497 29260497 PRJNA674050_P_NODE_22129_length_253_cov_0.866667_g21926_i0 PRJNA674050 22129 253 0.866667 2.19266751 Ectocarpus sp. CCAP 131 74372 SAR_Eukaryotes SAR_Eukaryotes 96.3 6.360000000000001e-21   NR CAB1105228.1 867726 g21926 i0 59.5 2.84584980237154 74 30 87.7 0 253 32 352 425 CAB1105228.1 unnamed protein product [Ectocarpus sp. CCAP 1310/34] diamond 720 96.3 1 Eukaryota Sar     Phaeophyceae Ectocarpales Ectocarpaceae Ectocarpus Ectocarpus sp. CCAP 1310/34
29513126 29513126 PRJNA674050_P_NODE_19610_length_260_cov_1.213904_g19407_i0 PRJNA674050 19610 260 1.213904 3.1561504 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 58.9 9.32e-8   NR KAH9117437.1 100861 g19407 i0 38.4 2.97692307692308 86 52 98.1 1 257 3 496 581 KAH9117437.1 hypothetical protein LEN26_012697 [Aphanomyces euteiches] diamond 774 58.9 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
29670813 29670813 PRJNA674050_P_NODE_17030_length_268_cov_1.594872_g16827_i0 PRJNA674050 17030 268 1.594872 4.27425696 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 147 1.35e-40   NR KAJ1414928.1 483371 g16827 i0 78.7 0.996268656716418 89 19 99.6 0 267 1 144 232 KAJ1414928.1 ribosomal protein L4 domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 267 147 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
30441384 30441384 PRJNA674050_P_NODE_35253_length_244_cov_0.912281_g35050_i0 PRJNA674050 35253 244 0.912281 2.22596564 Ectocarpus 2879 SAR_Eukaryotes SAR_Eukaryotes 86.7 9.88e-18   NR CBJ30141.1 2880 g35050 i0 61.2 3.09836065573771 67 24 82.4 1 16 216 254 318 CBJ30141.1 calcineurin catalytic subunit Ppb1 [Ectocarpus siliculosus] diamond 756 86.7 1 Eukaryota Sar     Phaeophyceae Ectocarpales Ectocarpaceae Ectocarpus Ectocarpus siliculosus
31535733 31535733 PRJNA674050_P_NODE_30356_length_247_cov_0.896552_g30153_i0 PRJNA674050 30356 247 0.896552 2.21448344 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 80.9 3.14e-16   NR KAJ1393893.1 483371 g30153 i0 47.6 0.995951417004049 82 43 99.6 0 246 1 22 103 KAJ1393893.1 hypothetical protein B484DRAFT_459246 [Ochromonadaceae sp. CCMP2298] diamond 246 80.9 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
31630386 31630386 PRJNA674050_P_NODE_25736_length_250_cov_0.881356_g25533_i0 PRJNA674050 25736 250 0.881356 2.20339 Ectocarpus siliculosus 2880 SAR_Eukaryotes SAR_Eukaryotes 56.2 6.98e-7   NR CBJ30838.1 2880 g25533 i0 89.3 0.336 28 3 33.6 0 168 85 143 170 CBJ30838.1 General transcription factor II H, polypeptide 2 [Ectocarpus siliculosus] diamond 84 56.2 1 Eukaryota Sar     Phaeophyceae Ectocarpales Ectocarpaceae Ectocarpus Ectocarpus siliculosus
31883352 31883352 PRJNA674050_P_NODE_22917_length_252_cov_0.871508_g22714_i0 PRJNA674050 22917 252 0.871508 2.19620016 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 71.2 3.69e-12   NR KAJ1415995.1 483371 g22714 i0 40.8 1.42857142857143 120 34 98.8 2 2 250 380 499 KAJ1415995.1 hypothetical protein B484DRAFT_401284, partial [Ochromonadaceae sp. CCMP2298] diamond 360 71.2 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
32199920 32199920 PRJNA674050_P_NODE_20858_length_256_cov_1.355191_g20655_i0 PRJNA674050 20858 256 1.355191 3.46928896 Ectocarpus sp. CCAP 131 74372 SAR_Eukaryotes SAR_Eukaryotes 93.2 5.43e-20   NR CAB1121415.1 867726 g20655 i0 50 13.78125 84 42 98.4 0 1 252 80 163 CAB1121415.1 unnamed protein product [Ectocarpus sp. CCAP 1310/34] diamond 3528 93.2 1 Eukaryota Sar     Phaeophyceae Ectocarpales Ectocarpaceae Ectocarpus Ectocarpus sp. CCAP 1310/34
32579672 32579672 PRJNA674050_P_NODE_33439_length_245_cov_0.906977_g33236_i0 PRJNA674050 33439 245 0.906977 2.22209365 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 54.7 2.95e-7   NR KAL4477597.1 5901 g33236 i0 47.1 0.83265306122449 68 33 83.3 1 25 228 1 65 KAL4477597.1 hypothetical protein ABPG74_002747 [Tetrahymena malaccensis] diamond 204 54.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
32673768 32673768 PRJNA674050_P_NODE_38600_length_242_cov_1.692308_g38397_i0 PRJNA674050 38600 242 1.692308 4.09538536 Ectocarpus sp. CCAP 131 74372 SAR_Eukaryotes SAR_Eukaryotes 66.6 9.75e-11   NR CAB1105140.1 867726 g38397 i0 50 2.19421487603306 58 29 71.9 0 242 69 59 116 CAB1105140.1 unnamed protein product [Ectocarpus sp. CCAP 1310/34] diamond 531 66.6 1 Eukaryota Sar     Phaeophyceae Ectocarpales Ectocarpaceae Ectocarpus Ectocarpus sp. CCAP 1310/34
32894187 32894187 PRJNA674050_P_NODE_17420_length_267_cov_1.340206_g17217_i0 PRJNA674050 17420 267 1.340206 3.57835002 Ectocarpus sp. CCAP 131 74372 SAR_Eukaryotes SAR_Eukaryotes 114 3.520000000000001e-27   NR CAB1113987.1 867726 g17217 i0 65.8 0.887640449438202 79 27 88.8 0 7 243 1622 1700 CAB1113987.1 unnamed protein product [Ectocarpus sp. CCAP 1310/34] diamond 237 114 1 Eukaryota Sar     Phaeophyceae Ectocarpales Ectocarpaceae Ectocarpus Ectocarpus sp. CCAP 1310/34

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