RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA951412" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 15 ✖

tax_clade 1

bioproject 1

  • PRJNA951412 · 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
4763155 4763155 PRJNA951412_P_NODE_3084_length_279_cov_1.466019_g2999_i0 PRJNA951412 3084 279 1.466019 4.09019301 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 165 3.87e-47   NR KAG7350435.1 303405 g2999 i0 92.9 0.913978494623656 85 6 91.4 0 1 255 343 427 KAG7350435.1 DEAD/DEAH box helicase domain protein [Nitzschia inconspicua] diamond 255 165 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
6037901 6037901 PRJNA951412_P_NODE_1185_length_411_cov_1.340237_g1100_i0 PRJNA951412 1185 411 1.340237 5.50837407 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 206 6.77e-66   NR GAX21567.1 1519565 g1100 i0 82.4 0.912408759124088 125 19 91.2 1 1 375 15 136 GAX21567.1 small subunit ribosomal protein S10e [Fistulifera solaris] diamond 375 206 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
21336859 21336859 PRJNA951412_P_NODE_1917_length_333_cov_1.796154_g1832_i0 PRJNA951412 1917 333 1.796154 5.98119282 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 158 7.33e-46   NR KAI2499764.1 210448 g1832 i0 65 1.05405405405405 117 35 100 1 1 333 92 208 KAI2499764.1 DNA binding protein [Fragilaria crotonensis] diamond 351 158 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
26803974 26803974 PRJNA951412_P_NODE_3961_length_254_cov_1.453039_g3876_i0 PRJNA951412 3961 254 1.453039 3.69071906 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 55.1 1.99e-6   NR GKY98814.1 2872254 g3876 i0 34.6 0.956692913385827 81 53 95.7 0 244 2 2017 2097 GKY98814.1 hypothetical protein MPSEU_000837500 [Mayamaea pseudoterrestris] diamond 243 55.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
27531134 27531134 PRJNA951412_P_NODE_3483_length_266_cov_2.067358_g3398_i0 PRJNA951412 3483 266 2.067358 5.49917228 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 67.8 6.73e-11   NR GKY94583.1 2872254 g3398 i0 60 0.56390977443609 50 17 56.4 1 264 115 320 366 GKY94583.1 hypothetical protein MPSEU_000423900 [Mayamaea pseudoterrestris] diamond 150 67.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
27657650 27657650 PRJNA951412_P_NODE_5124_length_249_cov_2.494318_g5039_i0 PRJNA951412 5124 249 2.494318 6.21085182 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 63.5 1.84e-9   NR XP_002183946.1 556484 g5039 i0 51.4 0.891566265060241 74 28 89.2 2 222 1 255 320 XP_002183946.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 222 63.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27878475 27878475 PRJNA951412_P_NODE_6725_length_245_cov_0.901163_g6640_i0 PRJNA951412 6725 245 0.901163 2.20784935 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 80.5 6.31e-16   NR KAL3939768.1 3061772 g6640 i0 50 1.67755102040816 70 35 85.7 0 8 217 199 268 KAL3939768.1 MAG: hypothetical protein SGBAC_005571 [Bacillariaceae sp.] diamond 411 80.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
28453506 28453506 PRJNA951412_P_NODE_5126_length_249_cov_2.284091_g5041_i0 PRJNA951412 5126 249 2.284091 5.68738659 Cyclotella 29203 SAR_Eukaryotes SAR_Eukaryotes 48.9 2.82e-4   NR KAL3801948.1 29204 g5041 i0 67.4 1.03614457831325 43 13 51.8 1 249 121 1278 1319 KAL3801948.1 hypothetical protein HJC23_010292 [Cyclotella cryptica] diamond 258 49.3 0.991886409736308 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
28478416 28478416 PRJNA951412_P_NODE_2266_length_312_cov_1.305439_g2181_i0 PRJNA951412 2266 312 1.305439 4.07296968 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 132 1.49e-33   NR CAJ1961429.1 2856 g2181 i0 55.3 1.98076923076923 103 45 99 1 311 3 326 427 CAJ1961429.1 unnamed protein product [Cylindrotheca closterium] diamond 618 132 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
28731020 28731020 PRJNA951412_P_NODE_2787_length_288_cov_3.213953_g2702_i0 PRJNA951412 2787 288 3.213953 9.25618464 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 83.6 1.02e-18   NR GKY99117.1 2872254 g2702 i0 62.5 0.833333333333333 80 27 81.3 3 286 53 3 81 GKY99117.1 hypothetical protein MPSEU_000867200 [Mayamaea pseudoterrestris] diamond 240 83.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28983838 28983838 PRJNA951412_P_NODE_1448_length_372_cov_5.859532_g1363_i0 PRJNA951412 1448 372 5.859532 21.79745904 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 106 3.03e-27   NR GAX28375.1 1519565 g1363 i0 73.1 0.75 93 25 75 0 372 94 3 95 GAX28375.1 hypothetical protein FisN_4Hh037 [Fistulifera solaris] diamond 279 106 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
30474606 30474606 PRJNA951412_P_NODE_1153_length_418_cov_2.466667_g1068_i0 PRJNA951412 1153 418 2.466667 10.31066806 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 136 5.57e-36   NR CAJ1937478.1 2856 g1068 i0 62.6 2.98564593301435 107 40 76.8 0 2 322 237 343 CAJ1937478.1 unnamed protein product [Cylindrotheca closterium] diamond 1248 137 0.992700729927007 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31036967 31036967 PRJNA951412_P_NODE_1215_length_406_cov_1.723724_g1130_i0 PRJNA951412 1215 406 1.723724 6.99831944 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 95.5 8.4e-20   NR XP_002181206.1 556484 g1130 i0 63.8 0.591133004926108 80 29 59.1 0 241 2 1 80 XP_002181206.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 240 95.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
31928635 31928635 PRJNA951412_P_NODE_1977_length_330_cov_1.214008_g1892_i0 PRJNA951412 1977 330 1.214008 4.0062264 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 94.7 1.71e-20   NR CAJ1937478.1 2856 g1892 i0 53.2 1.47272727272727 79 37 71.8 0 237 1 38 116 CAJ1937478.1 unnamed protein product [Cylindrotheca closterium] diamond 486 94.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31985315 31985315 PRJNA951412_P_NODE_5458_length_248_cov_1.771429_g5373_i0 PRJNA951412 5458 248 1.771429 4.39314392 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 71.2 3.61e-12   NR KAG7360593.1 303405 g5373 i0 45 0.967741935483871 80 44 96.8 0 247 8 700 779 KAG7360593.1 glycerol 3-phosphate dehydrogenase [Nitzschia inconspicua] diamond 240 71.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua

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