RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA785164" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

analysis 2

tax_superkingdom 1

tax_clade 1

  • Sar · 20 ✖

bioproject 1

  • PRJNA785164 · 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
2042292 2042292 PRJNA785164_P_NODE_48282_length_258_cov_2.967568_g47817_i0 PRJNA785164 48282 258 2.967568 7.65632544 Stentor roeselii 1703786 SAR_Eukaryotes SAR_Eukaryotes 424 4.32e-114   NTclustered gi|921061859|gb|KP970274.1| 1703786 g47817 i0 98.745 64.515503875969 239 2 92 1 21 258 64 302 Stentor roeselii isolate STR large subunit ribosomal RNA gene, partial sequence blastn 16645 424 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor roeselii
3317689 3317689 PRJNA785164_P_NODE_48263_length_258_cov_6.594595_g47798_i0 PRJNA785164 48263 258 6.594595 17.0140551 Mallomonas asmundiae 64709 SAR_Eukaryotes SAR_Eukaryotes 292 1.27e-74   NTclustered gi|16326554|gb|AF409122.1| 64709 g47798 i0 88.843 24.1627906976744 242 22 93 5 1 239 3689 3928 Mallomonas asmundae internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence blastn 6234 292 1 Eukaryota Sar     Synurophyceae Synurales Mallomonadaceae Mallomonas Mallomonas asmundiae
8419316 8419316 PRJNA785164_P_NODE_40227_length_284_cov_1.530806_g39762_i0 PRJNA785164 40227 284 1.5308059999999999 4.34748904 Fragilaria famelica 1003135 SAR_Eukaryotes SAR_Eukaryotes 152 2.51e-32   NTclustered gi|2862228909|gb|PQ645543.1| 1003135 g39762 i0 77.032 43.1549295774648 283 53 99 8 1 282 3771 3500 Fragilaria famelica isolate AGSB0425 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 12256 152 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria famelica
8866591 8866591 PRJNA785164_P_NODE_24867_length_373_cov_1.990000_g24402_i0 PRJNA785164 24867 373 1.99 7.4227 Poterioochromonas 88166 SAR_Eukaryotes SAR_Eukaryotes 601 2.8099999999999993e-167   NTclustered gi|323690576|gb|GU935635.1| 88167 g24402 i0 95.71 99.6005361930295 373 16 100 0 1 373 1199 1571 Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence blastn 37151 601 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
9694865 9694865 PRJNA785164_P_NODE_53708_length_249_cov_0.875000_g53243_i0 PRJNA785164 53708 249 0.875 2.17875 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 145 1.29e-41   NR KAJ1430068.1 483371 g53243 i0 89 0.987951807228916 82 9 98.8 0 3 248 57 138 KAJ1430068.1 ribosomal protein S3 [Ochromonadaceae sp. CCMP2298] diamond 246 145 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
12246026 12246026 PRJNA785164_P_NODE_49350_length_255_cov_2.538462_g48885_i0 PRJNA785164 49350 255 2.538462 6.4730781 Poterioochromonas malhamensis 88167 SAR_Eukaryotes SAR_Eukaryotes 342 1.2299999999999997e-89   NTclustered gi|323690576|gb|GU935635.1| 88167 g48885 i0 90.98 103.019607843137 255 21 100 2 1 255 2034 1782 Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence blastn 26270 342 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
23719602 23719602 PRJNA785164_P_NODE_61079_length_242_cov_0.911243_g60614_i0 PRJNA785164 61079 242 0.911243 2.20520806 Chrysophyceae sp. I76 429461 SAR_Eukaryotes SAR_Eukaryotes 283 7.1e-72   NTclustered gi|134142272|gb|EF432474.1| 429461 g60614 i0 87.917 94.0289256198347 240 29 99 0 1 240 1125 886 Chrysophyceae sp. I76 clone E7 beta tubulin (btub) mRNA, partial cds blastn 22755 283 1 Eukaryota Sar     Chrysophyceae       Chrysophyceae sp. I76
24165220 24165220 PRJNA785164_P_NODE_62839_length_237_cov_5.591463_g62374_i0 PRJNA785164 62839 237 5.591463 13.25176731 Entomoneis 186042 SAR_Eukaryotes SAR_Eukaryotes 230 9.16e-56   NTclustered gi|2202538958|gb|OM891864.1| 216750 g62374 i0 86.603 9.79746835443038 209 26 88 2 13 220 4053 3846 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 2322 230 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis cf. alata
25440331 25440331 PRJNA785164_P_NODE_62060_length_241_cov_0.916667_g61595_i0 PRJNA785164 62060 241 0.916667 2.20916747 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 134 6.35e-38   NR CAE7561516.1 2951 g61595 i0 85.9 0.970954356846473 78 11 97.1 0 6 239 6 83 CAE7561516.1 RPS7 [Symbiodinium microadriaticum] diamond 234 134 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
26768776 26768776 PRJNA785164_P_NODE_56801_length_246_cov_0.890173_g56336_i0 PRJNA785164 56801 246 0.890173 2.18982558 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 112 7.04e-28   NR KAJ1406720.1 483371 g56336 i0 69.1 0.98780487804878 81 23 96.3 1 241 5 99 179 KAJ1406720.1 phosphatase 2C-like domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 243 112 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
27654092 27654092 PRJNA785164_P_NODE_54684_length_248_cov_0.880000_g54219_i0 PRJNA785164 54684 248 0.88 2.1824 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 85.9 2.59e-17   NR KAJ1424539.1 483371 g54219 i0 52.4 0.991935483870968 82 39 99.2 0 2 247 488 569 KAJ1424539.1 hypothetical protein B484DRAFT_363461 [Ochromonadaceae sp. CCMP2298] diamond 246 85.9 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
28222070 28222070 PRJNA785164_P_NODE_47806_length_260_cov_1.401070_g47341_i0 PRJNA785164 47806 260 1.40107 3.642782 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 80.9 1.63e-15   NR KAJ1433363.1 483371 g47341 i0 59.7 0.773076923076923 67 24 77.3 2 59 259 2 65 KAJ1433363.1 beta-Glucocerebrosidase 2 N terminal-domain-containing protein, partial [Ochromonadaceae sp. CCMP2298] diamond 201 80.9 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
29810079 29810079 PRJNA785164_P_NODE_51891_length_250_cov_1.672316_g51426_i0 PRJNA785164 51891 250 1.672316 4.18079 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 50.8 5.37e-5   NR KAG9405943.1 112091 g51426 i0 62.5 1.536 32 12 38.4 0 184 89 1 32 KAG9405943.1 Protein fam50a [Aphanomyces cochlioides] diamond 384 50.8 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cochlioides
30306927 30306927 PRJNA785164_P_NODE_24352_length_378_cov_1.409836_g23887_i0 PRJNA785164 24352 378 1.409836 5.32918008 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 96.7 1.53e-20   NR KAL3942371.1 3061772 g23887 i0 52.4 1.31746031746032 82 39 65.1 0 2 247 135 216 KAL3942371.1 MAG: hypothetical protein SGBAC_003437 [Bacillariaceae sp.] diamond 498 96.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30631480 30631480 PRJNA785164_P_NODE_51333_length_251_cov_0.865169_g50868_i0 PRJNA785164 51333 251 0.865169 2.17157419 Ectocarpus 2879 SAR_Eukaryotes SAR_Eukaryotes 150 5.63e-40   NR CBJ26552.1 2880 g50868 i0 83.1 37.6852589641434 83 14 99.2 0 1 249 638 720 CBJ26552.1 DNA repair and recombination protein RAD54 homolog [Ectocarpus siliculosus] diamond 9459 150 1 Eukaryota Sar     Phaeophyceae Ectocarpales Ectocarpaceae Ectocarpus Ectocarpus siliculosus
30780340 30780340 PRJNA785164_P_NODE_55554_length_247_cov_0.885057_g55089_i0 PRJNA785164 55554 247 0.885057 2.18609079 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 58.9 7.32e-8   NR KAJ1406567.1 483371 g55089 i0 54.9 0.619433198380567 51 20 58.3 1 102 245 282 332 KAJ1406567.1 Pre-mRNA cleavage complex II protein Clp1-domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 153 58.9 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
30938495 30938495 PRJNA785164_P_NODE_62154_length_241_cov_0.916667_g61689_i0 PRJNA785164 62154 241 0.916667 2.20916747 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 115 8.97e-28   NR KAJ1429454.1 483371 g61689 i0 78.8 0.995850622406639 80 16 99.6 1 2 241 66 144 KAJ1429454.1 intraflagellar transport particle protein, partial [Ochromonadaceae sp. CCMP2298] diamond 240 115 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
31801112 31801112 PRJNA785164_P_NODE_38117_length_292_cov_1.465753_g37652_i0 PRJNA785164 38117 292 1.465753 4.27999876 root 1 Root_unresolved Root_unresolved 73.9 7.31e-13   NR KAJ1434190.1 483371 g37652 i0 42.4 2.60958904109589 85 48 87.3 1 291 37 482 565 KAJ1434190.1 hypothetical protein B484DRAFT_394161, partial [Ochromonadaceae sp. CCMP2298] diamond 762 74.3 0.994616419919246 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
32203378 32203378 PRJNA785164_P_NODE_43738_length_272_cov_2.090452_g43273_i0 PRJNA785164 43738 272 2.090452 5.68602944 Nannochloropsis gaditana 72520 SAR_Eukaryotes SAR_Eukaryotes 82.8 4.22e-16   NR EWM30252.1 72520 g43273 i0 43.6 0.860294117647059 78 44 86 0 271 38 492 569 EWM30252.1 rna-binding protein 25 [Nannochloropsis gaditana] diamond 234 82.8 1 Eukaryota Sar     Eustigmatophyceae Eustigmatales Monodopsidaceae Nannochloropsis Nannochloropsis gaditana
32266868 32266868 PRJNA785164_P_NODE_54078_length_248_cov_1.320000_g53613_i0 PRJNA785164 54078 248 1.32 3.2736 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 76.6 4.65e-14   NR KAJ1420393.1 483371 g53613 i0 43.2 0.979838709677419 81 45 98 1 3 245 650 729 KAJ1420393.1 hypothetical protein B484DRAFT_351281 [Ochromonadaceae sp. CCMP2298] diamond 243 76.6 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298

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