RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA637328", 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 · 18 ✖

tax_clade 1

  • Sar · 18 ✖

bioproject 1

  • PRJNA637328 · 18 ✖

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
1885201 1885201 PRJNA637328_P_NODE_17582_length_247_cov_2.191919_g17105_i0 PRJNA637328 17582 247 2.191919 5.41403993 Gomphonema parvulum 97227 SAR_Eukaryotes SAR_Eukaryotes 340 4.25e-89   NTclustered gi|2444483253|gb|OP718170.1| 97227 g17105 i0 91.87 100.404858299595 246 16 99 2 1 245 6195 5953 Gomphonema parvulum mitochondrion, complete genome blastn 24800 340 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
3706780 3706780 PRJNA637328_P_NODE_7823_length_327_cov_6.845324_g7348_i0 PRJNA637328 7823 327 6.845324 22.38420948 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 584 2.45e-162   NTclustered gi|2579686273|ref|NC_082433.1| 426669 g7348 i0 99.077 197.752293577982 325 3 99 0 1 325 66155 65831 Ulnaria ulna chloroplast, complete genome blastn 64665 584 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria ulna
6258777 6258777 PRJNA637328_P_NODE_5905_length_362_cov_3.006390_g5430_i0 PRJNA637328 5905 362 3.00639 10.8831318 Diatoma 2862 SAR_Eukaryotes SAR_Eukaryotes 595 1.2599999999999995e-165   NTclustered gi|817090855|gb|KM009487.1| 426639 g5430 i0 96.399 106.729281767956 361 13 99 0 1 361 762 402 Diatoma tenue isolate utcc62 PSII protein D1 (psbA) gene, partial cds; chloroplast blastn 38636 595 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Diatoma Diatoma tenuis
10813358 10813358 PRJNA637328_P_NODE_7869_length_326_cov_2.703971_g7394_i0 PRJNA637328 7869 326 2.703971 8.81494546 Ulnaria acus 1436140 SAR_Eukaryotes SAR_Eukaryotes 436 7.239999999999999e-118   NTclustered gi|283795033|ref|NC_013710.1| 1436140 g7394 i0 90.798 99.5950920245399 326 30 100 0 1 326 31378 31703 Synedra acus mitochondrion, complete genome blastn 32468 436 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria acus
11358493 11358493 PRJNA637328_P_NODE_10609_length_288_cov_12.242678_g10134_i0 PRJNA637328 10609 288 12.242678 35.25891264 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 520 6.079999999999999e-143   NTclustered gi|1209331308|gb|KY320366.1| 63141 g10134 i0 99.303 99.6527777777778 287 2 99 0 1 287 1415 1129 Navicula salinicola strain TA204 18S ribosomal RNA gene, partial sequence blastn 28700 525 0.990476190476191 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula salinicola
14637996 14637996 PRJNA637328_P_NODE_21272_length_221_cov_8.982558_g20795_i0 PRJNA637328 21272 221 8.982558 19.85145318 Navicula avium 2018708 SAR_Eukaryotes SAR_Eukaryotes 357 3.71e-94   NTclustered gi|2202538973|gb|OM891879.1| 2018708 g20795 i0 99.49 61.9004524886878 196 1 89 0 24 219 5550 5355 Haslea avium 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 13680 357 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula avium
14638042 14638042 PRJNA637328_P_NODE_5312_length_381_cov_2.891566_g4837_i0 PRJNA637328 5312 381 2.891566 11.01686646 Ulnaria acus 1436140 SAR_Eukaryotes SAR_Eukaryotes 545 1.37e-150   NTclustered gi|283795033|ref|NC_013710.1| 1436140 g4837 i0 92.67 15.2125984251969 382 22 99 6 1 379 32068 32446 Synedra acus mitochondrion, complete genome blastn 5796 545 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria acus
15911967 15911967 PRJNA637328_P_NODE_3173_length_499_cov_11.455556_g2709_i0 PRJNA637328 3173 499 11.455556 57.16322444 Encyonema minutum 431330 SAR_Eukaryotes SAR_Eukaryotes 664 0   NTclustered gi|168145881|emb|AM710515.1| 431330 g2709 i0 98.667 77.5571142284569 375 3 75 2 1 374 20 393 Encyonema minutum partial 28S rRNA gene, strain AT-137.13 blastn 38701 664 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Encyonema Encyonema minutum
17186882 17186882 PRJNA637328_P_NODE_12314_length_274_cov_3.555556_g11838_i0 PRJNA637328 12314 274 3.555556 9.74222344 Ulnaria acus 1436140 SAR_Eukaryotes SAR_Eukaryotes 392 1.3099999999999999e-104   NTclustered gi|283795033|ref|NC_013710.1| 1436140 g11838 i0 92.5 93.1313868613139 280 12 99 5 3 274 29305 29027 Synedra acus mitochondrion, complete genome blastn 25518 392 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria acus
17187038 17187038 PRJNA637328_P_NODE_3374_length_483_cov_34.728111_g2908_i0 PRJNA637328 3374 483 34.728111 167.73677613 Thalassionema frauenfeldii 186022 SAR_Eukaryotes SAR_Eukaryotes 580 4.8499999999999986e-161   NTclustered gi|18698485|gb|AF417686.1| 186022 g2908 i0 88.66 76.935817805383 485 44 99 11 3 483 29 506 Thalassionema frauenfeldii strain CCMP1798 large subunit ribosomal RNA gene, partial sequence blastn 37160 580 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Thalassionemales Thalassionemataceae Thalassionema Thalassionema frauenfeldii
17732962 17732962 PRJNA637328_P_NODE_10194_length_292_cov_23.489712_g9719_i0 PRJNA637328 10194 292 23.489712 68.58995904 Fragilariophyceae 33853 SAR_Eukaryotes SAR_Eukaryotes 525 1.3299999999999994e-144   NTclustered gi|2579686273|ref|NC_082433.1| 426669 g9719 i0 99.31 193.52397260274 290 2 99 0 3 292 66180 66469 Ulnaria ulna chloroplast, complete genome blastn 56509 525 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria ulna
18461084 18461084 PRJNA637328_P_NODE_1535_length_756_cov_18.954738_g918_i1 PRJNA637328 1535 756 18.954738 143.29781928 Tabularia sp. 2508070 SAR_Eukaryotes SAR_Eukaryotes 749 0   NTclustered gi|2862228887|gb|PQ645521.1| 2508070 g918 i1 95.349 74.6137566137566 473 19 62 3 173 644 4199 3729 Tabularia sp. isolate AGSB0382 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 56408 749 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Tabularia Tabularia sp.
20281520 20281520 PRJNA637328_P_NODE_1016_length_949_cov_12.198889_g706_i0 PRJNA637328 1016 949 12.198889 115.76745661 Navicula 50949 SAR_Eukaryotes SAR_Eukaryotes 811 0   NTclustered gi|2862228860|gb|PQ645494.1| 1923966 g706 i0 99.113 72.31822971549 451 4 77 0 327 777 3442 3892 Navicula sp. isolate AGSB0344 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 68630 811 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
20281566 20281566 PRJNA637328_P_NODE_5316_length_381_cov_2.689759_g4841_i0 PRJNA637328 5316 381 2.689759 10.24798179 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 488 2.34e-133   NTclustered gi|2739942924|dbj|LC814784.1| 41457 g4841 i0 89.817 101.593175853018 383 35 99 4 1 380 32238 31857 Skeletonema pseudocostatum NIES-2843 mitochondrial DNA, complete genome blastn 38707 488 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema pseudocostatum
22286091 22286091 PRJNA637328_P_NODE_14998_length_258_cov_8.507177_g14521_i0 PRJNA637328 14998 258 8.507177 21.94851666 Navicula tripunctata 431568 SAR_Eukaryotes SAR_Eukaryotes 457 4.26e-124   NTclustered gi|168145932|emb|AM710584.1| 431568 g14521 i0 98.833 99.4031007751938 257 2 99 1 3 258 30 286 Navicula tripunctata partial 28S rRNA gene, strain AT-202.01 blastn 25646 457 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula tripunctata
28975884 28975884 PRJNA637328_P_NODE_11648_length_279_cov_4.000000_g11172_i0 PRJNA637328 11648 279 4 11.16 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 106 2.6799999999999998e-24   NR KAI2512668.1 210448 g11172 i0 71.6 0.720430107526882 67 17 69.9 2 277 83 848 914 KAI2512668.1 hypothetical protein MHU86_1664 [Fragilaria crotonensis] diamond 201 106 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29303932 29303932 PRJNA637328_P_NODE_14309_length_262_cov_1.849765_g13832_i0 PRJNA637328 14309 262 1.849765 4.8463843 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 79 8.27e-15   NR EJK71780.1 159749 g13832 i0 43.2 4.93511450381679 88 48 98.5 1 259 2 287 374 EJK71780.1 hypothetical protein THAOC_06746, partial [Thalassiosira oceanica] diamond 1293 79 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
29354770 29354770 PRJNA637328_P_NODE_19849_length_235_cov_2.844086_g19372_i0 PRJNA637328 19849 235 2.844086 6.6836021 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 81.3 2.21e-16   NR KAI2502670.1 210448 g19372 i0 73.1 1.32765957446809 52 14 66.4 0 234 79 216 267 KAI2502670.1 GDP-mannose 4-6 dehydratase [Fragilaria crotonensis] diamond 312 81.3 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis

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