contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA753704" and tax_clade = "core chlorophytes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3282301 | 3282301 | PRJNA753704_P_NODE_16463_length_296_cov_3.923767_g16102_i0 | PRJNA753704 | 16463 | 296 | 3.923767 | 11.61435032 | Prototheca wickerhamii | 3111 | Plants | Plants | 128 | 4.44e-25 | NTclustered | gi|14212|emb|X68722.1| | 3111 | g16102 | i0 | 85.156 | 48.4560810810811 | 128 | 16 | 43 | 3 | 1 | 127 | 2239 | 2364 | P.wickerhamii mitochondrial gene for large ribosomal RNA | blastn | 14343 | 128 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 12210511 | 12210511 | PRJNA753704_P_NODE_19310_length_276_cov_1.536946_g18949_i0 | PRJNA753704 | 19310 | 276 | 1.536946 | 4.24197096 | Dunaliella salina | 3046 | Plants | Plants | 73.1 | 1.95e-8 | NTclustered | gi|383930345|ref|NC_016732.1| | 3046 | g18949 | i0 | 87.692 | 41.2355072463768 | 65 | 5 | 23 | 2 | 134 | 197 | 133610 | 133548 | Dunaliella salina chloroplast, complete genome | blastn | 11381 | 73.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 12681763 | 12681763 | PRJNA753704_P_NODE_29490_length_233_cov_3.087500_g29129_i0 | PRJNA753704 | 29490 | 233 | 3.0875 | 7.193875 | Eukaryota | 2759 | Plants | Plants | 431 | 2.2899999999999996e-116 | NTclustered | gi|1201359270|gb|MF040792.1| | 3078 | g29129 | i0 | 100 | 99.9914163090129 | 233 | 0 | 100 | 0 | 1 | 233 | 108 | 340 | Auxenochlorella pyrenoidosa isolate HIT9 18S ribosomal RNA gene, partial sequence | blastn | 23298 | 431 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 14760118 | 14760118 | PRJNA753704_P_NODE_6032_length_467_cov_10.647208_g5671_i0 | PRJNA753704 | 6032 | 467 | 10.647208 | 49.72246136 | Jaagichlorella hainangensis | 445995 | Plants | Plants | 276 | 2.47e-69 | NTclustered | gi|1863124765|ref|NC_048968.1| | 445995 | g5671 | i0 | 79.009 | 25.2612419700214 | 424 | 73 | 89 | 16 | 51 | 466 | 5692 | 5277 | Jaagichlorella hainangensis culture CGMCC:NO7101 mitochondrion, complete genome | blastn | 11797 | 276 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Jaagichlorella | Jaagichlorella hainangensis | |
| 16033574 | 16033574 | PRJNA753704_P_NODE_13333_length_326_cov_2.889328_g12972_i0 | PRJNA753704 | 13333 | 326 | 2.889328 | 9.41920928 | Helicosporidium sp. ex Simulium jonesi | 145475 | Plants | Plants | 183 | 1.04e-41 | NTclustered | gi|386800430|ref|NC_017841.1| | 145475 | g12972 | i0 | 77.37 | 51.8803680981595 | 327 | 62 | 98 | 9 | 1 | 318 | 10717 | 11040 | Helicosporidium sp. ex Simulium jonesi mitochondrion, complete genome | blastn | 16913 | 183 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Helicosporidium | Helicosporidium sp. ex Simulium jonesi | |
| 17779708 | 17779708 | PRJNA753704_P_NODE_1474_length_895_cov_5.086375_g1168_i0 | PRJNA753704 | 1474 | 895 | 5.086375 | 45.52305625 | Marvania | 97104 | Plants | Plants | 91.6 | 1.91e-13 | NTclustered | gi|2724824493|gb|PP746561.1| | 97105 | g1168 | i0 | 88.312 | 0.391061452513966 | 77 | 8 | 8 | 1 | 814 | 889 | 48115 | 48191 | Marvania geminata culture SAG:12.88 mitochondrion, complete genome | blastn | 350 | 91.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Marvania | Marvania geminata |
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);;