contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA565584" and tax_phylum = "Rhodophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 556373 | 556373 | PRJNA565584_P_NODE_221461_length_228_cov_2.890323_g220309_i0 | PRJNA565584 | 221461 | 228 | 2.890323 | 6.58993644 | Chondrus crispus | 2769 | Rhodophyta | other_Eukaryota | 176 | 1.16e-39 | NTclustered | gi|546299754|ref|XM_005710854.1| | 2769 | g220309 | i0 | 83.511 | 18.2675438596491 | 188 | 31 | 82 | 0 | 9 | 196 | 1042 | 1229 | Chondrus crispus mitochondrial F-type ATPase F1 subunit beta, precursor (CHC_T00009073001) mRNA, complete cds | blastn | 4165 | 176 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Gigartinales | Gigartinaceae | Chondrus | Chondrus crispus | |||
| 2410752 | 2410752 | PRJNA565584_P_NODE_67142_length_362_cov_3.391003_g65991_i0 | PRJNA565584 | 67142 | 362 | 3.391003 | 12.27543086 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 195 | 5.39e-45 | NTclustered | gi|52000406|dbj|AB091231.1| | 2771 | g65991 | i0 | 84.848 | 53.1933701657459 | 198 | 24 | 54 | 6 | 1 | 195 | 1123 | 929 | Cyanidium caldarium gene for 18S rRNA, partial sequence, strain: SAG16.91 | blastn | 19256 | 196 | 0.994897959183674 | Eukaryota | Rhodophyta | Bangiophyceae | Cyanidiales | Cyanidiaceae | Cyanidium | Cyanidium caldarium | |||
| 14586057 | 14586057 | PRJNA565584_P_NODE_57572_length_391_cov_8.389937_g56421_i0 | PRJNA565584 | 57572 | 391 | 8.389937 | 32.80465367 | Symphyocladia marchantioides | 88360 | Rhodophyta | other_Eukaryota | 93.5 | 2.2e-14 | NTclustered | gi|2431519202|ref|NC_070152.1| | 88360 | g56421 | i0 | 85.556 | 5.11253196930946 | 90 | 11 | 23 | 2 | 1 | 89 | 13542 | 13630 | Symphyocladia marchantioides isolate PD3704 voucher PD3704 mitochondrion, complete genome | blastn | 1999 | 93.5 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Ceramiales | Rhodomelaceae | Symphyocladia | Symphyocladia marchantioides | |||
| 19682384 | 19682384 | PRJNA565584_P_NODE_191176_length_246_cov_0.890173_g190024_i0 | PRJNA565584 | 191176 | 246 | 0.890173 | 2.18982558 | Ceratodictyon intricatum | 2725877 | Rhodophyta | other_Eukaryota | 141 | 4.61e-29 | NTclustered | gi|116734096|gb|EF033575.1| | 2725877 | g190024 | i0 | 84.138 | 18.020325203252 | 145 | 23 | 59 | 0 | 101 | 245 | 83 | 227 | Ceratodictyon intricatum voucher GWS001072 elongation factor 2 (EF2) gene, partial cds | blastn | 4433 | 141 | 1 | Eukaryota | Rhodophyta | Florideophyceae | Rhodymeniales | Lomentariaceae | Ceratodictyon | Ceratodictyon intricatum | |||
| 20958532 | 20958532 | PRJNA565584_P_NODE_218137_length_236_cov_2.834356_g216985_i0 | PRJNA565584 | 218137 | 236 | 2.834356 | 6.68908016 | Pyropia seriata | 79731 | Rhodophyta | other_Eukaryota | 342 | 1.12e-89 | NTclustered | gi|922081034|gb|KP241942.1| | 79731 | g216985 | i0 | 92.797 | 72.093220338983 | 236 | 17 | 100 | 0 | 1 | 236 | 1819 | 1584 | Pyropia seriata heat shock protein 70c (HSP70c) mRNA, complete cds | blastn | 17014 | 342 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Bangiales | Bangiaceae | Pyropia | Pyropia seriata | |||
| 23508213 | 23508213 | PRJNA565584_P_NODE_185419_length_247_cov_1.505747_g184267_i0 | PRJNA565584 | 185419 | 247 | 1.505747 | 3.71919509 | Pyropia sp. 2 LEY-2017 | 2058400 | Rhodophyta | other_Eukaryota | 357 | 4.22e-94 | NTclustered | gi|1297588698|gb|MG647763.1| | 2058400 | g184267 | i0 | 92.278 | 87.246963562753 | 259 | 8 | 100 | 2 | 1 | 247 | 94 | 352 | Pyropia sp. 2 LEY-2017 voucher LYCN151 small subunit ribosomal RNA gene, partial sequence | blastn | 21550 | 357 | 1 | Eukaryota | Rhodophyta | Bangiophyceae | Bangiales | Bangiaceae | Pyropia | Pyropia sp. 2 LEY-2017 |
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);;