RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA385073", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 9 ✖

tax_clade 1

bioproject 1

  • PRJNA385073 · 9 ✖

analysis 1

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
2956396 2956396 PRJNA385073_P_NODE_23943_length_299_cov_1.362832_g23781_i0 PRJNA385073 23943 299 1.362832 4.07486768 Lecythium sp. 3678_261K 238773 SAR_Eukaryotes SAR_Eukaryotes 246 1.19e-60   NTclustered gi|33089893|gb|AY283756.1| 238773 g23781 i0 92.899 66.8227424749164 169 12 57 0 131 299 768 600 Lecythium sp. 3678_261K actin gene, partial cds blastn 19980 246 1 Eukaryota Sar   Cercozoa Thecofilosea Tectofilosida Chlamydophryidae Lecythium Lecythium sp. 3678_261K
4904278 4904278 PRJNA385073_P_NODE_41844_length_251_cov_0.865169_g41682_i0 PRJNA385073 41844 251 0.865169 2.17157419 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 76.8 1.35e-9   NTclustered gi|220983369|dbj|AB453005.1| 29199 g41682 i0 82.418 5.20318725099602 91 12 35 4 161 248 3100 3011 Chlorarachnion reptans gene for nuclear large subunit ribosomal RNA, partial sequence blastn 1306 76.8 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Chlorarachnion Chlorarachnion reptans
5509326 5509326 PRJNA385073_P_NODE_21145_length_312_cov_2.188285_g20983_i0 PRJNA385073 21145 312 2.188285 6.8274492 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 148 3.6199999999999997e-31   NTclustered gi|1402550473|gb|MH488759.1| 2231160 g20983 i0 97.701 3.68910256410256 87 0 42 2 152 236 787 873 Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 1151 148 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
10610289 10610289 PRJNA385073_P_NODE_62849_length_226_cov_2.751634_g62687_i0 PRJNA385073 62849 226 2.751634 6.21869284 Paulinella micropora 1928728 SAR_Eukaryotes SAR_Eukaryotes 261 3.07e-65   NTclustered gi|1389527545|dbj|LC383945.1| 1928728 g62687 i0 88.426 95.0575221238938 216 25 96 0 1 216 464 249 Paulinella micropora gene for actin, complete cds blastn 21483 261 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Paulinellidae Paulinella Paulinella micropora
18256923 18256923 PRJNA385073_P_NODE_10535_length_399_cov_1.693252_g10374_i0 PRJNA385073 10535 399 1.693252 6.75607548 Lecythium sp. 3678_261K 238773 SAR_Eukaryotes SAR_Eukaryotes 551 3.089999999999999e-152   NTclustered gi|33089893|gb|AY283756.1| 238773 g10374 i0 91.688 73.4260651629073 397 33 99 0 1 397 611 215 Lecythium sp. 3678_261K actin gene, partial cds blastn 29297 551 1 Eukaryota Sar   Cercozoa Thecofilosea Tectofilosida Chlamydophryidae Lecythium Lecythium sp. 3678_261K
18256933 18256933 PRJNA385073_P_NODE_10955_length_393_cov_3.465625_g10794_i0 PRJNA385073 10955 393 3.465625 13.61990625 Rosculus piscicus 2231164 SAR_Eukaryotes SAR_Eukaryotes 468 3.15e-127   NTclustered gi|1402550472|gb|MH488758.1| 2231164 g10794 i0 91.092 32.3307888040712 348 27 88 4 1 345 823 1169 Rosculus piscicus isolate GS5C small subunit ribosomal RNA gene, partial sequence blastn 12706 468 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus piscicus
18257500 18257500 PRJNA385073_P_NODE_36295_length_262_cov_2.206349_g36133_i0 PRJNA385073 36295 262 2.206349 5.78063438 Guttulinopsis rogosa 2231170 SAR_Eukaryotes SAR_Eukaryotes 412 9.52e-111   NTclustered gi|1402550488|gb|MH488774.1| 2231170 g36133 i0 95.094 7.53053435114504 265 8 100 3 1 262 365 103 Guttulinopsis rogosa isolate FOLDEDA sequence blastn 1973 412 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Guttulinopsis Guttulinopsis rogosa
20807569 20807569 PRJNA385073_P_NODE_36537_length_262_cov_1.185185_g36375_i0 PRJNA385073 36537 262 1.185185 3.1051847 Rosculus piscicus 2231164 SAR_Eukaryotes SAR_Eukaryotes 265 2.8199999999999996e-66   NTclustered gi|1402550472|gb|MH488758.1| 2231164 g36375 i0 87.137 3.65648854961832 241 22 92 4 1 241 45 276 Rosculus piscicus isolate GS5C small subunit ribosomal RNA gene, partial sequence blastn 958 265 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus piscicus
20808038 20808038 PRJNA385073_P_NODE_60157_length_238_cov_2.127273_g59995_i0 PRJNA385073 60157 238 2.127273 5.06290974 Guttulinopsis rogosa 2231170 SAR_Eukaryotes SAR_Eukaryotes 337 5.27e-88   NTclustered gi|1402550485|gb|MH488771.1| 2231170 g59995 i0 92.149 7.67226890756303 242 13 100 3 1 238 286 47 Guttulinopsis rogosa isolate ATCC 50030 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 1826 337 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Guttulinopsis Guttulinopsis rogosa

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