contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJEB48872" and tax_clade = "Sar"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1349429 | 1349429 | PRJEB48872_P_NODE_369522_length_245_cov_1.631068_g353710_i0 | PRJEB48872 | 369522 | 245 | 1.631068 | 3.9961166 | Globisporangium rostratifingens | 2711122 | SAR_Eukaryotes | SAR_Eukaryotes | 409 | 1.1399999999999998e-109 | NTclustered | gi|297578576|gb|AY707986.2| | 2711122 | g353710 | i0 | 96.735 | 99.5673469387755 | 245 | 8 | 100 | 0 | 1 | 245 | 2184 | 2428 | Pythium rostratifingens strain CBS 115464 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 | 24394 | 409 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium rostratifingens | ||
| 1365953 | 1365953 | PRJEB48872_P_NODE_86542_length_716_cov_10.868538_g71954_i0 | PRJEB48872 | 86542 | 716 | 10.868538 | 77.81873208 | Phytopythium vexans | 907947 | SAR_Eukaryotes | SAR_Eukaryotes | 817 | 0 | NTclustered | gi|90655144|gb|DQ361265.1| | 907947 | g71954 | i0 | 93.613 | 76.481843575419 | 548 | 33 | 76 | 2 | 1 | 547 | 7 | 553 | Pythium vexans large subunit ribosomal RNA gene, partial sequence | blastn | 54761 | 817 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Phytopythium | Phytopythium vexans | ||
| 3894697 | 3894697 | PRJEB48872_P_NODE_231404_length_349_cov_1.945161_g215593_i0 | PRJEB48872 | 231404 | 349 | 1.945161 | 6.78861189 | Globisporangium rostratum | 2711123 | SAR_Eukaryotes | SAR_Eukaryotes | 579 | 1.2199999999999999e-160 | NTclustered | gi|292680107|dbj|AB468713.1| | 2711123 | g215593 | i0 | 96.562 | 93.2550143266476 | 349 | 12 | 100 | 0 | 1 | 349 | 746 | 398 | Globisporangium rostratum gene for large subunit ribosomal RNA, partial sequence, strain: OPU1441 | blastn | 32546 | 579 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium rostratum | ||
| 3896868 | 3896868 | PRJEB48872_P_NODE_278024_length_304_cov_2.192453_g262212_i0 | PRJEB48872 | 278024 | 304 | 2.192453 | 6.66505712 | Schizocladia ischiensis | 196139 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 9.099999999999999e-82 | NTclustered | gi|2018127600|ref|NC_053868.1| | 196139 | g262212 | i0 | 92.342 | 208.009868421053 | 222 | 17 | 100 | 0 | 7 | 228 | 86125 | 85904 | Schizocladia ischiensis culture CCMP:2287 chloroplast, complete genome | blastn | 63235 | 316 | 1 | Eukaryota | Sar | Schizocladia | Schizocladia ischiensis | ||||||
| 9919008 | 9919008 | PRJEB48872_P_NODE_617808_length_165_cov_0.904762_g601996_i0 | PRJEB48872 | 617808 | 165 | 0.904762 | 1.4928573 | Thalassiosira | 35127 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 2.08e-75 | NTclustered | gi|2632235341|gb|OR922723.1| | 35128 | g601996 | i0 | 98.788 | 100 | 165 | 2 | 100 | 0 | 1 | 165 | 3584 | 3748 | Thalassiosira pseudonana strain AGSB0188 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 | 16500 | 294 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Thalassiosirales | Thalassiosiraceae | Thalassiosira | Thalassiosira pseudonana | ||
| 17919440 | 17919440 | PRJEB48872_P_NODE_215375_length_368_cov_2.012158_g199567_i0 | PRJEB48872 | 215375 | 368 | 2.012158 | 7.40474144 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 580 | 3.609999999999999e-161 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g199567 | i0 | 95.135 | 100.375 | 370 | 15 | 100 | 2 | 1 | 368 | 3736 | 3368 | Colpoda sp. isolate CIL1 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 | 36938 | 580 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 24295963 | 24295963 | PRJEB48872_P_NODE_264860_length_315_cov_8.130435_g249048_i0 | PRJEB48872 | 264860 | 315 | 8.130435 | 25.61087025 | Babesia bigemina | 5866 | SAR_Eukaryotes | SAR_Eukaryotes | 538 | 1.8599999999999993e-148 | NTclustered | gi|833494855|ref|XM_012915027.1| | 5866 | g249048 | i0 | 97.46 | 1498.31428571429 | 315 | 8 | 100 | 0 | 1 | 315 | 226 | 540 | Babesia bigemina hypothetical protein, conserved partial mRNA | blastn | 471969 | 538 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 24298499 | 24298499 | PRJEB48872_P_NODE_319160_length_274_cov_2.076596_g303348_i0 | PRJEB48872 | 319160 | 274 | 2.076596 | 5.68987304 | Phytophthora megasperma | 4788 | SAR_Eukaryotes | SAR_Eukaryotes | 344 | 3.71e-90 | NTclustered | gi|2440150|emb|X75631.1| | 4788 | g303348 | i0 | 89.531 | 100.379562043796 | 277 | 22 | 100 | 7 | 1 | 274 | 3011 | 2739 | P.megasperma gene for 28S ribosomal RNA | blastn | 27504 | 344 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megasperma | ||
| 25216949 | 25216949 | PRJEB48872_P_NODE_680340_length_153_cov_1.429825_g664528_i0 | PRJEB48872 | 680340 | 153 | 1.429825 | 2.18763225 | Chrysophyceae | 2825 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 3.2e-63 | NTclustered | gi|219903753|emb|FM955256.1| | 2996 | g664528 | i0 | 97.945 | 95.4248366013072 | 146 | 3 | 95 | 0 | 8 | 153 | 249 | 394 | Hydrurus foetidus partial 18S rRNA gene | blastn | 14600 | 254 | 1 | Eukaryota | Sar | Chrysophyceae | Hydrurales | Hydruraceae | Hydrurus | Hydrurus foetidus |
Advanced export
JSON shape: default, array, newline-delimited
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);;