RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 27 ✖

tax_clade 1

bioproject 1

  • PRJNA1148190 · 27 ✖

analysis 1

  • blastn · 27 ✖

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
297039 297039 PRJNA1148190_P_NODE_534361_length_260_cov_1.310160_g523188_i0 PRJNA1148190 534361 260 1.31016 3.406416 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 267 7.77e-67   NTclustered gi|223994580|ref|XM_002286938.1| 296543 g523188 i0 99.32 0.565384615384615 147 1 57 0 114 260 1 147 Thalassiosira pseudonana CCMP1335 predicted protein mRNA blastn 147 267 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
299677 299677 PRJNA1148190_P_NODE_748841_length_243_cov_0.905882_g737668_i0 PRJNA1148190 748841 243 0.905882 2.20129326 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 449 6.65e-122   NTclustered gi|224012716|ref|XM_002294975.1| 296543 g737668 i0 100 1 243 0 100 0 1 243 323 81 Thalassiosira pseudonana CCMP1335 predicted protein partial mRNA blastn 243 449 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
1566897 1566897 PRJNA1148190_P_NODE_211302_length_368_cov_1.044068_g200132_i0 PRJNA1148190 211302 368 1.044068 3.84217024 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 680 0   NTclustered gi|1538979133|gb|MH113811.1| 303400 g200132 i0 100 23 368 0 100 0 1 368 99365 98998 Nitzschia palea chloroplast, complete genome blastn 8464 680 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
2310184 2310184 PRJNA1148190_P_NODE_350542_length_300_cov_1.563877_g339369_i0 PRJNA1148190 350542 300 1.563877 4.691631 Skeletonema 2842 SAR_Eukaryotes SAR_Eukaryotes 145 4.48e-30   NTclustered gi|2728403597|gb|PP777232.1| 41457 g339369 i0 91.429 34.5 105 9 35 0 196 300 5119 5223 Skeletonema pseudocostatum strain CNS00493 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 10350 145 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema pseudocostatum
4125930 4125930 PRJNA1148190_P_NODE_688504_length_246_cov_0.890173_g677331_i0 PRJNA1148190 688504 246 0.890173 2.18982558 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 296 9.3e-76   NTclustered gi|1538979133|gb|MH113811.1| 303400 g677331 i0 93.467 0.808943089430894 199 13 81 0 48 246 62454 62256 Nitzschia palea chloroplast, complete genome blastn 199 296 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
6670131 6670131 PRJNA1148190_P_NODE_209946_length_369_cov_1.040541_g198776_i0 PRJNA1148190 209946 369 1.040541 3.83959629 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 660 0   NTclustered gi|1538979133|gb|MH113811.1| 303400 g198776 i0 98.916 17.7018970189702 369 4 100 0 1 369 66227 65859 Nitzschia palea chloroplast, complete genome blastn 6532 660 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
7953256 7953256 PRJNA1148190_P_NODE_786927_length_241_cov_0.916667_g775754_i0 PRJNA1148190 786927 241 0.916667 2.20916747 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 359 1.1399999999999999e-94   NTclustered gi|224005968|ref|XM_002291909.1| 296543 g775754 i0 99.492 0.817427385892116 197 1 82 0 1 197 520 324 Thalassiosira pseudonana CCMP1335 predicted protein partial mRNA blastn 197 359 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
9221387 9221387 PRJNA1148190_P_NODE_276868_length_330_cov_1.326848_g265697_i0 PRJNA1148190 276868 330 1.326848 4.3785984 Eucampia zodiacus 444606 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.031   NTclustered gi|2091535207|ref|NC_057645.1| 444606 g265697 i0 100 0.0848484848484849 28 0 8 0 114 141 37044 37017 Eucampia zodiacus strain CNS00061 chloroplast, complete genome blastn 28 52.8 1 Eukaryota Sar   Bacillariophyta Mediophyceae Hemiaulales Hemiaulaceae Eucampia Eucampia zodiacus
11239432 11239432 PRJNA1148190_P_NODE_705769_length_245_cov_0.895349_g694596_i0 PRJNA1148190 705769 245 0.895349 2.19360505 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 420 5.26e-113   NTclustered gi|1538979133|gb|MH113811.1| 303400 g694596 i0 97.551 45.2612244897959 245 6 100 0 1 245 104597 104841 Nitzschia palea chloroplast, complete genome blastn 11089 420 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
11778293 11778293 PRJNA1148190_P_NODE_747350_length_243_cov_0.905882_g736177_i0 PRJNA1148190 747350 243 0.905882 2.20129326 Minidiscus spinulatus 2593073 SAR_Eukaryotes SAR_Eukaryotes 394 3.16e-105   NTclustered gi|2328369080|ref|NC_067956.1| 2593073 g736177 i0 95.6 103.707818930041 250 4 100 1 1 243 22664 22415 Minidiscus spinulatus chloroplast, complete genome blastn 25201 394 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Minidiscus Minidiscus spinulatus
13050232 13050232 PRJNA1148190_P_NODE_505851_length_265_cov_1.989583_g494678_i0 PRJNA1148190 505851 265 1.989583 5.27239495 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 473 4.3599999999999987e-129   NTclustered gi|1538979133|gb|MH113811.1| 303400 g494678 i0 98.868 32.3471698113208 265 3 100 0 1 265 46506 46242 Nitzschia palea chloroplast, complete genome blastn 8572 473 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
13050304 13050304 PRJNA1148190_P_NODE_511591_length_264_cov_1.612565_g500418_i0 PRJNA1148190 511591 264 1.612565 4.2571716 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 481 2.599999999999999e-131   NTclustered gi|1538979133|gb|MH113811.1| 303400 g500418 i0 99.62 56.6363636363636 263 1 99 0 1 263 95634 95372 Nitzschia palea chloroplast, complete genome blastn 14952 481 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
13052108 13052108 PRJNA1148190_P_NODE_648231_length_248_cov_0.880000_g637058_i0 PRJNA1148190 648231 248 0.88 2.1824 Navicula veneta 138539 SAR_Eukaryotes SAR_Eukaryotes 459 1.13e-124   NTclustered gi|2088232843|ref|NC_056794.1| 138539 g637058 i0 100 2 248 0 100 0 1 248 77932 78179 Navicula veneta isolate SZCZR1826 chloroplast, complete genome blastn 496 459 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula veneta
14325171 14325171 PRJNA1148190_P_NODE_478192_length_271_cov_1.181818_g467019_i0 PRJNA1148190 478192 271 1.181818 3.20272678 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 479 9.62e-131   NTclustered gi|1538979133|gb|MH113811.1| 303400 g467019 i0 98.524 63.2066420664207 271 4 100 0 1 271 30715 30445 Nitzschia palea chloroplast, complete genome blastn 17129 479 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
15599188 15599188 PRJNA1148190_P_NODE_479213_length_271_cov_0.883838_g468040_i0 PRJNA1148190 479213 271 0.883838 2.39520098 Nitzschia sp. DOCU1 3041873 SAR_Eukaryotes SAR_Eukaryotes 163 1.1e-35   NTclustered gi|2504366780|emb|OX596003.1| 3041873 g468040 i0 79.012 23.6236162361624 243 47 89 3 31 271 33001 32761 Nitzschia sp. DOCU1 genome assembly, organelle: plastid:chloroplast blastn 6402 163 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. DOCU1
15600230 15600230 PRJNA1148190_P_NODE_560513_length_255_cov_1.324176_g549340_i0 PRJNA1148190 560513 255 1.324176 3.3766488 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 472 1.5e-128   NTclustered gi|74325165|ref|NC_007405.1| 35128 g549340 i0 100 2 255 0 100 0 1 255 40264 40010 Thalassiosira pseudonana mitochondrion, complete genome blastn 510 472 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
16336600 16336600 PRJNA1148190_P_NODE_189153_length_385_cov_2.631410_g177983_i0 PRJNA1148190 189153 385 2.63141 10.1309285 Fistulifera 880756 SAR_Eukaryotes SAR_Eukaryotes 95.3 6.02e-15   NTclustered gi|2088232451|ref|NC_056789.1| 880757 g177983 i0 91.429 1.23896103896104 70 5 18 1 279 347 5419 5350 Fistulifera saprophila isolate SZCZR1829 mitochondrion, complete genome blastn 477 95.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera saprophila
16872940 16872940 PRJNA1148190_P_NODE_451974_length_276_cov_1.290640_g440801_i0 PRJNA1148190 451974 276 1.29064 3.5621664 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 403 6.08e-108   NTclustered gi|224015670|ref|XM_002297449.1| 296543 g440801 i0 99.548 0.800724637681159 221 1 80 0 56 276 903 683 Thalassiosira pseudonana CCMP1335 predicted protein partial mRNA blastn 221 403 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
16876967 16876967 PRJNA1148190_P_NODE_765874_length_242_cov_0.911243_g754701_i0 PRJNA1148190 765874 242 0.911243 2.20520806 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 392 1.1299999999999999e-104   NTclustered gi|1538979133|gb|MH113811.1| 303400 g754701 i0 95.868 30.2314049586777 242 10 100 0 1 242 12838 13079 Nitzschia palea chloroplast, complete genome blastn 7316 392 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
18148629 18148629 PRJNA1148190_P_NODE_526155_length_261_cov_2.180851_g514982_i0 PRJNA1148190 526155 261 2.180851 5.69202111 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 472 1.54e-128   NTclustered gi|1538979133|gb|MH113811.1| 303400 g514982 i0 99.234 4.79693486590038 261 2 100 0 1 261 11915 11655 Nitzschia palea chloroplast, complete genome blastn 1252 472 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
20695668 20695668 PRJNA1148190_P_NODE_332397_length_307_cov_1.316239_g321224_i0 PRJNA1148190 332397 307 1.316239 4.04085373 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 556 4.98e-154   NTclustered gi|1538979133|gb|MH113811.1| 303400 g321224 i0 99.349 8.80781758957655 307 2 100 0 1 307 102133 102439 Nitzschia palea chloroplast, complete genome blastn 2704 556 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
21968323 21968323 PRJNA1148190_P_NODE_164038_length_411_cov_1.727811_g152870_i0 PRJNA1148190 164038 411 1.727811 7.10130321 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 754 0   NTclustered gi|1538979133|gb|MH113811.1| 303400 g152870 i0 99.757 119.489051094891 411 1 100 0 1 411 1026 616 Nitzschia palea chloroplast, complete genome blastn 49110 754 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
23247502 23247502 PRJNA1148190_P_NODE_403399_length_286_cov_0.953052_g392226_i0 PRJNA1148190 403399 286 0.953052 2.72572872 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 501 2.18e-137   NTclustered gi|1538979133|gb|MH113811.1| 303400 g392226 i0 98.252 17.4195804195804 286 5 100 0 1 286 52371 52656 Nitzschia palea chloroplast, complete genome blastn 4982 501 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
23251283 23251283 PRJNA1148190_P_NODE_692679_length_245_cov_3.366279_g681506_i0 PRJNA1148190 692679 245 3.366279 8.24738355 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 424 4.07e-114   NTclustered gi|1538979133|gb|MH113811.1| 303400 g681506 i0 98.34 2.97142857142857 241 4 98 0 5 245 64554 64314 Nitzschia palea chloroplast, complete genome blastn 728 424 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
23252248 23252248 PRJNA1148190_P_NODE_772299_length_241_cov_2.291667_g761126_i0 PRJNA1148190 772299 241 2.291667 5.52291747 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 446 8.519999999999999e-121   NTclustered gi|1538979133|gb|MH113811.1| 303400 g761126 i0 100 8.08713692946058 241 0 100 0 1 241 96404 96164 Nitzschia palea chloroplast, complete genome blastn 1949 446 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
24523348 24523348 PRJNA1148190_P_NODE_564600_length_254_cov_1.541436_g553427_i0 PRJNA1148190 564600 254 1.541436 3.91524744 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 464 2.4999999999999994e-126   NTclustered gi|2589355395|ref|NC_077461.1| 29204 g553427 i0 99.606 197.728346456693 254 1 100 0 1 254 70505 70252 Cyclotella cryptica chloroplast, complete genome blastn 50223 464 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
24524728 24524728 PRJNA1148190_P_NODE_673680_length_246_cov_2.225434_g662507_i0 PRJNA1148190 673680 246 2.225434 5.47456764 Tenuicylindrus belgicus 1398096 SAR_Eukaryotes SAR_Eukaryotes 60.2 1.33e-4   NTclustered gi|2328369222|ref|NC_067957.1| 1398096 g662507 i0 89.796 0.434959349593496 49 2 20 3 1 48 95464 95510 Tenuicylindrus belgicus chloroplast, complete genome blastn 107 60.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Leptocylindrales Leptocylindraceae Tenuicylindrus Tenuicylindrus belgicus

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