RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA560029" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 14 ✖

bioproject 1

  • PRJNA560029 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
12022751 12022751 PRJNA560029_S_NODE_10210_length_365_cov_3.551370_g9986_i0 PRJNA560029 10210 365 3.55137 12.9625005 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 161 8.17e-46   NR KAF0701708.1 120398 g9986 i0 65.5 15.172602739726 119 41 97.8 0 8 364 13 131 KAF0701708.1 hypothetical protein As57867_007844 [Aphanomyces stellatus] diamond 5538 162 0.993827160493827 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
26794201 26794201 PRJNA560029_S_NODE_15461_length_327_cov_5.677165_g15237_i0 PRJNA560029 15461 327 5.677165 18.56432955 Lagenidium giganteum 4803 SAR_Eukaryotes SAR_Eukaryotes 60.5 5.67e-8   NR DBA04470.1 4803 g15237 i0 44.7 0.697247706422018 76 42 69.7 0 320 93 426 501 DBA04470.1 TPA: hypothetical protein N0F65_010066 [Lagenidium giganteum] diamond 228 60.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
26857830 26857830 PRJNA560029_S_NODE_23301_length_287_cov_2.186916_g23077_i0 PRJNA560029 23301 287 2.186916 6.27644892 Pelagomonas calceolata 35677 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0453   NR CAH0375798.1 35677 g23077 i0 38.8 0.700348432055749 67 40 70 1 203 3 4 69 CAH0375798.1 unnamed protein product [Pelagomonas calceolata] diamond 201 43.1 1 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Pelagomonas Pelagomonas calceolata
26857831 26857831 PRJNA560029_S_NODE_30741_length_256_cov_1.584699_g30517_i0 PRJNA560029 30741 256 1.584699 4.05682944 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0158   NR CAG9328855.1 1481888 g30517 i0 43.2 0.515625 44 24 51.6 1 105 236 114 156 CAG9328855.1 unnamed protein product [Blepharisma stoltei] diamond 132 43.9 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
27250975 27250975 PRJNA560029_S_NODE_4763_length_442_cov_6.398374_g4539_i0 PRJNA560029 4763 442 6.398374 28.28081308 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 90.5 2.54e-18   NR TNV78386.1 5974 g4539 i0 43.2 7.21493212669683 95 53 64.5 1 441 157 238 331 TNV78386.1 hypothetical protein FGO68_gene15615 [Halteria grandinella] diamond 3189 91.3 0.991237677984666 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
27693501 27693501 PRJNA560029_S_NODE_33484_length_246_cov_3.971098_g33260_i0 PRJNA560029 33484 246 3.971098 9.76890108 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 80.1 2.7e-15   NR SPQ93309.1 37360 g33260 i0 64.9 1.39024390243902 57 20 69.5 0 240 70 470 526 SPQ93309.1 unnamed protein product [Plasmodiophora brassicae] diamond 342 80.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28261356 28261356 PRJNA560029_S_NODE_17726_length_314_cov_4.431535_g17502_i0 PRJNA560029 17726 314 4.431535 13.9150199 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 58.2 2.94e-7   NR RLN99890.1 112090 g17502 i0 33.3 1.61464968152866 87 52 82.2 2 40 297 256 337 RLN99890.1 hypothetical protein DYB28_012959, partial [Aphanomyces astaci] diamond 507 58.2 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
29208934 29208934 PRJNA560029_S_NODE_23749_length_285_cov_2.080189_g23525_i0 PRJNA560029 23749 285 2.080189 5.92853865 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 46.2 7.53e-4   NR CAD8047472.1 5886 g23525 i0 70.8 1.01052631578947 24 7 25.3 0 20 91 33 56 CAD8047472.1 unnamed protein product [Paramecium primaurelia] diamond 288 46.6 0.991416309012876 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
29429536 29429536 PRJNA560029_S_NODE_35129_length_242_cov_1.218935_g34905_i0 PRJNA560029 35129 242 1.218935 2.9498227 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00173   NR CAE7541831.1 2951 g34905 i0 56.3 3 32 14 39.7 0 74 169 143 174 CAE7541831.1 unnamed protein product [Symbiodinium microadriaticum] diamond 726 45.8 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
30314659 30314659 PRJNA560029_S_NODE_7772_length_390_cov_6.340694_g7548_i0 PRJNA560029 7772 390 6.340694 24.7287066 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 79.7 2.19e-14   NR KAG1709295.1 4784 g7548 i0 63.5 7.97692307692308 74 16 55.4 3 5 220 642 706 KAG1709295.1 hypothetical protein DVH05_019938 [Phytophthora capsici] diamond 3111 80.5 0.990062111801242 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
30458520 30458520 PRJNA560029_S_NODE_17053_length_318_cov_1.885714_g16829_i0 PRJNA560029 17053 318 1.885714 5.99657052 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 75.5 3.06e-13   NR KAI2496705.1 210448 g16829 i0 54.4 0.641509433962264 68 29 64.2 1 4 207 1594 1659 KAI2496705.1 DNA dependent RNA polymerase [Fragilaria crotonensis] diamond 204 75.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30914606 30914606 PRJNA560029_S_NODE_18654_length_309_cov_4.368644_g18430_i0 PRJNA560029 18654 309 4.368644 13.49910996 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 81.6 1.69e-15   NR OMJ77313.1 5963 g18430 i0 57.6 2.7378640776699 66 28 64.1 0 305 108 472 537 OMJ77313.1 hypothetical protein SteCoe_23141 [Stentor coeruleus] diamond 846 82 0.995121951219512 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
30977785 30977785 PRJNA560029_S_NODE_8294_length_384_cov_4.610932_g8070_i0 PRJNA560029 8294 384 4.610932 17.70597888 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 82 3.41e-15   NR CEO95116.1 37360 g8070 i0 66.7 0.8984375 57 19 44.5 0 81 251 2362 2418 CEO95116.1 hypothetical protein PBRA_003882 [Plasmodiophora brassicae] diamond 345 82 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32513758 32513758 PRJNA560029_S_NODE_12639_length_346_cov_2.637363_g12415_i0 PRJNA560029 12639 346 2.637363 9.12527598 Blastocystis sp. subtype 4 944170 SAR_Eukaryotes SAR_Eukaryotes 57.4 8.67e-7   NR XP_014527687.1 944170 g12415 i0 55.3 0.407514450867052 47 21 40.8 0 1 141 163 209 XP_014527687.1 high mobility group b protein 6-like protein [Blastocystis sp. subtype 4] diamond 141 57.4 1 Eukaryota Sar     Bigyra Opalinata Blastocystidae Blastocystis Blastocystis sp. subtype 4

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