RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA562549", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 13 ✖

tax_clade 1

  • Sar · 13 ✖

bioproject 1

  • PRJNA562549 · 13 ✖

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
17123512 17123512 PRJNA562549_P_NODE_34654_length_205_cov_1.708333_g34421_i0 PRJNA562549 34654 205 1.708333 3.50208265 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 161 2.8499999999999995e-35   NTclustered gi|657012369|gb|KF302532.1| 2850 g34421 i0 86.395 0.717073170731707 147 20 72 0 59 205 226 80 Phaeodactylum tricornutum clone C80 40S ribosomal protein mRNA, complete cds blastn 147 161 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
17123584 17123584 PRJNA562549_P_NODE_7394_length_423_cov_2.497238_g7161_i0 PRJNA562549 7394 423 2.497238 10.56331674 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 213 1.3199999999999998e-66   NR KAI2505670.1 210448 g7161 i0 77.9 10.2056737588652 131 29 92.9 0 31 423 6 136 KAI2505670.1 small subunit ribosomal protein [Fragilaria crotonensis] diamond 4317 213 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
22222679 22222679 PRJNA562549_P_NODE_13478_length_313_cov_1.896825_g13245_i0 PRJNA562549 13478 313 1.896825 5.93706225 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 265 3.45e-66   NTclustered gi|657012511|gb|KF302595.1| 2850 g13245 i0 89.524 6.38019169329073 210 21 67 1 105 313 293 84 Phaeodactylum tricornutum clone C854 ubiquitin-ribosomal protein fusion S27a mRNA, partial cds blastn 1997 265 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
22222686 22222686 PRJNA562549_P_NODE_14138_length_306_cov_1.102041_g13905_i0 PRJNA562549 14138 306 1.102041 3.37224546 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 298 3.32e-76   NTclustered gi|657012465|gb|KF302574.1| 2850 g13905 i0 87.308 12.9705882352941 260 33 85 0 47 306 1 260 Phaeodactylum tricornutum clone C567 ribosomal protein mRNA, partial cds blastn 3969 298 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27932005 27932005 PRJNA562549_P_NODE_31045_length_212_cov_1.589404_g30812_i0 PRJNA562549 31045 212 1.589404 3.36953648 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 50.8 3.41e-5   NR KAG7349198.1 303405 g30812 i0 57.1 0.495283018867925 35 15 49.5 0 1 105 433 467 KAG7349198.1 glycine hydroxymethyltransferase [Nitzschia inconspicua] diamond 105 50.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28279096 28279096 PRJNA562549_P_NODE_31786_length_210_cov_1.832215_g31553_i0 PRJNA562549 31786 210 1.832215 3.8476515 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 97.1 8.45e-22   NR KAG7339704.1 303405 g31553 i0 69.6 5.91428571428571 69 21 98.6 0 3 209 244 312 KAG7339704.1 acetyl-CoA c-acetyltransferase [Nitzschia inconspicua] diamond 1242 97.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
29921395 29921395 PRJNA562549_P_NODE_32111_length_210_cov_0.872483_g31878_i0 PRJNA562549 32111 210 0.872483 1.8322143 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 63.9 7.97e-10   NR KAL3938159.1 3061772 g31878 i0 58.1 3.57142857142857 62 26 88.6 0 206 21 62 123 KAL3938159.1 MAG: hypothetical protein SGBAC_006866 [Bacillariaceae sp.] diamond 750 63.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30458722 30458722 PRJNA562549_P_NODE_33173_length_208_cov_0.884354_g32940_i0 PRJNA562549 33173 208 0.884354 1.83945632 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 70.1 1.91e-12   NR GKY98337.1 2872254 g32940 i0 58.6 0.836538461538462 58 24 83.7 0 4 177 96 153 GKY98337.1 hypothetical protein MPSEU_000791300 [Mayamaea pseudoterrestris] diamond 174 70.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
30489969 30489969 PRJNA562549_P_NODE_35953_length_203_cov_0.915493_g35720_i0 PRJNA562549 35953 203 0.915493 1.85845079 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 47 6.89e-4   NR CAB9523128.1 568900 g35720 i0 41.5 0.783251231527094 53 31 78.3 0 45 203 92 144 CAB9523128.1 expressed unknown protein [Seminavis robusta] diamond 159 47 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32102313 32102313 PRJNA562549_P_NODE_34338_length_206_cov_0.896552_g34105_i0 PRJNA562549 34338 206 0.896552 1.84689712 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 58.9 1.33e-9   NR KAL3790387.1 382360 g34105 i0 52 1.45631067961165 50 24 72.8 0 22 171 1 50 KAL3790387.1 hypothetical protein ACHAWO_011602 [Cyclotella atomus] diamond 300 58.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
32260798 32260798 PRJNA562549_P_NODE_26878_length_227_cov_1.795181_g26645_i0 PRJNA562549 26878 227 1.795181 4.07506087 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 95.9 1.39e-21   NR VEU33732.1 183589 g26645 i0 60.9 0.911894273127753 69 27 91.2 0 2 208 260 328 VEU33732.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 207 95.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
32401119 32401119 PRJNA562549_P_NODE_36059_length_203_cov_0.873239_g35826_i0 PRJNA562549 36059 203 0.873239 1.77267517 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 104 2.45e-24   NR XP_002289964.1 296543 g35826 i0 76.1 1.98029556650246 67 16 99 0 1 201 65 131 XP_002289964.1 the t-complex beta chaperonin-like protein, partial [Thalassiosira pseudonana CCMP1335] diamond 402 105 0.990476190476191 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
32860225 32860225 PRJNA562549_P_NODE_28720_length_220_cov_1.635220_g28487_i0 PRJNA562549 28720 220 1.63522 3.597484 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 108 5.8e-26   NR KAG7341887.1 303405 g28487 i0 65.3 1.02272727272727 75 24 99.5 1 219 1 218 292 KAG7341887.1 NADH:flavin oxidoreductase [Nitzschia inconspicua] diamond 225 108 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);;