contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA473824" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2997032 | 2997032 | PRJNA473824_P_NODE_134263_length_153_cov_2.017241_g133625_i0 | PRJNA473824 | 134263 | 153 | 2.017241 | 3.08637873 | Jenufa minuta | 993092 | Plants | Plants | 259 | 6.88e-65 | NTclustered | gi|1829768154|ref|NC_046780.1| | 993092 | g133625 | i0 | 97.386 | 1 | 153 | 3 | 100 | 1 | 1 | 153 | 21797 | 21646 | Jenufa minuta culture CAUP:H8102 mitochondrion, complete genome | blastn | 153 | 259 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 2997707 | 2997707 | PRJNA473824_P_NODE_44323_length_184_cov_1.857143_g43685_i0 | PRJNA473824 | 44323 | 184 | 1.857143 | 3.41714312 | Jenufa minuta | 993092 | Plants | Plants | 340 | 2.99e-89 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g43685 | i0 | 100 | 100.603260869565 | 184 | 0 | 100 | 0 | 1 | 184 | 45826 | 46009 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 18511 | 340 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 4273596 | 4273596 | PRJNA473824_P_NODE_171984_length_150_cov_1.380531_g171346_i0 | PRJNA473824 | 171984 | 150 | 1.380531 | 2.0707965 | Jenufa minuta | 993092 | Plants | Plants | 278 | 1.85e-70 | NTclustered | gi|1829768154|ref|NC_046780.1| | 993092 | g171346 | i0 | 100 | 1 | 150 | 0 | 100 | 0 | 1 | 150 | 18910 | 19059 | Jenufa minuta culture CAUP:H8102 mitochondrion, complete genome | blastn | 150 | 278 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 4273652 | 4273652 | PRJNA473824_P_NODE_20184_length_263_cov_1.194690_g19546_i0 | PRJNA473824 | 20184 | 263 | 1.19469 | 3.1420347 | Auxenochlorella pyrenoidosa | 3078 | Plants | Plants | 481 | 2.58e-131 | NTclustered | gi|1201359271|gb|MF040793.1| | 3078 | g19546 | i0 | 99.62 | 90.5703422053232 | 263 | 1 | 100 | 0 | 1 | 263 | 493 | 231 | Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence | blastn | 23820 | 481 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 6823972 | 6823972 | PRJNA473824_P_NODE_130106_length_158_cov_0.966942_g129468_i0 | PRJNA473824 | 130106 | 158 | 0.966942 | 1.52776836 | Jenufa minuta | 993092 | Plants | Plants | 292 | 7.07e-75 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g129468 | i0 | 100 | 98.3670886075949 | 158 | 0 | 100 | 0 | 1 | 158 | 43743 | 43900 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 15542 | 292 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 8099935 | 8099935 | PRJNA473824_P_NODE_32047_length_211_cov_3.683908_g31409_i0 | PRJNA473824 | 32047 | 211 | 3.683908 | 7.77304588 | Jenufa minuta | 993092 | Plants | Plants | 383 | 5.79e-102 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g31409 | i0 | 99.526 | 51.654028436019 | 211 | 0 | 100 | 1 | 1 | 211 | 92522 | 92313 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 10899 | 383 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 10650067 | 10650067 | PRJNA473824_P_NODE_13449_length_330_cov_1.464164_g12812_i0 | PRJNA473824 | 13449 | 330 | 1.464164 | 4.8317412 | Jenufa minuta | 993092 | Plants | Plants | 610 | 4.09e-170 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g12812 | i0 | 100 | 99.4848484848485 | 330 | 0 | 100 | 0 | 1 | 330 | 46427 | 46098 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 32830 | 610 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 14475816 | 14475816 | PRJNA473824_P_NODE_8012_length_480_cov_3.146727_g7426_i0 | PRJNA473824 | 8012 | 480 | 3.146727 | 15.1042896 | Jenufa minuta | 993092 | Plants | Plants | 854 | 0 | NTclustered | gi|1829768154|ref|NC_046780.1| | 993092 | g7426 | i0 | 98.952 | 0.99375 | 477 | 5 | 99 | 0 | 4 | 480 | 17505 | 17981 | Jenufa minuta culture CAUP:H8102 mitochondrion, complete genome | blastn | 477 | 854 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 15749793 | 15749793 | PRJNA473824_P_NODE_6013_length_638_cov_2.618968_g5481_i0 | PRJNA473824 | 6013 | 638 | 2.618968 | 16.70901584 | Jenufa minuta | 993092 | Plants | Plants | 933 | 0 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g5481 | i0 | 98.857 | 221.633228840125 | 525 | 2 | 83 | 1 | 1 | 521 | 102925 | 103449 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 141402 | 933 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 17024290 | 17024290 | PRJNA473824_P_NODE_43214_length_186_cov_2.355705_g42576_i0 | PRJNA473824 | 43214 | 186 | 2.355705 | 4.3816113 | Jenufa minuta | 993092 | Plants | Plants | 344 | 2.34e-90 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g42576 | i0 | 100 | 102.134408602151 | 186 | 0 | 100 | 0 | 1 | 186 | 31355 | 31540 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 18997 | 344 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 19573064 | 19573064 | PRJNA473824_P_NODE_7996_length_481_cov_2.905405_g7410_i0 | PRJNA473824 | 7996 | 481 | 2.905405 | 13.97499805 | Jenufa minuta | 993092 | Plants | Plants | 883 | 0 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g7410 | i0 | 99.792 | 148.357588357588 | 481 | 1 | 100 | 0 | 1 | 481 | 104205 | 103725 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 71360 | 883 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 20847869 | 20847869 | PRJNA473824_P_NODE_124737_length_165_cov_1.218750_g124099_i0 | PRJNA473824 | 124737 | 165 | 1.21875 | 2.0109375 | Jenufa minuta | 993092 | Plants | Plants | 305 | 9.59e-79 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g124099 | i0 | 100 | 99.0424242424242 | 165 | 0 | 100 | 0 | 1 | 165 | 34387 | 34223 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 16342 | 305 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 20847946 | 20847946 | PRJNA473824_P_NODE_131757_length_156_cov_0.983193_g131119_i0 | PRJNA473824 | 131757 | 156 | 0.983193 | 1.53378108 | Jenufa minuta | 993092 | Plants | Plants | 124 | 2.6799999999999998e-24 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g131119 | i0 | 98.571 | 0.448717948717949 | 70 | 1 | 45 | 0 | 87 | 156 | 93153 | 93084 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 70 | 124 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 20848243 | 20848243 | PRJNA473824_P_NODE_19597_length_267_cov_1.547826_g18959_i0 | PRJNA473824 | 19597 | 267 | 1.547826 | 4.13269542 | Jenufa minuta | 993092 | Plants | Plants | 442 | 1.2399999999999995e-119 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g18959 | i0 | 97.318 | 64.314606741573 | 261 | 6 | 97 | 1 | 8 | 267 | 104637 | 104897 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 17172 | 442 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 21498402 | 21498402 | PRJNA473824_P_NODE_4657_length_889_cov_2.490610_g4208_i0 | PRJNA473824 | 4657 | 889 | 2.49061 | 22.1415229 | Chlorophyta | 3041 | Plants | Plants | 998 | 0 | NTclustered | gi|2131194042|gb|MZ561475.1| | 83794 | g4208 | i0 | 86.952 | 113.418447694038 | 889 | 114 | 99 | 2 | 2 | 889 | 59871 | 58984 | Ulva californica strain U484-3 chloroplast, complete genome | blastn | 100829 | 998 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva californica | |
| 24673437 | 24673437 | PRJNA473824_P_NODE_8820_length_441_cov_2.806931_g8215_i0 | PRJNA473824 | 8820 | 441 | 2.806931 | 12.37856571 | Chloroidium sp. KL-2023a | 3031248 | Plants | Plants | 782 | 0 | NTclustered | gi|2450595352|gb|ON986219.1| | 3031248 | g8215 | i0 | 98.639 | 145.08843537415 | 441 | 6 | 100 | 0 | 1 | 441 | 220776 | 220336 | Chloroidium sp. KL-2023a clone 2023 chloroplast, complete genome | blastn | 63984 | 782 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium sp. KL-2023a |
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);;