contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA682370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 664327 | 664327 | PRJNA682370_S_NODE_21981_length_156_cov_1.264463_g21369_i0 | PRJNA682370 | 21981 | 156 | 1.264463 | 1.97256228 | Tetraselmis suecica | 270643 | Plants | Plants | 134 | 4.4600000000000006e-27 | NTclustered | gi|1486933343|gb|MF957257.1| | 270643 | g21369 | i0 | 82.468 | 40.5448717948718 | 154 | 25 | 98 | 2 | 4 | 156 | 999 | 847 | Tetraselmis suecica heat shock protein 70 mRNA, complete cds | blastn | 6325 | 134 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorodendrophyceae | Chlorodendrales | Chlorodendraceae | Tetraselmis | Tetraselmis suecica | |
| 664537 | 664537 | PRJNA682370_S_NODE_7061_length_287_cov_2.134921_g6449_i0 | PRJNA682370 | 7061 | 287 | 2.134921 | 6.12722327 | Dicloster acuatus | 91190 | Plants | Plants | 134 | 9.21e-27 | NTclustered | gi|2724824305|gb|PP746556.1| | 91190 | g6449 | i0 | 80.925 | 76.0313588850174 | 173 | 30 | 60 | 3 | 43 | 214 | 1587 | 1417 | Dicloster acuatus culture SAG:41.98 mitochondrion, complete genome | blastn | 21821 | 134 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Dicloster | Dicloster acuatus | |
| 5003002 | 5003002 | PRJNA682370_S_NODE_15064_length_184_cov_2.120805_g14452_i0 | PRJNA682370 | 15064 | 184 | 2.120805 | 3.9022812 | Trebouxiaceae | 2507902 | Plants | Plants | 126 | 9.12e-25 | NTclustered | gi|1750939486|gb|MH917293.1| | 1825957 | g14452 | i0 | 91.304 | 98.8315217391304 | 92 | 8 | 50 | 0 | 47 | 138 | 15464 | 15373 | Trebouxia sp. TR9 mitochondrion, complete genome | blastn | 18185 | 126 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia lynnae |
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);;