RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA474426" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 20 ✖

bioproject 1

  • PRJNA474426 · 20 ✖

analysis 1

  • diamond · 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
24048904 24048904 PRJNA474426_P_NODE_5899_length_446_cov_1.738035_g5697_i0 PRJNA474426 5899 446 1.738035 7.7516361 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 99.4 5.53e-21   NR KAK1735525.1 267567 g5697 i0 63 3.90807174887892 73 27 49.1 0 216 434 351 423 KAK1735525.1 divalent metal cation transporter [Skeletonema marinoi] diamond 1743 99.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
27202488 27202488 PRJNA474426_P_NODE_32742_length_167_cov_0.881356_g32537_i0 PRJNA474426 32742 167 0.881356 1.47186452 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 47.8 2.28e-4   NR CAB9531141.1 568900 g32537 i0 34.5 0.988023952095808 55 36 98.8 0 166 2 19 73 CAB9531141.1 hypothetical protein SEMRO_3274_G346120.1 [Seminavis robusta] diamond 165 47.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27518649 27518649 PRJNA474426_P_NODE_14863_length_269_cov_1.777273_g14658_i0 PRJNA474426 14863 269 1.777273 4.78086437 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 87.4 9.98e-18   NR KAJ1431655.1 483371 g14658 i0 49.3 0.769516728624535 69 35 77 0 2 208 822 890 KAJ1431655.1 FACT complex subunit-domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 207 87.4 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
27708509 27708509 PRJNA474426_P_NODE_21864_length_212_cov_1.552147_g21659_i0 PRJNA474426 21864 212 1.552147 3.29055164 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 48.9 1.61e-4   NR KAJ1396680.1 483371 g21659 i0 62.9 0.495283018867925 35 13 49.5 0 127 23 241 275 KAJ1396680.1 S-adenosyl-L-methionine-dependent methyltransferase [Ochromonadaceae sp. CCMP2298] diamond 105 48.9 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
28023905 28023905 PRJNA474426_P_NODE_19145_length_229_cov_2.272222_g18940_i0 PRJNA474426 19145 229 2.272222 5.20338838 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0418   NR RHZ12526.1 112090 g18940 i0 41.2 1.38864628820961 51 23 59 2 10 144 121 170 RHZ12526.1 hypothetical protein DYB26_008579 [Aphanomyces astaci] diamond 318 42.4 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
28481998 28481998 PRJNA474426_P_NODE_27926_length_183_cov_1.529851_g27721_i0 PRJNA474426 27926 183 1.529851 2.79962733 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 70.9 2.07e-12   NR CDW78896.1 5949 g27721 i0 68.6 3.91803278688525 51 15 82 1 162 13 553 603 CDW78896.1 tubulin-tyrosine ligase family protein [Stylonychia lemnae] diamond 717 71.6 0.990223463687151 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
28860736 28860736 PRJNA474426_P_NODE_28608_length_180_cov_2.198473_g28403_i0 PRJNA474426 28608 180 2.198473 3.9572514 Symbiodiniaceae 252141 SAR_Eukaryotes SAR_Eukaryotes 55.1 2.36e-7   NR CAE7399977.1 878477 g28403 i0 60 3 45 18 75 0 15 149 101 145 CAE7399977.1 pheT [Symbiodinium natans] diamond 540 55.1 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium natans
29129127 29129127 PRJNA474426_P_NODE_11269_length_317_cov_2.376866_g11064_i0 PRJNA474426 11269 317 2.376866 7.53466522 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 96.3 9.7e-22   NR CAI2378551.1 5936 g11064 i0 51.7 0.823343848580442 87 42 82.3 0 57 317 56 142 CAI2378551.1 unnamed protein product [Moneuplotes crassus] diamond 261 96.3 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
29397594 29397594 PRJNA474426_P_NODE_34289_length_165_cov_0.887931_g34084_i0 PRJNA474426 34289 165 0.887931 1.46508615 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 42 0.0239   NR CAD8051780.1 65129 g34084 i0 79.2 2.30909090909091 24 5 43.6 0 152 81 273 296 CAD8051780.1 unnamed protein product [Paramecium sonneborni] diamond 381 42 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
29570809 29570809 PRJNA474426_P_NODE_10070_length_338_cov_2.941176_g9865_i0 PRJNA474426 10070 338 2.941176 9.94117488 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 60.5 2.8e-8   NR CEO98403.1 37360 g9865 i0 77.1 3.1508875739645 35 8 31.1 0 214 318 70 104 CEO98403.1 hypothetical protein PBRA_006517 [Plasmodiophora brassicae] diamond 1065 60.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29570812 29570812 PRJNA474426_P_NODE_21630_length_213_cov_2.682927_g21425_i0 PRJNA474426 21630 213 2.682927 5.71463451 Durusdinium trenchii 1381693 SAR_Eukaryotes SAR_Eukaryotes 48.1 3.14e-4   NR CAK9020061.1 1381693 g21425 i0 47.6 0.591549295774648 42 22 59.2 0 87 212 466 507 CAK9020061.1 Multiple EGF-like-domain protein 3 [Durusdinium trenchii] diamond 126 48.1 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Durusdinium Durusdinium trenchii
29839623 29839623 PRJNA474426_P_NODE_35251_length_164_cov_0.886957_g35046_i0 PRJNA474426 35251 164 0.886957 1.45460948 Monodopsidaceae 425072 SAR_Eukaryotes SAR_Eukaryotes 48.9 8.49e-5   NR EWM22330.1 72520 g35046 i0 43.8 4.53658536585366 48 27 87.8 0 1 144 489 536 EWM22330.1 eukaryotic initiation factor 3 p66 subunit [Nannochloropsis gaditana] diamond 744 48.9 1 Eukaryota Sar     Eustigmatophyceae Eustigmatales Monodopsidaceae Nannochloropsis Nannochloropsis gaditana
29855193 29855193 PRJNA474426_P_NODE_15831_length_259_cov_1.152381_g15626_i0 PRJNA474426 15831 259 1.152381 2.98466679 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 114 1.33e-27   NR CAD8206787.1 43137 g15626 i0 75.7 3.42857142857143 74 18 85.7 0 223 2 1 74 CAD8206787.1 unnamed protein product [Paramecium octaurelia] diamond 888 114 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
29997738 29997738 PRJNA474426_P_NODE_13371_length_286_cov_6.396624_g13166_i0 PRJNA474426 13371 286 6.396624 18.29434464 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0331   NR OEH77175.1 88456 g13166 i0 41.8 1.37412587412587 55 22 56.6 2 13 174 197 242 OEH77175.1 cast domain-containing protein [Cyclospora cayetanensis] diamond 393 43.5 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Cyclospora Cyclospora cayetanensis
30202416 30202416 PRJNA474426_P_NODE_9812_length_343_cov_1.476190_g9607_i0 PRJNA474426 9812 343 1.47619 5.0633317 Symbiodinium pilosum 2952 SAR_Eukaryotes SAR_Eukaryotes 60.8 3.28e-8   NR CAE7301466.1 2952 g9607 i0 39 5.26530612244898 100 49 84.8 4 342 52 172 262 CAE7301466.1 katG, partial [Symbiodinium pilosum] diamond 1806 60.8 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium pilosum
30297903 30297903 PRJNA474426_P_NODE_11452_length_314_cov_2.116981_g11247_i0 PRJNA474426 11452 314 2.116981 6.64732034 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 107 9.22e-25   NR KAL4491372.1 2486642 g11247 i0 61.5 1.49044585987261 78 30 74.5 0 241 8 78 155 KAL4491372.1 hypothetical protein ABPG72_008028 [Tetrahymena utriculariae] diamond 468 107 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
30581574 30581574 PRJNA474426_P_NODE_5773_length_450_cov_1.678304_g5571_i0 PRJNA474426 5773 450 1.678304 7.552368 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 84 2.8e-16   NR XP_001460553.1 5888 g5571 i0 32.2 0.993333333333333 149 89 95.3 3 2 430 48 190 XP_001460553.1 uncharacterized protein GSPATT00004025001 [Paramecium tetraurelia] diamond 447 84 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
31972839 31972839 PRJNA474426_P_NODE_5478_length_460_cov_8.768856_g5280_i0 PRJNA474426 5478 460 8.768856 40.3367376 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 100 1.9900000000000003e-21   NR KAJ1405515.1 483371 g5280 i0 47.5 0.919565217391304 141 45 87.4 6 46 447 63 181 KAJ1405515.1 phosphatidylinositol-4-phosphate 5-kinase-domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 423 100 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
32242409 32242409 PRJNA474426_P_NODE_30738_length_172_cov_2.016260_g30533_i0 PRJNA474426 30738 172 2.01626 3.4679672 Plasmodium 5820 SAR_Eukaryotes SAR_Eukaryotes 57 1.26e-7   NR VUZ95235.1 5855 g30533 i0 61.3 3.78488372093023 31 12 54.1 0 95 3 307 337 VUZ95235.1 MORN repeat protein, putative [Plasmodium vivax] diamond 651 57.4 0.993031358885017 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium vivax
32415956 32415956 PRJNA474426_P_NODE_12519_length_298_cov_1.642570_g12314_i0 PRJNA474426 12519 298 1.64257 4.8948586 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 82.8 6.43e-16   NR CDW91214.1 5949 g12314 i0 69.8 1.08724832214765 53 16 53.4 0 244 86 3005 3057 CDW91214.1 dynein heavy chain axonemal [Stylonychia lemnae] diamond 324 82.8 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae

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