contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA896758" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 872773 | 872773 | PRJNA896758_P_NODE_12101_length_331_cov_1.112403_g11711_i0 | PRJNA896758 | 12101 | 331 | 1.112403 | 3.68205393 | Chlamydomonas incerta | 51695 | Plants | Plants | 187 | 8.189999999999998e-43 | NTclustered | gi|74272706|gb|DQ122918.1| | 51695 | g11711 | i0 | 83.663 | 70.0030211480363 | 202 | 29 | 60 | 4 | 20 | 219 | 520 | 321 | Chlamydomonas incerta S-adenosyl-L-methionine synthetase (SAMS) mRNA, partial cds | blastn | 23171 | 187 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 1243915 | 1243915 | PRJNA896758_P_NODE_24161_length_246_cov_0.890173_g23771_i0 | PRJNA896758 | 24161 | 246 | 0.890173 | 2.18982558 | Halofilum | 1929135 | Plants | Plants | 455 | 1.4500000000000002e-123 | NTclustered | gi|1189013853|gb|MF034634.1| | 97102 | g23771 | i0 | 100 | 101.272357723577 | 246 | 0 | 100 | 0 | 1 | 246 | 1430 | 1185 | Halofilum salinum strain SAG 1.95 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 | 24913 | 455 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Halofilum | Halofilum salinum | ||
| 1243931 | 1243931 | PRJNA896758_P_NODE_5161_length_500_cov_1.857143_g4772_i0 | PRJNA896758 | 5161 | 500 | 1.857143 | 9.285715 | Eukaryota | 2759 | Plants | Plants | 54.7 | 0.014 | NTclustered | gi|2082258891|ref|XM_043067628.1| | 3055 | g4772 | i0 | 88.636 | 0.612 | 44 | 5 | 9 | 0 | 293 | 336 | 4402 | 4359 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_11g476100v5), mRNA | blastn | 306 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 5976194 | 5976194 | PRJNA896758_P_NODE_3965_length_574_cov_2.668663_g3583_i0 | PRJNA896758 | 3965 | 574 | 2.668663 | 15.31812562 | Pedinomonas sp. UTEX 'LB 1027' | 1108795 | Plants | Plants | 250 | 1.87e-61 | NTclustered | gi|371782101|emb|HE610133.1| | 1108795 | g3583 | i0 | 79.683 | 31.8780487804878 | 379 | 52 | 64 | 18 | 1 | 366 | 4726 | 5092 | Pedinomonas sp. UTEX 1027 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 1027 | blastn | 18298 | 250 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinomonadales | Pedinomonadaceae | Pedinomonas | Pedinomonas sp. UTEX 'LB 1027' | |
| 7621938 | 7621938 | PRJNA896758_P_NODE_12326_length_328_cov_0.925490_g11936_i0 | PRJNA896758 | 12326 | 328 | 0.92549 | 3.0356072 | Bryopsis | 3128 | Plants | Plants | 281 | 3.61e-71 | NTclustered | gi|969822372|gb|KT950953.1| | 3129 | g11936 | i0 | 82.911 | 94.6585365853659 | 316 | 50 | 96 | 4 | 12 | 325 | 740 | 427 | Bryopsis maxima actin gene, partial cds | blastn | 31048 | 281 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis maxima | |
| 14900805 | 14900805 | PRJNA896758_P_NODE_25352_length_243_cov_0.905882_g24962_i0 | PRJNA896758 | 25352 | 243 | 0.905882 | 2.20129326 | Stichococcus bacillaris | 37433 | Plants | Plants | 313 | 9.1e-81 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g24962 | i0 | 96.316 | 17.1646090534979 | 190 | 7 | 78 | 0 | 54 | 243 | 7182 | 6993 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 4171 | 313 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 19999499 | 19999499 | PRJNA896758_P_NODE_6716_length_437_cov_3.214286_g6326_i0 | PRJNA896758 | 6716 | 437 | 3.214286 | 14.04642982 | Chlorella variabilis | 554065 | Plants | Plants | 255 | 3e-63 | NTclustered | gi|552813385|ref|XM_005843877.1| | 554065 | g6326 | i0 | 81.731 | 17.6064073226545 | 312 | 52 | 71 | 5 | 63 | 372 | 1369 | 1061 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_59785) mRNA, complete cds | blastn | 7694 | 255 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 25098889 | 25098889 | PRJNA896758_P_NODE_25480_length_243_cov_0.905882_g25090_i0 | PRJNA896758 | 25480 | 243 | 0.905882 | 2.20129326 | Hazenia capsulata | 2202518 | Plants | Plants | 363 | 8.909999999999999e-96 | NTclustered | gi|2724824830|gb|PP746569.1| | 2202518 | g25090 | i0 | 93.827 | 6.0082304526749 | 243 | 12 | 100 | 3 | 1 | 243 | 21060 | 21299 | Hazenia capsulata culture UTEX:1918 mitochondrion, complete genome | blastn | 1460 | 363 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Hazeniaceae | Hazenia | Hazenia capsulata |
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);;