RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA1008624" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJNA1008624 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
27223979 27223979 PRJNA1008624_P_NODE_35443_length_163_cov_0.912281_g35255_i0 PRJNA1008624 35443 163 0.912281 1.48701803 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 73.9 8.12e-14   NR CAG9328584.1 1481888 g35255 i0 72.1 0.791411042944785 43 12 79.1 0 161 33 158 200 CAG9328584.1 unnamed protein product [Blepharisma stoltei] diamond 129 73.9 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
27382273 27382273 PRJNA1008624_P_NODE_20123_length_191_cov_1.823944_g19935_i0 PRJNA1008624 20123 191 1.823944 3.48373304 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 69.7 5.69e-12   NR CAB9528269.1 568900 g19935 i0 47.6 0.989528795811518 63 33 99 0 3 191 372 434 CAB9528269.1 Inherit from euNOG: Reverse transcriptase (RNA-dependent DNA polymerase) [Seminavis robusta] diamond 189 69.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27792791 27792791 PRJNA1008624_P_NODE_27364_length_169_cov_0.866667_g27176_i0 PRJNA1008624 27364 169 0.866667 1.46466723 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 58.9 1.63e-8   NR GLE09482.1 114742 g27176 i0 60.4 3.76331360946746 53 20 92.3 1 163 8 106 158 GLE09482.1 hypothetical protein PINS_up021188 [Pythium insidiosum] diamond 636 58.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
28297755 28297755 PRJNA1008624_P_NODE_37006_length_162_cov_0.920354_g36818_i0 PRJNA1008624 37006 162 0.920354 1.49097348 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00143   NR KAI2490444.1 210448 g36818 i0 47.5 2.22222222222222 40 20 74.1 1 43 162 96 134 KAI2490444.1 hypothetical protein MHU86_24131 [Fragilaria crotonensis] diamond 360 45.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28424264 28424264 PRJNA1008624_P_NODE_30146_length_167_cov_0.881356_g29958_i0 PRJNA1008624 30146 167 0.881356 1.47186452 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 79.7 1.18e-15   NR KAI9995130.1 4787 g29958 i0 66.7 2.74850299401198 51 17 91.6 0 154 2 285 335 KAI9995130.1 hypothetical protein PInf_012177 [Phytophthora infestans] diamond 459 79.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
28487382 28487382 PRJNA1008624_P_NODE_28847_length_168_cov_0.873950_g28659_i0 PRJNA1008624 28847 168 0.87395 1.468236 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 106 5.66e-25   NR OMJ68454.1 5963 g28659 i0 92.6 0.964285714285714 54 4 96.4 0 6 167 3117 3170 OMJ68454.1 hypothetical protein SteCoe_34092 [Stentor coeruleus] diamond 162 106 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
28550643 28550643 PRJNA1008624_P_NODE_27567_length_169_cov_0.866667_g27379_i0 PRJNA1008624 27567 169 0.866667 1.46466723 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 53.1 2.83e-6   NR CAB9521594.1 568900 g27379 i0 49.1 0.940828402366864 53 27 94.1 0 161 3 794 846 CAB9521594.1 Reverse transcriptase (RNA-dependent DNA polymerase) (Partial), partial [Seminavis robusta] diamond 159 53.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28708463 28708463 PRJNA1008624_P_NODE_32327_length_165_cov_0.896552_g32139_i0 PRJNA1008624 32327 165 0.896552 1.4793108 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 69.7 3.88e-12   NR CAB9525983.1 568900 g32139 i0 57.4 0.981818181818182 54 23 98.2 0 164 3 232 285 CAB9525983.1 unknown protein [Seminavis robusta] diamond 162 69.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29655116 29655116 PRJNA1008624_P_NODE_35610_length_163_cov_0.912281_g35422_i0 PRJNA1008624 35610 163 0.912281 1.48701803 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 49.7 4.51e-5   NR CAB9527445.1 568900 g35422 i0 48.8 2.57668711656442 41 21 75.5 0 123 1 339 379 CAB9527445.1 hypothetical protein SEMRO_1998_G310121.1 [Seminavis robusta] diamond 420 49.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30887584 30887584 PRJNA1008624_P_NODE_32294_length_165_cov_0.896552_g32106_i0 PRJNA1008624 32294 165 0.896552 1.4793108 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 50.4 2.42e-5   NR CAI2360389.1 5936 g32106 i0 92.3 0.472727272727273 26 2 47.3 0 86 163 293 318 CAI2360389.1 unnamed protein product [Moneuplotes crassus] diamond 78 50.4 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
31488447 31488447 PRJNA1008624_P_NODE_22856_length_182_cov_1.406015_g22668_i0 PRJNA1008624 22856 182 1.406015 2.5589473 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 114 1.02e-27   NR CAB9505263.1 568900 g22668 i0 89.5 0.93956043956044 57 6 94 0 176 6 1566 1622 CAB9505263.1 NADH dehydrogenase (ubiquinone) complex I, assembly factor 6 [Seminavis robusta] diamond 171 114 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31899426 31899426 PRJNA1008624_P_NODE_29897_length_167_cov_0.881356_g29709_i0 PRJNA1008624 29897 167 0.881356 1.47186452 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 82 1.88e-16   NR KAJ1442902.1 483371 g29709 i0 75.5 0.952095808383233 53 12 95.2 1 3 161 611 662 KAJ1442902.1 P-loop containing nucleoside triphosphate hydrolase protein [Ochromonadaceae sp. CCMP2298] diamond 159 82 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
32215911 32215911 PRJNA1008624_P_NODE_28498_length_168_cov_0.873950_g28310_i0 PRJNA1008624 28498 168 0.87395 1.468236 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 41.2 0.046   NR CDW74479.1 5949 g28310 i0 54.8 0.553571428571429 31 14 55.4 0 115 23 216 246 CDW74479.1 UNKNOWN [Stylonychia lemnae] diamond 93 41.2 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32342621 32342621 PRJNA1008624_P_NODE_28519_length_168_cov_0.873950_g28331_i0 PRJNA1008624 28519 168 0.87395 1.468236 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 64.3 3.39e-10   NR CAI2384268.1 5936 g28331 i0 58.3 0.857142857142857 48 20 85.7 0 10 153 534 581 CAI2384268.1 unnamed protein product [Moneuplotes crassus] diamond 144 64.3 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
32721328 32721328 PRJNA1008624_P_NODE_31220_length_166_cov_0.888889_g31032_i0 PRJNA1008624 31220 166 0.888889 1.47555574 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 60.5 7.37e-9   NR GKY94061.1 2872254 g31032 i0 50 1.89759036144578 52 26 94 0 163 8 381 432 GKY94061.1 hypothetical protein MPSEU_000372700 [Mayamaea pseudoterrestris] diamond 315 60.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris

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