RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA1008624" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

  • Sar · 12 ✖

bioproject 1

  • PRJNA1008624 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
3551910 3551910 PRJNA1008624_P_NODE_2843_length_510_cov_5.600868_g2662_i0 PRJNA1008624 2843 510 5.600868 28.5644268 root 1 Root_unresolved Root_unresolved 909 0   NTclustered gi|197359040|gb|FJ002189.1| 29204 g2662 i0 99.016 111.362745098039 508 3 99 2 3 508 859 352 Cyclotella cryptica isolate C114 16S ribosomal RNA gene, partial sequence; chloroplast blastn 56795 918 0.990196078431373 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
3980450 3980450 PRJNA1008624_P_NODE_16084_length_211_cov_5.796296_g15896_i0 PRJNA1008624 16084 211 5.796296 12.23018456 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 366 5.83e-97   NTclustered gi|1169296926|gb|KY364696.1| 29205 g15896 i0 98.551 78.9194312796209 207 3 98 0 4 210 5617 5823 Cyclotella meneghiniana 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 16652 366 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
4829353 4829353 PRJNA1008624_P_NODE_3644_length_450_cov_1.850374_g3458_i0 PRJNA1008624 3644 450 1.850374 8.326683 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 784 0   NTclustered gi|1803023461|gb|MN937452.1| 2850 g3458 i0 98.427 196.635555555556 445 7 99 0 3 447 68871 68427 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 88486 787 0.996188055908513 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
6532070 6532070 PRJNA1008624_P_NODE_12566_length_236_cov_1.620321_g12378_i0 PRJNA1008624 12566 236 1.620321 3.82395756 Trithigmostoma cucullulus 1346499 SAR_Eukaryotes SAR_Eukaryotes 274 4.15e-69   NTclustered gi|759083539|gb|KM222156.1| 1346499 g12378 i0 89.593 74.1652542372881 221 15 92 6 12 228 112 328 Trithigmostoma cucullulus voucher CXM08110902 large subunit ribosomal RNA gene, partial sequence blastn 17503 274 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Trithigmostoma Trithigmostoma cucullulus
6532632 6532632 PRJNA1008624_P_NODE_32326_length_165_cov_0.896552_g32138_i0 PRJNA1008624 32326 165 0.896552 1.4793108 Nitzschia reversa 2675857 SAR_Eukaryotes SAR_Eukaryotes 150 4.76e-32   NTclustered gi|2721953992|gb|OR464345.1| 2675857 g32138 i0 92.381 62.8363636363636 105 8 64 0 32 136 55547 55443 Nitzschia reversa mitochondrion, complete genome blastn 10368 150 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
9929322 9929322 PRJNA1008624_P_NODE_10228_length_261_cov_1.495283_g10040_i0 PRJNA1008624 10228 261 1.495283 3.90268863 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 449 7.22e-122   NTclustered gi|98978883|gb|DQ512402.1| 29205 g10040 i0 97.71 100.314176245211 262 4 99 1 1 260 340 79 Cyclotella menegheniana strain F8 large subunit ribosomal RNA gene, partial sequence blastn 26182 449 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
10357223 10357223 PRJNA1008624_P_NODE_18289_length_199_cov_2.253333_g18101_i0 PRJNA1008624 18289 199 2.253333 4.48413267 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 357 3.2699999999999996e-94   NTclustered gi|512134943|gb|JX178902.1| 1295638 g18101 i0 99.49 98.5879396984925 196 1 98 0 1 196 1376 1181 Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 19619 357 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
11633356 11633356 PRJNA1008624_P_NODE_9270_length_275_cov_1.398230_g9082_i0 PRJNA1008624 9270 275 1.39823 3.8451325 Nitzschia anatoliensis 2862141 SAR_Eukaryotes SAR_Eukaryotes 398 2.8199999999999996e-106   NTclustered gi|2072715385|gb|MT740317.1| 2862141 g9082 i0 93.04 99.1018181818182 273 17 99 2 2 273 5743 5472 Nitzschia anatoliensis clone SZCZ E372 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 27253 398 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia anatoliensis
12908002 12908002 PRJNA1008624_P_NODE_25951_length_172_cov_1.406504_g25763_i0 PRJNA1008624 25951 172 1.406504 2.41918688 Navicula ramosissima 265559 SAR_Eukaryotes SAR_Eukaryotes 263 6.12e-66   NTclustered gi|1102548834|ref|NC_031848.1| 265559 g25763 i0 94.675 96.5 169 9 98 0 4 172 20901 20733 Navicula ramosissima voucher 10.TA439.Nram.mt mitochondrion, complete genome blastn 16598 263 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula ramosissima
22678122 22678122 PRJNA1008624_P_NODE_12078_length_240_cov_3.214660_g11890_i0 PRJNA1008624 12078 240 3.21466 7.715184 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 388 1.45e-103   NTclustered gi|1169296927|gb|KY364697.1| 29204 g11890 i0 96.203 99.3458333333333 237 9 99 0 1 237 4270 4034 Cyclotella cryptica 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 23843 388 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
23106234 23106234 PRJNA1008624_P_NODE_14519_length_221_cov_1.622093_g14331_i0 PRJNA1008624 14519 221 1.622093 3.58482553 Navicula avium 2018708 SAR_Eukaryotes SAR_Eukaryotes 211 3.05e-50   NTclustered gi|2721953916|gb|OR464343.1| 2018708 g14331 i0 86.598 16.5882352941176 194 22 87 4 3 194 47072 47263 Haslea avium mitochondrion, complete genome blastn 3666 211 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula avium
24380081 24380081 PRJNA1008624_P_NODE_17260_length_205_cov_1.179487_g17072_i0 PRJNA1008624 17260 205 1.179487 2.41794835 Amphifilidae sp. H-1 1407012 SAR_Eukaryotes SAR_Eukaryotes 363 7.279999999999998e-96   NTclustered gi|550533551|dbj|AB856528.1| 1407012 g17072 i0 99.01 79.1658536585366 202 2 99 0 1 202 908 707 Amphifilidae sp. H-1 gene for 18S ribosomal RNA, partial sequence blastn 16229 363 1 Eukaryota Sar     Bigyra Amphifilida Amphifilaceae   Amphifilidae sp. H-1

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